Excel Charts Course: Basic to Advanced

Learn to design purpose-driven, simple Excel visualizations with professional colors, clear key insights, and appropriate chart types for trends, comparisons, and relations, making them readable in 10 seconds.

Learn to insert and customize charts in Excel, including clustered column charts, data selection, axis titles, legends, data labels, and trend lines.

Learn to format individual chart elements in Excel by selecting axes, legends, or data labels and applying element-specific formatting, including secondary axis and grid lines.

Learn to change chart types and add a secondary axis in Excel charts, using combo charts to compare two data series with different scales.

Learn to create, customize, and save chart templates in Excel to apply consistent formatting across new charts, including color, borders, line styles, and axis settings.

Learn to create and customize bar and column charts in Excel to compare revenue by category and by month, including multi-dimensional and stacked options with legends and axis formatting.

Learn to create line charts and trend lines in Excel, visualize patterns, forecast future trends with linear or polynomial options, and interpret the R-squared value on the chart.

Create area charts in Excel to visualize changes over time, such as revenue by services by month and its trend.

Explore how to create and customize pie and donut charts in Excel, including when to use each, how to display percentages, and how to compare categories and multiple metrics.

Acquire skills to create box and whisker charts in Excel 2016 and later, analyze data distribution using quartiles, median, min and max, and identify outliers.

Create waterfall charts to visualize changes in net income and spending from positive and negative contributions, using subtotals to highlight income statement, balance sheet, and cash flow effects.

Create a funnel chart to visualize progress across stages, showing percent of total and percent outstanding, with color adjustments to enhance clarity.

Learn to create radar charts to compare multiple items across criteria, using scaling to normalize data and reveal patterns in seasonal sales and survey results, limit categories to maximize impact.

Create and customize heat maps in Excel using color scales to visualize seasonal temperature trends, with dynamic updates via formulas and data validation, and hide values using custom formatting.

Explore creating geospatial power map charts in Excel to visualize state and country data, using color, size, labels, and 3d map options to compare population, income, and unemployment.

learn to create combo charts in Excel that visualize two datasets on different scales using a secondary axis, blending a column chart with a line chart for clear insights.

Learn to create sparklines in Excel, customize tiny charts for dashboards, highlight high and low points, set axis min and max, and color-code positive or negative contributions.

Learn to create an image overlay chart in Excel by using a 100% column chart behind a thermometer, with transparent background, removed axes and gridlines, and 0–100 percent axis settings.

Learn to highlight special date ranges in Excel charts by creating a 0/1 helper column, building a combo chart, and formatting series to visualize campaigns like Thanksgiving and Christmas.

Discover how to keep Excel charts automatically updated as you refresh data sets by using offset-based dynamic ranges, named ranges, and data validation for interactive selection.

Learn to create an interactive scroll-and-zoom chart in Excel using form controls, offset-based dynamic ranges, and a combo chart on primary and secondary axes to reveal varying data points.

Learn dashboard tricks in Excel to build dynamic charts with scroll and zoom, shapes, and interactive controls. Leverage offset, named ranges, and index/match to drive responsive dashboards.

Learn to create an animated Excel chart that updates automatically with a year selector using a spin button, linked chart title, and hidden data, enabling dynamic comparisons.

Learn pivot charts in Excel to summarize revenue and expense by year and month with slicers, link multiple charts to one data set, and build a dashboard with formatting.

Learn to apply value-based color formatting to charts by categorizing data into four thresholds using the percent rank formula and conditional logic to highlight series.

Dynamically highlight selected cities in an Excel chart by building a dynamic data series and applying colors to emphasize the chosen category.

Learn to create a pacing chart in Excel that plots monthly revenue, cumulative revenue, and monthly targets with a line chart and conditional formatting to highlight under or over performance.

Learn to build an Excel gauge chart by combining a donut chart with slices and a needle, using radians and trigonometry to show target versus actual.

Create a 100-box percentage grid in Excel with a scatter plot, linking percentage calculations to empty and filled boxes to visualize target progress.