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.
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re dipping our toes into Word-y waters, as we look at a classic Word/Excel double act – the mail merge.
As the penultimate blog in this ICAEW modelling good practice blog series I will be moving away from the guidelines in the code and discussing how using sensitivity and scenario analysis is a key part of any financial model.
This week, we have a Creator level post in which we are looking at the various options with Power Query’s Merge option.
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re dipping our toes into Word-y waters, as we look at a classic Word/Excel double act – the mail merge.
This week, we have a Creator level post in which we are looking at the various options with Power Query’s Merge option.
For details of what this project is all about and how to develop your own version, please look at the Excel archive file article listed below:
This week, we have a Developer level post in which we’re going to look at how to build a custom function that will convert text into title case.
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.
The life-changing benefits of using Power Query when working with any form of external data might be obvious.
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Smith tackles your Excel questions, quandaries, and more.
Discover useful Excel hints and tips so you can use Excel more efficiently and effectively with our Excel expert David Lyford-Smith.
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.
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.
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.