Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community subscribers and can be accessed by logging in to your ICAEW account.
Webinars
You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community members.
Applying the financial modelling code beyond Excel
This webinar considers the Financial Modelling Code in the ‘new world’ of modelling.
New 2021-22 features for Excel, PowerPoint, Teams and other Microsoft 365 (public)
Keeping you up to date with the new features from Microsoft 365.
We have other webinars planned for the rest of the year– check our list of upcoming webinars or refer to the latest newsletter.
Excel Tips and Tricks
Excel Tips and Tricks #456 – Revisiting loan modelling
How to model the draw down, interest and repayments on a loan.
Excel Tips and Tricks #457 – Excel error checking and handling
Looking at new and improved ways of checking for and handling errors.
Excel Tips and Tricks #458 – Revisiting line breaks in Excel
Quickly summarizing how line breaks and multi-line formatting works in Excel.
Other blogs
Named functions, LAMBDAs and XLOOKUP in Google Sheets
David Benaim shares is views on the recently released update to Google Sheets.
How to review a spreadsheet Part 5#: The Formula Auditing Group
The Formula Auditing Group can be found on the Formulas ribbon. It has a range of helpful functions to validate details within the spreadsheet, especially when resolving errors.
Excel how to: speed up by using keyboard shortcuts
A personal selection of some of the keyboard shortcuts and techniques that can help speed up your use of Excel.
Excel Community round-up September 2022
All the new Excel articles from the Community in September 2022.
Rapid Microsoft reaction to keyboard shortcut article – Ctrl+Shift+V
Microsoft has introduced a useful new keyboard shortcut to allow a copied selection to be pasted as values with a single key combination. In contract, a longstanding issue with the implementation of the Excel Tables feature is still unresolved after years of user feedback.
Charting with dynamic arrays (public)
In Excel for the web and Excel Desktop (Insiders Beta), charts will now respond to dynamic arrays.
Finding match exceptions before they become lookup errors
How to automate exception reporting when matching lists or tables in Excel using Power Query.
Archive and Knowledge Base
This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.