ICAEW.com works better with JavaScript enabled.

Excel Community round up - May 2021

Author: David Lyford-Smith

Published: 09 Jun 2021

Here are all the new Excel articles and webinars from the Excel Community in May 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.

Call for comments (public)

We are working on a new publication, entitled “How to Review a Spreadsheet”, and are looking for your comments.


Excel Tip of the Week Live: your questions answered (no 4) (public)
In our latest free Q&A webinar, David Lyford-Smith answers all comers. Please note there were some minor connection issues during this webinar.
You can also check out our accompanying blog, featuring all the answers and more.

Excel Tip of the Week

392 – Text to Columns redux (public)
We break down how to use the Text to Columns Wizard to split a string or CSV file into separate columns.

393 – AND/OR
These two logic functions can help you build up more complex queries for your IF functions.

394 – The Accessibility Checker
Considering disability access can improve your workbooks for all your users.

395 – Revisiting hidden rows and columns
How do hidden rows and columns really work? What alternatives are there?

Other blogs

Excel update – Power Query can now use Dynamic Arrays as a data source
Simon Hurst shares the latest PQ update for Excel 365.

Finding the Nth item on a list
Modeller Liam Bastick talks through how to find the 2nd, 3rd, etc. instance of a particular value.

Community project – Rescuing the lost archive – part 5
Simon Hurst continues to explore Power BI as he shows how to add visuals to the Excel Community archive.

Intro to Financial Modelling – Part 15: Calculation Techniques – Flags and Masks (public)
Ben Ducker of RSM tackles the question of how to easily and clearly make calculations which can handle switching on and off under different circumstances.

Highest invoices by customer using Power Query
Simon Hurst takes a look at Liam’s topic for this month from a totally different angle.

Excel community

This article is brought to you by the Excel Community where you can find additional extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business.