If the student is already familiar with Microsoft Office Excel its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools this course is for them. This class will put the full power of Exel at their fingertips and will enhance skills and give the participant the ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic and dynamic arrays to construct and apply elaborate formulas and functions.

1 day - $295.00

Course taught by an expert Microsoft Office Instructor.

Prerequisites:

Basic knowledge of Microsoft Exel is required.

Course Outline

Working with Multiple Worksheets and Workbooks
Using Links and External References
Using 3-D References
Consolidating Data 


Sharing and Protecting Workbooks
Collaborating on a Workbook
Protecting Worksheets and Workbooks 


Automating Workbook Functionality 

Applying Data Validation

Searching for Invalid Data and Formulas with Errors
Working with Macros

Using Lookup Functions, Dynamic Arrays, and Formula Auditing
Using Lookup Functions
Using Dynamic Arrays and Dynamic Array Functions
Tracing Cells
Watchong and Evaluating Formulas

Forecasting Data
Determining Potential Outcomes Using Data Tables
Determining Potential Outcomes Using Scenarios
Using the Goal Seek Feature
Forecast ingData Trends 


Creating Sparklines and Mapping Data
Creating Sparklines
Mapping Data