Here are all the new Excel articles and webinars from the Excel Community in March 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
David Lyford-Smith shares a selection of his favourite Excel tips and tricks.
Excel Tip of the Week
383 – Revisiting ranking functions (public)
We examine how to assign numbers in a range a rank, using RANK.AVG and RANK.EQ.
Added in the latest versions of Excel, Data types allow you to easily look up certain key information about a wide array of common types of data.
385 – Power Query: Creating transaction references
Use the powerful data transformation tool to automatically generate transaction references or similar tags from data – even from just a basic summary.
386 – Power Pivot: RELATEDTABLE
Extend your analyses with this powerful DAX function.
387 – Revisiting fixing broken links
Broken links sometimes seem to be invisible. How can you find and fix them?
Other blogs
Liam Bastick shows you how to highlight certain points in a chart to show key values.
Accountants’ guide to Excel - Mastering number formats part 2
We have republished this key article from the archives to share with you not only Simon Hurst’s excellent guidance on custom number formats, but also our 20 Principles for Good Spreadsheet Practice-compliant template.
Excel Community project – Rescuing the lost archive – part 3 (public)
Simon continues his exploration of how to use Power BI to access the Excel Community’s past content.
Intro to Financial Modelling – Part 14: Error reduction – common pitfalls (public)
Modeller Kyle Chaning-Pearce explores some common sources of error in financial models – and how to avoid them.
Excel, Teams, Power BI, PowerPoint, Zoom, G Sheets, Meets: New tech features for Dec 20-Feb 21 (public)
David Benaim returns with the latest round-up of what’s new and what’s hot in Microsoft 365 and beyond.
Why the lack of Excel skills could threaten the economic recovery from the pandemic (public)
Simon discusses how spreadsheet skills could form part of the recovery plan from Covid-19.
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.
