The Complete Excel Course with AI Integration
Excel or Power BI: which should you learn first?
Learn Excel first and you open Power BI already knowing its back end: Power BI Desktop prepares data with the same Power Query and measures it with the same DAX as Excel's Power Pivot. The Complete Excel Course with AI Integration puts Power Query, the data model and DAX in your hands inside Excel, on industry-standard projects designed after talking with people from many different industries, up to SalesFusion: raw CSV files carried through a data model to a dashboard with slicers.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Turn a folder of raw CSV exports into one clean table with Power Query, the same editor Power BI Desktop prepares data in.
- Relate a sales table to its product and region lookups one-to-many in a Power Pivot data model, with no lookup formula dragged down a column.
- Write DAX measures for sales, profit, margin and each category's share of the total that recalculate under every slicer.
- Build an interactive Excel dashboard: KPI cards linked to PivotTables, and slicers connected to every PivotTable on the page.
- Chart a PivotTable with PivotCharts that follow its slicers: a column chart to compare categories, a line chart for the monthly trend.
Projects
What you will build.
The course has 14 industry-standard projects. These three matter most here.
-
Project 12
SalesFusion
A sales report that refreshes itself from a folder of files.
Power BI's own workflow rehearsed in Excel from start to finish: Power Query prepares raw CSV exports, Power Pivot relates the tables, DAX measures do the maths and slicers drive the finished dashboard.
-
Project 08
MarketPulse
One screen that shows which campaigns earn back their spend.
A campaign dashboard people can click through, built entirely in a workbook: KPI cards for CTR, conversion rate and ROI, and slicers that refilter every PivotTable and chart when you pick a channel or a campaign.
-
Project 05
SalesPlusPerformance
A sales question answered in seconds, straight from the order data.
Where your first interactive report takes shape: slicers that cut a sales PivotTable to one state, city or region, and PivotCharts on a sheet of their own that follow them.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 10 of them, 1 h 4 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 154 Introduction to Power Query in Excel
Start at Lesson 154 if you already build PivotTables: Power Query and the data model are the part of this path that Power BI shares, and the SalesFusion dataset of CSV files comes with its resources; to build the whole project, take its lessons in order from Lesson 153. To see first what a workbook dashboard can do, begin at Lesson 62; if PivotTables are new, at Lesson 57, and at Lesson 1 if Excel itself is.
10 of 186 lessons · 1 h 4 min
07 PivotTables and PivotCharts: data analysis made easy Slicers on a sales PivotTable that cut it to one state, city or region, then PivotCharts on a dashboard sheet that move with them: a column chart by product category and a line chart of the monthly net sales trend.
- 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
- 63 PivotCharts in Excel Create interactive charts from a PivotTable 5 min
11 MarketPulse campaign intelligence dashboard MarketPulse's headline figures as KPI cards, shapes linked straight to PivotTable cells, then channel and campaign slicers connected to every PivotTable through Report Connections, so one click, or several with Ctrl held, refilters the whole dashboard.
- 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
15 SalesFusion: advanced data tools and a Power Query modelling system ETL in plain terms, extract, transform and load: a pipeline whose logic you set up once and rerun on every new file, loading clean data into Excel or, as the lesson says, into Power BI.
- 154 Start here Introduction to Power Query in Excel The ETL workflow explained 5 min
15 SalesFusion: advanced data tools and a Power Query modelling system A whole folder of sales files combined into one table with From Folder and cleaned once in the sample file for every file to come, with column quality and column profile switched on across the entire dataset.
- 166 From Folder in Power Query Combine every sales file in a folder automatically 9 min
15 SalesFusion: advanced data tools and a Power Query modelling system The model and the dashboard: three tables related one-to-many in Power Pivot's Diagram View, measures written once in DAX for sales, profit, margin and each category's share, a report laid out from the model, then four PivotTables that one set of slicers filters together. Power Pivot needs Excel for Windows.
- 169 Power Pivot Data Model in Excel Relationships and Diagram View 6 min
- 170 DAX measures in Power Pivot Total sales, margin percent and percent of total 10 min
- 171 PivotTable report from the Data Model Format the SalesFusion report in Excel 5 min
- 172 Interactive Excel dashboard Data model PivotTables, slicers and styling 10 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.
Should I learn Excel or Power BI first?
Excel first, unless your job is already to publish reports for a whole organisation. Excel is where data arrives, gets checked and gets modelled, and it holds the tools Power BI prepares and models data with: Power Query, a data model and DAX. Go straight to Power BI when reports must reach many people online, refreshed on a schedule, with access set for each reader. The Complete Excel Course with AI Integration from Coding Liquids takes the Excel route all the way to an interactive dashboard on a data model, and the 10 lessons picked here (1 hour 4 minutes) are that route.
What is the difference between Excel and Power BI?
Excel is a workbook you shape cell by cell: inputs you type, formulas, what-if models and reports in one file. Power BI is Microsoft's analytics platform for reports: Power BI Desktop builds them on a data model, and the Power BI service shares them in the browser and on phones, with refresh on a schedule. Underneath they share a core, Power Query to prepare data and DAX to measure it, and The Complete Excel Course with AI Integration teaches that core in Excel, on SalesFusion, right through to a dashboard with slicers (Lesson 172).
Is Excel or Power BI better for a dashboard?
Choose Power BI when a whole organisation must open the same dashboard online on a refresh schedule. For a dashboard you build, check and send as a file, Excel does the whole job, and The Complete Excel Course with AI Integration has you prove it twice. MarketPulse links KPI cards to PivotTable cells and connects channel and campaign slicers to every PivotTable through Report Connections (Lesson 112, Lesson 113); SalesFusion wires four PivotTables on a data model to one set of slicers that filters them all at once (Lesson 172).
Is advanced Excel enough, or do I need Power BI as well?
For the data side of the work, advanced Excel as The Complete Excel Course with AI Integration teaches it is the real thing: Power Query combining and cleaning a folder of exports (Lesson 166), relationships in a Power Pivot data model (Lesson 169) and DAX measures that answer to every slicer (Lesson 170). Power BI earns its place when reports must be published and shared across an organisation; its canvas and online service are not taught here. You arrive at them with the modelling already in your hands.
What are the pros and cons of Excel and Power BI?
Excel's strengths are freedom and reach: any layout you like, numbers typed straight into a model, what-if changes on the spot, and a file any colleague with Excel can open. Sharing one live, secured report with many readers is where Power BI is stronger, along with visuals built for exploring and refresh on a schedule; it is no place, though, to type a budget or work cell by cell. The Complete Excel Course with AI Integration plays to Excel's strengths and takes you as far towards Power BI as Excel goes: a data model and DAX measures behind a dashboard with slicers (Lesson 170, Lesson 172).
Which Power BI skills does this Excel course teach?
The ones under the bonnet. The Complete Excel Course with AI Integration teaches Power Query's extract, transform and load (Lesson 154) and its From Folder combine (Lesson 166), one-to-many relationships in a data model (Lesson 169), and DAX measures built with CALCULATE and DIVIDE (Lesson 170), and Power BI Desktop works with that same Power Query editor and that same DAX. Its visuals, publishing and sharing are not in the lessons; the modelling you take to them is.
Is there a project that practises the Power BI workflow in Excel?
Yes: SalesFusion, the industry-standard project of The Complete Excel Course with AI Integration that walks, inside Excel, the steps Microsoft sets out for Power BI short of publishing. You connect to raw sales files and prepare them in Power Query (Lesson 166), model the tables with relationships (Lesson 169), add calculations as DAX measures (Lesson 170), lay out the report (Lesson 171) and explore it through slicers on four PivotTables (Lesson 172). The finished SalesFusion workbook comes with the course to check yours against.
Is this course a good start if I plan to move to Power BI later?
Yes, because it starts you where Power BI work starts, with the data. The Complete Excel Course with AI Integration takes you through data analysis in Excel end to end, from raw data to a finished dashboard, and its SalesFusion lessons put Power Query, a data model and DAX in your hands before Power BI ever opens; the Power Pivot lessons need Excel for Windows. Lifetime access keeps the DAX lesson there for the day Power BI asks for a measure, the optional instructor support plan adds two months of written questions answered by the instructor, with Ask AI in every lesson, from the day you choose, and the Certificate of Completion carries a verification link an employer can check.
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 KPI dashboard
- 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