Here are all the new Excel articles and webinars from the Excel Community in August 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.
Excel Tip of the Week
405 – DATEDIF redux (public)
We examine the troubled date-difference calculation function, and some more reliable alternatives.
Want to see only the active contracts based on start and end dates? We have you covered.
Find out the top invoices per customer with this simple formula workaround.
Learn our tips for how to lay out your data for maximum effectiveness.
Make scroll wheels, buttons, checkboxes and more.
Liam Bastick shows how to make the popular S-shaped distribution of costs over time.
Can you even make two Sparklines at once? Simon Hurst explores some creative solutions.
Simon looks at some of the handy features of the new Navigation pane.
John Tennent shows you how to make the most of your charts.
Andrew Paw of Protiviti reviews the last eighteen months’ worth of our blogs exploring the Financial Modelling Code.
Simon responds to a recent media article about the continued demand for basic Excel skills.
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.