Microsoft Excel – Level 3 Advanced Formulas
Laptops are provided to use with on-site, classroom training
Everyone receives a physical workbook, 8 hours, $225 per person

Advanced shortcuts
Create, edit, and evaluate formulas
Trace precedents and dependents
Profit Margin formula
Custom number formats including hours, minutes and seconds
Autofill series
Data validation using formulas and error messages
Naming data and using in formulas
If and, not, iferror, averageifs, countifs, sumifs
Dsum, dcount, dcounta, dmin, dmax and daverage
Sumproduct
Formula errors
Nested formulas including if formulas with multiple outcomes
Date formulas including now, today, year, month, day
Calculating workdays between dates
Absolute, relative and mixed cell references
Advanced 3D referencing other files and sheets
Vlookup, Hlookup, Xlookup
Match, Index
Advanced Match
Aggregate
Row
Goal Seek and Scenario Manager
Watch Window
Round up or down
Conditional formatting based on other columns and criteria
Trim, Lower, Upper, Proper, Left, Search, Find, Right, Mid formulas