New Advanced Topics

Advanced Microsoft Excel Training

Level 3: MS Excel Advanced
Our Advanced class is a 1 day class intended for power users who need to increase their competency and productivity with Excel by learning to better extract the meaning from the data.

$500 per trainee for a full day of instructor-led Excel training.
Group discounts up to 75%.
Group of 2 to 5 trainees: $800 online or $1,800 onsite.
Group of 6 to 10 trainees: $1,000 online or $2,000 onsite.

Class participants will learn the skills that Microsoft covers in their Excel Expert designation examinations, plus advanced usage of formulas, functions, and macros.

MS Excel Advanced Class Outline

1. Advanced Formulas And Functions
2. Advanced Macros
3. Calculating Subtotals
4. Advanced Filters
6. Data Validation
7. What-If Scenarios
8. Pivot Tables And Pivot Charts
9. Lookup And Reference Functions
10. Database Functions
11. Using Named Ranges
12. Hyperlinking Data
13. Data Consolidation
14. Data Protection