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

Is Excel bad for you

Here the experts share their views on spreadsheet strengths and weaknesses and whether they have any distance left to run.

Blogs and discussions

Accountants – is the end Insight?

The most recent Excel 2016 update for those on the Office 365 monthly release schedule includes the new 'Insights' feature.

Excel Tip of the Week #237 - Resetting overgrown worksheets

Ever had a file that suddenly ballooned in size? Or a worksheet that seemed harder to use than it should be? This can happen when Excel misjudges how much of a worksheet is in use.

Webinars and recordings

Power BI Desktop - turn data into action

Almost exactly two years ago, Rishi Sapra presented an excellent introduction to Power BI and its capabilities. Since then, Microsoft has continued to update Power BI with significant updates arriving monthly. This webinar will focus on the free version of Power BI, Power BI Desktop, and cover the different components of Power BI Desktop using a practical example to take you from raw data to interactive report.

PivotTables

A starter kit for the most powerful data analysis and presentation tool in Excel, the PivotTable.

INDEX MATCH

The combination function INDEX MATCH is the most powerful, reliable, and flexible solution for any lookup-and-reference problem.

VLOOKUP

A quick introduction to the ubiquitous lookup-and-reference function, VLOOKUP – useful for everything from filling employee details from a master database to looking up prior year balances.

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

Financial modeling in Excel for Dummies

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

Mastering financial mathematics in Microsoft Excel: a practical guide to business calculations (3rd edition)

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

Advanced Excel reporting for management accountants

Automating management reporting with 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.