ACPD logo

Excel Skills Booster for Accountants

(67 reviews)
by Paula Guilfoyle

This course examines what Excel can offer accountants. Become confident in using fundamental and advanced Excel functions and features including conditional calculations and IF statements, lookups, tables, PivotTables and dynamic arrays.

£100+vat
4 CPD hours
120 days' access

This course will enable you to

  • Familiarise yourself with some fundamental Excel functions including IF statements, AND statements, and OR statements
  • Work with Excel PivotTables to quickly navigate, analyse data and find insights
  • Understand the VLOOKUP formula and how you can overcome its limitations with XLOOKUP
  • Use functions such as IF, INDEX, and MATCH to create dynamic and interactive charts
  • About the course

      Excel is a valuable tool for any accountant, but with so many features, are you making the most of what it has to offer? It can be difficult to keep track of all the tools available in Excel, but some can really transform the spreadsheets that you produce.

      This course will help you to ensure your Excel skills are up to date. Not only will you be able to use some fundamental functions of Excel such as IF statements, AND statements, and OR statements, but you'll also discover the new XLOOKUP function. Familiarise yourself with the benefits that using Excel PivotTables can provide when analysing data and create dynamic, interactive charts using functions such as IF, INDEX, and MATCH.

    Look inside

    Contents

    How it works

    Author

    Paula Guilfoyle

    Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.

    Reviews

    4.4
    (67 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.