Excel Level III
Power Moves
Suggested Prerequisites: Excel Levels I and II
Description: Welcome to Microsoft Excel Level III. This course is the third in a series of courses designed for individuals who will use Microsoft Excel as a tool to assist them in storing and analyzing numeric data. The topics in this course cover the critical skills necessary to perform advanced Excel features. The major topics covered in this course will include Advanced Functions, PivotTables, Worksheets, Consolidating Data, Analyzing Data, Protecting Data, Macros, and Import/Export Options.
Topics
Advanced Functions
- Advanced IF Statements – Boolean Operators
- Advanced IF Statements – Nested IF Statements
- SumIF and More
- The Auditing Tools
- The IFERROR Statement
Using PivotTable Reports and Charts
- Creating PivotTable Reports
- Modifying PivotTable Reports
- Creating a PivotCharts
Working with Multiple Worksheets
- Linking Cells in Different Workbooks
- Consolidating Data
- Saving a Workspace
Analysis Tools
- Using the Goal Seek Utility
- Using the Scenario Manager
Introduction to Macros
- Recording a Macro
- Running a Macro
- Turning a Macro into a Toolbar Button
Importing and Exporting Data
- Export to Microsoft Word
- Export a Text File to Any Software Environment
- Export Data to a MS PowerPoint Presentation
- Import a Word Table
Advanced Visual Enhancements
- Conditional Formatting
- Smart Art
Excel Level III