Excel Community round-up - August 2020

Here is all of August 2020's new Excel content.  Excel Community and Tech Faculty members can access all posts by logging in to their accounts: Other users can access posts described as "public".

Excel Tip of the Week

353 - Audit sampling templates: Dynamic arrays (public)

A new series kicks off, showing three different ways of doing random sampling for audit.  For part 1: Using the new dynamic arrays in Excel 365.


A very different text function, REPLACE can insert a text string into a targeted location within another string.

355 - Connecting Google Sheets and Excel

Publish your Google Sheets data, and you can automatically draw it down into an Excel file via Power Query.

356 - Audit sampling templates: Traditional formulas

Take a look at how to do random and monetary unit sampling using nothing more than traditional Excel formulas and some Tables.

Other blogs

Accountants' guide to Excel - the importance of TRUE and FALSE

Simon Hurst shows you all the ins and outs of Boolean logic and how it is represented in Excel.

Exploring Charts (Graphs) in Excel - Part 2: Sparklines

John Tennent takes us through all the ins and outs of the tiny chart variant, sparklines, and how to use them to add comprehensibility to your data.

Power Query combine - How to automate consolidations

Combining data can let you automate consolidations and more - without writing a single formula.  Simon Hurst explains.

Intro to Financial Modelling, Part 8: Clarity - Use of formatting (public)

John Yeldham of Mazars brings us the eighth instalment of this series exploring the Financial Modelling Code - covering importance of formatting to clear communication.

When is a spreadsheet error not a spreadsheet error?  Lazy journalism or SEP field? (public)

Simon peels back the layers of a recent story of spreadsheet misadventure in the media.

Excel, Teams, Zoom PBI++ May-Aug 2020 new features (public)

David Benaim showcases all the new updates and features in Microsoft 365 and more.

Modelling 101: Part 63 - Conditionally formatted chart data labels

Modeller Liam Bastick shows you how to get chart data labels that look right every time.