Overview

• Analysing data with Pivot Tables
• Making decisions through Nested Logical Functions – IF, AND, OR
• Finding and copying data with Nested XLOOKUP functions – sophisticated Lookup techniques
• XLOOKUP extended capabilities – e.g. wild card LOOKUP & returning multiple columns
• Finding and copying multiple records using FILTER function

This webinar was recorded on 09th November 2023.

Chris James

Chris James is passionate about both spreadsheets and effective learning, Chris enjoys helping people develop their spreadsheet skills through a variety of platforms; from in-person classroom courses he delivers, to remote access courses.

Originally trained in IT support, Chris followed his passion for training and moved across to IT training back in 2001. The next 15 years saw Chris work for a variety of London based training companies a freelance Microsoft trainer. As MS Excel grew in its use with office and business workers alike, the demand for effective training grew with it and Chris found most of his time spent delivering 1-day Excel courses for businesses in and around central London.

In 2016 Chris founded his own business with a training company focused solely on helping people to develop spreadsheet skills. A family run business with Chris’ daughters (Joetta, Alicia and Laurissa) very much central to the growth of the business. Chris spends much of the winter months travelling Latin America, exercising his use of the Spanish language.

6 CPD units

1 hour of learning = 1 unit of CPD.

ACCA members can use this learning to meet their CPD requirements provided it is relevant to their career. If the event contributes to general knowledge and skills, it should be recorded as non-verifiable CPD. If the learning can be applied in the workplace, it will contribute to verifiable CPD.

Fee: 199 GBP + VAT (238.80 GBP) per delegate

Please note: If you are unable to join the live webinars, they will be available on-demand 24 hours after the live webinar ends and you will have access to the sessions for 12 months.

The webinar handout material will be available on the webinar platform when you log in to view, 15 minutes before the live webinar start.

If you wish to view or download handout materials, before the day of the webinar, they will also be available through your document library on https://events.accaglobal.com.

This event is organised by ACCA UK Continuous Learning Team.

If you have any queries regarding this event please contact us on:

UKCL@accaglobal.com