The Complete Excel Course with AI Integration

Build a chart dashboard in Excel

Anyone can insert a chart; the skill is knowing which chart answers the question. In The Complete Excel Course with AI Integration you learn it on an industry-standard project, the Marketing Engagement Dashboard, designed after talking with people from many different industries: a year of marketing figures across eight channels, turned chart by chart into visuals a manager reads in a meeting. You make column, line, pie and combo charts, sparklines, funnels, waterfalls and treemaps yourself, in Excel alone.

Taught by Sagnik Bhattacharya and Virginia Thorn

The Complete Excel Course with AI Integration: Sagnik Bhattacharya and Virginia Thorn

What you will be able to do

You will be able to:

  • Match a chart to its question: columns or bars to compare, a line for a trend, a pie for shares of a whole, a combo for two measures on different scales.
  • Build a combo chart with revenue as columns and sign-ups as a line on a secondary axis, and judge when a second axis helps and when it confuses.
  • Format a chart until it reads at a glance: a title that says what it shows, only the chart elements it needs, bar spacing, fills, borders and effects.
  • Add line, column and win-loss sparklines beside a table, giving every row its own trend without a full-size chart.
  • Use a funnel for drop-off between stages, a Pareto for the few causes behind most incidents and a waterfall for how gains and losses reach a final figure.
  • Show how values spread with a histogram and a box and whisker chart, and how a total divides by region, country and channel with a sunburst and a treemap.

Projects

What you will build.

The course has 14 industry-standard projects. These two matter most here.

  • Project 04

    Marketing Engagement Dashboard

    Nine charts, each picked for the question it answers.

    The project at the centre of this page: a starter workbook of marketing figures across eight channels that you turn into a full set of charts, sheet by sheet, with the finished workbook to compare.

  • Project 01

    Personal Budget Tracker

    Your first workbook: where the money goes each month.

    Category totals gathered from a transactions sheet into a summary, then a pie chart with percentage labels: the first chart of the course, and it follows the totals as they change.

Tap or pinch to zoom in, drag to move around. Click or scroll to zoom in, drag to move around.

Lessons

The lessons that matter, in course order.

The Complete Excel Course with AI Integration has 186 lessons. This page picks out 11 of them, 1 h of video. Each lesson keeps its number in the course.

Where to start

Lesson 48 Choosing the right Excel chart

Start at Lesson 48 if you can already select a range and insert a chart: the starter workbook holds a year of campaign data ready to chart. Never made a chart? Begin at Lesson 16, and at Lesson 1 if Excel itself is new. With the charts done, slicers and PivotCharts follow from Lesson 62, and MarketPulse puts charts, KPI cards and slicers on one interactive dashboard from Lesson 105.

11 of 186 lessons · 1 h

02 Project: personal budget tracker 2 of 5 lessons · 15 min A summary built from another sheet, then a first chart: category totals pulled from the transactions sheet onto the dashboard sheet, a pie chart, percentage labels, chart styles and the chart filter.
  1. 16 Monthly expense summary in Excel Category totals for a personal budget tracker 7 min
  2. 17 Excel charts for beginners Pie chart of budget expenses by category 8 min
06 Data visualisation: charts and graphs 9 lessons · 45 min The Marketing Engagement Dashboard, chart by chart: choosing the right chart; column, line, pie and combo charts; the Format pane in depth; line, column and win-loss sparklines; funnel, Pareto and waterfall; histogram, box and whisker, sunburst and treemap.
  1. 48 Start here Choosing the right Excel chart Column, line, pie, combo and modern chart types 4 min
  2. 49 Column charts in Excel Insert, format and label a column chart 5 min
  3. 50 Line charts in Excel Show trends over time with a line chart 4 min
  4. 51 Pie charts in Excel Show proportions and parts of a whole 4 min
  5. 52 Combo charts in Excel Column and line chart with a secondary axis 4 min
  6. 53 Formatting charts in Excel Titles, data labels, colours and chart styles 7 min
  7. 54 Sparklines in Excel Line, column and win-loss mini charts in cells 5 min
  8. 55 Funnel, Pareto and waterfall charts in Excel Modern charts for business data 5 min
  9. 56 Histogram, box and whisker, treemap and sunburst Advanced Excel chart types 6 min

Instructors

Who teaches it.

Virginia Thorn smiling at the camera, dark hair tied back, wearing a navy top.

Instructor, Excel with AI

Virginia Thorn

Emmy Award winner. Teaches Excel with AI at Coding Liquids.

