ICAEW’s Excel Community has worked with a broad swathe of modelling organisations and experts, taking a half dozen methodologies and paring down to the commonly held, widely accepted beliefs about what constitutes good modelling.
There are now eight different suites of Excel online training available as part of your membership subscription – this is a major benefit. Improve your Excel capabilities and minimise spreadsheet risk.
Twenty principles for good spreadsheet practice aims to reduce spreadsheet errors and wasted time.
The framework is a structure for assessing ability and proficiency when using spreadsheets.
Features and articles
Simon Hurst breaks down how data analysis expressions work and what they can achieve.
Data – how you get it and what you do with it – has been an important part of the accountant’s role since the beginning; but it is only now, with data exploding in volume, variety and velocity, that accountants can start to add serious value to their business and that of their clients. As the guide says, ‘data analytics can broadly be defined as the use of data to support business decisions’.
Simon Hurst explains how to take your Excel expertise to a whole new level with the gradual introduction of dynamic array functions.
Financial models are vital tools in modern business, but are highly susceptible to being ruined by their creators' bad habits. ICAEW decided to turn this situation around by developing a new code of practice.
Blogs and discussions
Modern Excel – Text clean up Text formulas in Excel are difficult, Ever tried extracting the last name from a “full name” column, where some have double-barrelled names?
The Excel Tip of the Week shows you how to write in large swathes of formulas automatically using VBA.
Webinars and recordings
Providing a step-by-step guide demonstrating how to methodically transform any automatically generated report extract into usable data.
Archive of webinar recordings. Includes financial modelling, PivotTables, Power Query, Excel Tip of the Week Live and many more.
The introduction of the Power Query tools to Excel in Excel 2010 made it possible to fully automate a range of spreadsheet processes.
Join David Benaim to discover some of the newer features of Excel and how they can help you to utilise the program.
Finance in a Digital World
ICAEW is collaborating with Deloitte to ensure its members and students have the knowledge and skills to take advantage of the opportunities offered by the fourth industrial revolution and to meet its challenges head on. Log-in to access exclusive content, including: eLearning, webinars and bite-sized summaries on individual technologies and the broader impact of digital technologies on finance.
The Library & Information Service provides a hand-picked collection of eBooks as a benefit of membership. If you are unable to access an eBook, please see our Help and support or contact email@example.com
A practical guide to financial modelling, demonstrating how to plan, design and build financial models.
A beginner's guide to financial modeling using Microsoft Excel.
Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter