Creating Dashboard in Excel

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy

Course Description

Thanks for taking interest in learning the Excel Dynamic Dashboard.

I will teach you step by step how to create Dashboard from Huge database.

All this you will learn with Advanced Formulas techniques. No third party software required, no add ins required.

You will learn how to create

1) Drop down

2) Checkbox

3) Radio button

4) Scroll bar with practical projects.

5) Combination Chart

6) Dynamic HR Dashboard

7) Interactive Sales Dashboard

In this course i have not spent much time on Formatting, so only Core aspect of Dashboard construction which you need i have explained.

(Practice files available for all the topics)

Who this course is for:

  • Analyst, Finance, HR, Sales & Marketing

Course content

3 sections • 23 lectures • 4h 13m total length
  • 3) Creating Yearly Quarterly and Monthly Reports
  • 2) Refreshing Pivot Table
  • 4) Using Interactive Slicer and Timeline
  • 5) Comparing Yearly Data with Pivot
  • 6) Creating Dynamic Dashboard with Pivot Table


Microsoft Certified Trainer & Microsoft office Specialist
  • 4.6 Instructor Rating
  • 543 Reviews
  • 11,150 Students
  • 3 Courses

Ramzan carries more than 18+ years of experience in the field of IT Training & Project Management. After getting his Diploma in Information Technology he did his MBA with Dual Specialization in IT Project Management.

He has experience of designing, managing & implementing large databases bearing very good understanding and extensive experience in Advance Excel, VBA - Macros programming, advance Powerpoint, Excel Dashboard, MS Access & MSP (Microsoft Project).

Along with other companies around the world he has done trainings for the following companies in UAE - Dubai : Manipal University, Etisalat, World Bank Group, Sharjah Islamic Bank, Emirates NBD, Redbull, Carestream health, Rotana, Funcity, Johnson & Johnson, Mastercard, Dulsco, AstraZeneca & MAF (Majid al Futtaim Properties).

Ramzan is based in Dubai.