The Complete Excel Course with AI Integration
Excel skills for your CV, and how to prove them
A CV line that says advanced Excel is easy to write and easy to doubt. The Complete Excel Course with AI Integration gives you the version an interviewer believes: every skill employers ask for, learnt on an industry-standard project, from clean data and lookups across HR sheets to a live dashboard, a Power Query data model and VBA. Each line you write then has a workbook behind it, and an answer ready the moment someone asks how you did it.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Write a skills section where every Excel line names a result rather than a buzzword, and each one is backed by a workbook you built.
- Clean, total, look up and summarise data to the standard an office expects, with a finished project to show for every one of those skills.
- Claim advanced Excel and mean it: lists that rebuild themselves, Power Query, a Power Pivot data model with DAX, and VBA you wrote.
- Show AI skills an employer can trust: a PivotTable drafted by Copilot from one prompt, and every result checked against its source.
- Open a dashboard you built during an interview and let its KPI cards follow the PivotTables underneath them as the data changes.
Projects
What you will build.
The course has 14 industry-standard projects. These five matter most here.
-
Project 09
FinanceGuard
The budget vs actual report finance teams send every month.
Evidence for the dashboard line on your CV: a budget vs actual report whose KPI cards, combo chart and slicers you can rebuild from its starter workbook.
-
Project 12
SalesFusion
A sales report that refreshes itself from a folder of files.
The advanced lines of a CV in one project: Power Query, a Power Pivot data model and DAX measures, proved by a report you can refresh in front of an interviewer.
-
Project 06
PeopleInsight HR workbook
Employee data joined across sheets with one formula.
Where your lookup skills get their proof: XLOOKUP, INDEX and MATCH, and spilled UNIQUE and FILTER lists on HR data, ready to open when someone says show me.
-
Project 11
FormatWizard
One click that checks a whole sheet for you.
The proof behind VBA on a CV: code you declared, looped and debugged yourself, ending in a macro that validates a sales sheet from top to bottom.
-
Project 14
Agentic AI in Excel
AI finds and fixes the formula; you check it before it counts.
An AI line worth adding: Copilot building PivotTables from a prompt, ChatGPT and Claude on formulas and charts, and a checklist proving you verify what they return.
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 12 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 22 Cleaning data in Excel
Start at Lesson 22 and add a line to your CV as each skill becomes yours; if the core is already there, go straight to Lesson 75 for the advanced layer. New to Excel? Begin at Lesson 1, since every skill here builds on the opening sections.
11 of 186 lessons · 1 h 12 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) Data cleaning you can claim and show: an employee database with mixed dates, stray spaces, misspellings and doubled symbols made consistent with TRIM, Paste Special values and Find and Replace.
- 22 Start here Cleaning data in Excel TRIM, Paste Special values and Find and Replace 13 min
04 Essential formulas and functions (IF, SUMIF and more) Conditional reporting with SUMIFS and COUNTIFS: totals and counts that meet two conditions at once, from one product in one region to the sales of a single month.
- 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
07 PivotTables and PivotCharts: data analysis made easy Slicers on a PivotTable, the step that turns a static summary into a report anyone can filter by state, city or region in a click.
- 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
08 Advanced Excel functions: lookups, text and arrays XLOOKUP across sheets, with exact match, an if-not-found message and two-way lookups, on the PeopleInsight HR data: a CV line you can demonstrate in moments.
- 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
08 Advanced Excel functions: lookups, text and arrays Dynamic arrays that mark a CV as current: UNIQUE spilling a distinct list of statuses or locations, and FILTER returning only the rows that meet AND or OR conditions.
- 75 UNIQUE function in Excel Extract a distinct list with dynamic arrays 6 min
- 76 FILTER function in Excel Dynamic array filtering with AND and OR criteria 5 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) A PivotTable of revenue by region and month built from one Copilot prompt, then refined and sorted, with the lesson's rule that your prompt controls the outcome.
- 92 PivotTables with Copilot Build an Excel PivotTable from a prompt 5 min
12 Project: FinanceGuard budget variance analyser (budget vs actual Excel dashboard) KPI cards on the FinanceGuard dashboard, each a shape linked live to a PivotTable value: total budget, actuals, variance and budget utilisation at a glance.
- 121 KPI cards in Excel Summary cards for a budget variance dashboard 4 min
14 VBA and macros in Excel: FormatWizard VBA from its first real program: Option Explicit, variables and data types, and the difference between a subroutine and a function, the vocabulary an interviewer probes when VBA is on your CV.
- 144 VBA variables and data types Sub vs function for Excel beginners 6 min
15 SalesFusion: advanced data tools and a Power Query modelling system Power Query From Folder: every sales file in a folder combined and cleaned once, so a new month becomes a refresh rather than a copy and paste.
- 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 DAX measures in a Power Pivot data model, total sales, margin and each category's share of the total, that recalculate for every slicer; Power Pivot needs Excel for Windows.
- 170 DAX measures in Power Pivot Total sales, margin percent and percent of total 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.
Which Excel skills should I put on my CV, and where can I learn them?
The skills you can show working. At the core: cleaning a messy list, totals by condition with SUMIFS, lookups with XLOOKUP, and PivotTables with slicers; for an advanced CV, add Power Query, a data model with DAX, VBA and AI on top. The Complete Excel Course with AI Integration from Coding Liquids teaches every one of them inside its projects. Those projects are industry standard, each designed after talking with people from many different industries about the workbooks their work depends on, so every line you add comes with one of those workbooks behind it. The lesson for each skill is on this page: 11 lessons, 1 hour 12 minutes in all.
What Excel skills do employers look for?
Work they can hand you from day one: a messy export cleaned, totals by region or product, records matched across sheets, a summary a manager can filter and a dashboard that answers a question. Adverts name those tasks by their tools, such as XLOOKUP or VLOOKUP, PivotTables, SUMIFS and data cleaning. The Complete Excel Course with AI Integration makes each one something you have built: an employee database cleaned (Lesson 22), HR records joined with XLOOKUP (Lesson 69), and the FinanceGuard dashboard with KPI cards fed live by its PivotTables (Lesson 121).
What counts as advanced Excel skills on a CV?
Anything past one formula on one sheet: lists that rebuild themselves with UNIQUE and FILTER (Lesson 75), Power Query combining a whole folder of files (Lesson 166), DAX measures in a Power Pivot data model (Lesson 170), VBA you wrote yourself (Lesson 144) and flows in Power Automate. The Complete Excel Course with AI Integration teaches each inside a project rather than as a feature tour. A good rule for the CV: call a skill advanced only when you could build it again with the interviewer watching, and after these projects you can.
Can you give examples of Excel skills on a resume or CV?
Write each as a result with its tool inside, then make sure a workbook stands behind it. After The Complete Excel Course with AI Integration, lines such as these are true of you: 'Cleaned and standardised employee records with TRIM, Find and Replace and Remove Duplicates'; 'Built a budget vs actual dashboard with KPI cards and slicers'; 'Combined monthly sales files with Power Query into a data model with DAX measures'; 'Wrote a VBA macro that validates a sales sheet in one click'. Each names a skill and an outcome, and gives an interviewer something to ask you about.
What Excel skills should a fresher put on a resume?
The core, done well, beats a long list: a clean list, IF with SUMIFS and COUNTIFS, XLOOKUP, a PivotTable with slicers and a chart that fits its question. The opening sections of The Complete Excel Course with AI Integration give you all of them on projects you can take to an interview, and the formula, PivotTable and lookup sections end in Ninja Challenges that tell you plainly whether you can do it unaided (Lesson 40, Lesson 66, Lesson 78). Add one advanced skill you have truly built, Power Query for instance, and a first CV stands out.
Which Excel skills belong on a data analyst's CV?
The whole chain from raw data to an answer: cleaning, conditional totals, lookups, PivotTables, dynamic arrays, Power Query and a data model with DAX, finished as a dashboard. That is the entire data analysis workflow The Complete Excel Course with AI Integration covers in Excel, end to end, and every stage is a line you can back with a workbook. SalesFusion alone proves three of the strongest, Power Query, Power Pivot and DAX (Lesson 166, Lesson 170), with a report that refreshes from a folder of files in Excel for Windows.
Should I list AI skills such as Copilot alongside Excel?
Yes, as long as you show the judgement along with the prompt. The Complete Excel Course with AI Integration has you build a PivotTable of revenue by region and month from a single Copilot prompt and refine it (Lesson 92), and puts Copilot, ChatGPT and Claude to work on formulas, charts and cleaning with a checklist for everything they return (Lesson 99). You learn all of it by watching, with nothing to buy: Copilot is optional and needs its own Microsoft licence, Claude in Excel a paid Claude plan, and to try things yourself a free ChatGPT account covers the ChatGPT lessons and a free Claude account about half of the Claude ones. A line such as 'Drafted PivotTables with Copilot and verified each result against the source data' tells an employer you are quick and careful at once.
How can an employer check the Excel skills on my CV?
In three ways, and The Complete Excel Course with AI Integration equips you for all of them. Open a workbook you built and walk through it: FinanceGuard's KPI cards read live from its PivotTables, so when the data changes the cards change in front of the interviewer (Lesson 121). Repeat a task on the spot, which the Ninja Challenges rehearse. And share your Certificate of Completion, whose verification link anyone can open. Skills shown this way stop being claims and become things the interviewer has seen.
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