Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Charts

via YouTube

Overview

Learn how to create dynamic and visually appealing charts and graphs in Excel. This course covers a wide range of topics including creating Gantt charts, variance charts, stacked charts, and more. By the end of the course, you will be able to improve the readability of your charts, visualize data effectively, and create impressive visual representations in Excel. The course is designed for individuals who want to enhance their data visualization skills using Excel.

Syllabus

Excel Charts & Graphs: Learn the Basics for a Quick Start.
How to create a dynamic map chart with drop-down (works with ANY Excel version).
Quick Gantt Chart in Excel (Unusual technique).
Fully Featured Excel Gantt Chart - actual, planned & percentage completed.
Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW).
Excel Charts: Matrix or Excel Panel Charts - Showing many variables at once.
Improve readability of Excel Line Charts: Dynamic Legends in Excel.
Excel Advanced Charts: Comparison to Budget, Previous Year and Forecast or Outlook.
3 Tips for Impressive Excel Charts.
Microsoft Excel: How to Improve your Charts & Tables for Better Communication - Promo.
Excel Charts: Visualize your KPI on a map in ANY version of Excel.
Excel Charts: Sorted Bar Chart as Alternative to the Pie Chart.
Excel Tables: Best Practice to Create Tables for Financial Reporting in Excel.
How to Conditionally Format Symbol colors in Excel Tables (without Conditional Formatting).
Excel Tables: Use Smart Conditional Formatting for great table layout.
Excel Variance Charts: Actual to Previous Year or Budget Comparisons.
Better Excel Variance Charts to show percentage change (Simple & uncommon technique).
Excel Arrow Variance Chart: Dynamic Arrows in Chart to Show Change to Previous Year / Budget.
Excel Charts: Total Values for Stacked Charts in Excel.
Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability.
Excel Charts: How To Show Percentages in Stacked Charts (in addition to values).
How to add series lines / connectors to stacked column charts in Excel.
Skip Dates in Excel Charts (ignore gaps in Excel horizontal chart axis).
Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis).
Optimized Excel Line Charts: Prevent drop to zero & dynamic Legend positioning.
Excel Dynamic Chart with Drop down List (column graph with average line).
3 REALLY Useful Excel Chart Tips You May Have Missed.
Excel Column Chart - Stacked and Clustered combination graph.
How to create a Step Chart in Excel (that is fully dynamic & easy to read).
Easiest Step Chart in Excel (this trick will surprise you!).
Dynamic WordArt in Excel with Bar in Bar Chart (Info-chart that shows % completion).
Excel VBA: Adjust Fill Color of WordArt with a Macro.
Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel).
Excel Conditional Bar Chart with Drop-down & Icons (This Chick's Trouble for Excel Hash).
How to Create a Sales Funnel Chart in Excel (Not the "usual" Funnel).
Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts).
Charting Survey Results in Excel (Visualize Employee Satisfaction results).
Progress Circle Chart in Excel as NEVER seen before!.
5 Eye-Tracking Discoveries for OPTIMAL Chart Design - Do you use these?.
Simple Excel Trick to Conditionally Format Your Bar Charts.
How To Create A Histogram in Excel (& change the bin size).
Excel Column Chart | Replicating COVID-19 Overlapped Bar Chart.

Taught by

Leila Gharani

Reviews

Start your review of Excel Charts

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.