ICAEW.com works better with JavaScript enabled.

Excel Community round up – November 2022

Author: Excel Community

Published: 28 Nov 2022

Here are all the Excel blogs and webinars from the Excel Community in November 2022.

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.  



You 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 Tricks

Excel 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 blogs

Dynamic 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.