Advanced Analysis & Visualization in Excel

Goal is Simple: Learn to create one pager executive dashboards in MS Excel that update with the click of the Refresh button, or with a simple copy-paste of your new data.

This course is suitable for you if you answer YES to:-

• Do you want to spend less time creating reports and more time analyzing and gaining insights from the reports?
• Do your reports take a long time to update each reporting cycle?
• Do you want to gain skills to avail credible dashboards that allow the management to understand what is going on and make better decisions, quickly?

Course Description:

This training aims at making the process of “Data to Decisions” efficient and cost effective. This will be achieved by maximum utilisation of the most basic, easily available and affordable reporting tool MS Excel. For example, it is interesting to note that although ALL organizations have MS Excel and use it in more than 50% of their reporting/analysis processes, only about 10% of the features available in Excel are used in most of the organizations. In terms of ROI, MS Excel is among the worst performing reporting tools in most organizations.

This training provides you with the technical know-how to move from reporting your data with simple tables full of dull numbers to creating and presenting key information through the use of high-impact, meaningful and appealing reporting solutions (dashboards).

The course will help you to:

• Explore top 15 advanced data analysis functions that will save your report generation turn-around time!
• Move from static, dull reports to interactive and insightful dashboards -learn to apply form controls, slicers, pick lists, and camera tool to create interaction
• Show top performers using formulas and YoY% by a click of a mouse
• Achieve more with advanced analytical charts -Pareto chart, Scrolling charts, Gauge Charts
• Easily spot trends and patterns in your data by using icon sets, traffic lights, Sparklines and Custom Number formats
• Creating a dashboard in Excel step-by-step