The Complete Excel Course with AI Integration
Excel certification and course certificates
Want proof of your Excel skills for a CV or LinkedIn? The Complete Excel Course with AI Integration gives you two kinds: a Certificate of Completion from Coding Liquids, emailed as a PDF with a verification link and a QR code anyone can check, and the industry-standard workbooks you built along the way, ready to open in an interview. Microsoft's certification is a separate award, earned only through Microsoft's own exam; the lessons below are where your showpiece workbooks are finished.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Show an employer a Certificate of Completion they can verify in seconds, by link or QR code, with workbooks you built standing behind it.
- Link KPI cards to PivotTable values and wire slicers so one click filters a whole marketing dashboard.
- Finish a budget vs actual dashboard with a combo chart on a secondary axis, department slicers and compact number formats.
- Join separate VBA routines into one macro with an error handler that checks a whole sheet in a single click.
- Lay out DAX measures from a Power Pivot data model as a report, then link several PivotTables to the same slicers.
- Build a Power Automate Desktop flow that asks for a yes or no on each row and writes every answer into the workbook.
Projects
What you will build.
The course has 14 industry-standard projects. These five matter most here.
-
Project 08
MarketPulse
One screen that shows which campaigns earn back their spend.
Open it in an interview and let the campaign slicers answer the follow-up questions: KPI cards and PivotCharts that all respond to one click.
-
Project 09
FinanceGuard
The budget vs actual report finance teams send every month.
Spending by department set against its budget, finished with KPI cards, a combo chart and slicers: a file worth linking beside the certificate.
-
Project 11
FormatWizard
One click that checks a whole sheet for you.
VBA you wrote yourself, from recorded macros to a master routine with an error handler, which you can talk through line by line.
-
Project 12
SalesFusion
A sales report that refreshes itself from a folder of files.
Messy CSV files turned into a Power Pivot data model with DAX measures and a styled report, built in Excel for Windows.
-
Project 13
AutoFlow
The weekly report routine, run by a flow instead of by you.
Approval flows in Power Automate Desktop, a Windows app, that ask about each row in turn and write the answers back into Excel.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 12 of them, 1 h 15 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 112 KPI cards in Excel
Each run here comes late in a project that starts earlier in its section (MarketPulse at Lesson 105, for example), so reach these lessons by following the course: the certificate comes from completing The Complete Excel Course with AI Integration, not from this page. New to Excel? Begin at Lesson 1; the free preview lessons on the course page show the teaching first.
12 of 186 lessons · 1 h 15 min
11 MarketPulse campaign intelligence dashboard The end of MarketPulse: KPI cards that read their figures from the PivotTables, channel and campaign slicers joined through report connections, then figures shown in thousands and the layout tidied for a stakeholder review.
- 112 Start here 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
12 Project: FinanceGuard budget variance analyser (budget vs actual Excel dashboard) FinanceGuard brought to a finish: KPI cards, a combo chart of actuals against budget on a secondary axis, slicers that filter by department, then compact figures, one colour palette and a dark blue theme.
- 121 KPI cards in Excel Summary cards for a budget variance dashboard 4 min
- 122 Budget vs actual charts in Excel Combo chart with secondary axis for variance 5 min
- 123 Slicers and PivotCharts in Excel Interactive FinanceGuard budget dashboard 4 min
- 124 Finish the FinanceGuard dashboard in Excel Final polish and variance insights 10 min
14 VBA and macros in Excel: FormatWizard The FormatWizard routines joined in one RunFullValidation macro with an error handler, so a single click checks the whole sales sheet.
- 152 Complete Excel validation macro One VBA subroutine with an error handler 3 min
15 SalesFusion: advanced data tools and a Power Query modelling system SalesFusion's report: the DAX measures of the Power Pivot data model arranged by product category, then more PivotTables tied to shared slicers and styled as one dashboard. Power Pivot needs Excel for Windows.
- 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
16 Power Automate: weekly sales report automation AutoFlow's approval flow in Power Automate Desktop, a Windows app: a yes or no answer written into the sheet, then a loop that asks about every row in turn.
- 183 Approval flow in Power Automate Desktop If conditions and message box buttons 9 min
- 184 Loops in Power Automate Desktop Loop and For each actions for Excel rows 5 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 course gives a certificate I can show employers?
The Complete Excel Course with AI Integration from Coding Liquids, and it gives you more to show than the certificate. Complete it and your Certificate of Completion arrives by email as a PDF, kept in your student area too, with a verification link and a QR code an employer can check in seconds. Behind it stand industry-standard projects, designed after talking with people from many different industries: the MarketPulse and FinanceGuard dashboards, a VBA validation macro, a Power Query report and an approval flow. It is no route to Microsoft's certification or an accredited qualification, but it is proof you can open, and this guide picks out the 12 lessons (1 hour 15 minutes) where those workbooks are finished.
Is there an official Excel certification from Microsoft?
Yes: Microsoft Office Specialist (MOS), at Associate and Expert level, is awarded only for passing Microsoft's own proctored exam, so no course can award it, and The Complete Excel Course with AI Integration was not built to prepare for it. What The Complete Excel Course with AI Integration gives you is its own Certificate of Completion from Coding Liquids, checkable by link or QR code, and finished workbooks, from a budget vs actual dashboard to a VBA macro that checks a whole sheet, that show an employer what you can do.
Is Excel certification worth it, or is a course certificate enough?
A course certificate does its job when the work behind it can be shown, and The Complete Excel Course with AI Integration gives you both: a Certificate of Completion an employer can verify, and finished workbooks such as the FinanceGuard budget vs actual dashboard to open when an interviewer hands you a spreadsheet task or asks how you built something. Where a job advert names Microsoft Office Specialist, only Microsoft's exam meets that request; elsewhere, a verified certificate with a workbook beside it makes the case for you.
Is the certificate from this Excel course accredited?
What it gives you is proof any employer can check for themselves. The Certificate of Completion from The Complete Excel Course with AI Integration carries its certificate number, with a verification link and a QR code that open its page on the Coding Liquids site, showing the course, your name and the date of issue. It confirms that you completed the course and is not an accredited qualification, academic credit or licence; it stays valid unless revoked under the Terms of Use, for instance after a refund, and the workbooks you built stand behind it.
Can I get an Excel certificate for free?
What you can try free is the teaching: the free preview lessons of The Complete Excel Course with AI Integration on the course page are open to anyone, though no certificate comes from them, and Microsoft's certification is an exam booked and paid for separately. The Certificate of Completion goes to students who have the full course, bought or given to them, and complete it, and it comes with what gives it weight: the finished workbooks of every project, yours to open for an employer.
How do I earn the certificate, and is there a final exam?
By completing The Complete Excel Course with AI Integration, with no final exam to sit: once the course counts as complete, as the Terms of Use define completion, your certificate is issued automatically and emailed to you as a PDF. It records completion, one per student for the course, with no grade, score or level to chase. It prints the course's full title, its instructors, the date, a certificate number and the name in your profile, so set that name the way you want it read before you finish.
How should I list the certificate on my CV and LinkedIn?
Name it exactly and let the link do the convincing: a Certificate of Completion for The Complete Excel Course with AI Integration, issued by Coding Liquids, with its verification link or certificate number so any reader can check it. Keep the words certification and Microsoft away from it. Beside it, link or describe one workbook you built and can explain, such as the SalesFusion report on a Power Pivot data model or the FormatWizard validation macro: proof a reader can open rather than take on trust.
Is there an Excel with AI course that comes with a certificate?
Yes. The Complete Excel Course with AI Integration teaches Copilot, ChatGPT and Claude inside Excel, and its Certificate of Completion carries that full title, so the AI skills you learnt are named on it. The AI section sets each assistant to work on real tasks with a checklist for their answers, and later projects bring them back. Keep a workbook where you caught and corrected an AI answer to show beside the certificate: it proves the habit the course drills into you, checking what AI gives you before it counts.
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
- 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