And if you are an Excel Community or Tech Faculty subscriber, don’t forget that you need to renew your membership to keep access for 2022 – see our overview of what’s coming here.
Thought leadership report
How to review a spreadsheet (public)
We have launched our fourth thought leadership report, a guide on how to consider the issues and plan a review for a spreadsheet. Whether you’re looking for a full methodology for assessing the trustworthiness of your sheets, or just a few handy shortcuts and reviewing tips, check out our new guide.
Webinars
How to review a spreadsheet launch event (public)
Join project leader John Tennent and myself for an overview of ‘How to review a spreadsheet’, plus some hands-on guidance, in our highest-ever rated webinar!
John returns for a premium webinar introducing you to the world of Excel automation, with a beginner’s guide to VBA and macros.
Excel Tip of the Week
418 – How to review a spreadsheet (public)
Completing the triptych of resources around our new guide, I discuss how this publication came to be.
419 – Revisiting macros and custom functions
Put the lessons from our VBA webinar into practice, with a few of my favourite add-ons.
420 – STOCKHISTORY and exchange rates
The Excel 365 function that you might be missing out on – and how it’s not just for stocks.
We go back to the beginning, with a fresh look at the very first topic from the Excel Tip of the Week.
422 – Better error catching formulas
IFERROR and friends are useful, but can hide true mistakes. Learn some better alternatives with our guide.
Other blogs
Using Power Query to simplify your spreadsheets (public)
Simon Hurst takes inspiration from our new publication and considers how Power Query can actually make for an easier time for a reviewer.
Power Query and spreadsheet review
Simon dives deeper into how proper use of PQ could aid reviewability.
Modeller Liam Bastick looks at the thorny issue of calculating the overlap between two time periods.
Conditional formatting and spreadsheet review – one rule to find them all
As we examined in the Tip of the Week, functions like IFERROR can cause issues if defined too broadly. Simon considers how to find all such functions easily.
Scenarios in financial modelling (public)
Alex Carse gives an overview of our recent free webinar from Ben Ducker on scenario modelling, with timestamps for each key topic.
Microsoft Lists: Flexible data entry with visual view options
David Benaim gives an overview of the powerful data entry options available in Excel alternative Lists.