Start learning
My learning

The Complete Excel Course with AI Integration

Excel course for e-commerce managers

This guide is for e-commerce managers and marketplace sellers managing listings, orders, fees and ads in Excel. The Complete Excel Course with AI Integration has no shop data of its own, but works heavily with order-level sales. This page selects the lessons online selling needs: text functions for listing files, SKU lookups, campaign return on investment, PivotTables by channel and product, and Power Query with a data model for marketplace reports.

See the plans Watch free lessons

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

At work, you will be able to:

  • Assemble bulk product upload and revision sheets: concatenate attribute fields into titles using TEXTJOIN and CONCAT, clean up phrasing with SUBSTITUTE and PROPER, and restrict attributes to approved choices using drop-down lists.
  • Consolidate marketplace fee, return and order spreadsheets using Power Query: stack tables, join records by order ID, and combine a folder of files.
  • Calculate net profit per order after subtracting shipping, returns and marketplace fees using XLOOKUP or a custom column, and determine channel margin percent using a DAX measure.
  • Monitor inventory levels across SKUs with lookup functions, and highlight items needing replenishment using IF combined with AND.
  • Evaluate advertising spend relative to revenue across campaigns using return on investment calculations protected by IFERROR.
  • Construct an interactive weekly sales dashboard categorised by product and sales channel, featuring slicers, KPI cards and PivotTables.

Projects

What you will build.

The course has 14 projects. These four matter most here.

  • Power Query sales report in Excel (SalesFusion): sales by category, sales by region and a monthly trend, with slicers for channel, year, category and region.

    Project 12

    SalesFusion

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

    Consolidate weekly fee, return and order sheets from multiple marketplaces by order ID and append them into a unified dataset.

  • Marketing dashboard in Excel with slicers at work (MarketPulse): KPI cards, a spend against revenue chart and a monthly ring, filtered to one channel by the Channel and Campaign slicers.

    Project 08

    MarketPulse

    One screen that shows which campaigns earn back their spend.

    Compare marketing costs directly against resulting campaign revenue to evaluate return on investment across each advertising channel.

  • Excel PivotTables and a PivotChart of sales data (SalesPlusPerformance): net sales by product category as a column chart, with State, Region and City filters.

    Project 05

    SalesPlusPerformance

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

    Examine product units and sales revenue across weeks and channels using order reports filtered through marketplace slicers.

  • XLOOKUP formula in Excel (PeopleInsight): each employee row looks up its location from another sheet.

    Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    Extract brand, type and size segments from SKU codes using LEFT, MID and RIGHT, while retrieving related stock, costs and platform fees via lookups.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 22 Cleaning data in Excel

Start with Lesson 22 if you already know how to enter figures and basic formulas, because building listing files requires tidy text. If you are entirely new to Excel, start at Lesson 1. Those already comfortable with SUMIFS and text manipulation can jump ahead to Lesson 153 to learn Power Query for marketplace reporting, or head straight to Lesson 105 to analyse advertising spend against sales.

68 of 186 lessons · 5 h 58 min

03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 4 of 9 lessons · 28 min Techniques for scrubbing marketplace listing exports: apply TRIM, Paste Special and Find and Replace, eliminate duplicate SKU rows with Remove Duplicates, and divide combined attributes using Flash Fill and Text to Columns. Lessons work through an employee database.
  1. 22 Start here 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
  3. 24 Flash Fill in Excel Split first and last names automatically 3 min
  4. 25 Text to Columns in Excel Split data by delimiter into separate columns 6 min
04 Essential formulas and functions (IF, SUMIF and more) 9 of 13 lessons · 53 min Use IF to spot SKUs reaching reorder thresholds, IFS to classify inventory tiers, and AND alongside OR to evaluate multiple conditions, followed by SUMIF, SUMIFS and COUNTIFS to calculate sales and unit volumes by product and channel. Exercises are based on sales data.
  1. 29 The IF function in Excel Pass or fail results with a single condition 3 min
  2. 30 IF function practice in Excel Categorise sales data with IF formulas 6 min
  3. 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
  4. 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
  5. 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
  6. 34 SUM, COUNT and COUNTA in Excel SUM with FILTER and counting numbers with COUNT 7 min
  7. 35 SUM, COUNT and COUNTA in Excel COUNTA, unique counts and completeness checks 4 min
  8. 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
  9. 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
