The Complete Excel Course with AI Integration

Excel course with instructor support

A video cannot answer back; The Complete Excel Course with AI Integration with instructor support does. For two months, from the day you choose, you ask a question under the lesson you are on and the instructor answers it in writing, never the AI, with an email when the answer arrives; for a quick doubt, Ask AI replies at once. You build industry-standard projects, and the lessons below are where asking pays off most: where your Excel, files or settings differ from the screen and a person gets you past it.

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:

  • Ask a question under the lesson that teaches it, formula pasted in, and choose whether Ask AI answers at once or the instructor replies in writing.
  • Lock references with F4 so a copied formula keeps pointing at the right cells, and read what #DIV/0!, #NAME? and #VALUE! tell you.
  • Build decisions with IF, nested IF, IFS, AND and OR, and check your attempt at a challenge file against its solution.
  • Pull values across sheets with XLOOKUP or INDEX and MATCH, with a message in place of an error when nothing matches.
  • Switch on the Developer tab, save macros in a macro-enabled workbook, get past the macro security warning and write your first VBA.
  • Connect Power Query to files and whole folders on your own computer, then relate tables in Power Pivot and automate a workbook with Power Automate Desktop on Windows.

Projects

What you will build.

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

  • Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    XLOOKUP, IFERROR and INDEX with MATCH on an HR dataset: formulas that read one sheet to fill another, and a person to ask when a lookup returns something you cannot explain.

  • Project 11

    FormatWizard

    One click that checks a whole sheet for you.

    Your first VBA, from switching on the Developer tab and saving an .xlsm file to the macro security warning and a first compile error: the moments when one question to the instructor keeps you moving.

  • Project 12

    SalesFusion

    A sales report that refreshes itself from a folder of files.

    Power Query tied to a CSV file and to a folder on your own computer, then Power Pivot and DAX: when your files behave differently from the lesson's, a written answer saves the guessing. Power Pivot needs Excel for Windows.

  • Project 13

    AutoFlow

    The weekly report routine, run by a flow instead of by you.

    Power Automate Desktop driving Excel from outside: your flow opens your workbook from its place on your computer and follows your machine's date and number settings, with the instructor there when your set-up differs from the video. It is a separate Windows app.

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

  • Project 03

    Sales Goal Tracker

    IF, IFS, AND and OR on sales targets: formulas that choose between answers by rules you set, with a challenge file to try alone and the instructor to ask when your answer and the solution differ.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 10 Relative vs absolute references in Excel

This path joins the course at Lesson 10; if Excel is new to you, begin at Lesson 1 and switch the support on when you reach the formulas. If IF and XLOOKUP are already routine, start at Lesson 139, where VBA meets your own Excel's settings, or at Power Query from Lesson 155. The free preview lessons on the course page show the teaching first.

26 of 186 lessons · 2 h 6 min

01 Microsoft Excel fundamentals: building a foundation from scratch 3 of 13 lessons · 10 min Dollar signs set with F4, each expense as a percentage of income, then #DIV/0!, #NAME? and #VALUE! met on purpose and handled with IFERROR: errors Excel names with a code, which a question can quote exactly.
  1. 10 Start here Relative vs absolute references in Excel Dollar signs and mixed references 3 min
  2. 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
  3. 12 Common Excel errors and how to fix them DIV0, NAME, VALUE errors and IFERROR 4 min
04 Essential formulas and functions (IF, SUMIF and more) 5 of 13 lessons · 28 min IF with one condition, IF practice on sales data, nested IF and IFS for tiers and labels, then AND and OR: the course's logic functions, where a formula decides between answers by conditions you write, and a pasted formula gets a precise answer.
  1. 29 The IF function in Excel Pass or fail results with a single condition 3 min
  2. 30 IF function practice in Excel Categorise sales data with IF formulas 6 min
  3. 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
  4. 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
  5. 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
04 Essential formulas and functions (IF, SUMIF and more) 1 of 13 lessons · 8 min A Ninja Challenge file with hints, for COUNTIF, SUMIF, IF, COUNTIFS, SUMIFS and IFS tried on your own before the solution file: a course exercise, so the instructor's guidance is there when you are stuck.
  1. 40 Excel Ninja Challenge COUNTIF, SUMIF, IF, COUNTIFS, SUMIFS and IFS practice 8 min
08 Advanced Excel functions: lookups, text and arrays 3 of 12 lessons · 15 min XLOOKUP between two sheets with locked ranges and a not-found message, IFERROR for a lookup value that stops matching, then INDEX and MATCH.
  1. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
  2. 70 IFERROR in Excel Handle lookup errors in VLOOKUP and XLOOKUP formulas 3 min
  3. 71 INDEX and MATCH in Excel A flexible alternative to VLOOKUP 6 min
08 Advanced Excel functions: lookups, text and arrays 1 of 12 lessons · 3 min A lookup challenge on orders and products whose own solution meets an error from a stray @ sign before the column fills: the kind of surprise a written question can describe.
  1. 78 Excel Ninja Challenge XLOOKUP, totals and text concatenation lookup challenge 3 min
14 VBA and macros in Excel: FormatWizard 5 of 17 lessons · 20 min The Developer tab switched on in Excel's options, which the lesson says looks different on a Mac, then saving a macro-enabled workbook, the warning that disables macros when the file reopens, a first compile error fixed and your first line of VBA: set-up steps where your screen may not match the video, and one question settles it.
  1. 139 Developer Tab in Excel Run macros from a button and the quick access toolbar 4 min
  2. 140 Save macros in Excel Macro-enabled workbooks and the XLSM file format 3 min
  3. 141 The VBA Editor in Excel Open it with Alt+F11 and learn the workspace 4 min
  4. 142 Working in the VBA editor Macro security, trust settings, switching to Excel 6 min
  5. 143 Your first VBA code Modules, worksheets, rows, columns and formatting 4 min
