Intermediate To Advanced Excel Class
Our one day advanced Excel training includes formulas like: Vlookup and Index Match, SumIfs (two and three criteria), If, and introduction to advanced PivotTables. An introduction to macros and VBA programming.
The only Excel class to offer 90+ minutes of Vlookup and 90+ minutes of PivotTables!
Our intermediate-advanced Excel training is hands-on and includes practice exercises.
The only training to offer a library of over 310 self assessment tests for practice.
Course includes an illustrated printed 85 page manual!
Training Schedule
Weekdays:
December 20th 9am-5pm
January 16th 9am-5pm
January 22nd-23rd 1pm-5pm
Weekends:
January 11th-12th 9am-1pm
Intermediate To Advanced Excel Class Outline
Keyboard Shortcuts
Autosum
Preselect
Absolute Reference
Freeze vs. Table
Filter vs. Slicer
Subtotal Function
Sort
Data Subtotal
Goto Special
Named Ranges
Vlookup
Keyboard Shortcuts
Same Worksheet
Multiple Worksheets
Vlookup Caveats
Index and Match
Keyboard Shortcuts
Same Worksheet
Multiple Worksheets
SumIfs
One Criteria
Multiple Criteria
CountIfs
IfError
If Then Else
Text Outcome
Formulaic Outcome
Nested If Then Else
And / Or
Text Functions
Array Formulas
Database Functions
3-Dimensional Functions
Formula Auditing
Goal Seek
Forecast
Keyboard Shortcuts
PivotTables
PivotCharts
Scenarios
Solver
Group and Outline
Data from the Web
Data Validation
Remove Duplicates
Unique Function
Record a Macro
Edit a Macro
Write VBA Code
Comments
Track Changes
Passwords
Workbook Protection
Worksheet Protection
Range Protection
Frequently Asked Questions
Most classes typically start at either 9am or 1pm
We provide a Windows computer.
Yes, upon completion you will receive an attractive gold foil certificate.
The ability to use a mouse and a keyboard. Knowledge of the topics from Introduction To Excel
31 West 34th Street. Near Penn Station, NJ Transit, and the N, Q, R, W, B, D, F, 1, 2, 3, A, C, E trains.
The entrance may be challenging to spot. We are between Steve Madden and Zara.