Here are all the new Excel articles from the Excel Community in October 2020. 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 recording
Super charge your PivotTables with Power Pivot
Our final 2020 Excel webinar shows you the ropes of this little-appreciated but deeply powerful feature.
Excel Tip of the Week
366 – Lost coronavirus cases (public)
We break down the story from the headlines – what happened with the PHE spreadsheet error?
Sometimes you can skip the table, and get straight in to making visualisations.
368 – Power Pivot: Connections
Following on from the webinar linked above, the TOTW explores how connections can be created to join a whole dataset together.
The two-part series concludes with a look at DAX and how to write custom analyses of your data.
Other blogs
Modelling inventory on a FIFO basis
Microsoft MVP Liam Bastick takes a look at how to apply FIFO rules when creating your model.
Spreadsheet errors: How to reduce risk
We speak to Wired Magazine about the need to take spreadsheets seriously.
Using data types in Excel for easy-to-create management accounts
Simon Hurst explores the potential of the new feature, recently added in early access for Microsoft 365.
Simon explores the STOCKHISTORY function – coming soon to a spreadsheet near you.
Intro to Financial Modelling part 11: Clarity and Named Ranges (public)
Alistair Hynd takes us through the landmine of opinions over how to handle named ranges in the world of financial modelling.
Why our key skills could now be a matter of life and death
Analysing and interpreting data correctly is more important now than ever.