The Complete Excel Course with AI Integration

Pass an Excel test for a job interview

An Excel assessment asks multiple-choice questions, sets tasks in a workbook, or both, and The Complete Excel Course with AI Integration rehearses each kind: section quizzes that explain every answer, and Ninja Challenges you solve alone before opening the solution file. Behind them stand industry-standard projects where you do the tasks tests are built from: clean an employee database, decide and total sales with IF and SUMIFS, summarise orders in a PivotTable, match HR records with XLOOKUP.

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:

  • Clean any list a test hands you: stray spaces trimmed, misspellings fixed in one pass with Find and Replace, duplicate records removed as whole rows.
  • Mark every row achieved or missed, or pass or fail, with IF, then total and count by two conditions at once with SUMIFS and COUNTIFS.
  • Turn thousands of sales rows into a PivotTable in a few clicks, grouped by quarter or month and narrowed to one region with slicers.
  • Pull a city, a region or an HR partner's name from another sheet with XLOOKUP or INDEX and MATCH, ranges locked so the formula fills down cleanly.
  • Pick the chart a question asks for, and light up every value over a limit with conditional formatting.
  • Sit a task file alone like a mock test, then mark your work against the solution file and see exactly where each answer went wrong.

Projects

What you will build.

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

  • Project 05

    SalesPlusPerformance

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

    Where you rehearse the PivotTable task: net sales by region and category, order dates grouped into quarters and months, slicers to narrow the view, then a challenge you solve entirely on your own.

  • Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    Lookups you can explain line by line when an interviewer asks how: XLOOKUP filling in city, state and region from a location sheet, and INDEX with MATCH returning each employee's HR business partner.

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

    Your formula rehearsal on one sales sheet: targets marked achieved or missed with IF, then SUMIFS and COUNTIFS problems you answer before the solution appears, closing on the first Ninja Challenge.

  • Project 02

    Dunder Michael Paper Company employee database

    The clean-up task on a realistic raw sheet: dates reformatted, extra spaces trimmed, misspelt departments and doubled @ signs replaced, and duplicate employee records spotted, then removed.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 40 Excel Ninja Challenge

Test date close? Start at Lesson 40: give yourself a time limit and sit the challenge before watching anything, and every question you cannot finish points to a lesson above it on this page. With more time, take the path in order from Lesson 15; if Excel is new to you, begin at Lesson 1.

17 of 186 lessons · 1 h 21 min

02 Project: personal budget tracker 1 of 5 lessons · 3 min Conditional formatting on a budget: a highlight rule that lights up every amount above a set limit, and the menu where data bars and icon sets live.
  1. 15 Conditional formatting in Excel Highlight rules, data bars and icon sets 3 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 2 of 9 lessons · 19 min A raw employee list made trustworthy: TRIM and Paste Special values, Find and Replace for misspellings and stray symbols, then duplicates highlighted and whole duplicate rows removed.
  1. 22 Cleaning data in Excel TRIM, Paste Special values and Find and Replace 13 min
  2. 23 Remove duplicates in Excel Find and delete duplicate rows in an employee list 6 min
04 Essential formulas and functions (IF, SUMIF and more) 1 of 13 lessons · 3 min IF from first principles: a pass mark in one cell, pass or fail returned for every student and filled down the whole list with the fill handle.
  1. 29 The IF function in Excel Pass or fail results with a single condition 3 min
04 Essential formulas and functions (IF, SUMIF and more) 1 of 13 lessons · 7 min SUMIFS and COUNTIFS with two conditions at once, including a month counted from a date range, and pause-and-try problems where you write the formula before the answer 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 first Ninja Challenge, a mock test in all but name: a file of questions with hints on sales data, answered alone, then checked against the solution file formula by formula.
  1. 40 Start here 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 second mock test, on messy text: names and departments recased, full names split, emails rebuilt with CONCAT, places and IDs standardised and drop-down lists added, then the worked answers.
  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
06 Data visualisation: charts and graphs 1 of 9 lessons · 4 min Which chart answers which question: column to compare, line for change over time, pie for parts of a whole and combo for two measures on two axes.
  1. 48 Choosing the right Excel chart Column, line, pie, combo and modern chart types 4 min
07 PivotTables and PivotCharts: data analysis made easy 4 of 10 lessons · 10 min The PivotTable task from an empty grid: insert one from a table, set rows, values and Value Field Settings, group order dates into quarters and months, then filter by state or region with slicers.
  1. 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
  2. 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
  3. 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
  4. 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
07 PivotTables and PivotCharts: data analysis made easy 1 of 10 lessons · 1 min The PivotTable Ninja Challenge from a problem file: sales by region, by region and category, and a monthly trend, with AI allowed to explain the task but never to answer it.
  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 · 6 min XLOOKUP with exact match, a clean message when nothing is found, ranges locked with F4 and two-way lookups, plus a column you fill yourself before the walkthrough.
  1. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
