ACPD logo

AI Tools in Excel

(2 reviews)
by Alan Murray

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

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.

    Look inside

    Contents

    How it works

    Author

    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.

    Reviews

    4.3
    (2 reviews)
    5
    4
    3
    2
    1
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.

    You might also like

    Take a look at some of our bestselling courses

    alt

    2025 Autumn Budget

    alt

    2025 Winter Update: UK Tax

    alt

    2025 Tax Bulletin: December

    alt

    The Accountant as Company Secretary

    Got a team of 2 or more?

    Develop and retain a talented finance team with our team subscriptions.

    Use ACPD101 for 10% off any purchase.