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.
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.
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.
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 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.
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.
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.
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.
Power Pivot is freely available in Excel, but is often overlooked. But the powerful add-in can supercharge your PivotTables, allowing more nuanced and detailed calculations and summaries than ever before.
Discover useful Excel hints and tips so you can use Excel more efficiently and effectively with our Excel expert David Lyford-Smith.
One of the most enduringly popular data analysis features in Excel, PivotTables are an essential ingredient in any accountant’s data analysis toolbelt.
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Smith tackles your Excel questions, quandaries, and more.
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
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.
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.
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.