The Complete Excel Course with AI Integration

Excel practice exercises with answers

Watching a formula and writing one are different skills, and The Complete Excel Course with AI Integration trains the second. Lessons stop for you to try IF, SUMIFS and lookups before the answer; the formula, text, PivotTable and lookup sections close with Ninja Challenges, a task file now and the solution file afterwards; later come a VBA challenge and a Power Automate one. Every exercise sits on an industry-standard project, and section quizzes explain each answer, so you always know why.

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:

  • Label every sale achieved or missed, high or low priority, eligible for a bonus or due a follow-up call, with the trickier rules written by you before the answer appears.
  • Answer a whole sheet of conditional sum and count questions on your own, then hold each formula against the solution file.
  • Clean a messy employee file unaided, from names typed in every casing to emails rebuilt in one consistent format.
  • Summarise sales by region, by category and by month in PivotTables from a problem file, with no one showing you the clicks.
  • Prove a tracker you built still works by adding a task and checking that every drop-down, highlight and count follows it.
  • Extend a VBA loop to catch two kinds of missing data in one pass, and build a Power Automate Desktop flow that flags rows for you.

Projects

What you will build.

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

  • Project 05

    SalesPlusPerformance

    A sales question answered in seconds, straight from the order data.

    Order-level data you first summarise with guidance, so the PivotTable challenge that closes the section, by region, by category and by month, finds you ready to do it alone.

  • Project 07

    TaskFlow

    One sheet that shows what is done, what is late and what is urgent.

    Two kinds of practice in one tracker: a highlight rule you write before the reveal, and a stress test proving every formula, drop-down and colour rule follows a new task.

  • Project 11

    FormatWizard

    One click that checks a whole sheet for you.

    A challenge mid-build: you extend a loop so a single pass flags a missing region, a missing salesperson or both, then set your code beside the solution.

  • Project 13

    AutoFlow

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

    Automation you assemble without writing code, on Windows: a flow that loops through client rows, reads each status and writes a flag wherever it says onboarded.

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

    Home to most of the formula exercises: sales rows to label, tier, total and count, a quick challenge in lesson after lesson, and the first Ninja Challenge as the finale.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 30 IF function practice in Excel

Start at Lesson 30, the first lesson built as practice; if IF is new to you, watch Lesson 29 just before it, and complete beginners begin at Lesson 1. The Ninja Challenges come with files of their own, so you can also open one straight away to see where you stand.

16 of 186 lessons · 1 h 27 min

04 Essential formulas and functions (IF, SUMIF and more) 6 of 13 lessons · 36 min Rules that label every sale, from achieved or missed to customer tiers, deal priority, bonus eligibility, risk and follow-up, then counts of what is filled in, with quick challenges to solve before each answer is shown.
  1. 30 Start here IF function practice in Excel Categorise sales data with IF formulas 6 min
  2. 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
  3. 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
  4. 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
  5. 34 SUM, COUNT and COUNTA in Excel SUM with FILTER and counting numbers with COUNT 7 min
  6. 35 SUM, COUNT and COUNTA in Excel COUNTA, unique counts and completeness checks 4 min
04 Essential formulas and functions (IF, SUMIF and more) 1 of 13 lessons · 7 min Totals and counts with two conditions, where you pause to build the north-region and excellent-rating formulas yourself before the solution appears.
  1. 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
04 Essential formulas and functions (IF, SUMIF and more) 1 of 13 lessons · 8 min The formula section's closing test: a challenge file with hints, from counting one region's sales to scoring performance with IFS, then the solution file and every answer walked through.
  1. 40 Excel Ninja Challenge COUNTIF, SUMIF, IF, COUNTIFS, SUMIFS and IFS practice 8 min
05 Text functions and data validation (enhancing data quality) 2 of 7 lessons · 11 min A brief of clean-up tasks on an employee file, from names in every casing to emails rebuilt as firstname.lastname, solved in your own time and answered task by task in the next lesson.
  1. 46 Ninja Challenge: problem Clean messy data with text functions and validation 4 min
  2. 47 Ninja Challenge: solution PROPER, Text to Columns and drop-down lists 7 min
07 PivotTables and PivotCharts: data analysis made easy 1 of 10 lessons · 1 min PivotTables with nothing to copy from: a problem statement file asks for sales by region, by region and category, and a monthly trend, with the solution file waiting for when you finish.
  1. 66 Excel Ninja Challenge PivotTable sales by region, category and monthly trend 1 min
08 Advanced Excel functions: lookups, text and arrays 1 of 12 lessons · 3 min A lookup brief on orders and products: names and unit costs fetched with XLOOKUP, each line totalled and order IDs formatted, then the solution built in front of you.
  1. 78 Excel Ninja Challenge XLOOKUP, totals and text concatenation lookup challenge 3 min
09 Project: task automation with data validation and forms 1 of 9 lessons · 8 min Highlight rules written as formulas in TaskFlow, flagging overdue and completed tasks, with one rule you write yourself first: high priority but less than half done.
  1. 82 Conditional formatting in Excel Highlight overdue and completed tasks 8 min
