Microsoft Excel Dashboard Infographics Masterclass Volume 1

Kick off the Microsoft Excel dashboard infographics masterclass volume 1 with an introduction to the course.

Learn to design a KPI chart in a Microsoft Excel dashboard, using color coding, numbers, and range-based formatting to visualize positive and negative values.

Create a project gantt chart in Excel by mapping each activity's status with an IF formula, calculating days, and applying conditional formatting to show complete and incomplete tasks.

Learn to build a capsule chart in Excel to visualize pharmaceutical sales data, combining stacked bars with shapes, data labels, and dashboard‑ready formatting for industry dashboards.

Learn to create a tornado chart, also called a butterfly chart, to compare two groups across metrics such as productivity, efficiency, attrition, absenteeism, conversion, and quality in Excel.

Design a target vs achieved chart in Excel by preparing data, creating a stacked column chart with a secondary axis, and applying formatting, data labels, and a scrollable employee selector.

Build a dynamic progress bar chart in Excel linking service level, efficiency, and conversion to a 100% stacked horizontal bar with spin buttons, showing real-time changes.

Explore building and customizing a pyramid chart in Excel to visualize data with colored sections, axis adjustments, labels, and formatting options for clear infographics.

design a traffic signal chart in excel to visualize service level, efficiency, and conversion using red, yellow, and green indicators that respond to thresholds below 50, 51–80, and above 80.

Explore creating a lollipop chart to visualize data as modern dashboard infographics in Microsoft Excel, translating complex data into clear, engaging visuals and targets.

Learn to design a moving trophy chart in an Excel dashboard by selecting data, moving images, and building a clear, global infographic.

Explore using a spider web chart to visualize monthly sales data with infographics in a Microsoft Excel dashboard, highlighting month-by-month trends and easy comparison.

Learn to build a validation chart in Excel that highlights invalid data outside the valid month range (January–December) using data validation and highlighting to flag outliers on dashboards.

Design a star rating dashboard in Excel to visualize seven employees' performance as a 1–5 star scale, with formatting tips and steps to convert the chart into a picture.

learn to build a dynamic cylinder chart in Excel to visualize monthly target attainment with red and green liquid indicators and if function based data for dashboards.

Design a KPI cylinder chart in Excel to visualize service level, sales conversion, operational efficiency, net promotions, and first call resolution. Prepare supporting data and convert to cylinders.

Learn to build a circle (donut) chart in Excel to visualize service level and performance metrics, using supporting data, donut hole size, secondary axis, color tuning, and dynamic labels.

Design a human chart in an Excel dashboard infographic using employment data by gender and age. Learn to assemble data, adjust axes, and insert human figures to visualize workforce insights.

Master the timeline tool to present large data clearly in Excel dashboards, learn to design timelines that highlight monthly trends and enable fast, readable data visuals.

learn to build a target chart in Excel for dashboards, including preparing data, inserting a chart, and formatting visuals to create compelling infographics.

Discover how to create balloon charts in Excel dashboards, adjust colors, labels, and arrangement, and visualize data with balloon-sized markers.

Learn to build a population chart within an Excel dashboard, visualize population distribution, and apply color controls for clear infographics.

Create a bike race chart in Excel using a pie chart, then customize the visuals by removing outlines, adjusting colors, and adding design elements for your dashboard-friendly presentation.

Learn how to create a project timeline chart in Excel by plotting milestones with dates, adding a baseline and values, and formatting lines, error bars, and labels.

Design and build a battery cell chart in Excel, exploring multiple methods to visualize battery life, customize with labels, and set min and max values.

Create a heatmap chart in Excel using green, amber, and yellow color scales to visualize performance against a target and reveal distribution across data.

Design a speedometer chart in Excel and customize its colors, labels, borders, and fonts to create a clean dashboard infographic, using a template to tell the data story.

Learn to build a flight chart in Excel by creating a line with markers chart, adding an orange target line, transforming markers to airplane icons, and styling with sky fill.

Celebrate completing the Microsoft Excel dashboard infographics masterclass volume 1 and share your feedback to help design better courses; engage in the Q&A and continue your journey toward graphics excellence.