This is an advanced course, and is intended for those who have a good understanding of Excel and want to jump a few levels.
Objectives
- Learn shortcuts to speed up data analysis
- Perform sensitivity and scenario analysis
- Use Goal Seek and Solver to solve complex problems
- Understand the structure of and concepts in VBA
- How to build your own functions... extend the library of built in functions
- Use VBA to automate repetitive tasks