15 SalesFusion: advanced data tools and a Power Query modelling system 1 of 21 lessons · 2 min Power Query's first import: a CSV file opened from a folder on your own computer, kept as a live connection and sent to Transform Data rather than loaded as it is.
  1. 155 Import a CSV with Power Query Get data from text and transform data 2 min
15 SalesFusion: advanced data tools and a Power Query modelling system 1 of 21 lessons · 9 min A query that reads every file in a folder and takes in a new one on refresh. It depends on where that folder sits on your machine, exactly the detail to put in a question.
  1. 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 2 of 21 lessons · 16 min Power Pivot, part of Excel for Windows only, which asks you to enable its add-ins on first use, then relationships in Diagram View, a warning about external data connections and your first DAX measures.
  1. 169 Power Pivot Data Model in Excel Relationships and Diagram View 6 min
  2. 170 DAX measures in Power Pivot Total sales, margin percent and percent of total 10 min
16 Power Automate: weekly sales report automation 3 of 12 lessons · 9 min Power Automate Desktop, a Windows app installed from the Microsoft Store and signed in to on first use, then a first flow and one that opens your own workbook and follows your computer's date and number settings.
  1. 174 Power Automate Desktop for Excel Set up AutoFlow and your first automation 3 min
  2. 175 Your first Power Automate flow Flows, triggers, actions and Display message 3 min
  3. 176 Connect Excel to Power Automate Launch Excel and the Excel instance variable 3 min
16 Power Automate: weekly sales report automation 1 of 12 lessons · 5 min The Power Automate Ninja Challenge: flag every onboarded client in a starter file with a loop, a read, an If and a write, tried alone before the walk-through.
  1. 185 Power Automate Ninja Challenge Flag onboarded rows with loop, read, if, write 5 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.

Is there an Excel course with a tutor I can ask?

Yes, a teacher who answers in writing. Coding Liquids offers The Complete Excel Course with AI Integration with instructor support: for two months, from the day you switch it on, you post a question under any lesson and the instructor answers it, while Ask AI replies at once from the course's own lessons. The support is written, with no live lessons or tutoring sessions, so every answer stays under its lesson for you to read again. The projects you learn on are industry standard, each designed after talking with people from many different industries, and the 26 lessons picked here (2 hours 6 minutes) are where a question pays off most.

Can I book a live lesson or a call with the Excel teacher?

You get something you can keep instead: the instructor's written answers to your questions for two months, each filed under the lesson it belongs to, with room for follow-ups in the same conversation. Taught in recorded lessons with captions, The Complete Excel Course with AI Integration gives written support, not live classes, calls, screen sharing or one-to-one tutoring, and through those two months Ask AI answers in every lesson at any hour, beside the practice workbooks that come with every project.

Will the instructor fix the spreadsheet I use at work?

You get the explanation that lets you fix it yourself, and the skill stays with you. Paste the formula that misbehaves into a question under the lesson that teaches it, say what Excel returned against what you expected, and the instructor explains what that lesson's technique needs. The support in The Complete Excel Course with AI Integration covers what the course teaches and its exercises, so reviewing or repairing a whole workbook, building formulas or sheets for you, financial advice and topics the course leaves out stay outside it; what you carry back to work is a fix you understand.

When should I use Ask AI rather than ask the instructor?

Ask AI for speed, the instructor for depth. Ask AI answers the moment you ask, from the course's own lessons, and labels its reply as the AI assistant's, so it suits a quick check you then try in your own workbook. If the reply leaves a doubt, Send to the instructor passes the same question on, and in The Complete Excel Course with AI Integration a question with the instructor is answered by the instructor, never by the AI. You choose, question by question.

I study Excel around a full-time job. When should the two months start?

Whenever suits you: the two months of support in The Complete Excel Course with AI Integration start on the day you switch them on, not the day you buy. Once started they run without a pause and days you do not use are not added back, so pick a stretch of weeks with regular evenings free, for example from the VBA lessons at Lesson 139 or Power Query at Lesson 155, and the instructor's answers land on the part you find hardest.

If my employer bought my seat, can my manager see my questions?

No, your questions are yours. In The Complete Excel Course with AI Integration, your questions and the instructor's replies are not shown to other learners or to the administrator of a team plan. A team administrator sees each member's name, email address, progress and certificates, never the support conversation, so you can ask about the basics as freely as about VBA.

What if I need instructor support later, or for longer than two months?

Yes to both, from your account. Bought The Complete Excel Course with AI Integration self-paced? Add a two-month block of support whenever you like during your access. Already using your months? Buy another block now and it follows on the day the current one finishes. Each block is a separate purchase with refund terms of its own, set out in the Refund Policy under Instructor support, and your lessons stay yours with lifetime access whatever you decide.

Do I need the support plan, or is the self-paced Excel course enough?

Take the support if a question left unanswered would stop you: it puts the instructor on your side for two months. The self-paced course is complete on its own, since The Complete Excel Course with AI Integration gives every project its practice workbooks, plus section quizzes and Ninja Challenges with solutions. Support adds a person to ask when your result and the finished file disagree and the lesson does not show why, plus Ask AI in every lesson. Both options hold the full course, lifetime access and the same Certificate of Completion, and support can be added later, the day you find you want someone to ask.

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.