Questions

Asked before starting.

Which Excel course teaches the chart types and when to use each one?

The Complete Excel Course with AI Integration from Coding Liquids teaches both on one build: the Marketing Engagement Dashboard, an industry-standard project on a year of campaign data. Column, line, pie and combo charts come first, then sparklines, then the business charts (funnel, Pareto and waterfall) and the statistical and hierarchy charts (histogram, box and whisker, sunburst and treemap), and you make each one by hand alongside the question it answers. This page lines up 11 lessons, 1 hour of video, in Excel alone. Later, Copilot and ChatGPT draft charts for you to judge (Lesson 93), and the course ends with a Certificate of Completion.

What is the best Excel chart for comparisons, trends or percentages?

The one that fits the question, a rule The Complete Excel Course with AI Integration sets before any chart is drawn (Lesson 48). Comparing categories, such as sessions by channel, calls for a column or bar chart (Lesson 49). A trend over time, such as sign-ups month by month, calls for a line (Lesson 50). Percentages of one whole, such as sign-ups by channel, suit a pie, with one slice pulled out to draw the eye (Lesson 51). A timeline of tasks is a Gantt chart made from stacked bars, which TaskFlow draws (Lesson 83).

How do I make a chart in Excel with two y axes?

Build a combo chart, as The Complete Excel Course with AI Integration does with revenue and sign-ups (Lesson 52). Select the month, revenue and sign-up columns, choose Insert Combo Chart and take the preset that draws revenue as columns and sign-ups as a line on a secondary axis. The second axis gives the smaller series a scale of its own, so it no longer lies flat along the bottom. The lesson teaches the judgement too: add a second axis when the two measures tell one connected story, and your readers always know which axis to read.

Which Excel chart uses nested rectangles?

The treemap. Each rectangle's area stands for its value, and in The Complete Excel Course with AI Integration a table of revenue by region, country and channel becomes blocks you can compare at a glance (Lesson 56). The same lesson draws a sunburst from the same table, showing that hierarchy as rings, with regions at the centre and countries and channels around them. Reach for the treemap to compare sizes and the sunburst to follow the levels; both sit under All Charts in Recommended Charts.

How do I make a chart in Excel from data on different sheets?

Bring the figures together first, then chart them. In The Complete Excel Course with AI Integration the budget's category totals are formulas that reach into the transactions sheet, collected in a small table on the dashboard sheet (Lesson 16), and the pie chart is drawn from that table, so it changes when the totals do (Lesson 17). To chart only some columns, select the labels, hold Ctrl and select the values, as the sign-ups line chart does (Lesson 50); add more value columns the same way for more lines.

How do I turn Excel charts into an interactive dashboard?

Connect them to PivotTables and slicers, which The Complete Excel Course with AI Integration does in stages after the Marketing Engagement Dashboard. Slicers filter a PivotTable with clickable buttons (Lesson 62) and PivotCharts redraw from it as you click (Lesson 63); Copilot drafts a mini dashboard with KPIs, charts and slicers for region and channel (Lesson 98); and in MarketPulse, slicers and a timeline joined through Report Connections filter every PivotTable, chart and KPI card at once (Lesson 113). The chart choices you learn on this path decide what each of those screens shows.

When should I use a funnel, Pareto or waterfall chart?

When a plain bar chart cannot say where the problem is. In The Complete Excel Course with AI Integration the funnel shows the count at each stage of the customer journey, narrowing towards the final conversion so the biggest drop-off stands out; the Pareto ranks issue categories by incidents, and its cumulative line shows how few of them make up most of the total; and the waterfall walks monthly recurring revenue from its starting figure through each increase and decrease to the end (Lesson 55). For how values spread, the histogram and box and whisker follow (Lesson 56).

Is there an Excel chart dashboard template I can start from?

Start from a workbook instead of a template: The Complete Excel Course with AI Integration hands you the Marketing Engagement Dashboard as a starter file of campaign figures and has you build every chart on it yourself, with the finished workbook to compare. A template gives you charts wired to someone else's layout; once you have made a combo, a funnel, a waterfall or a treemap by hand, you can put any of them on your own figures, restyle it in the Format pane (Lesson 53) and know it says what you mean. The same goes for the sparklines that give every row of a table its own trend (Lesson 54), and lifetime access keeps each lesson there for the next report.

Excel with AI

See the whole course.

The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 industry-standard projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.

The same course

For another job, goal, level, topic or comparison.