A practical guide to using Dynamic Arrays in Excel

Event information

Dynamic arrays have introduced entirely new ways of working in Excel. This webinar will cover a practical introduction to dynamic arrays, exploring how using this capability can make spreadsheets more flexible, scalable, and efficient when it comes to financial modelling.

Our experts Ruth Butler-Lee, Head of Financial Modelling at Arriva UK Trains Ltd, John Yeldham, Financial Modeller at JogEye, and Ben Ducker, Principal Consultant at Modelling Expert Ltd will also explore the limitations of using traditional Excel formulas in modelling scenarios, such as inconsistencies across ranges, bloated file sizes, and the reliance on manual changes, and how dynamic arrays address these challenges.

Through practical demos, they will showcase how dynamic arrays can simplify and enhance common tasks including:

• Eliminating helper columns with functions like UNIQUE
• Creating dynamic ranges for expanding selections
• Improving formula consistency across large datasets

This webinar is open to all but is ideal for those with good Excel knowledge seeking a clearer understanding of how to use dynamic arrays to solve common problems faced when using formulas in Excel. 

Key benefits

• Learn how to use dynamic arrays and how they can improve formula consistency and file performance.
• Explore real-life use cases, and how dynamic arrays can help solve common problems faced by users in Excel.
• Discover how dynamic arrays can simplify use of Excel in financial modelling, reducing the need for manual adjustments and risk of errors. 

About the speakers

	Ben Ducker, Principal Consultant, Modelling Expert Ltd Ben is a chartered accountant, a member of the ICAEW Excel Community Advisory Group, and a former Director at a top 7 UK accountancy firm. He has over 18 years' experience in Financial Modelling, Financial Planning and Analysis, and Corporate Finance and currently provides a wide range of freelance financial modelling consultancy services to UK based SME’s and their advisors.
	Ruth Butler-Lee, Head of Financial Modelling, Arriva UK Trains Ruth is a Chartered Accountant and Head of Financial Modelling at Arriva UK Trains, where she leads a dedicated team supporting strategic decision-making across the business. Ruth began her career as a software developer and technology auditor before discovering her passion for Excel and Financial Modelling at KPMG. There, alongside client work, she ran internal training courses in Excel and Financial Modelling before making the move to industry nine years ago.
	John Yeldham, Financial Modeller, JogEye John has 20 years experience in financial modelling development in both project and corporate finance - supporting deals and finance for Private Equity, renewable energy developers and waste recycling, among others. During his career, John created and renewed the financial modelling methodologies at two major accounting firms, and recently has specialised in utilising the latest Excel functionality (including dynamic arrays!) to help large infrastructure and energy clients model and manage their asset portfolios.

CPD hours

ICAEW's revised Continuing Professional Development (CPD) Regulations bring in new CPD requirements. This includes a minimum number of hours and an ethics requirement. Attending this webinar could contribute up to 1hr of verifiable CPD, providing you can demonstrate that the content is relevant to your role.

A copy of the webinar booking confirmation email is accepted as evidence of verifiable CPD. You will need to save the email as a JPEG or PDF before uploading it to your record. Click here to use ICAEW’s self-assessment tool to help you work out how much CPD you will need to fulfil each year.

Costs

ICAEW members and non-members are welcome to join. This event is organised by the Excel Community. Please click here to join online.