05 Text functions and data validation (enhancing data quality) 7 lessons · 35 min Formulas for catalogue descriptions: assemble titles using CONCAT, the & operator and TEXTJOIN, standardise casing and spacing with TRIM, UPPER, LOWER and PROPER, swap wording throughout titles with FIND, SEARCH and SUBSTITUTE, split text with Text to Columns, and control attribute entries via drop-down lists.
  1. 41 CONCAT, the & operator and TEXTJOIN in Excel Combine text from multiple cells 6 min
  2. 42 TRIM, UPPER, LOWER and PROPER in Excel Clean messy text and fix capitalisation 6 min
  3. 43 FIND, SEARCH and SUBSTITUTE in Excel Locate and replace text with formulas 5 min
  4. 44 Text to Columns wizard in Excel Split a column by a comma delimiter 4 min
  5. 45 Data validation in Excel Create drop-down lists for consistent data entry 4 min
  6. 46 Ninja Challenge: problem Clean messy data with text functions and validation 4 min
  7. 47 Ninja Challenge: solution PROPER, Text to Columns and drop-down lists 7 min
07 PivotTables and PivotCharts: data analysis made easy 10 lessons · 33 min Summarise transaction records with PivotTables: review weekly sales and unit numbers across channels and products, group dates, and create interactive PivotCharts and slicers. Practice files use order-level sales data closely resembling marketplace order reports.
  1. 57 PivotTables 101 in Excel What a PivotTable does and the sales dataset 5 min
  2. 58 Preparing data for PivotTables Clean data with TRIM, PROPER, find and replace 5 min
  3. 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
  4. 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
  5. 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
  6. 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
  7. 63 PivotCharts in Excel Create interactive charts from a PivotTable 5 min
  8. 64 PivotTable design Tab Report layouts, PivotTable styles and number formats 5 min
  9. 65 Refresh a PivotTable in Excel Update pivots when source data changes 2 min
  10. 66 Excel Ninja Challenge PivotTable sales by region, category and monthly trend 1 min
08 Advanced Excel functions: lookups, text and arrays 7 of 12 lessons · 31 min Retrieve stock counts, cost figures and fee rates for orders or SKUs using XLOOKUP, VLOOKUP, and INDEX and MATCH, handle unrecognised codes with IFERROR, and manipulate SKU strings using CONCAT, TEXTJOIN, LEFT, MID and RIGHT. The source material uses HR records.
  1. 67 Lookup functions in Excel The PeopleInsight HR dataset and why lookups matter 2 min
  2. 68 VLOOKUP in Excel Find employee data across sheets with exact match 4 min
  3. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
  4. 70 IFERROR in Excel Handle lookup errors in VLOOKUP and XLOOKUP formulas 3 min
  5. 71 INDEX and MATCH in Excel A flexible alternative to VLOOKUP 6 min
  6. 72 CONCAT and TEXTJOIN in Excel Combine employee names and text with a delimiter 3 min
  7. 73 LEFT, RIGHT and MID in Excel Extract parts of a text code like DAL-SAL-0001 7 min
11 MarketPulse campaign intelligence dashboard 10 lessons · 50 min The MarketPulse project covers cleaning campaign data, shaping KPI strategies using ChatGPT and Copilot, determining click-through rates, conversion rates and return on investment wrapped in IFERROR, and assembling PivotTables, KPI cards, slicers and a timeline.
  1. 105 MarketPulse marketing dashboard in Excel Project overview and campaign data 4 min
  2. 106 Clean and check marketing data in Excel Remove duplicates, Copilot KPI plan 4 min
  3. 107 Plan a marketing dashboard with ChatGPT KPIs and the PivotTable strategy 4 min
  4. 108 Marketing PivotTables in Excel Build the MarketPulse pivot back end 6 min
  5. 109 CTR, conversion rate and ROI in Excel Marketing KPI formulas with IFERROR 4 min
  6. 110 PivotTables with Copilot Generate and verify marketing pivots in Excel 6 min
  7. 111 Marketing charts and a timeline in Excel MarketPulse dashboard PivotCharts 4 min
  8. 112 KPI cards in Excel Marketing KPI cards for the MarketPulse dashboard 7 min
  9. 113 Slicers for an Excel dashboard Interactive filtering in MarketPulse 4 min
  10. 114 Polish an Excel marketing dashboard Final formatting and insights in MarketPulse 9 min
