Build Interactive Excel Dashboards with Real Data & Projects

Learn what dashboards are, their benefits, best practices, and how to create them using Excel. Master data visualization principles applicable to Power BI, Tableau, and more.

Learn key data visualization best practices, including choosing effective visuals, formatting charts, storytelling, and avoiding common mistakes. Master essential charts like bar, line, scatter, and maps for clear communication.

Discover why data visualization matters! Learn how visuals simplify complex data, reveal patterns, and enhance decision-making. See firsthand how charts improve understanding compared to raw data.

Learn how to choose the right chart by understanding data types, communication goals, and audience needs. Explore essential visuals like KPI cards, line charts, bar charts, pie charts, scatter plots, and maps.

Learn how to improve chart clarity by eliminating noise, formatting axis labels, adding context, and using colors strategically for better storytelling in data visualization.

Enhance data storytelling with clear titles, strategic labels, and effective formatting. Avoid common visualization mistakes like incorrect chart types, cluttered visuals, and inconsistent colors for better insights.

Kickstart your first project as a data visualization specialist! Learn to choose the right chart, eliminate noise, and tell a compelling story using a stacked area chart in Excel.

Learn how to create a stacked area chart in Excel to visualize music industry trends. Compare line charts vs. stacked charts and adjust data order for clearer storytelling.

Learn how to clean up your Excel chart by removing noise, formatting axes, adjusting labels, and replacing legends with direct annotations for better clarity.

Enhance your Excel chart to tell a compelling story using colors, labels, and annotations. Highlight key trends, market shifts, and the impact of digital formats effectively.

Learn key dashboard design principles, including exploratory vs. explanatory dashboards, selecting the right visuals, adding context, and designing effective layouts for better decision-making.

Learn how to define a clear purpose for your dashboard by identifying the audience, their needs, and key metrics. Discover best practices for selecting visuals and adding filters effectively.

Learn the importance of adding context to dashboards. Discover how comparisons, trends, and benchmarks make KPIs meaningful, ensuring clear insights for better decision-making.

Learn how to design effective dashboard layouts using reading patterns, visual hierarchy, and Gestalt principles to guide users through insights clearly and intuitively.

Kick off your first full Excel dashboard project! Learn how to define objectives, select key metrics, choose visuals, and prepare data for an interactive job market analysis dashboard.

Start building the Excel dashboard by preparing data for visualization. Learn how to create industry filters, remove duplicates, sort data, and set up interactive selections for analysis.

Learn to calculate the average annual wage by industry in Excel using the AVERAGEIFS formula. Format the data properly and verify calculations to ensure accuracy.

Create a bar chart in Excel to visualize average annual wages by industry. Apply formatting best practices, adjust spacing, and customize axis labels for better readability.

Sort bar chart data in descending order for better readability. Fix sorting issues caused by sheet references and adjust axis settings to align the chart correctly.

Calculate total employees by industry using SUMIFS. Format the data and create a doughnut chart to visualize the job market composition. Apply best practices for better readability.

Improve the doughnut chart by grouping industries into "selected" and "others." Use VLOOKUP for dynamic selection, format labels as percentages, and enhance readability with best practices.

Compare wage and employee trends over multiple years. Use AVERAGEIFS and SUMIFS, fix X-axis labels, apply a secondary axis, and create a combo chart for better trend visualization.

Enhance chart readability by splitting the combo chart into two while maintaining a unified look. Format labels, axes, and scales to improve data clarity and visual comparison.

Create a state-wise comparison map for employee distribution. Prepare data, use SUMIFS for calculations, and insert a map chart to visualize workforce concentration across industries.

Normalize employee distribution using per-thousand capita. Use Excel's geography data type for state populations, compute employee ratios, and update the map for a more accurate industry-based workforce distribution.

Enhance the map visualization by adding an average wage metric and a toggle feature. Learn how to dynamically switch views and adjust map colors for clearer insights.

Learn how to design the final dashboard layout by strategically placing visuals, filters, and selectors. Follow a structured approach to ensure readability, alignment, and an effective user experience.

Learn how to use color strategically in your Excel dashboard to improve clarity. Highlight key metrics with consistent color coding, adjust chart formatting, and enhance data visualization.

Enhance your Excel dashboard by dynamically highlighting selected industries in bar charts. Learn to create a new data series, apply conditional formatting, and improve data readability.

Improve user experience in your Excel dashboard with form controls. Learn to sync selections, use spin buttons, apply the INDEX function, and create interactive option buttons.

