The Complete Excel Course with AI Integration

Excel or Access for a database: which to use?

Linked tables that many people update at once belong in Access. A list you sort, check, total and chart belongs in Excel, and The Complete Excel Course with AI Integration takes it far past a plain grid: tables that grow with each entry, drop-down lists that refuse stray values, lookups that join sheets by ID, and a Power Pivot data model with one-to-many relationships, the idea databases are built on. Each of its industry-standard projects was designed after talking with people from many different industries.

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 records in an Excel table that takes in every new entry, with a total row that never misses one.
  • Sort records on two levels at once and filter them by text, by a number range and by AND or OR conditions.
  • Make a column accept only values from an approved list, so entries match whoever types them.
  • Fetch each record's details from another sheet by a shared ID with VLOOKUP and XLOOKUP, two-way lookups included.
  • Link a sales table to its product and region tables one-to-many in a Power Pivot data model, as a database links its tables.

Projects

What you will build.

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

  • Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    Lookups that work like a database's relations: each employee's department name, HR partner, city, state, region and work arrangement fetched from lookup sheets by a shared code.

  • Project 12

    SalesFusion

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

    A relational model inside a workbook: sales, products and regions held as separate tables, merged with a left outer join in Power Query and related one-to-many in Power Pivot.

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

  • Project 02

    Dunder Michael Paper Company employee database

    Your records as a proper table: the employee list grows with each new hire, sorts on several levels, filters by branch, salary band, status or manager, and its department column takes values only from a list.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 19 Excel tables

Start at Lesson 19, where a plain list becomes an Excel table: everything after it, from drop-down lists to the data model, works on records kept that way. Never used Excel? The free preview lessons from Lesson 1 come first. Records already in tables? Go to Lesson 68 for lookups, or to SalesFusion from Lesson 153 for joins and relationships, on Windows for its Power Pivot lessons.

8 of 186 lessons · 50 min

03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 3 of 9 lessons · 24 min The Dunder Michael Paper Company records turned into an Excel table that takes in each new employee and sums salaries in its total row, then sorted by one column or several and filtered by branch, salary band, status and manager.
  1. 19 Start here Excel tables Create and format a table, structured references and total row 8 min
  2. 20 Sorting data in Excel Single and multi-level sort on an employee database 6 min
  3. 21 Filtering data in Excel AutoFilter, text and number filters on employee data 10 min
05 Text functions and data validation (enhancing data quality) 1 of 7 lessons · 4 min A drop-down list for the department column, built from a sheet of approved names: anything typed that is not on the list is refused, so the records stay consistent however many people fill them in.
  1. 45 Data validation in Excel Create drop-down lists for consistent data entry 4 min
08 Advanced Excel functions: lookups, text and arrays 2 of 12 lessons · 10 min Records joined across sheets by a shared code: VLOOKUP brings each employee's department name and HR business partner from a lookup sheet, then XLOOKUP adds city, state, region and work arrangement, with a fallback for codes it cannot find and a two-way lookup.
  1. 68 VLOOKUP in Excel Find employee data across sheets with exact match 4 min
  2. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
15 SalesFusion: advanced data tools and a Power Query modelling system 1 of 21 lessons · 5 min A database join without a formula: Power Query merges product and region lookup tables into the sales table with a left outer join, so every sale is kept and gains the names that go with its codes.
  1. 163 Merge queries in Power Query Look up product and region names with a left join 5 min
15 SalesFusion: advanced data tools and a Power Query modelling system 1 of 21 lessons · 6 min Relationships, the heart of a database, built in Excel: three tables loaded into the Data Model and linked one-to-many in Power Pivot's Diagram View, which the lesson calls the same principle behind professional database tools. Power Pivot needs Excel for Windows.
  1. 169 Power Pivot Data Model in Excel Relationships and Diagram View 6 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 use Excel or Access for a database?

Use Access when your records spread over several related tables, many people enter data at the same time, and a new record must match one that already exists in another table; Microsoft's own guidance draws the line there. Use Excel when the records form a list, or a few, that you sort, check, total and chart. The Complete Excel Course with AI Integration from Coding Liquids makes Excel the strong choice for that work, and the 8 lessons picked here (50 minutes) take a list from a plain range to a data model with relationships.

What is the difference between Excel and Access?

Access is a database: records live in tables linked by relationships, people enter them through forms, reports sum them up, and one table can refuse a record with no match in another. Excel is a spreadsheet, where the data, the calculations and the charts share one grid. The gap is narrower than it looks, and The Complete Excel Course with AI Integration closes it from the Excel side: a table that grows with its records (Lesson 19), then a Power Pivot data model whose one-to-many links leave Excel, in the lesson's words, thinking about your data the way a database does (Lesson 169).

What are the pros and cons of Excel and Access?

Access gives you forms that make data entry easy, reports for printed or on-screen summaries, rules that keep linked tables in step, and safe updates when many people work at once; in return it runs on Windows desktops and asks you to design its tables before the first record goes in. Excel puts calculations, PivotTables and charts right beside the data, on Windows, Mac or the web; in return nothing ties one sheet to another unless you build it. The Complete Excel Course with AI Integration teaches you to build it: drop-down lists that keep entries clean (Lesson 45) and lookups that join sheets by ID (Lesson 69).

Is Excel or Access better for inventory?

For a stock list one person keeps, with quantities to total and items to flag, Excel is quicker to set up and easier to analyse; once several people log stock movements against linked product and supplier tables at the same time, Access is the safer home. The lessons of The Complete Excel Course with AI Integration practise on the course's own employee and sales records, and every skill a stock sheet needs is among them: a table that takes in each new item (Lesson 19), filters for one category or a range of quantities (Lesson 21), totals that meet several conditions (Lesson 37) and product details looked up by code (Lesson 69).

Can Excel be used as a database?

For a list of records that a few people keep, yes, and built properly it behaves like one. In The Complete Excel Course with AI Integration the records sit in an Excel table, one row per record and one column per field (Lesson 19); a drop-down list accepts only approved values (Lesson 45); VLOOKUP fetches details from another sheet by ID (Lesson 68); and in SalesFusion three tables are related one-to-many in a Power Pivot data model (Lesson 169), which needs Excel for Windows.

Can I use Excel and Access together?

Yes, and Microsoft suggests exactly that: keep the data in Access and analyse it in Excel to get the benefits of both. The analysis half is what The Complete Excel Course with AI Integration trains you for: PivotTables that group and total a table in a few drags (Lesson 59), Power Query merges that join tables with a left outer join (Lesson 163) and a data model that relates them one-to-many (Lesson 169).

When should I move my records from Excel to Access?

When the list stops being a list: the records need several linked tables, more people must add to them at the same moment, or each entry has to match a record somewhere else before it is accepted. Until then a well-built workbook does the job, and The Complete Excel Course with AI Integration shows you how to build one that holds up: records sorted on more than one level without a row coming apart (Lesson 20), and details pulled from another sheet by XLOOKUP, with a fallback when a code is missing (Lesson 69).

Is there a course that covers Excel and Access for managing records?

The Complete Excel Course with AI Integration gives you the Excel half at full depth: records kept in tables, guarded by drop-down lists, joined across sheets and related in a data model, each skill built on an industry-standard project: the Dunder Michael Paper Company database, the PeopleInsight HR workbook and SalesFusion. Access itself is not taught. With lifetime access the lessons stay yours to revisit, a Certificate of Completion with a verification link marks the finish, the optional instructor support plan adds 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 covers the purchase.

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.