Intermediate to Advanced Excel Training
Advanced Microsoft Excel training is for those familiar with basic Excel concepts that inlcude the following prerequisites:
- Absolute References
- SumIfs 1 Criteria
- Sort and Filter
- Freeze Panes
Advanced Excel training includes a printed 85 page manual. Each student works on a Windows computer with Excel 2020.
Sale Price: $279
The objectives of the advanced Excel class include:
- Keyboard Shortcuts
- Advanced Excel Formulas: Named Ranges, Vlookup, Index/Match, If, SumIf, IfError
- Formula Auditing
- Data Analysis with Pivot Tables
- Automate Excel with Macros
- Database Validation and Extract Unique Values
Frequently Asked Questions
Where are you located?
Our classes are taught at 225 West 34th Street and are convenient to Penn Station. Corporate classes are also taught on-site.
How long is the class?
Weekday classes begin at 9am, weekend classes begin at 10am. There is a 40-50 minute lunch break. The ending time is variable.
Do I need to bring anything?
The class provides a computer and printed notes along with a pen and snacks. You may bring lunch or purchase it nearby.