Excel Charts, Infographics & Data Visualization Masterclass

Copy Excel charts into Word or PowerPoint using five options: destination theme, source formatting with link data, embedding with destination or source theme, or paste as a picture.

Explore how to choose the right chart in Excel using recommended charts, compare six chart types with monthly website visitors data, and learn when to adjust suggestions.

Create engaging data visuals by building advanced pie and donut charts, including multi-series donuts and dynamic trackers, to illustrate emissions, population, and energy improvements in reports and dashboards.

Use area charts in Excel to visualize change over time. Explore stacked and 100% stacked area charts to compare emissions by region and sector.

Create a totally interactive geospatial visualization in Excel by building a map chart of biocapacity and eco footprint across countries, then fine-tune projections and filter with slicers and tables.

Learn how sunburst charts visualize hierarchical data in Excel 2016+. Concentric rings from inner to outer levels reveal relationships within the data.

Create a histogram in Excel to visualize salary distribution across bins, adjust bin width and bin count, manage underflow/overflow, and add data labels for clarity.

Explore how a box and whisker chart displays variation and key statistics—maximum, minimum, median, and average—for states such as California and Texas.

Create Pareto charts in Excel 2016+ (Office 365) to visualize the cumulative percentages of sales data in a combined column-and-line chart, without pre-sorting.

Emphasize key events in data visualizations by highlighting a single value with bar, donut, or pie charts, using formatting, data labels, and sorting to guide audience focus.

Learn to make data self-documenting with trend-based conditional formats in Excel, using color scales, data bars, and icon sets to highlight trends and anomalies across a data block.

Learn value-based conditional formatting to highlight criteria in worksheets, including top/bottom rules and custom formats. Identify duplicates with highlight cell rules and flag recycling rates below 48%.

Learn to create an interactive infographic in Excel using the people graph add-in, customize types and themes, and link data with option buttons and VLOOKUP for a dynamic chart.

Create a progress doughnut chart in Excel to visualize percentage completion toward a goal. Apply conditional formatting to color the segments and add centered labels linked to data.

Create a dynamic heat map in Excel by linking a scroll bar to an index-based data slice and applying a conditional color scale to display monthly earnings by year.

Learn to build a dynamic Excel line chart with max and min dots, colored green and red, by overlaying a scatter series and using absolute references and if formulas.

Learn to create dot plots and dumbbell charts in Excel to compare one, two or three data points, format data labels, adjust axes, and use error bars.

Create a Gantt chart in Excel using start dates, durations, and end dates, then refine with a stacked bar method, axis range adjustments, and data labels.

Design a frequency distribution chart in Excel by building a histogram with bins and class limits, using pivot tables to count scores and add cumulative percentages.

Create interactive Excel charts by using a combo box form control to dynamically update data via a staging table and an index function, delivering a responsive clustered column chart.

Toggle 2019 sales in a dynamic combo chart with a checkbox. Learn to insert and format the checkbox, link a cell, and switch chart types to show or hide data.

Use a list box to select a country and dynamically update two clustered column charts for sales and net sales, using index and column functions across the dashboard's three layers.

Design a traffic light dashboard in Excel using three traffic light visuals, titles, and formatting, then link each light to calculation data with the camera tool to mirror cell values.

Create sparkling charts and a sales dashboard by merging cells and inserting sparklines. Configure data ranges to visualize product metrics and apply these techniques to any dashboard.