Here are all the new Excel articles and webinars from the Excel Community in October 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
Scenarios in financial modelling (public)
Ben Ducker of RSM gives us an overview of how to quickly and easily add scenario options to any financial model.
Excel Tip of the Week
414 – Select Case and stamp duty revisited (public)
David Lyford-Tilley examines the powerful Select Case syntax in VBA, and how to use it for computing stamp duty.
415 – Spreadsheet Competency Framework – Five years on
How has our report on spreadsheeting ability aged over the last five years?
Some options for exploring how to lay out and present your pivots.
What are custom data types all about – and why aren’t they all they’re cracked up to be?
Power Query vs VBA
In a two-part series, Simon Hurst explores how PQ can serve as a replacement calculation engine in Excel.
Other blogs
Achieving the Impossible: Reversing Text
Is flipping around a text string really impossible without the shiny new LAMBDA function?
John Tennent’s bi-monthly exploration of charts and graphs continues.
Microsoft Forms: Analysis automation on surveys created in minutes
Microsoft MVP David Benaim explores how to use Forms to replace tasks often just done in Word.
Doing the impossible with Power Query
Simon Hurst explores how to tackle Liam’s text-reversing challenge using Power Query.