15 SalesFusion: advanced data tools and a Power Query modelling system 21 lessons · 2 h 7 min In the SalesFusion project, Power Query brings in CSV files, cleans the data, creates custom profitability columns, merges and stacks tables, and compiles a folder of files; Power Pivot connects the tables so DAX measures can calculate total sales and margin percentage for a reporting dashboard. The Power Pivot lessons need Excel for Windows.
  1. 153 SalesFusion Power Query project Excel ETL pipeline and data model overview 5 min
  2. 154 Introduction to Power Query in Excel The ETL workflow explained 5 min
  3. 155 Import a CSV with Power Query Get data from text and transform data 2 min
  4. 156 Clean columns in Power Query Remove and rename columns for modelling 5 min
  5. 157 Clean text in Power Query Trim, clean, replace values and fix text case 6 min
  6. 158 Data types in Power Query Fix date, whole number, decimal and text types 7 min
  7. 159 Date columns in Power Query Add year, month and year-month fields for reports 7 min
  8. 160 Business logic in Power Query Custom and conditional columns for profitability 6 min
  9. 161 Group By in Power Query Summarise sales by month and region to validate data 5 min
  10. 162 Close and Load in Power Query Connection only, table or Data Model 5 min
  11. 163 Merge queries in Power Query Look up product and region names with a left join 5 min
  12. 164 Reuse a Power Query pipeline Duplicate queries for a new year of sales data 5 min
  13. 165 Append queries in Power Query Combine 2024 and 2025 sales tables 3 min
  14. 166 From Folder in Power Query Combine every sales file in a folder automatically 9 min
  15. 167 From Folder automation in Power Query Profit metrics and fiscal year columns 7 min
  16. 168 Build a sales fact table in Power Query Merge lookups and append history 6 min
  17. 169 Power Pivot Data Model in Excel Relationships and Diagram View 6 min
  18. 170 DAX measures in Power Pivot Total sales, margin percent and percent of total 10 min
  19. 171 PivotTable report from the Data Model Format the SalesFusion report in Excel 5 min
  20. 172 Interactive Excel dashboard Data model PivotTables, slicers and styling 10 min
  21. 173 Unpivot columns in Power Query Turn wide month columns into a long table 8 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.

Which Excel course is suitable for e-commerce managers and online sellers?

The Complete Excel Course with AI Integration from Coding Liquids addresses the practical spreadsheet tasks of digital selling: generating bulk listing files with CONCAT, TEXTJOIN and SUBSTITUTE, consolidating marketplace returns, order and fee exports in Power Query, calculating net profit per order with lookups and custom columns, monitoring SKU stock with reorder indicators, evaluating advertising expenditure against sales using return on investment, and constructing a channel and product sales dashboard. The 68 lessons selected on this page take 5 hours 58 minutes to complete.

Can an e-commerce manager work out profit per order after accounting for shipping, fees and returns?

Yes. With the Power Query The Complete Excel Course with AI Integration teaches, you join fee data to orders using order IDs, append return records, and add a custom column that subtracts returned amounts, shipping costs and marketplace fees from revenue, mirroring the approach taught in the profitability lessons using sales data. Directly in a worksheet, XLOOKUP performs an equivalent match, while a DAX measure calculates margin percentage across channels or products.

Does this course instruct marketplace sellers on listing optimisation or platform rules?

No. The Complete Excel Course with AI Integration focuses on Excel. It does not teach marketplace platform rules, listing optimisation, inventory management software or advertising networks. Instead, it concentrates on managing the spreadsheets transferred between those systems: bulk upload files, consolidated fee and order exports, inventory checks, marketing campaign returns and weekly sales summaries.

How does an e-commerce manager create bulk listing or update files in Excel?

By applying the text manipulation lessons in The Complete Excel Course with AI Integration: combine brand, product, colour and size columns into formatted titles with TEXTJOIN and CONCAT, clean up spacing and capitalisation using TRIM and PROPER, replace specific phrases across listings with SUBSTITUTE, dissect SKU segments using LEFT, MID and RIGHT, and enforce valid marketplace attribute entries using drop-down lists.

Can online sellers track advertising spend against sales revenue by campaign?

Yes. Through the MarketPulse dashboard project in The Complete Excel Course with AI Integration, you compute conversion rates, click-through rates and return on investment for each campaign using IFERROR, before constructing PivotTables, slicers, a timeline and KPI cards. By matching sales to each campaign using XLOOKUP, similar calculations reveal return on advertising spend across campaigns and channels.

Excel with AI

See the whole course.

The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.

See the plans Watch free lessons

The same course

For another job, level or topic.

By job

Finance and accounting
HR and office administration
Operations and supply chain
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
Technology

By level and topic