Microsoft Excel For Intermediate/Advanced Level
Excel is the most commonly deployed spreadsheet package in the world, partly because it comes as part of Microsoft Office. Participants will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds.
They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, participants will learn to work with PivotTables and PivotCharts.
Upon completion of this program, participants should be able to:
- Outline and Group Data
- Work with PivotTables
- Hyperlink Excel and The Internet
- Creating and Using Shared Workbooks
- Work with Visual Basic and Macros
- Perform Advanced File Management
- Customize Excel and Use Excel With Other Programs