What Will I Learn?
- Significantly improve your Excel reports to create more powerful graphs that communicate your information in the best manner
- Learn creative & simple techniques that allow you to create your own Excel charts from scratch
- Create dynamic Excel charts. Why? To save time! I have seen many cases where people are unnecessarily manually updating graphs. This costs considerable time and nerves.
- Impress your management by including new Excel graphs in your reports (such as my Pin chart for variances)
- Apply Best Practice methods to considerably improve the design of your Excel charts and tables
- Apply techniques that highlight chart and table elements to direct the reader attention where it is needed most
- Use effective Chart Combinations that are pivotal to management reports
- Apply best methods to compare performance in your Excel graphs: as in Actual data versus Budget, forecasts and previous year
- Learn by doing. Download the Demo Excel Workbook and follow each section with me. Once you complete a section, you will do an exercise to test your understanding. Learning by doing works best!
- Learn advanced Excel lookup methods (such as matrix lookups) which you can use in your larger data files. The methods learnt in Behind the scenes secrets of dynamic charts can be applied to many other areas.
- Become the Excel data Visualization star in your department by creating impressive Excel charts and graphs in your reports
Requirements
- Existing experience and knowledge of Excel's basic charting options and formulas
- This course is aimed for current intermediate to advanced Excel users and will significantly build on existing knowledge
- Demonstration is done using Excel 2010. However, the focus of this training is to teach you new methods of doing things which you can do regardless of the Excel version you have
No comments:
Post a Comment