Here are all the new Excel articles and webinars from the Excel Community in February 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.
Webinar
John Tennent takes us through a guided tour of how to make the most of Excel’s chart features.
Excel Tip of the Week
379 – Processing survey results (public)
An exploration of how to analyse the results of some common survey question types.
AutoSum is a handy feature for quickly writing in formulas – but be aware of its limitations.
381 – Treemap and Sunburst charts
These newer hierarchy chart types are useful for showing how an organisation or amount breaks down into its constituent parts.
382 – Keeping your VBA code readable
VBA is to be used sparingly – and when you do use it, make sure you keep it easy to follow.
Other blogs
Liam Bastick explores the ins and outs of a critical business calculation.
Rescuing the lost archive – Part 2 (public)
Simon Hurst continues his exploration of how Power BI can make the most of our extensive spreadsheet archive.
Exploring charts (graphs) in Excel – Part 5: Column/bar charts, clustered, stacked, and 100%
John Tennent continues the blog series that accompanies the above webinar.
Spreadsheet Knowledge Base launches (public)
Simon’s series concludes with the official launch of the Spreadsheet Knowledge Base – a searchable Power BI presentation of all our content.
ICAEW 20 Principles Excel workbook template
Simon highlights a classic template made to help you measure your spreadsheets against the Twenty Principles for Good Spreadsheet Practice.
Intro to Financial Modelling – Part 13: VBA (public)
John Yeldham shares a few thoughts about the place of VBA (or otherwise) in financial modelling.
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.
