Learn To Build Interactive
Dashboard in Excel

By a top Microsoft Excel Specialist & Microsoft Certified Trainer

Includes
Practice File

Life Time Access

Certificate of Completion

100% Practical

  • Impress management with Dashboard that make the decision-making process faster
  • Effectively summarize and present data clearly
  • Learn Advanced Functions in an easy-to-understand language
  • Build dynamic dashboard
  • Build dashboard using Pivot Table for interactivity
Get Lifetime access for this workshop in just AED 99

Register before October 07, 2024 to unlock amazing bonuses

Who is this workshop for?

Excel users looking to create Dynamic and Interactive Dashboards

You are currently using Excel and want to improve your Dashboard skills​

Anyone who wants to learn how to tell compelling stories with data​

Yes I want to Upskill myself in Excel Dashboard !
(Join now in just AED 99 Today)

What will you learn in this workshop?

Course Introduction

  • What is Dashboard ?
  • What will you learn in this Dashboard Course ?
  • Download Practice Files
Module 1

Cleaning Messy Data

1 Correcting Spelling Mistakes in your Data
2 Fixing Merge Cell Issue
3 Fixing Date Format
4 Deleting Blank Rows & Columns
5 Removing Unwanted Spaces Using Trim Formula

Module 2

Creating Dashboard Using Pivot Table

  1. Creating your 1st Report with Pivot Table
  2. Calculating Count & Percentage – %
  3. Creating Yearly, Monthly & Quarterly Reports
  4. Refresh, AutoRefresh and Increasing your data Range
  5. Using Interactive Slicer
  6. Using Timeline
  7. Creating Multiple Pivots on same sheet
  8. Creating Dashboard Layout
  9. Creating Charts & Pasting on Dashboard Sheet
  10. Connecting Slicers to all the Reports
  11. Conclusion
Module 3

Creating Dashboard Layout

  • Creating Layout for Dashboard
  • Adding Charts
  • Adding Slicers
  • Report Connecting
  • Adding Total Sales
  • Total Records
  • Average Sales Formulas
  • Creating Charts & Pasting on Dashboard Sheet
Module 4

Final Touches (Protect and Share)

  • Hiding Extra Worksheets and Columns
  • Protecting Your Dashboard Sheet from Deletion
  • Saving your Dashboard to One Drive
Module 5

Publishing Dashboard

Module 6
I Am Ready To Invest In Myself Now!
(Click to Book your spot now in just AED 99 Today)

Extra Bonuses

Excel Tips & Tricks E-Book

An Excel cheatsheet with shortcuts to simplify your learning and save your time.

100+ PowerPoint Infographics

Create stunning presentations easily using premium Infographic Templates

Grab Your Bonuses Now! Time is running out!

  • 00Hours
  • 00Minutes
  • 00Seconds
Get Lifetime access for this workshop in just AED 99
(Book your spot Now and Start Learning)

Meet your Trainer

  • Microsoft Excel Specialist
  • Microsoft Certified Trainer
  • Power BI Analyst
  • 55,000+ Students Trained

Ramzan is passionate about telling stories with data. Microsoft Certified Trainer,Excel Specialist with Power BI.

17+ years of experience in managing large databases, from requirements gathering through implementation and support.
Currently serving corporate clients across Gulf and Europe taking care of their training programs, helping them in preparing & analysing customized summaries & MIS Reports, Creating Dynamic HR, Sales & Financial Dashboards, Automating regular reports with Macros and Creating Interactive Dashboards using Power BI

Have conducted sessions in corporates such as Ferrari, Landmark, National Bank of Fujairah, Roche, King Span and many other companies in UAE, India, Saudi Arabia, Oman, Qatar, Malaysia & Maldives with excellent feedback.
Have trained more than 55,000+ people from various companies from Junior to Senior management across GCC locations.
Ramzan helps answering business questions using data in creative ways.

Click to Start Learning - AED 99

Earn your Excel Dashboard Expert certification

Yes, you will receive certification from a Microsoft Certified Trainer, which lends a lot of credibility to your certificate and resume. 

Get Certified by Micorsoft Certified Trainer
(Click to Start Learning : AED 99)

You may not believe me, but you can believe them

Experiences shared by people who previously attended this workshop

Get Lifetime access for this Dashboard workshop in just AED 99

Still Wondering If the Workshop is for YOU?

Please check all boxes, where your answer is YES!

If you checked ANY of the boxes above, then you’re invited to join The Modern Excel Dashboard Workshop 

I Am Ready To Invest In Myself Now!

Frequently Asked Questions

We have answered all common questions below that you might have about the workshop. For any further queries, please reach us at contact@upgradeskill.ae

I made the payment but didn’t receive any email

Write to us at contact@upgradeskill.ae and our support team will be able to resolve your issue in the shortest amount of time.

Will this be live or pre-recorded?

The workshop is completely Pre Recorded, so that you can watch and repeat anytime.

How much experience do I need for this workshop?
There is no prior experience required for this workshop.
Can I get a refund?
No. We do not offer refunds in any case. If you are unsure about the workshop, read testimonials, learn more about the trainer, and make an informed decision. If you miss the live workshop, we will move you to the next batch only ONCE.
Will I get a certificate after completion?

Yes, you will receive a certificate of completion from a Microsoft Certified Trainer after completing the workshop. 

What is the time zone?

As its already Recorded, hence you can watch as per your flexibility

Join the Excel Dashboard Mastery Workshop Now