ICAEW.com works better with JavaScript enabled.


Excel is one of the most popular end-user tools in the accountant’s portfolio. Spreadsheets enable us to quickly and flexibly perform analysis that otherwise would be difficult or time-consuming; however, there is a tendency to place undue trust in them. The Excel Community is a 'one-stop shop' for accountants who want to use Excel better and understand and minimise spreadsheet risk.

In this section

Features and articles

The essential guide to data analytics for smaller firms

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’.

Blogs and discussions

Modern Excel - Flash Fill & TEXTJOIN text tools

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?

Webinars and recordings

Webinar recordings

Archive of webinar recordings. Includes financial modelling, PivotTables, Power Query, Excel Tip of the Week Live and many more.

Finance in a digital world

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 library@icaew.com

Using Excel for business and financial modelling: a practical guide

A hands-on guide to using Excel in the business context. Contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away.

Principles of financial modelling: model design and best practices using Excel and VBA

A practical guide to financial modelling, demonstrating how to plan, design and build financial models.

Financial modeling in Excel for Dummies

A beginner's guide to financial modeling using Microsoft Excel.

Terms of use: You are permitted to access, download, copy, or print out content from eBooks for your own research or study only, subject to the terms of use set by our suppliers and any restrictions imposed by individual publishers. Please see individual supplier pages for full terms of use.

* Some of the content on this web page was provided by the Chartered Accountants’ Trust for Education and Research, a registered charity, which owns the library and operates it for ICAEW.