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 advanced chart formatting options, including dynamic titles linked to cells, axis formatting, error bars, and combining chart types for dashboards and templates.

Master advanced charting and formatting techniques in Excel by overlapping bar charts, creating negative bars, automatically highlighting the maximum and minimum values, and adding an average line for data visualization.

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 a clustered column chart to compare sales with defined lower and upper limits, then switch the limit series to lines with markers and customize with up and down arrows.

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.

Explore how a waterfall chart in Office 365 Excel 2016+ visualizes the cumulative effect of positive and negative values, using blue for increases, orange for decreases, and green for totals.

Learn five practical methods to create funnel charts in Excel 2016+ and Office 365, from built-in funnel charts to in-cell visuals and SmartArt pyramids.

Explore spark lines in Excel, mini in-cell charts that reveal trends in table-based data, using line, column, and win loss types; learn to create, customize, color, and manage them.

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.

Customize Excel charts to maximize clarity by adjusting appearance, axis scales, and elements like data tables, trend lines, and error bars, while using shapes and icons sparingly.

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%.

Apply conditional formatting to highlight values with data bars, colors, and icons, and create rules to visualize comparisons directly in Excel worksheets.

Learn to use icon sets, data bars, and symbols in Excel to visualize trends in limited dashboard space, creating in-cell charts and conditional formatting for at-a-glance insights.

Learn to insert Unicode symbols and up and down arrows in Excel charts using if statements and the if error function, then build a clustered column chart for dashboards.

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 Excel half progress doughnut chart to visually track completed versus remaining tasks, display 80% progress, and annotate with central and edge text boxes.

Design a tube chart infographic in Excel to visualize impressions, watch time, and click-through rate, using percent values, colors, and linked labels.

Learn to build a pictograph in Excel by replacing bars with fruit icons, formatting data series and axes, and refining layout for a clear, easy-to-read data visualization.

Learn to create waffle charts in Excel to visualize progress toward a goal using a 10 by 10 grid, conditional formatting, and the camera tool for clean, at-a-glance KPIs.

Learn to boost data visualization in Excel by using add-ins like people graph and bubbles, build pivot tables, count orders, and highlight collectible activities for clearer insights.

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.

Construct top and bottom ranking charts in Excel using large and small functions with if, by creating two columns for teams and wins.

Learn to create panel charts for side-by-side time comparisons by overlaying simple line and scatter charts, formatting series, and adding vertical dividers to clearly compare multiple data categories.

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.

Learn to build a timeline milestone chart in Excel to visualize planned milestones and progress, using date, activity, and text-placement helper columns and formatting steps.

Learn to create actual versus target charts in Excel, using two representations: stacked columns with distinct colors and a line chart with red target markers, including formatting tips.

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.

Map thousands of McDonald's locations worldwide in Excel using 3D maps, load a CSV dataset, clean data with Power Query, and animate data over time with color coding and themes.

Explore how to switch between multiple data views in dashboards using Excel form controls, enabling interactive buttons, check boxes, and scroll bars for reports across regions or markets.

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.

Create a dynamic Excel chart controlled by option buttons, using a staging table and nested if formulas to switch data for tobacco, cosmetics, candy, and soft drinks.

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.

Learn to build a dynamic on-demand chart with the rollover method in Excel, using index, match, averageif, countifs, iferror, hyperlink, and vba udev macros.

Discover how to visualize complex data in Excel with the Meco chart (Marimekko), a variable-width stacked chart that shows two categorical variables and market shares across regions.

Create an Excel dashboard using a traffic light technique to display monthly sales across products, with conditional formatting and data validation to select months.

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.