Excel – Part Three is an advanced Excel course designed for power users who want to master Excel’s most sophisticated features. Students learn to use advanced formula techniques, work with Excel’s data analysis tools including Goal Seek and Solver, protect and audit workbooks, record and run macros, and apply best practices for managing and sharing large, complex Excel workbooks.
What You Will Learn
- Use advanced formulas and array functions including XLOOKUP, XMATCH, dynamic arrays, and LET
- Apply Excel’s What-If Analysis tools including Goal Seek, Data Tables, and Scenario Manager
- Use Solver for complex optimization problems with multiple constraints
- Record, edit, and run Excel macros using the macro recorder and the Visual Basic editor
- Protect workbooks and worksheets, audit formulas, and manage large workbook structures
Who Should Attend
Experienced Excel users who work with complex spreadsheets and want to master advanced features to solve sophisticated data problems.
Prerequisites
Completion of Excel – Part Two or equivalent intermediate Excel experience including PivotTables, lookup functions, and data validation.
