Advanced Automated Dashboard Reporting System Using Excel

Overview:

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 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

1. Excel users preparing the same kinds of reports repeatedly
2. Data analyzers who are engaged with a large data set
3. Data drivers
4. Business reporters
5. Senior leaders engaged with reporting

What You Will Learn from This Course:

1. Dashboard tricks, functions and application step-by-step
2. 04 practical scratch to complete dashboard projects
3. Obtain the knowledge of PowerPivot and PowerQuery
4. Setting conditions on live tabular and graphical data
5. Managing big data in Excel professionally

Training Contents:

1. Ice-breaking – A Prezi presentation on Dashboard Reporting
2. Data Matching & Lookups for Preparing Dashboard’s Raw Data
3. Functions for Data Summarization & Aggregation from big Data
4. Charts & Graphs – Customization & setting conditions
5. Objects & Form Controls – Setting parameters for Dashboard
6. Visual Effect – Advanced Conditional Formatting applicable on Dashboard
7. Dashboard Project-1: Using PivotTable, PivotChart, Slicers and Timeline
8. Dashboard Project-2: Using PowerPivot, the Excel’s Built-in Self Service BI Tool
9. Dashboard Project-3: LIVE Data linking from multiple files Using PowerQuery
10. Dashboard Project-4: Using Form controls, functions, Various Tools and Charts
11. Questions & Answers in the Whole Session

Note:

• All participants will get a digital certificate from Thriving Skills Limited.
• Must set up your first name, last name, and display name from settings of your profile for your certificate.
• Don’t click on the “FINISH COURSE” button.
• If you click on the “FINISH COURSE” button then the webinar will be finished and a Certificate will be generated.

Instructor of this Training:

Nazmul Muneer

Courses of this Instructor:

1. Microsoft Excel – Advanced Level
2. Most Common Features of Excel for Professionals
3. Microsoft Excel – VBA & Macro
4. Microsoft Excel VBA & Macro Basics
5. Lookup Functions with Practical Business Case Study
6. Excel VBA & Macro
7. Microsoft Excel-Professional Tips & Tricks
8. Most Out of Excel
9. Advanced Automated Dashboard Reporting System Using Excel
10. Microsoft Excel Advanced Data Processing and Reporting Techniques
11. Advanced Excel with Practical Business Case Studies