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 five different suites of Excel online training available to Excel Community members as part of their membership subscription – this is a major benefit of Community membership.
Twenty principles for good spreadsheet practice aims to reduce the amount of time wasted and the number of (sometimes costly) errors caused by businesses.
The framework is a structure for assessing ability and proficiency when using spreadsheets.
Features and articles
Simon Hurst explains how PivotTables can drive management reporting and the creation of interactive dashboards.
Simon Hurst explains how you can avoid the Fear Of Missing Out when it comes to new features in Excel through the ICAEW Excel Community.
The Excel Community has created a new code – an application of the tenets of best practice and the Twenty principles for good spreadsheet practice to financial modelling construction.
Simon Hurst explains how to use Data Validation and hierarchical lists together.
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
In the sixth of his ongoing annual series, “Excel Tip of the Week” author David Lyford-Smith returns with another selection of hand-picked tips and tricks to speed up and improve your Excel practice.
This webinar will guide you through the benefits of Excel Community membership – whether individually or part of an organisation.
Late last year ICAEW launched the Financial modelling code, a high-level guide to the goals and methods of good financial models.
Liam Bastick has been a model auditor for the best part of 30 years and has seen common mistakes made in modelling time and time again.
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