Excel Skills Booster for Accountants

(61 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.

price €85+vat
cpd hours 4 CPD hours
access 120 days' access

Use CPA101 for 10% off any purchase.

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

imac
slide-1
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

Contents

  • The fundamentals
    • Logical tests, comparative operators, and IF statements
    • Comparative operators
    • The AND and OR statements
    • The basics of IF
    • Using IF with AND
    • Nested IF statements
    • SUMIF and SUMIFS
  • Understanding tables
    • Working with tables
    • An introduction to PivotTables
    • Inserting PivotTables
    • PivotTable design
    • Advanced PivotTable tricks
    • Paula's analysis
  • Don't forget to lookup!
    • Introducing VLOOKUP
    • VLOOKUP with approximate match
    • INDEX
    • MATCH
    • Looking up to the left
    • INDEX and MATCH
    • XLOOKUP vs VLOOKUP
    • XLOOKUP
    • XLOOKUP with wildcards
    • XLOOKUP approximate match
  • Advanced charting techniques
    • How to fix the axis scale across multiple charts
    • Data validation
    • Dynamic ranges to visualise subsets of data
    • Tips for creating dashboards
    • Formatting charts based on criteria

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
(61 reviews)
5
4
3
2
1
 
 
 
 
    SS
    Stephen S
    26 Mar 2025
    26 Mar 2025
    Very useful course. Graphs are tricky but practice makes perfect.
    TH
    Terry H
    22 Jan 2025
    22 Jan 2025
    Very well explained and it's easy to follow and process the information alongside the course. Definitely for those wanting to improve their excel skills.
    AG
    Annette G
    30 Dec 2024
    30 Dec 2024
    This course was exactly what I was hoping for, lots of new knowledge for me. There were a few bits I was already comfortable with, but every section had extra tips and shortcuts I didn't know before, which I found really useful. A couple of feedback points: Section 4 � Advanced charting techniques �Dynamic ranges to visualise subsets of data�. In the Excel download, tab �Dynamic ranges�, the date in cell A25 was different from the tutor�s version. This made it very difficult to follow the session until the error was hunted down and corrected! Section 4 � Advanced charting techniques �Using multiple sheets� the image showing the calculations sheet, example formulas and demonstrating the meaning of �helper columns� is not in a high enough resolution to read, even when magnified or saved.
Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.
Access to this course
Total CPD unitshourshours4 unitshourshours21 units20 hours21 hours800+ unitshourshours800+ unitshourshours
Access period120 days120 days
Access to end 2025		12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team’s needs
Learn moreLearn moreLearn more

Why not upgrade?

Find the best way to complete your CPD

You might also like

Take a look at some of our bestselling courses

Use CPA101 for 10% off any purchase.