The Complete Excel Course with AI Integration
Excel, Python or SQL: which to learn first?
Excel first, SQL once your data sits in a database, Python when the analysis has to run as code: a sound order for anyone new to data. The Complete Excel Course with AI Integration makes the first step a strong one. On industry-standard projects designed after talking with people from many different industries, you filter, join, group and total data the way SQL and Python do, without leaving Excel, right up to Power Query pipelines that rerun on next year's file.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Answer a question with several conditions, such as one product's sales in one region, with a single SUMIFS or COUNTIFS.
- Group thousands of sales rows by region, category and month in a PivotTable without writing a line of code.
- Pull every row that meets AND or OR conditions into a list that follows the data, with one FILTER formula.
- Summarise a table by month and region with Power Query's Group By, summing sales and counting rows to check the data.
- Join a sales table to its product and region lookups with a left outer join, and stack a second year's rows beneath it.
- Point a finished cleaning pipeline at next year's file and let every step run again without touching a cell.
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.
The GROUP BY of the spreadsheet world: a PivotTable that sums thousands of orders by region, state, channel and category as you drag fields, and folds order dates into years, quarters and months.
-
Project 06
PeopleInsight HR workbook
Employee data joined across sheets with one formula.
A WHERE clause written as a formula: FILTER returns the employees of one location, one job level, or those who pass AND and OR tests at once, in a list that follows the data.
-
Project 12
SalesFusion
A sales report that refreshes itself from a folder of files.
Where Excel works like a data pipeline: Group By totals, a left outer join to two lookup tables, the same steps rerun on a new year's file, and both years stacked into one table.
-
Project 03
Sales Goal Tracker
Questions with conditions stacked, answered in one formula: one product's sales in one region, big deals with an excellent rating, and orders counted between two dates.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 9 of them, 38 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 37 SUMIFS and COUNTIFS in Excel
Begin at Lesson 37 if you can already write a SUM: SUMIFS is where Excel starts answering questions with conditions, the way a query does. New to Excel? Take the free preview lessons from Lesson 1 first, then the formulas from Lesson 28. Fluent in formulas already? SalesFusion opens at Lesson 153, and its Group By arrives at Lesson 161.
9 of 186 lessons · 38 min
04 Essential formulas and functions (IF, SUMIF and more) SUMIFS and COUNTIFS on sales records: the total for one product in one region, deals above a threshold with an excellent rating, and orders counted between two dates, the conditions a WHERE clause carries.
- 37 Start here SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
07 PivotTables and PivotCharts: data analysis made easy GROUP BY with a mouse: a PivotTable built from the sales table totals net sales by region, then by state, with sales channels across the columns, sets revenue beside cost for each product category and rolls order dates up into years, quarters and months.
- 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
- 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
- 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
08 Advanced Excel functions: lookups, text and arrays FILTER on the PeopleInsight employee table: staff at one location, staff at one job level, then an asterisk for AND and a plus for OR, every result spilled from a single formula.
- 76 FILTER function in Excel Dynamic array filtering with AND and OR criteria 5 min
15 SalesFusion: advanced data tools and a Power Query modelling system Group By in Power Query's advanced mode: sales summed and rows counted for every month and region, sorted to float the biggest figures up and filtered to drop empty groups, a quality check before anything is loaded.
- 161 Group By in Power Query Summarise sales by month and region to validate data 5 min
15 SalesFusion: advanced data tools and a Power Query modelling system SalesFusion's joins and stacks: sales merged with product and region lookups in a left outer join that keeps every sale, the whole pipeline pointed at the next year's file to run every step again, with the join kinds SQL users know on show, then both years appended into one table.
- 163 Merge queries in Power Query Look up product and region names with a left join 5 min
- 164 Reuse a Power Query pipeline Duplicate queries for a new year of sales data 5 min
- 165 Append queries in Power Query Combine 2024 and 2025 sales tables 3 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.
Should I learn Excel, Python or SQL first?
Excel first if data is new to you: every row and every result stays in view while you work, and the questions you learn to ask carry straight into the other two. Add SQL when your data lives in a database you must query, and Python when the analysis has to run as code: automated, very large, or heading into statistics and machine learning. The Complete Excel Course with AI Integration from Coding Liquids makes Excel a strong first step, and the 9 lessons picked here (38 minutes) do in Excel what SQL and Python are known for: filtering, joining, grouping and rerunning.
Is Python better than Excel for data analysis?
At some jobs, yes; at the daily ones, Excel usually gets you there first. Python wins when data outgrows a workbook, when the same analysis must run unattended, or when the work turns to statistics and machine learning. Excel wins when you need an answer today, a result you can see and check cell by cell, and a workbook anyone in the office can open and follow. The Complete Excel Course with AI Integration sharpens that edge to a professional level: SUMIFS with stacked conditions (Lesson 37), PivotTables that regroup sales as you drag (Lesson 60) and a Power Query pipeline that reruns on a new file (Lesson 164).
What is the difference between Excel and SQL?
SQL is the language for asking a database questions: pick the rows WHERE a condition holds, JOIN one table to another, GROUP BY to total. Excel is where you see the data, work on it and present it, and it runs the same ideas without a line of code. The Complete Excel Course with AI Integration teaches them in Excel's form: FILTER returns the rows that pass AND or OR conditions (Lesson 76), a PivotTable groups and totals (Lesson 61), and Power Query merges a sales table with its lookups in a left outer join (Lesson 163), the very join a SQL query would write.
Can Excel do joins and GROUP BY like SQL?
Yes, through Power Query, and The Complete Excel Course with AI Integration has you do both on SalesFusion's sales data. Group By sums sales and counts rows for every month and region (Lesson 161); a merge brings product and region names into each sale with a left outer join (Lesson 163); the next lesson shows the other join kinds, right outer, full outer and inner, as the whole pipeline reruns on a new year's file (Lesson 164); and an append stacks both years into one table (Lesson 165), the job SQL's UNION ALL does.
Can Excel clean data the way Python does?
It can, and without code: Power Query records every cleaning step and replays it on the next file, the repeatable workflow Python scripts are prized for. In The Complete Excel Course with AI Integration you set the cleaning once in a sample file and every file dropped into the folder gets it: spaces trimmed, codes in capitals, stray symbols replaced, data types fixed, and column quality showing errors and empty cells across the whole dataset (Lesson 166). A pipeline built for one year then runs every step on the next year's file after a single change of source (Lesson 164).
Should I automate Excel tasks with Python or with macros?
Reach for Python when the job spreads far beyond one workbook, across many systems and files; use Excel's own tools when the task lives in the workbook. The Complete Excel Course with AI Integration teaches three of them: a recorded macro, then VBA with loops and an error handler that checks a whole sheet in FormatWizard (Lesson 152); Power Query steps that run again on every new file; and Power Automate Desktop flows, on Windows, that open a workbook and read its data for you (Lesson 178).
Does learning Excel first make SQL and Python easier?
It gives you a head start on both, because the hard part is the thinking, and Excel trains it in plain sight. After The Complete Excel Course with AI Integration, a WHERE clause is the FILTER condition you already write (Lesson 76), GROUP BY is the PivotTable you already drag (Lesson 59), a JOIN is the merge you already run (Lesson 163), and a Python cleaning script spells out in code what your Power Query steps do. Python and SQL themselves are not taught; you arrive at them knowing exactly what you want your code to do.
Is this Excel course a good first step into data analysis?
Yes. The Complete Excel Course with AI Integration takes you through the entire workflow of data analysis in Excel, end to end, from a raw export to a finished dashboard, on industry-standard projects whose finished workbooks show what you can do. Lifetime access keeps every lesson there for the day SQL or Python sends you back to check a technique, the Certificate of Completion carries a verification link, the optional instructor support plan gives two months of written questions answered by the instructor, with Ask AI in every lesson, from the day you choose, and a 14-day money-back guarantee stands behind it.
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
- Certificates
- 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