In this course you will learn how to take advantage of some of the more advanced features of Microsoft ® Excel® to prepare and present your business data
A sound knowledge of the advanced features and functionality in Excel used for business reporting (prior attendance of our Excel on Steroids course qualiﬁes you as an advanced Excel user
- Create dynamic data models which will serve as the back-end of your Dashboard using advanced functions and formula.
- Create PivotTables and Pivot Charts.
- Explore alternative visualization techniques like sparklines and conditional formatting for at-a-glance analysis
- Create advanced and custom charts
- Create an interactive, macro-charged Dashboard.
• Design meaningful Dashboard Reports catering to your audience’s requirements and goals following Dashboard design best practise