RFP
Find a firm
Become a member
Member log in
This event has ended
Recording: Intermediate / Advanced Excel for auditors, tax and advisory professionals
Area: People Development
Duration: 3 hours
Recording – English version
Please click here to view the recording
Who should attend this interactive workshop?
This workshop is suitable for staff of all levels from trainee up to managing partner level. Member firms are welcome to register as many employees as you wish to attend.About the workshop
This session looks at tips and tricks for summarising, transforming and presenting data in Excel – key skills for finance professionals. Even if you think you know the following topics, check again – this session will demonstrate little known issues, classic gotchas and pro tips. Topics will include:
- Working with Tables: why you should use them more than you do
- Revisiting PivotTables: why people make mistakes and don’t even realise
- Useful functions – and some that hinder: if you think you know SUM, IF and VLOOKUP, think again
- File review tips: how to spot common issues and errors quickly without third party software
- Keyboard shortcuts
- Custom number formatting: ever wanted your numbers to look just that little bit better?
- Quick charting tips.
Facilitator: Liam Bastick
Liam has over 30 years’ experience in financial model development / auditing,
valuations, M&A, strategy, training and consultancy.
Liam has headed Ernst & Young’s modelling team in Melbourne and was an
Assistant Director in their strategic valuations team in London. He was also a
senior member of the UK Post Office’s M&A and strategy teams.
Liam is a Fellow of the Institute of Chartered Accountants (ICAEW), a Fellow of the
Institute of Chartered Management Accountants (CIMA) and is a professional
mathematician.
He has published the following books: An Introduction to Financial Modelling, Power BI MVP Book, Excel Insights, Continuing Financial Modelling, Financial Modelling in Power BI Liam has been a Microsoft MVP for the last 12 years and speaks at global conferences on Excel, PowerBI and financial modelling.
If you have any questions about this interactive workshop please contact Alastair McTavish at alastair.mctavish@nexia.com
Are you looking to develop and retain your top talent?
- For more details about Nexia's 2023 Global Leadership programmes attended by 200+ Nexians in 2021-22 please click here: https://nexia.com/members-area/people-development/training-events/
- Please click here to download the brochure for Nexia's 2023 Leadership programmes
- To access high-quality Audit, IFRS and professional skills learning join 2000+ Nexians using the Nexia Learning Hub and register on www.nexialearning.com
- Watch Bean Audit learning – testimonials from Nexia members to learn why a growing number of member firms are using Bean Audit learning to help develop their trainees auditors.
