AI Tools in Excel

by

Learn how to use ChatGPT and Copilot to speed up and simplify your Excel work, from cleaning data and writing formulas to generating insights.

£100 +VAT

4 CPD hours

120 days’ access

Use ACPD101 for 10% off any purchase.

AI Tools in Excel

£100 +VAT

4 CPD hours 120 days’ access
Use ACPD101 for 10% off any purchase.

AI Tools in Excel

This course is not currently available. To find out more, please get in touch.

This course will enable you to

  • Identify the distinct strengths of ChatGPT and Excel Copilot, and when to use each
  • Clean, reformat, and correct inconsistent data in Excel
  • Use AI to troubleshoot formula errors and build them step-by-step
  • Generate macro code snippets, troubleshoot and enhance VBA code
  • Streamline your Excel workflows
  • Create compelling summaries, insights and data visualisations

About the course

Navigating Excel can be disorientating. With the software changing every year, you can suddenly find yourself left in the dark. But with AI tools like ChatGPT and Copilot, you can now consult a friendly voice for advice, ensuring that you’re always using Excel as efficiently as possible.

In this course, you’ll explore how ChatGPT and Copilot can support your work at every stage of a spreadsheet workflow, from cleaning and reformatting data to writing formulas, generating summaries, and building visualisations. You’ll also see how AI can help with more technical tasks like generating macros and enhancing VBA code, while offering guidance on which tool to use and when.

By the end, you’ll be able to use AI confidently to improve the speed, accuracy, and creativity of your Excel work, whether you’re troubleshooting errors, analysing data, or automating repetitive tasks.

Contents

The basics

Using AI
Different AI tools
Introduction to ChatGPT
Useful ChatGPT settings
Using ChatGPT
Using Copilot in Excel
Everyday Excel with Copilot

Cleaning data

Cleaning data with Copilot
Clean Data
Fixing messy data with ChatGPT
Fixing messy data
Getting transformation steps

Writing formulas

Writing formulas with Copilot
Using Copilot
Stepping up with Copilot
Writing formulas with ChatGPT
Using ChatGPT
Fixing formulas with ChatGPT
Using AI to explain formulas

Automating tasks

Generating macros with ChatGPT
Writing macros with ChatGPT
Enhancing macro code with ChatGPT
Power Query
Power Query in action

Analysing data

Data insights with ChatGPT
Analyse Data in Excel
Asking ChatGPT specific questions
Asking Copilot specific questions
Charts in ChatGPT
Enhancing reports with Copilot

How it works

Author

Alan Murray

Alan Murray

Alan has over 20 years” experience as an Excel trainer and loves to help companies improve their business processes and learn how to harness the power of Excel.