ICAEW.com works better with JavaScript enabled.

Excel Community September 2021 round-up

Author: David Lyford-Tilley

Published: 05 Oct 2021

Here are all the new Excel articles and webinars from the Excel Community in September 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.


Excel Tip of the Week Live: your questions answered (no 5) (public)

In our latest open questions-and-answers webinar, “Excel Tip of the Week” author David Lyford-Tilley tackles another bevy of your questions and quandaries. You can also read the answers to all the questions we received in the accompanying blog.

Excel Tip of the Week

410 – Installing VBA redux (public)

Got some handy-looking macro or custom function you want to use? Even without coding knowledge, you can access the area in Excel where you can paste the code in, with our handy guide.

411 – Revisiting Flash Fill

Easily make data transformations without writing a single formula, with the AI-driven Flash Fill feature.

412 – Working with large numbers of sheets

Find your way around a large workbook and keep the sheets manageable, with our handy guide.

413 – Flattening and unfolding data

Whether you need to compress tabular data into one column, or unfold a single column into a table, our handy guide has you covered.

Excel – escaping from cells

Part 1

Part 2

In this two-part series, Simon Hurst explores how good data structure and practices can improve database-style storage and manipulation of data in Excel.

Other blogs

New tech features for Jun-Aug 2021 (public)

Microsoft MVP David Benaim is back, with a review of the latest features in Microsoft 365 and other business software, including significant new functionality in Teams, Power BI, and more.

Depending on data validation lists

Data validation is one of the key tools to control user input. Modeller and MVP Liam Bastick explores how to use it to its full effect, including dependent dropdowns.

WFH and Excel skills

Simon Hurst asks how the lockdown periods have affected our abilities with spreadsheets – for the better, or for the worse?