What you'll learn:
- Build dynamic Excel charts that update automatically when new data is added using Tables, OFFSET, and Name Manager
- Create interactive charts with multiple views using INDEX MATCH to eliminate manual chart switching
- Set up automatic bar sorting with RANK and automatic series label positioning for line and stacked charts
- Apply conditional color formatting to highlight positive and negative values in charts and tables
- Build variance charts using two professional methods for actual versus budget and actual versus previous year comparisons
- Create bullet charts, pin charts, panel charts, box plots, Pareto charts, and Gantt charts from scratch
- Use dynamic annotations, error bar dividers, and visual techniques to direct reader attention to key data points
- Apply chart and table design best practices to produce cleaner, more readable management reports
Most Excel users know how to insert a chart. This course teaches you how to make charts that actually communicate.
There is a significant difference between a chart that displays data and one that directs attention, tells a clear story, and supports fast decision-making.
This course covers the techniques finance and reporting professionals use to close that gap, from dynamic auto-updating charts to advanced variance visualization methods you won't find in standard Excel training.
What you'll be able to do after this course:
Apply chart and table design best practices to produce cleaner, more readable reports
Build dynamic charts that update automatically when new data is added using Excel Tables, OFFSET, and the Name Manager
Create interactive charts that show different views using INDEX MATCH, eliminating manual chart updates
Set up automatic bar sorting using the RANK function so charts always display in the right order
Position series labels automatically for line and stacked column charts without manual adjustment
Use conditional formatting to color positive and negative columns, data labels, and table rows dynamically
Build variance charts using two professional methods for comparing actual versus budget or target
Create bullet charts (vertical and horizontal) for compact, precise performance measurement
Add dynamic annotations, vertical dividers, and error bars to direct reader attention to key data points
Design tables with smart color coding, symbols, and conditional formatting for faster readability
Build comparison charts for actual versus previous year using pin charts, symbols, and reference regions
Show predictive outlook development with continuous line series and visual dividers
Create advanced chart types: scatter, bubble, box plot, Pareto, panel, parts-to-whole, sparklines, and Gantt charts with completion tracking
Build waterfall and bridge charts from scratch for financial flow visualization
Why this course goes beyond standard Excel chart training:
Most Excel chart courses teach you how to format charts. This one teaches you the underlying techniques: how to use OFFSET and Name Manager together for dynamic ranges, how INDEX MATCH powers interactive dashboards, how RANK drives automatic sorting, and how error bars can be repurposed as visual dividers.
These are transferable skills that work across any chart type you build in the future.
What's inside:
12 sections covering every major chart type used in corporate reporting
Dynamic chart techniques: auto-updating ranges, interactive views, automatic sorting and label positioning
Attention techniques: conditional colors, dynamic annotations, dividers, and table design
Performance comparison: actual vs budget, actual vs previous year, bullet charts, variance methods
Advanced chart combinations: scatter, bubble, box plot, panel, Pareto, Gantt, sparklines, waterfall
Exercises with answer files at the end of every section
Downloadable cheat sheets covering every chart type as a quick reference guide
Compatible with Excel 2010 and above including Microsoft 365
Taught by Leila Gharani, Microsoft MVP and trusted by 515,000+ students across 11 courses on Udemy.
Enroll now and start with the chart type most relevant to your next report.
