Excel Data Visualization & Interactive Dashboard Course

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Unlock the true power of Excel with this hands-on, project-based course designed to make you a pro in data analysis and dashboard creation. Whether you’re a student, job seeker, or working professional, this course will equip you with real-world Excel skills like analyzing data with Pivot Tables, building insightful Excel Charts, and creating dynamic interactive dashboards for sales and HR data.

From mastering essential elements and controls to building visually appealing dashboards, this course takes you step-by-step through practical examples, helping you build skills that employers truly value.

This course is ideal for those who want to go beyond formulas and dive into the visual and analytical power of Excel. By the end of the course, you will be confident in building interactive dashboards from scratch and using Excel as a powerful business intelligence tool.

Show More

What Will You Learn?

  • How to summarize large datasets using Pivot Tables
  • How to create professional and dynamic Excel Charts
  • Step-by-step process to build an Interactive Sales Dashboard
  • Use of Form Controls and Elements (Drop-downs, Sliders, Buttons) to make dashboards interactive
  • Create a complete HR Dashboard with real-time insights
  • Best practices for formatting, designing, and presenting dashboards
  • Tips to automate and update dashboards easily

Course Content

Section 1: Analyzing Data with Pivot Table

  • Pivot Table Essentials: What, Why & How to Build Your First Report in Excel
    10:46
  • Customizing Pivot Table Layout with Design Tools in Excel
    05:02
  • Summarize, Format & Group Data in Pivot Tables like a Pro
    07:53
  • Enhance Pivot Reports with Interactive Slicers and Timelines
    08:25
  • Advanced Pivot Features: Calculated Fields, Filter Pages & Drill Down Data
    07:15
  • Calculating % of Grand Total in Pivot Reports
    01:41
  • Analyzing Data with % of Column Total and % of Row Total
    03:23
  • Understanding % Of and Parent Totals in Pivot Tables
    11:08
  • Comparing Values with Difference From and % Difference From
    01:35
  • Tracking Progress with Running Total and % Running Total
    02:12
  • Ranking Items Dynamically with Show Values As
    01:51
  • Using Index to Analyze Relative Importance in Pivot Tables
    03:51

Section 2: Excel Charts

Section 3: Creating Interactive Sales Dashboard

Section 4: Elements & Controls for Intractive Dashboard

Section 5: Creating Interactive HR Dashboard

Student Ratings & Reviews

No Review Yet
No Review Yet