09 Project: task automation with data validation and forms 1 of 9 lessons · 3 min A stress test of the finished tracker: a task added the way teams add one, by copying a row, then every drop-down, highlight and days-past-due count checked against the new dates.
  1. 87 Testing an Excel task tracker Stress test TaskFlow with sample data 3 min
14 VBA and macros in Excel: FormatWizard 1 of 17 lessons · 5 min The VBA challenge: make one pass of the loop flag a missing region, a missing salesperson or both, then study the solution and, as the lesson suggests, rewrite parts of it with Claude or ChatGPT and correct what they get wrong.
  1. 148 VBA If Else and loops Check missing sales data and build a FlagText message 5 min
16 Power Automate: weekly sales report automation 1 of 12 lessons · 5 min Automation practice on Windows: a client onboarding sheet and a Power Automate Desktop flow you assemble yourself to loop down its rows, read each status and flag every onboarded client, before the solution is built on screen.
  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.

Where can I find Excel practice exercises with answers?

Inside The Complete Excel Course with AI Integration from Coding Liquids, where practice is part of the teaching rather than an extra. Lessons stop for you to try the formula first (Lesson 33, Lesson 37); the formula, text, PivotTable and lookup sections close with Ninja Challenges, each a task file with a solution file to check yourself against; and section quizzes explain every answer. Each exercise is set on an industry-standard project, and the projects were designed after talking with people from many different industries, so what you practise is the work itself. This page gathers 16 lessons of practice, 1 hour 27 minutes of video.

Are there Excel practice exercises for beginners?

Plenty, and they start early. The Complete Excel Course with AI Integration begins at your very first spreadsheet, and by Lesson 30 you are practising IF on raw sales data, with quick challenges in the lessons that follow. The first Ninja Challenge (Lesson 40) puts hints beside its questions, and the clean-up challenge (Lesson 46) tells you which function to reach for on its email task. Each challenge asks only for what the lessons before it have taught, and the worked solutions show the way whenever you are stuck.

Where can I practise the IF function with exercises?

On a sales sheet where every IF decides something real. The Complete Excel Course with AI Integration starts with achieved or missed against quota (Lesson 30), moves to customer tiers with nested IF (Lesson 31), sets deal priority as a quick challenge with IFS (Lesson 32) and has you build the follow-up rule with OR before the reveal (Lesson 33). The first Ninja Challenge then mixes IF with SUMIF and COUNTIFS on fresh questions, its solution file waiting at the end (Lesson 40).

Can I download the exercises and their solutions?

Yes, once you own The Complete Excel Course with AI Integration: the practice files sit beside the lessons as Excel workbooks, which serve you better than any PDF because you practise in Excel itself. The Ninja Challenges of the formula, text, PivotTable and lookup sections each come with a task file and a solution file, and most projects give you a starter workbook and a finished one to compare against. The VBA and Power Automate challenges are solved on screen after you have had your go, and the lessons themselves are watched online.

Which Excel exercises suit a data analyst?

The ones that copy an analyst's day: clean a messy employee file (Lesson 46), summarise sales by region, category and month in PivotTables (Lesson 66), join orders to a product list with XLOOKUP (Lesson 78) and test a finished workbook with new data before anyone relies on it (Lesson 87). The Complete Excel Course with AI Integration covers the entire data analysis workflow in Excel, end to end, from raw data to a finished dashboard, so after these exercises SalesFusion carries the same skills into Power Query and a Power Pivot data model, which needs Excel for Windows.

How do the section quizzes work?

They are a check, never a hurdle. Most sections of The Complete Excel Course with AI Integration close with an optional multiple-choice quiz on what they taught; attempts are unlimited, each one is scored straight away, and then every question shows the correct option with a short explanation of why. The quiz tells you whether you understood a section, the Ninja Challenge whether you can do it, and between them you know exactly which lesson to go back to.

Can I use ChatGPT on the practice tasks?

To understand a task, yes; to answer it, the course asks you to hold back. The PivotTable challenge of The Complete Excel Course with AI Integration says so in its brief: use AI to explore the problem, not to generate the solution (Lesson 66), since an answer you did not work out teaches you little. Once you can do the work yourself, the course puts AI to work on purpose: the VBA challenge has you rewrite parts of its solution with Claude or ChatGPT and correct them (Lesson 148), and the AI section hands you a checklist for anything Copilot returns (Lesson 99).

Can I practise VBA and Power Automate as well as formulas?

Yes, and the course sets both as challenges. In FormatWizard, The Complete Excel Course with AI Integration stops you mid-build with a VBA task: extend a loop so one pass flags rows missing a region, a salesperson or both, then compare your code with the solution (Lesson 148). AutoFlow closes on a Power Automate Ninja Challenge, a flow you assemble alone to flag every onboarded client (Lesson 185), in Power Automate Desktop on Windows. Few things prove automation skills like code and flows you built and fixed yourself, and this one course gives you both VBA and Power Automate.

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.