Live Excel Dashboard MasterClass (August 18-19, 2022 on Zoom)

4.8 out of 5
4.8
4 reviews
How To Create Excel Dashboard Live Zoom Training

Learn to create Management Reports & Dashboards in Excel.

Excel Dashboard Comparing 2 Countries
Excel Dashboard Comparing 2 Countries

Analyze data dynamically within a single page and get an overview of the health of your sales, marketing, services, human resources etc. using Dashboards designed in Microsoft Excel.

Works with any version of Microsoft Excel (Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007).

The next MasterClass will be held over Zoom on the following dates & Times:

  • Date: 18-August-2022 & 19-August-2022
  • Time: 11am to 7pm (UTC +8). This is Singapore time.

You can enrol in this course now. Pay via PayPal. We will send you the confirmation & Zoom Meeting Links prior to the training.

A ZIP file containing all exercises and sample files will be available on the Training day for you to download.

You can then do the exercises along with me as we do it, step by step and learn to create several dashboards in Excel.

A Dashsboard Created in Microsoft Excel
A Dashsboard Created in Microsoft Excel

A highly practical and hands-on workshop.

Mr. Vinai’s tips, tricks and articles on Advanced Techniques to Analyze Data, Present Data are highly popular, and regularly appear in the press. Recently, The Straits Times newspaper published an article written by Mr. Vinai, about the 8 Habits of Effective Data Analysts.

Who should attend the Excel Dashboard MasterClass?

Sales, Marketing, Finance, IT Executives, Engineers, Project Managers, Directors, CXOs, Managing Directors, General Managers, and Data Warriors who dabble with data and want to learn advanced techniques to convert Data into actionable Information.

The ability to create dynamic dashboards cut down the time required to load, clean and prepare data and generate reports every week and every month. You spend more time analyzing the data to find hidden trends and take action to improve the results you are getting.

A Dynamic Dashboard with a Dropdown for Countries
A Dynamic Dashboard with a Dropdown for Countries

Meet Your Trainer for this workshop:

Vinai Prakash, Founder of ExcelChamp
Vinai Prakash

This Advanced Excel Dashboard Masterclass Training workshop is conducted by Excel Guru, Vinai Prakash, PMP, MBA, GAP.

Vinai has over 35 years of experience in Business Intelligence, Data Mining, Creating Management Reports and Dashboards for MNCs, large and small companies around the world.

He has coached over 5,800 students in Singapore, Australia, Egypt, Dubai, India, Malaysia, Zimbabwe, Indonesia and over 25 other countries.

How To Join this Training:

Simply make the payment, and we will confirm your seat within 1 day. The Zoom Link, and exercises link will be emailed to you prior to the training.

Do You Have Any Questions?

Simply email your questions to us. We will get back to you within the day.

Excel Dashboard MasterClass Live over Zoom
Excel Dashboard MasterClass Live over Zoom

Introduction

1
Introduction to Excel Dashboards

An introduction to Excel Dashboards & Interactive Controls That Bring Dynamic Reporting to life.

2
Principles of Great Dashboard Design

Excel Fundamentals

1
Relative & Absolute Referencing
2
Creating & Using Range Names
3
Using Conditional Formatting
4
Format Data with Excel Tables
5
Methods to Sort & Filter Data
6
Using Excel Slicers

Data Preparation

1
Loading Data into Excel
2
Remove Duplicates
3
Split Data into Multiple Columns
4
Excel Functions to Clean Data
5
Data Validation
6
Error Handling

Creating Mini Dashboards With Excel

1
Logical Functions
2
Lookup Functions
3
Creating a simple Excel dashboard

Excel Dashboards With Pivot Tables & Charts

1
Introduction to Excel Pivot Tables & Charts
2
Creating Pivot Table Reports for Analysis
3
Creating a sophisticated Excel Dashboard With Pivot Tables, Charts & Slicers

Dashboards With Advanced Controls

1
Introduction to Excel Developer Tools
2
Excel Dashboard with Buttons
3
Excel Dashboard with Dropdowns
4
Excel Dashboard with Scroll Bars
5
Excel Dashboards with Check Boxes

Wrap Up

Sales, Marketing, Finance, IT Executives, Engineers, Project Managers, Directors, CXOs, Managing Directors, General Managers, and Data Warriors who dabble with data and want to learn advanced techniques to convert Data into actionable Information. The ability to create dynamic dashboards cut down the time required to load, clean and prepare data, and generate reports every week and every month. You spend more time analyzing the data to find the hidden trends and take action to improve the results you are getting.
This is a live training, conducted by Mr. Vinai on Zoom. After the training, the entire session, broken into sections, will be available to you to view at your leisure in the form of shorter videos. Recordings will be live within 7 days after the finish of the training.
Make sure you have Microsoft Excel installed, so that you can do the exercises as Mr. Vinai will demonstrate on the training.
Absolutely. The videos of the live training will be made available to you within 1 week of the training end date.

This live training will be conducted over Zoom. It is better to install Zoom software beforehand. If you do not have Zoom installed, you can view the entire session on your browser too.

4.8
4.8 out of 5
4 Ratings

Detailed Rating

Stars 5
3
Stars 4
1
Stars 3
0
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Enrolled: 43 students
Duration: 2 Days
Lectures: 25
Video: 14 Hours
Level: Beginner