How to review a spreadsheet
Reduce the risk that your spreadsheet gives you the wrong answer.
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.
Featured items
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.
Excel Tip of the Week #417 - Custom data types
Hello all and welcome back to the Excel Tip of the Week! This week we have a Creator level post in which we’re going to look at expanding data types with our own custom ones. For a refresher on normal data types and how they work, check out TOTW #384.
Power Query versus VBA – part 2
Please note that this is article aims to demonstrate a range of Power Query techniques and is not intended to be used to perform any actual tax calculations, which are often subject to a range of additional considerations.
Excel Tip of the Week #416 - PivotTable layouts
This week, we have Creator post in which we’re taking a look at some options for how to lay out your PivotTables.
Excel resources
Features and articles
Excel Tip of the Week #417 - Custom data types
Hello all and welcome back to the Excel Tip of the Week! This week we have a Creator level post in which we’re going to look at expanding data types with our own custom ones. For a refresher on normal data types and how they work, check out TOTW #384.
How to review a spreadsheet
ICAEW’s Excel Community has launched a new guide setting out common sources of spreadsheet error, how to review them with confidence, and steps you can take to give the next user a helping hand.
Is Excel still fit for purpose?
And if not, what are the alternatives?
Excel Tip of the Week #416 - PivotTable layouts
This week, we have Creator post in which we’re taking a look at some options for how to lay out your PivotTables.
Webinars and recordings
Scenarios in Financial Modelling
An introduction to building scenarios.
Excel Tip of the Week Live: your questions answered (no 5)
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Smith tackles your Excel questions, quandaries, and more.
The top 10 Excel formulas
Excel "Tip of the Week” author David Lyford-Smith goes through the most used and most popular formulas in Excel – collated from Microsoft’s own list of the most popular plus a couple of choices of our own.
10 everyday problems that Power Query solves best
The life-changing benefits of using Power Query when working with any form of external data might be obvious.
Disclaimer: The opinions expressed by external guest speakers in interviews or other publications included on this website are, by their nature, those of the speaker. They are not necessarily fully endorsed by the ICAEW or purport to reflect the official policies and views of the ICAEW or its members.
Complete the FDW eLearning course
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 eLearning content.
Ebooks
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
Data visualization with Excel dashboards and reports
Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons.
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.
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.