Here are all the new Excel articles and webinars from the Excel Community in January 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.
Webinars
Financial Modelling Standards (public)
David Lyford-Smith joined a panel to discuss the place of financial modelling standards in the field, and compare current efforts to develop and promote them.
Tip of the Week Live: Your Questions Answered #3 (public)
David took on all comers with an open, all-Q&A webinar, covering topics from PivotTables to lookups to data management. Accompanying this webinar we also have this free blog post in which David answers ALL the questions we received.
Excel Tip of the Week
375 – Workbook viewing redux (public)
Learn how to set up your workbooks to make viewing and navigation as easy as possible.
376 – Discounting functions redux
Revise how to use NPV and IRR functions to calculate discounted cash flows and more.
377 – The limits of Excel
Excel has limits on what it can contain – but most sensible use should never run into them.
378 – Revisiting splitting data by category
We take a look at how to divide data into multiple categories.
Other blogs
LAMBDA formulaic recursion – it’s all about ME!
Liam Bastick shows how the new LAMBDA function can be used to define your own custom functions, and how this allows you to dip into the world of recursion.
Section numbering
Liam shows how to make automatic section numbers work.
Recent Excel updates – so near, yet so far
Simon Hurst critically assesses the newer additions to Excel – Tables, dynamic arrays, and more.
The importance of Excel to the financial system (public)
Excel is the bedrock of the global financial system – and, as Simon argues, understanding it is a critical skill.
Intro to Financial Modelling Part 12: Error reduction – Constructing error checks (public)
Modeller John Yeldham brings the next part of our exploration of the Financial Modelling Code, looking at the whys and wherefores of error checks.
Excel Community project – Rescuing the lost archive (public)
Simon takes on building an explorer for the Excel Community’s past content using Power BI.