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.
The recent pace of technological changes and increasing volumes of data being dealt with, has created a need for finance professionals to be able to manipulate and analyse data to aid in-depth insights, improve financial reporting and ultimately facilitate better business decision making.
Spreadsheets have been a staple tool of finance for over forty years.
Author Steve Wexler reflects on the importance of feedback, iteration and constant improvement when it comes to creating the best data visualisations.
John Tennent offers 10 tips to help you get accustomed to some of the less well known Excel features.
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?
The Excel Tip of the Week shows you how to write in large swathes of formulas automatically using VBA.
https://ion.icaew.com/excelcommunity/b/weblog/posts/analysing-data-from-multiple-workbooks-part-2-setting-an-example
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.
Power BI Desktop is a free application that can turn financial data into animated and interactive visualisations.
David Lyford-Smith returns to Excel’s powerful automation and data cleaning tool, Power Query.
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.