08 Advanced Excel functions: lookups, text and arrays 1 of 12 lessons · 6 min INDEX and MATCH taken apart and put back together, so you can explain the pairing that searches in any direction when an interviewer brings it up.
  1. 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 The lookup Ninja Challenge: each product's name and cost per unit fetched into an orders sheet with XLOOKUP, line totals worked out and order IDs rebuilt by joining text.
  1. 78 Excel Ninja Challenge XLOOKUP, totals and text concatenation lookup challenge 3 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 practice tests for job assessments?

Yes: The Complete Excel Course with AI Integration from Coding Liquids rehearses both halves of an Excel assessment. Its Ninja Challenges hand you a task file on sales, employee or order data to finish alone, then a solution file to mark it against (Lesson 40, Lesson 66, Lesson 78), and its section quizzes ask multiple-choice questions and explain every answer. The tasks themselves are learnt on industry-standard projects, designed after talking with people from many different industries. It trains the skill rather than one employer's question bank, so it pays off at this interview and every one after it. This page holds 17 lessons, 1 hour 21 minutes in all.

What questions come up in an Excel assessment test?

Expect two kinds, often in one sitting: multiple-choice questions on what a feature or function does, and tasks you carry out in a workbook or an on-screen copy of Excel. The tasks keep returning to the same ground: tidy a list, decide with IF, total with SUMIFS, build a PivotTable or a chart, look a value up. The Complete Excel Course with AI Integration has you do each on a project before it ever tests you, from cleaning at Lesson 22 to XLOOKUP at Lesson 69, and its quizzes cover the multiple-choice side with an explanation under every question.

What is on a basic Excel test for a job interview?

Everyday tasks, done accurately: totals with SUM and AutoSum, a list sorted and filtered, an IF that returns pass or fail, a highlight on values over a limit and a chart that fits the question. The Complete Excel Course with AI Integration gives you each of them early, with SUM at Lesson 9, sorting at Lesson 20, IF at Lesson 29 and choosing a chart at Lesson 48, so you meet a basic test with its usual tasks already done once on a real workbook.

How do I answer Excel questions in a job interview?

With a workbook you built open in front of you. Asked how you would bring data across from another sheet, show the XLOOKUP that fills each employee's city and region in the PeopleInsight HR workbook (Lesson 69); asked how you summarise sales, show the SalesPlusPerformance PivotTable grouped by quarter and month (Lesson 61). The Complete Excel Course with AI Integration has you build these workbooks yourself, and its chart section opens by promising a portfolio-ready dashboard you can walk into an interview with (Lesson 48). Talking an interviewer through your own formulas says more than any definition you could recite.

How do I get faster for a timed Excel test?

Do each task once before the day, and keep your hands on the keyboard. The lessons of The Complete Excel Course with AI Integration work with the shortcuts that matter against a clock: Ctrl+Shift+Down to select a whole column (Lesson 59), Ctrl+H for Find and Replace and Ctrl+Alt+V for Paste Special (Lesson 22), and F4 to lock a range, then a double-click on the fill handle to send a formula down the column (Lesson 69). Time yourself on a Ninja Challenge such as Lesson 40, sit it again a week later, and the second run shows how much quicker you have become.

I have not used Excel for years. How do I brush up before an interview?

Quiz first, then watch. Most sections of The Complete Excel Course with AI Integration end with an optional multiple-choice quiz you can retake as often as you like, and the results put the right answer and an explanation under every question, so one sitting on formulas, PivotTables and lookups shows exactly what has slipped. Then rewatch only those lessons, each of them one skill: SUMIFS is Lesson 37, XLOOKUP is Lesson 69. With lifetime access the same course is your refresher before every interview that follows.

What does an Excel test for a data analyst role ask?

The same tasks set harder, plus the tools analysts lean on: PivotTables over thousands of rows, lookups that handle missing values, lists that build themselves with UNIQUE and FILTER, and at the top level Power Query and a data model. 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, ending with Power Query combining a folder of files (Lesson 166) and DAX measures in a Power Pivot data model (Lesson 170), which needs Excel for Windows. The PivotTable and lookup challenges on this page are an analyst's mock test.

Can I ask someone when a practice task stumps me?

Yes, with the instructor support plan. For two months you post written questions under any lesson, a Ninja Challenge included, and the instructor answers with guidance on the exercise rather than the finished formula, which is how the skill becomes yours; Ask AI in every lesson replies at once from that lesson's material. The two months start on the day you switch them on, not the day you buy The Complete Excel Course with AI Integration, so time them to your applications and the help covers the exact weeks you prepare.

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.