Start date: 24 June 2019
Location: Boyle Enterprise Centre
This course is designed for those with a strong working knowledge of Excel who wish to become more proficient.
- Conditional Formatting
- Advanced Formulae & Functions
- Auditing Formulae
- What-If Analysis
- Working with Advanced Filters
- Consolidating Data
- Working with Pivot Tables
- Data Entry Validation
- Power Query
To create complex models involving multiple linked Excel spreadsheets and files, analysing data using what ifs and scenarios, validating and auditing data and automating commonly used features with macros.