Many of the new Excel 2007 features and functions have been streamlined and simplified making it easier than ever for you to crunch the numbers. So, this training course will cover in detail proven time-saving shortcuts and tips that will dramatically boost your Excel functionality you will learn how to:
- Confidently tackle complex data analysis techniques and formulas
- Get the most out of Pivot Tables and Pivot Charts functions
- Maximise the power of effective forecasting to push your management decision making capabilities to new heights
- Apply different approaches to business planning including deterministic and probabilistic models
- Sort functions on worksheets that now allow you to sort by up to 64 different criteria
- Correctly use the Autofilter tool - this has changed dramatically so what do you need to know to make it work for you?