Microsoft Excel is widely used to prepare various types of analytical interactive reports for the top management who are at the planning stage. The latest buzzword in the world of Excel is Automated Live interactive Dashboard Reporting. A dashboard report is a management tool that measures and presents critical data on the key business performance areas in a summarized easy-to-read format. To prepare a smart dashboard report, you have to use various form controls, appropriate charts, functions to fetch aggregated data, various formatting and few professional tricks.

This project-based professional workshop will help you through various functions, tools, tips and tricks to boost up your Excel productivity and you will learn how to map and handle big data in Excel that will work for you and generate the interactive reports describing the core information within seconds professionally.

Who Should Attend?

Excel developers, regular Excel users and all kinds of analysts who want to gain skills in designing visual reports. Those who want to start getting creative with an interest in learning about dynamic charts and visually appealing data will benefit from this course

• Excel users preparing the same kinds of reports repeatedly
• Data analyzers who are engaged with large data set
• Data drivers
• Business reporters
• Senior leaders engaged with reporting

Training Contents

• Ice breaking – A Visual Presentation on General Rules for Dashboard Preparation
• Data Matching & Lookups for Preparing Dashboard’s Raw Data
• Functions for Data Summarization from big Data
• Customizing the Charts and other Visual Tools for Cool Dashboard
• Customizing the Advanced Conditional Formatting on Dashboard
• Dashboard Project-1: Using PivotTable, PivotChart, Slicers and Timeline
• Dashboard Project-2: Using PowerPivot, the Excel’s Built-in Self Service BI Tool
• Dashboard Project-3: Using Power Query, combining data from multiple files
• Using the Objects & Form Controls to Control Your Dashboard
• Dashboard Project-3: A Comprehensive Formula Based Dashboard Report
• Questions & Answers in the Whole Session