Duration: 1 day (6.5 hours)
This advanced Excel course looks at some of the statistical analysis tools available and gives examples of when they might be used.
This course is aimed at advanced users of Excel who work with statistical data often and have a good knowledge of Maths.
By the end of the course you will be able to:
- Use Goal Seek
- Create and view scenarios
- Use Forecast Sheet
- Create single and double input data tables
- Create models using the solver
- Install and use the Analysis Toolpak
- Create and use array formulas
- Use a range of advanced Financial and Statistical Excel functions