Khóa học chuyên sâu về Biểu đồ Excel, Infographics & Trực quan hóa Dữ liệu

COMPLETELY UPDATED — 2025 EDITION WITH NEW VIDEOS

Stop patching together YouTube tutorials. Learn everything in one place, in the right order.

Data visualization is one of the most valuable skills in modern business — and Excel is far more powerful than most people realize. This course takes you from the fundamentals of why charts work, all the way to building animated, interactive, executive-level dashboards entirely inside Excel.

By the end, you will be able to:

• Build 50+ chart types — from simple bar charts to advanced Mekko, Fan, Tornado, and Bullet charts

• Create fully interactive dashboards with drop-downs, scroll bars, and dynamic filters

• Design professional infographics directly inside Excel — no extra tools needed

• Know exactly which chart type to use for any data scenario

• Apply conditional formatting to tell visual stories without even using a chart object

• Automate and animate charts using VBA macros

What's inside — section by section:

1. Foundations of data visualization — Why charts work, the 4-step framework for choosing the right chart, and how to confidently approach any visualization challenge.

2. Charting techniques & formatting mastery — Chart elements, the Camera Tool, advanced custom number formatting, and every formatting option Excel offers.

3. 20+ built-in chart types, covered in depth — Line, column, bar, area, pie, histogram, waterfall, funnel, Pareto, Gantt, treemap, sunburst, box & whisker, geospatial maps, and more.

4. Conditional formatting as a visualization tool — Heat maps, data bars, icon sets, in-cell sparklines, and trend-based color scales — powerful visuals without a single chart object.

5. Infographics in Excel — People graphs, progress doughnuts, waffle charts for KPIs, tube charts, 3D donuts, and pictographs — built entirely inside Excel.

6. Advanced custom charts — Speedometer gauges, lollipop charts, bullet graphs, panel charts, fan charts for forecasting, Mekko/Marimekko, and more.

7. Interactive & dynamic charts — Drop-downs, option buttons, check boxes, list boxes, and scroll bars — charts that actually respond to user input in real time.

8. Animated charts & VBA macros — Rollover charts, animated visuals, macro-driven dashboards, and a fully interactive visualization map using 3D Maps.

9. Real-world dashboard projects — Apply everything you've learned to build two complete, professional dashboards from start to finish.

Your instructor: Andreas is a Microsoft Certified Expert with over 25 years of experience running his own computer learning school. He now teaches students in 150+ countries and brings real classroom structure to every lecture — practical, clear, and built around actual business problems.

Everything included:

• 10+ hours of high-quality video content

• 50+ downloadable project files (including code-free versions to follow along)

• 50-page PDF reference guide with a detailed table of contents

• Quizzes and homework exercises after every section

• 1-on-1 instructor support

• Lifetime access and a certificate of completion

Compatible with Excel 2013, 2016, 2019, and 365 — PC and Mac. Only basic spreadsheet experience required.

Not satisfied? 30-day money-back guarantee — no questions asked.

Enroll now and make your data impossible to ignore.