ICAEW.com works better with JavaScript enabled.

Excel

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.

Excel Community

Latest from the Excel Community

The Excel Community is a 'one-stop shop' for accountants who want to use Excel better and understand and minimise spreadsheet risk.

The importance of Excel to the financial system

Excel is critically important to the whole financial system. The opportunities to improve the productivity and reliability of so many business processes mean that it really is worth investing the intellectual effort in becoming proficient in the use of Excel.

Excel Tip of the Week #377 - The limits of Excel

This week we have a General User level post in which we’re going to be talking – in a very literal sense – about the limits of Excel. Like all programs, Excel can only handle so much data – so we’re going to go through and talk about where those limits are and what they mean for our Excel use.

Renewed content and upcoming events 2021

As part of your subscription, you can access all of our past publications, including our back catalogue of Tech Essentials, the short introductory guides which were originally bundled with your bimonthly Chartech magazine.

Excel resources

Features and articles

The importance of Excel to the financial system

Excel is critically important to the whole financial system. The opportunities to improve the productivity and reliability of so many business processes mean that it really is worth investing the intellectual effort in becoming proficient in the use of Excel.

Renewed content and upcoming events 2021

As part of your subscription, you can access all of our past publications, including our back catalogue of Tech Essentials, the short introductory guides which were originally bundled with your bimonthly Chartech magazine.

Excel Tip of the Week #376 - Discounting functions redux

This week we have a Creator post in which we are making a definitive re-examination of the four key functions in Excel for handling discounting calculations: NPV, XNPV, IRR, and XIRR.

Excel Community round-up - December 2020

Here are all the new Excel articles from the Excel Community in December 2020. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.

Webinars and recordings

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 (3rd edition)

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. Formerly titled Using Excel for business analysis.

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.

Power Pivot and Power BI: the Excel user's guide to DAX, Power Query, Power BI and Power Pivot in Excel 2010-2016

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience.

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.