The Complete Excel Course with AI Integration

Excel or Google Sheets: which should you learn?

Several people typing into one sheet at once? Google Sheets was made for that. Messy data turned into answers, a routine run by a macro, a folder of files that becomes one report? That is Excel's ground, and The Complete Excel Course with AI Integration puts you on it with industry-standard projects, each designed after talking with people from many different industries. The everyday formulas you learn still travel with you into Sheets.

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:

  • Keep a monthly budget that totals every category, lights up any expense over your limit and shows its split in a pie chart.
  • Turn order-level sales into totals by region, state and channel in a PivotTable, then cut it to one region with slicers.
  • Have Copilot chart a PivotTable for you, then ask it for two chart options and the story each one tells.
  • Record a macro once and replay its formatting with a shortcut key whenever a row needs it.
  • Drop a new sales file into a folder and let Power Query fold it into one clean table on the next refresh.

Projects

What you will build.

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

  • Project 01

    Personal Budget Tracker

    Your first workbook: where the money goes each month.

    A household budget in Excel from the first formula: totals and an average expense, a highlight that catches the big spends, a category summary and a pie chart labelled in percentages.

  • Project 05

    SalesPlusPerformance

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

    Order-level sales regrouped in a drag: net sales by region, state and channel, revenue against cost by category, dates rolled up into quarters and months, and slicers for one state or region.

  • Project 14

    Agentic AI in Excel

    AI finds and fixes the formula; you check it before it counts.

    Copilot and ChatGPT set the same chart task, so you see which one builds inside the workbook and which hands back a file to check, and which assistant the instructor pairs with each spreadsheet.

  • Project 11

    FormatWizard

    One click that checks a whole sheet for you.

    Excel's own automation from its first step: what a macro is and what VBA does underneath, then a macro recorded, named and run from a shortcut key.

  • Project 12

    SalesFusion

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

    Power Query turning a folder of sales files into one living dataset: drop in a new file, refresh, and every cleaning step runs on it too.

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

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, 56 min of video. Each lesson keeps its number in the course.

Where to start

Lesson 14 SUM and AVERAGE in Excel

Start at Lesson 14 if you have kept a budget in Google Sheets: the Personal Budget Tracker does the same job in Excel, and its first formulas will look familiar. At home with formulas already? Go straight to PivotTables at Lesson 59. Never used a spreadsheet? The free preview lessons from Lesson 1 come first.

12 of 186 lessons · 56 min

02 Project: personal budget tracker 4 of 5 lessons · 22 min Your money on one dashboard: total income, expense and savings with an average expense beside them, a rule that lights up every expense over your limit, a total for each category and a pie chart showing each one's share.
  1. 14 Start here SUM and AVERAGE in Excel Personal budget tracker totals and average expense 4 min
  2. 15 Conditional formatting in Excel Highlight rules, data bars and icon sets 3 min
  3. 16 Monthly expense summary in Excel Category totals for a personal budget tracker 7 min
  4. 17 Excel charts for beginners Pie chart of budget expenses by category 8 min
07 PivotTables and PivotCharts: data analysis made easy 4 of 10 lessons · 10 min PivotTables on order-level sales: net sales by region and state with sales channels across the top, revenue against cost by product category, order dates grouped into years, quarters and months, then slicers that filter the report to one state or region.
  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
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 6 min Copilot builds a line chart of monthly revenue and a bar chart by region from a PivotTable and explains the story each tells; ChatGPT works on an uploaded copy, and the lesson ends with the instructor's choice of assistant for Excel and for Google Sheets.
  1. 93 Charts with Copilot and ChatGPT Create and choose the right Excel chart 6 min
14 VBA and macros in Excel: FormatWizard 2 of 17 lessons · 9 min What a macro is and the VBA that powers it, on the FormatWizard sales sheet, then a first macro recorded with a name and a shortcut key that puts bold, italic and a highlight back on a flagged row in one click.
  1. 136 Excel macros and VBA for beginners What macros are, the FormatWizard project 3 min
  2. 137 Record your first Excel macro Name, run and use absolute references 6 min
15 SalesFusion: advanced data tools and a Power Query modelling system 1 of 21 lessons · 9 min Next month's sales file goes into a folder, you press refresh, and From Folder adds it to one combined table, its cleaning steps written once in the sample file and column quality flagging errors and empty cells across every file.
  1. 166 From Folder in Power Query Combine every sales file in a folder automatically 9 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.

Should I learn Excel or Google Sheets?

