AI Tools in Excel

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.