Beginner module
Syllabus covered
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 – Udemy 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 Charts: Matrix or Excel Panel Charts – Showing many variables at once
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
Intermediate module
Syllabus covered
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)
Quick Gantt Chart in Excel (Unusual technique)
Fully Featured Excel Gantt Chart – actual, planned & percentage completed
How to add series lines / connectors to stacked column charts in Excel
Skip Dates in Excel Charts (ignore gaps in Excel horizontal chart axis)
Advanced module
Syllabus covered
Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)
Excel Charts & Graphs: Learn the Basics for a Quick Start
Optimized Excel Line Charts: Prevent drop to zero & dynamic Legend positioning
Excel Dynamic Chart with Drop down List (column graph with average line)
Excel Dynamic Chart with Drop down List (column graph with average line)
Excel Column Chart – Stacked and Clustered combination graph
How to create a Step Chart in Excel (that is fully dynamic & easy to read)
How to create a dynamic map chart with drop-down (works with ANY Excel version)
Dynamic WordArt in Excel with Bar in Bar Chart (Info-chart that shows % completion)
Excel VBA: Adjust Fill Color of WordArt with a Macro
Expert module
Syllabus covered
Build Impressive Charts: It’s NOT your usual Bar Chart (Infographics in Excel)
Easiest Step Chart in Excel (this trick will surprise you!)
3 Handy Excel Chart Tips You Might Have Missed
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)
Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)
GUESS what’s HIDDEN in Excel? (Cool Trick)
Progress Circle Chart in Excel as NEVER seen before!