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.
WebinarsYou can find our archive of all previous webinars here, many of which remain exclusive to Excel Community members.
Excel success stories
This webinar explores the best of the best examples of making the most of Excel.
We are now planning the webinar series for 2023 – check our list of upcoming webinars or refer to the latest newsletter.
Excel Tips and TricksExcel Tips and Tricks #459 – Examples of using LAMBDA() in Excel
Patrick O’Beirne looks at examples of using LAMBDA() in Excel.
Excel Tips and Tricks #460 – revisiting hidden worksheets
Looking at how hiding and unhiding worksheets works.
Excel Tips and Tricks #461 – things Google Sheets (still) does better than Excel
Looking at some of the functionality you can find in Google Sheets that Excel is yet to fully master.
Other blogsDynamic Arrays and Charts – bigger and better Excel dashboards await (public)
How the new ability for charts to use Dynamic Arrays dynamically as their data source allows Excel dashboards to be even more automatic and exciting.
How to review a spreadsheet: part 6 – other useful functions
A few other useful Excel functions and features that can identify potential errors and help focus a review.
Microsoft Bookings with me and Bookings (public)
David Benaim loose at the pros and cons of the Bookings with me scheduling app.
Excel updates – quick access to Excel Blogs and the Excel Features Flyer
Microsoft’s Excel Blog includes useful information on ‘what’s new’ together with a handy guide as to whether a feature should be available in your own Excel version.
Traffic cameras – incorporate real traffic lights into your Excel reports
How to display product pictures and real traffic lights.
Risk Bubble Charts – part 1
Introducing you to a Risk Bubble Chart which helps you to keep track of the likelihood of any given problem.
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.