Booking with a Training Ticket
Once you have booked your course, you will receive an email with your booking
confirmation. The steps you will need to follow to access your online course
will arrive in a separate email within 48 hours of your order being
processed.
Please be aware that participants will have access to this course for
120 days from the date of receiving access via email notification
Course overview
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.
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
Contact Us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at
(+353) 01 523 3930