NEWExcel AI Agents: use Copilot and Claude in Excel, and prove every number is right. Excel AI Agents course. See the course →

Excel — Charts · Course on Udemy

Make Excel charts people actually understand

From choosing the right chart to dynamic, interactive visuals and infographics, with the project files to build every one yourself.

★ 4.8 from 1,185 ratings on Udemy · 88 lessons · 10.5 hours

Enroll on Udemy →Watch a free lesson first

30-day refund through Udemy · Lifetime access · Certificate of completion

Watch the course trailer (3:15)

Is this course for you?

A clear chart makes your point before anyone reads the numbers.

You will get the most from it if you…

  • present data in reports, slides or meetings
  • feel stuck with Excel’s default charts
  • want charts that update when the data changes
  • are working towards building dashboards

By the end you will be able to…

  • pick the right chart with a four-step process
  • build modern charts: treemap, histogram, waterfall, funnel, box and whisker
  • add infographics, in-cell charts and heat maps
  • create advanced charts such as gauges, bullet graphs, Gantt and tornado charts
  • make charts interactive with drop-down lists, check boxes and scroll bars

Ready to combine charts into dashboards? See the Excel Dashboard Masterclass.

A few of the charts you will build

Every chart comes with its project file.

01Speedometer gauge
02Bullet graph
03Gantt chart
04Tornado chart
05Waffle chart
06Panel chart
07Burndown chart
08Heat map
09People graph
10Traffic lights dashboard

What is inside

Four parts, from the right chart choice to interactive visuals.

1. Charting techniques and the basics

Why and how we visualise data, the four-step process for choosing a chart, chart elements, empty and hidden cells, then line, column, pie and area charts and the modern ones: treemap, histogram, box and whisker, Pareto, sunburst, waterfall and funnel.

2. Functions and formatting

The functions charts rely on, advanced chart formatting, custom number formats, conditional formatting, small multiples, in-cell charts, icon sets and heat maps.

3. Infographics and advanced charts

People graphs, progress doughnuts, tube and waffle charts, then gauges, bullet graphs, ranking charts, panel charts, lollipop charts, timelines, Gantt, burndown and tornado charts.

4. Interactive charts and a dashboard

Charts driven by drop-down lists, option buttons, check boxes, list boxes and scroll bars, macro-driven visuals, and a traffic lights (RAG) dashboard.

What students say

Reviews from students of this course on Udemy.

“I am a very experienced Excel user - but spent very little time in charts, graphs, and data visualization. This course was a great starter for me. The examples and exercises were not tedious or overbearing. I'll use surely use this as future inspiration and reference.”William M. L.
“Another great course from Andreas. Fantastic training with clear and concise instructions. Learned a lot new tricks about Excel Charts and already used them in my job. Thank you Andreas!”Jol S.
“Very very good course and very practical if you want to improve your presentation skills by use of visuals.”David N.

What is included

  • 88 video lessons, 10.5 hours
  • Project files for every chart
  • Lifetime access on any device, including the Udemy app for offline viewing
  • Certificate of completion
  • A Q&A section on every lesson
  • 30-day refund through Udemy

Your instructor

Andreas Exadaktylos, MSc in Computer Science, has taught Excel for over 25 years and runs Mellon Training.

More than 80,000 students have taken his courses on Udemy. He also publishes free Excel tutorials on YouTube and on this site.

Questions before you start

Anything else? Write to info@mellontraining.com.

Do I need Excel experience?

You should know the basics: entering data, simple formulas and inserting a chart. The course covers the functions charts need along the way.

Which version of Excel do I need?

A recent version of Excel. Modern charts such as treemap, waterfall and funnel need Excel 2016 or Microsoft 365, and those lessons are marked.

Where is the course hosted?

On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.

What if it is not right for me?

Udemy offers a refund within 30 days of purchase, under its refund policy.

Can I see a lesson before I buy?

Yes. Watch the free clustered stacked column chart lesson on this site, or the preview lessons on the Udemy course page.

Ready to make your charts clearer?

88 lessons, from the right chart choice to interactive visuals.

Enroll on Udemy →

FREE · TWO COMPLETE PACKS

Before you go: 28 Excel macros and 50 AI prompts, free

Ready-to-run macros with a practice workbook, plus the AI prompts I actually use for formulas, cleaning and analysis. Yours to keep.

No spam, ever. Unsubscribe with one click.