The Complete Excel Course with AI Integration
Build a KPI dashboard in Excel with slicers
One screen a manager reads at a glance and filters with one click: that is MarketPulse, the KPI dashboard you build in The Complete Excel Course with AI Integration. From raw campaign data you make everything behind it: the PivotTables, CTR, conversion rate and ROI, KPI cards, charts, a timeline and slicers, with the finished workbook to compare. It is an industry-standard project, designed after talking with people from many different industries, and it runs in Excel alone, every formula yours to change.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Prepare a campaign table for analysis: convert it to an Excel Table, remove duplicates and plan the KPIs with Copilot or ChatGPT before a chart is drawn.
- Build six PivotTables on a back-end sheet, from grand totals to channel, month and campaign views, each named and set apart so the dashboard can draw on it.
- Write CTR, conversion rate and ROI with IFERROR and locked references, so a zero never turns a headline figure into an error.
- Make KPI cards from shapes linked to single cells, with GetPivotData switched off, so each card shows a live total or rate.
- Wire a timeline and Channel and Campaign slicers to every PivotTable and chart, and filter the whole dashboard by date, by channel or by several campaigns at once.
- Finish it like a report people trust: thousands shown as K, one colour theme across charts, slicers and timeline, clear chart titles, and the gridlines and formula bar hidden.
Projects
What you will build.
The course has 14 industry-standard projects. These three matter most here.
-
Project 08
MarketPulse
One screen that shows which campaigns earn back their spend.
The dashboard on this page, from a starter workbook of campaign data to a decision screen: totals and rates on cards, spend against revenue by campaign, conversion share by channel, and filters for date, channel and campaign.
-
Project 05
SalesPlusPerformance
A sales question answered in seconds, straight from the order data.
Built on order-level sales data, it gives you your first PivotTable, dates grouped into months and quarters, a PivotChart on a sheet of its own and Refresh All: the base that MarketPulse's back end stands on.
-
Project 14
Agentic AI in Excel
AI finds and fixes the formula; you check it before it counts.
Built around Copilot, ChatGPT and Claude on real tasks, it includes a mini dashboard Copilot drafts from a few prompts and the QA checklist that decides whether its numbers can be trusted.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 23 of them, 1 h 38 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 105 MarketPulse marketing dashboard in Excel
Start at Lesson 105 if you have built a PivotTable before: the MarketPulse starter workbook is ready and the dashboard grows lesson by lesson. New to PivotTables? Begin at Lesson 59. New to formulas, at Lesson 10, or at Lesson 1 if Excel itself is new.
23 of 186 lessons · 1 h 38 min
01 Microsoft Excel fundamentals: building a foundation from scratch The formula habits behind every KPI: F4 and dollar signs that pin a reference, an expense shown as a percentage of income, and IFERROR turning #DIV/0! into a readable message.
- 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
- 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
- 12 Common Excel errors and how to fix them DIV0, NAME, VALUE errors and IFERROR 4 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) Excel Tables on an employee list: a table takes in each row added below it, so the PivotTables drawn from it never miss new data.
- 19 Excel tables Create and format a table, structured references and total row 8 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) Duplicates spotted with a highlight rule, then removed with Remove Duplicates, whole rows at a time: the check MarketPulse runs before anything is summed.
- 23 Remove duplicates in Excel Find and delete duplicate rows in an employee list 6 min
07 PivotTables and PivotCharts: data analysis made easy Your first PivotTable from a sales table, rows, columns and values in the field list, Value Field Settings, then dates rolled up into years, quarters and months.
- 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
- 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
- 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
07 PivotTables and PivotCharts: data analysis made easy PivotCharts moved to a sheet of their own, the Design tab's layouts, styles and custom number formats, and Refresh All, which brings every PivotTable in the workbook up to date at once.
- 63 PivotCharts in Excel Create interactive charts from a PivotTable 5 min
- 64 PivotTable design Tab Report layouts, PivotTable styles and number formats 5 min
- 65 Refresh a PivotTable in Excel Update pivots when source data changes 2 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) Copilot drafts a mini dashboard with KPI values, charts and slicers for region and channel, then a QA checklist tests the source, the time frame and each chart's wiring.
- 98 Mini dashboard with Copilot in Excel KPIs, charts and slicers on one page 3 min
- 99 Check AI output in Excel A quick QA checklist for Copilot results 2 min
11 MarketPulse campaign intelligence dashboard MarketPulse end to end: the campaign table checked, KPIs planned with Copilot and ChatGPT, six PivotTables, CTR, conversion rate and ROI with IFERROR, Copilot's PivotTables verified, charts with a timeline, eight KPI cards, Channel and Campaign slicers, and the final polish.
- 105 Start here MarketPulse marketing dashboard in Excel Project overview and campaign data 4 min
- 106 Clean and check marketing data in Excel Remove duplicates, Copilot KPI plan 4 min
- 107 Plan a marketing dashboard with ChatGPT KPIs and the PivotTable strategy 4 min
- 108 Marketing PivotTables in Excel Build the MarketPulse pivot back end 6 min
- 109 CTR, conversion rate and ROI in Excel Marketing KPI formulas with IFERROR 4 min
- 110 PivotTables with Copilot Generate and verify marketing pivots in Excel 6 min
- 111 Marketing charts and a timeline in Excel MarketPulse dashboard PivotCharts 4 min
- 112 KPI cards in Excel Marketing KPI cards for the MarketPulse dashboard 7 min
- 113 Slicers for an Excel dashboard Interactive filtering in MarketPulse 4 min
- 114 Polish an Excel marketing dashboard Final formatting and insights in MarketPulse 9 min
Instructors
Who teaches it.
Instructor, Excel with AI
Virginia Thorn
Emmy Award winner. Teaches Excel with AI at Coding Liquids.
Questions
Asked before starting.
Which course teaches you to build a KPI dashboard in Excel from scratch?
The Complete Excel Course with AI Integration from Coding Liquids: its MarketPulse project is an industry-standard KPI dashboard, and you build every layer of it yourself from a starter workbook of campaign data. You make the six PivotTables behind it, write CTR, conversion rate and ROI, turn every headline figure into a KPI card, chart spend against revenue by campaign and conversion share by channel, then wire a timeline and slicers to all of it: the whole road from raw data to a finished dashboard. The path on this page is 23 lessons, 1 hour 38 minutes of video, with the finished MarketPulse to check yours against and lifetime access for the next dashboard you build.
How do I build a KPI dashboard in Excel step by step?
In layers, engine first and screen last, the order The Complete Excel Course with AI Integration follows in MarketPulse. Turn the raw data into an Excel Table and check it for duplicates (Lesson 106); decide what the dashboard must say before building it (Lesson 107); build the PivotTables on a Pivots sheet (Lesson 108); write the KPI formulas (Lesson 109); then add charts and a timeline (Lesson 111), KPI cards (Lesson 112), slicers (Lesson 113) and the polish (Lesson 114). The raw data, the PivotTables and the dashboard each get a sheet of their own, so the screen people read never mixes with the machinery behind it.
Should I download a KPI dashboard template or build my own?
The first question any dashboard gets is 'where does that number come from?', and only the person who built it can answer: build your own. A template arrives with someone else's PivotTables, links and formats, and the first odd figure sends you digging through them. In The Complete Excel Course with AI Integration you wire every part of MarketPulse yourself, from each card's cell link to each slicer's connections, beginning with the starter workbook and checking against the finished one. A new KPI, a new channel or your own data is then an edit you know how to make, and on the plan with instructor support the instructor answers your written questions under any lesson for two months from the day you switch it on, with Ask AI alongside.
How do I calculate CTR, conversion rate and ROI in Excel?
As ratios inside IFERROR, the way The Complete Excel Course with AI Integration writes them for MarketPulse (Lesson 109). CTR is clicks divided by impressions, conversion rate is conversions divided by clicks, and ROI is revenue minus spend, divided by spend, with the cell references locked by F4. IFERROR returns zero wherever a division would fail, so a campaign with no clicks shows 0% instead of an error, and each result is formatted as a percentage. The planning prompt also asks for CPC, CPA and ROAS (Lesson 107): spend over clicks, spend over conversions and revenue over spend, each one more card built the same way.
How do I make KPI cards in Excel?
Draw a shape and link it to a cell. In The Complete Excel Course with AI Integration each MarketPulse card is a rounded rectangle whose formula bar points at one figure on the Pivots sheet (Lesson 112). Untick 'Use GetPivotData functions for PivotTable references' under File, Options, Formulas first, so a click gives a plain cell reference, then lock it with F4 and set the number large and the label small. Five cards carry revenue, spend, conversions, clicks and impressions; three carry CTR, conversion rate and ROI; and every one changes the moment a slicer or the timeline changes its cell.
How do I add slicers and a timeline that filter the whole dashboard?
Insert each once, then connect it to every PivotTable. In The Complete Excel Course with AI Integration, MarketPulse's timeline is inserted on the date field and joined to all the PivotTables through Report Connections, and each chart through Filter Connections (Lesson 111). The Channel and Campaign slicers come from PivotTable Analyze and are connected the same way (Lesson 113): miss one connection and one chart sits still while the rest move, so every click is tested. Ctrl picks several campaigns at once, the timeline steps through days, months, quarters or years, and matching styles finish the controls (Lesson 114).
Can I build a sales dashboard in Excel the same way?
Yes: the build stays, only the fields change. The Complete Excel Course with AI Integration teaches PivotTables on order-level sales data first: net sales by region, state and sales channel (Lesson 60), dates rolled up into months and quarters (Lesson 61) and a PivotChart of the monthly trend (Lesson 63). Put a sales table where MarketPulse has campaigns, make region and product the slicers (Lesson 113), and the cards show the sales figures you choose. Keep the data in an Excel Table and one Refresh All brings every PivotTable, chart and card up to date as new orders arrive (Lesson 65).
Can AI build an Excel dashboard for me?
It can draft one quickly, and The Complete Excel Course with AI Integration makes you the one who signs it off. Copilot fills KPI values, suggests and creates charts and adds slicers for region and channel on a mini dashboard (Lesson 98), and a QA checklist then tests the source, the time frame and every chart's wiring (Lesson 99). Inside MarketPulse, Copilot proposes KPIs and reports inconsistencies (Lesson 106), ChatGPT plans the PivotTables and charts (Lesson 107), and Copilot generates PivotTables you check against your own (Lesson 110). You can follow these lessons simply by watching; to try them, a free ChatGPT account covers the ChatGPT parts, while Copilot and Claude in Excel run on paid plans of your own and stay optional.
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.
By job
Finance and accounting
- Accountants and finance teams
- Bookkeepers and accounts assistants
- FP&A and budget analysts
- Auditors and fraud examiners
- Payroll administrators
- Tax accountants and advisers
- Banking professionals
- Cost and management accountants
- Financial controllers
- Credit control and receivables teams
- Accounts payable teams
- Financial planners and advisers
- Credit analysts and loan officers
- Insurance underwriters
- Insurance claims handlers
- Reconciliation analysts
- Treasury analysts
- Medical billing and coding specialists
- Fund accountants
- Billing administrators
- AML and KYC analysts
- Actuarial analysts
- Insurance agents and brokers
- Retirement planners
HR and office administration
Operations and supply chain
- Operations and project managers
- Procurement and purchasing officers
- Logistics coordinators
- Inventory controllers and storekeepers
- Supply chain analysts
- Warehouse managers and supervisors
- PMO analysts
- Import and export coordinators
- Production planners
- Demand planners
- Fleet and transport managers
- Apparel merchandisers
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
- Quantity surveyors and estimators
- Civil and site engineers
- Quality managers and engineers
- Construction project managers
- Health and safety officers
- Document controllers
- Production managers and supervisors
- Mechanical and electrical engineers
- Industrial engineers
- Planning engineers
- Sustainability and ESG analysts
- Maintenance planners
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
By goal
- Instructor support
- Certificates
- How long it takes
- Is Excel worth learning
- A retirement calculator
- A budget tracker
- A task tracker
- A budget vs actual report
- A sales goal tracker
- An employee database
- A chart dashboard
- An employee lookup
- A self-refreshing sales report
- A checking macro
- A Power Automate flow
- A compound interest calculator
- A SIP calculator
- An Excel test for a job
- A step-up SIP calculator
- Practice exercises
- Excel skills for a CV