Advanced Dashboard Reporting Using Excel

Instructor

Categories

Please fill following information

Advanced-Dashboard-Reporting-Using-Excel_WEB

Overview
Instructor

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

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

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

Course Information

Reg. Ends 02 June, 2021
Start Date 03 June, 2021
End Date 05 June, 2021
Class Schedule 07:30PM to 10:30PM
Total Hours 9
Venue Title Online Live Training
Venue Address www.sudoksho.com/class-room

MD. Nazmul Muneer, MCT

Microsoft Certified Trainer

Md. Nazmul Muneer is a Microsoft Certified Professional "Microsoft Excel (Excel and Excel 2019)" and also obtained the prestigious Certificate from Microsoft "Microsoft Certified Trainer (MCT)".

Md. Nazmul Muneer is one of the key contributors in the Accounts & Finance department of Beximco Pharmaceuticals Ltd. with 12+ years job experience and has previous work experience in Energypac Power Generation Ltd. Mr. Muneer also works as a freelance Excel automation consultant and Facilitator. In the last few years he has conducted more than 300 professional Excel training programs in many national and multinational corporate houses and educated in Excel more than 7,000 participants through effective training.

He is a regular Excel Facilitator and online course author of few leading training institutes and platforms. He also conducted Excel presentation in few educational institutes including Dhaka University, Jagannath University, United University, ICMAB, ICAB and more. He has also conducted exclusive corporate professional training programs for many Bangladeshi and MNCs organizations.

He is expertise in developing automated formula-based Excel dashboard, VBA/Macro based Excel application, strategic business model, various problem-solving calculators, What-if Analysis model, data analysis dashboard using Business Intelligence (BI) tools, KPI automation etc.

Mr. Muneer has obtained educational experience in two different disciplines. He is a post graduate in Accounting and has a Diploma in Professional Software Engineering. These have enabled him to acquire vast IT knowledge on developing Database Software, Advanced Excel with VBA, Access with programming, VB, SQL server, Crystal report, IBM AS/400, ORACLE E-Business Suit functional and implementation, etc.