Excel Advanced:
Analyse data using Pivot Tables, Automate repetitive task with Macros and build on existing formula knowledge with Nested ifs and Text manipulation formulae.
Course Outline
Excel Advanced 1 Day
Who is it for?
The course is suitable for existing users of Microsoft Excel wanting to further their knowledge – this course covers automating spreadsheets and using advanced data handling techniques.
Prerequisites
Delegates should have a good knowledge of the Introduction and Intermediate outline.
- Advanced Functions
- An in-depth look into:
- Nesting IF’s
- And/Or Functions
- Array Formulas
- Text Functions
- Database Functions
- New formulas; XLOOKUP, Filter, Sort and Unique (O365 only)
- Pivot Tables
- Pivot Tables and Pivot Charts:
- Creating and Editing Tables & Charts
- Refreshing Data
- Displaying Pages
- Slicers
- Templates & Editing
- Templates & Advanced Editing Techniques:
- Creating & Editing Templates
- Deleting Templates
- Paste Special & Paste Link
- Data Validation
- Custom Views
- Shared workbooks
- Spreadsheet Automation
- Working with Macros:
- Creating & Naming Macros
- Absolute and Relative Macros
- Creating Macro Buttons
- The VBA screen