The ICAEW Blogs & Forums will no longer be updated with new posts. Your community announcements and articles will now be hosted on icaew.com under their respective community areas. This site and its contents will be closed and made available in an archive at the end of October.
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.
354 - REPLACE
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.
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.