Choose Google Sheets if your work lives in shared files that several people edit at the same time in a browser; choose Excel if it needs depth: PivotTables with slicers, recorded macros, Power Query folding a folder of files into one table. Unsure? Start with Excel. Sheets supports the formulas desktop spreadsheets use, so yours travel with you, and Excel's heavier tools come on top. The Complete Excel Course with AI Integration from Coding Liquids takes you the whole Excel way on industry-standard projects, and the 12 lessons picked here (56 minutes) show where it pulls ahead.

What is the difference between Excel and Google Sheets?

Where each one lives, and how far each one goes. Google Sheets works in a browser and on phones and tablets for anyone with a Google account, lets several people edit one sheet at the same moment, keeps a revision history to roll back to, and saves its macros as Apps Script. Excel is Microsoft's spreadsheet, on Windows, Mac and the web, with Power Query, VBA and, on Windows, Power Pivot built for heavy, repeated work. The Complete Excel Course with AI Integration teaches that Excel side, from a first recorded macro (Lesson 137) to a folder of sales files combined into one query (Lesson 166).

Is Excel or Google Sheets better for data analysis?

For the entire analysis, from raw files to a finished report, Excel takes you further, and The Complete Excel Course with AI Integration walks that road end to end; Sheets serves a shared list and its everyday summaries well. In Excel you drag order-level sales into a PivotTable for totals by region, state and channel (Lesson 60), let it roll order dates up into years, quarters and months (Lesson 61) and slice it to one region with a click (Lesson 62). Then Power Query combines a folder of sales files and profiles every column for errors and empty cells across the whole dataset (Lesson 166).

Is Excel or Google Sheets better for budgeting?

Either keeps a household budget. Choose Sheets if two of you update it from your phones; choose Excel if you want the budget to grow into money models you build yourself, retirement included. The Complete Excel Course with AI Integration starts with the Personal Budget Tracker: a total for each category (Lesson 16), a rule that lights up any expense over your limit (Lesson 15) and a pie chart of where the money goes (Lesson 17). Then comes WealthFlow, a retirement simulator you build with a SIP (a sum invested every month), an SWP (a regular withdrawal) and inflation, every assumption yours to change and no website or app between you and your own plan (Lesson 133).

What are the pros and cons of Excel and Google Sheets?

Sheets' strengths: several people editing at once, sharing settings for who may view or edit, revision history, and your sheet on any phone, tablet or desktop. Its trade-off: macros are Apps Script, and Google offers a converter for Excel files that carry VBA code. Excel's strengths: Power Query, Power Pivot with DAX, VBA and Power Automate for heavy, repeated work; its trade-off: Power Pivot and Power Automate need Windows. The Complete Excel Course with AI Integration turns those strengths into skills of your own: slicers on a PivotTable (Lesson 62), a recorded macro replayed in one click (Lesson 137) and a folder query refreshed in another (Lesson 166).

Do Excel formulas work in Google Sheets?

The everyday ones, yes. Google states that Sheets supports the formulas typical of desktop spreadsheets, and SUMIFS, COUNTIFS, FILTER and XLOOKUP all appear in its function list. So the formulas you master in The Complete Excel Course with AI Integration go wherever your files go: SUM and AVERAGE in the budget tracker (Lesson 14), SUMIFS stacking several conditions (Lesson 37), XLOOKUP across sheets (Lesson 69) and FILTER spilling only the rows you ask for (Lesson 76). Past the formulas, the course carries on into Power Query and VBA, Microsoft's own tools for the heavy jobs.

Which AI works best with Excel, and which with Google Sheets?

The instructor's favourite is Claude for Excel, and ChatGPT if you work in Google Sheets: that advice closes the The Complete Excel Course with AI Integration lesson in which Copilot and ChatGPT take on the same chart task (Lesson 93). Copilot draws a line chart of monthly revenue and a bar chart by region inside the workbook and explains what story each one tells; ChatGPT edits an uploaded copy and needed a second prompt to bring its PivotTable back. You then watch Claude itself analyse data and build inside Excel at Lesson 104.

Is this Excel course for me if my team uses Google Sheets?

Yes, if you want to be the one your team turns to when a spreadsheet job gets heavy. The formulas, PivotTables and charts of The Complete Excel Course with AI Integration are ideas a Sheets user works with every day, and Power Query, macros and VBA give you the tools to take the big jobs into Excel. You need Microsoft Excel to follow the lessons, and Google Sheets itself is not taught. What you get is lifetime access, a Certificate of Completion with a verification link, the optional instructor support plan with two months of written questions answered by the instructor and Ask AI in every lesson, started on the day you choose, and a 14-day money-back guarantee.

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.