AssistantAI TRAINING
Learning guide · 3 courses

Get spreadsheet data ready for AI

Before using AI to analyze a spreadsheet, check whether the data is complete and consistent. Cleaning is different from interpreting results. Preserve the original and check what changed.

Find your starting point

Data Cleaning & Processing with Copilot in Excel is focused on missing values, duplicates, data types, standardization, text operations and repeatable prompts, with 20 AI-graded assignments listed. It requires Copilot in Excel. The course links a 30-day trial for some learners. Microsoft Excel Masterclass With ChatGPT, Copilot & AI is broader, with cleaning, workbook audits, dashboards, models and scripts.

Advanced Data Analysis & Visualization with Copilot in Excel starts after data preparation and covers statistical analysis, external data, pivots, charts and reporting, with 22 assignments listed. ChatGPT + Zapier: From Email Inbox to Excel Spreadsheet also ends in a spreadsheet, but it teaches email extraction into Google Sheets rather than cleaning an existing workbook.

Keep the source data and a change log. Check totals, missing values, duplicate decisions and date or text types yourself. Confirm whether the course needs Excel, Copilot or Zapier access.

Example to try

Make sense of a spreadsheet

  1. 01Start with

    A small table of expenses

  2. 02Make a first pass

    Clean data + a useful formula

  3. 03Make it yours

    Check row counts and totals

Use a fictional example to practise the workflow.

Compare the courses

CourseWhat you’ll doTimeCost and access
Data Cleaning & Processing with Copilot in ExcelMicrosoft
  • Twenty AI-graded assignments are listed.
  • Page includes hands-on activities/debriefs for error correction, data error identification, Copilot activation, transformation and data preparation
  • The five module estimates are 5+3+3+3+4 hours (18 hours).
  • Videos/readings/assignments are components of module study estimates, not video runtime.
  • Copilot software license is separate and required according to page.
Microsoft Excel Masterclass With ChatGPT, Copilot & AISawan Kumar
  • Practical spreadsheet and analyst projects are listed
  • 14h 58m of video
  • Check the course page for current pricing and software requirements.
Advanced Data Analysis & Visualization with Copilot in ExcelMicrosoft
  • 22 assignments are listed across the five modules.
  • 2 weeks at 10 hours a week
  • Check the course page for certificate pricing, free trials and options to study without a certificate.
  • Listed as included in Coursera Plus. Check your subscription for access.

Take a closer look

Try this before you choose

Make a small nonsensitive sheet with a duplicate, a missing value, a text-number mismatch and an inconsistent date. Compare how each method handles them, then check row counts and totals before moving on to analysis.

You might also find these helpful