Finalize your Excel dashboard with formatting, logos, and protection. Learn to secure sheets, enhance visuals, and validate insights for a professional, user-friendly experience.

Start your second Excel dashboard project! Design a sales performance dashboard for Mojo Toys using key metrics, interactivity, and advanced Excel techniques for insightful business decisions.

Define the dashboard’s purpose through a quiz! Identify key metrics, visuals, and filters for effective sales tracking. Prepare to dive into data in the next module.

Convert data into an Excel table, create filters for region and date, and set up dynamic formulas for automatic updates. Prepare your dataset for a responsive dashboard.

Assign names to key cells for easier formula management. Use the Name Manager to enhance readability and simplify referencing in your Excel dashboard calculations.

Calculate key KPIs like total revenue, previous year revenue, and previous month revenue. Use structured formulas and named references for better readability in your Excel dashboard.

Create dynamic KPI cards for total revenue, year-over-year, and month-over-month changes. Use text boxes and linked images to display values with conditional formatting in your dashboard.

Build a dynamic revenue trend analysis for current and previous years using SUMIFS with mixed references. Format and validate data for accurate trend visualization in your dashboard.

Create a dynamic line chart to visualize revenue trends. Fix axis labels, handle missing data correctly, and format the chart for clear insights and professional presentation.

Prepare store performance data by calculating total revenue, previous month revenue, and month-over-month percentage change. Ensure data accuracy and formatting before visualizing it in the next module.

Visualize store revenue and month-over-month percentage change using bar charts. Format the charts for clarity, align labels, and use color coding for positive and negative values.

Sort revenue data dynamically using ranking and index-match functions. Ensure charts update automatically with data changes, maintaining proper order and formatting.

Identify the top and bottom-performing products driving revenue changes. Learn how to rank products, calculate performance metrics, and display insights effectively in your Excel dashboard.

Set up your dashboard layout for clarity and efficiency. Learn how to position key metrics, format elements, and organize visuals to guide users through a logical data story.

Learn how to bring visuals from the Dataprep sheet to your dashboard. Align elements, format data, and structure your Excel dashboard for a professional look.

Enhance your dashboard with strategic color usage and dynamic highlights. Learn how to emphasize key trends, create interactive filters, and format charts for better insights.

Refine your dashboard with storytelling techniques. Learn how to pose key questions, add contextual insights, and format data for clarity, making your dashboard more intuitive and impactful.

Learn how to securely share your Excel dashboard online using OneDrive. Set permissions, protect data, and enable real-time collaboration for seamless access across different regions.

Fixing linked picture issues in Excel Online by using text boxes and dynamic formulas. Learn how to add conditional formatting, symbols, and finalize your KPI dashboard for seamless online access.

Kickstarting our final project! We'll transform raw hotel booking data into a compelling, explanatory dashboard for leadership. Learn visualization techniques, layout design, and exporting insights.

Understanding the story behind our data! We'll analyze key trends in cancellations, revenue loss, and booking patterns to craft a compelling dashboard for hotel management.

Defining our dashboard's purpose and visuals! Through a quick quiz, we determine the right audience, goals, and best chart types for effective data storytelling.

Building a combo chart to visualize seasonality! We align dual axes, refine grid lines, and use colors, markers, and labels to highlight key trends in cancellation rates and pricing.

Highlighting revenue loss due to cancellations! We use a column chart, format data labels, adjust colors, and add annotations to emphasize the loss in July and August.

Learn a smart trick for conditional formatting in data labels! Format values dynamically to show in millions or thousands based on their size for a cleaner, more professional look.

Visualize cancellation breakdown by lead time using a stacked bar chart! Learn how to switch from a pie chart for better clarity and storytelling while saving space.

Learn how to compare lead time with cancellation rate and average daily rate using bar charts. Discover a trick to display selective pivot chart data for better visualization!

Learn how to design a structured Excel dashboard by setting up a layout for problem and opportunity insights. Prepare for the next step—adding visualizations!

Now that our layout is ready, we’ll place the visualizations onto the dashboard. Watch as we align and adjust them for a clean, professional look!

We finalize our dashboard by adding titles, subtitles, and a compelling narrative. Learn how to effectively present insights and drive strategic recommendations for leadership decisions!

Learn how to save your Excel dashboard as an image for easy sharing. Follow these steps to ensure a high-quality, non-transparent snapshot of your final project.