ICAEW.com works better with JavaScript enabled.

Excel Community round-up - October 2020

Author: David Lyford-Smith

Published: 09 Nov 2020

Here are all the new Excel articles from the Excel Community in October 2020. 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

362 – The Status Bar (public)
The thin bar at the bottom of Excel can tell you a whole lot more than you may realise.

363 – Subtotal feature redux
Excel’s built-in tool for building tiered summaries with subtotals gets a fresh look.

364 – Dynamic arrays: Creating a visual work schedule
The powerful new dynamic arrays feature can be turned to a number of applications.

365 – Revisiting finding items that add to a target
Figure out which items from a list comprise a given total with the powerful Solver add-in.

Other blogs

Smoothing Capex
Microsoft MVP Liam Bastick looks at some detailed ways of smoothing out the modelling of cash flows.

The greatest spreadsheet error of them all – treating Excel with utter contempt (public)
Simon Hurst reacts to the PHE lost coronavirus case debacle, and the media framing of it.

Nightmare on spreadsheet: take Excel use seriously (public)
In ICAEW’s Daily mailing, David Lyford-Smith puts his own spin on the PHE crisis and why spreadsheet failings will keep on happening until people change their attitude.

Exploring Charts in Excel – Part 3: Line charts
John Tennent’s series on charts and visualisation continues with the classic line chart.

Intro to Financial Modelling part 10: Clarity: Units and sign convention (public)
Modeller Jo Hayes breaks down how to keep units and signs clear in your financial models, and why the details matter.

How does Excel survive? (public)
Responsible for career, and life-threatening errors – but we still use it.  What keeps Excel going?

Dynamic arrays: Google Sheets vs Excel
David Benaim crosses the streams to find out whether Google or Microsoft has the leading version of the powerful new dynamic arrays.

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.