Microsoft Excel Advanced
This 1 day Microsoft Excel Advanced course is for people who need to analyse large data sets. Showing you how to manipulate data with a range of Excel functions. Giving delegates the ability to set up data models using ‘What If’ scenarios and use a variety of Excel tools.
At the end of the course delegates will be able to:
- Use Excel Functions
- Advanced data filters
- Carry out “What-Ifs” using Goal Seek, and Scenario Manager
- Conditional Formatting using formulas
- Create dashboard interfaces using multiple Pivot Tables and Charts
What Skills will I learn ?
- Use Excel Functions
- Advanced data filters
- Carry out “What-Ifs” using Goal Seek, and Scenario Manager
- Conditional Formatting using formulas
- Create dashboard interfaces using multiple Pivot Tables and Charts