Advanced Dashboard Reporting 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?

Regular Excel users, managers, decision makers, dynamic business reporters, data analyst and the users who wants to gather the advanced modern reporting techniques.

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 Power Query
4. Setting conditions on live tabular and graphical data
5. Managing big data in Excel professionally

Training Contents:

1. Functions for Data Summarization & Aggregation from big Data
2. Charts & Graphs – Customization & setting conditions
3. Dashboard Project-1: Using PivotTable, PivotChart, Slicers and Timeline
4. Dashboard Project-2: Using PowerPivot, the Excel’s Built-in Self Service BI Tool
5. Dashboard Project-3: LIVE Data linking from multiple files Using Power Query
6. Dashboard Project-4: Using Form controls, functions, Various Tools and Charts
7. Questions & Answers in the Whole Session

Note:

• After completing every lesson click on the “COMPLETE” button the go to the next lesson.
• 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 course will be finished and a Certificate will be generated.
• More details: https://thrivingskill.com/faqs/

Training Instructor:

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. Lookup Functions with Practical Business Case Study
5. Microsoft Excel-Professional Tips & Tricks
6. Most Out of Excel
7. Advanced Automated Dashboard Reporting System Using Excel
8. Microsoft Excel Advanced Data Processing and Reporting Techniques
9. Advanced Excel with Practical Business Case Studies