$395.00 $295.00
Intermediate-Advanced Excel Class
Corporate Clients: More than 3 students?
Click Here For Corporate Rates
The advanced Excel Training looks at advanced formulas and functions, formula auditing techniques, data-analysis with pivot tables.
Description
Intermediate-Advanced Excel Class
Advanced Microsoft Excel Training covers advanced formulas and functions (Vlookup, If/Then, Index/Match, formula auditing techniques, what-if data-analysis techniques (pivot tables, scenarios, forecasting), database features (validation, extract unique values), and advanced macros (with light VBA programming).
Advanced Excel Training Objectives:
* Review Formulas, Function, Absolute References
* Advanced Excel Formulas: Named Ranges, Vlookup, Index, Match, If, SumIf, IsError, Text Functions, Formula Auditing
* Advanced Data Analysis:What-If Analysis with Pivot Tables
* Database Features: Validation, Advanced Filters, Import Excel Data and Export Excel data
* Automate Excel with Macros