Excel Advanced Charts & Visualization Techniques

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!


Leave a Reply