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.
406 – Power Pivot: Filtering active contracts
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.
408 – Data structure good practices
Learn our tips for how to lay out your data for maximum effectiveness.
Make scroll wheels, buttons, checkboxes and more.
Other blogs
Liam Bastick shows how to make the popular S-shaped distribution of costs over time.
Multiple Sparklines in a single cell
Can you even make two Sparklines at once? Simon Hurst explores some creative solutions.
Excel Navigation pane breaks new ground
Simon looks at some of the handy features of the new Navigation pane.
Exploring Charts (Graphs) in Excel – 8: Best practice in layout and recycling charts
John Tennent shows you how to make the most of your charts.
Intro to Financial Modelling – Part 19: Wrap-up (public)
Andrew Paw of Protiviti reviews the last eighteen months’ worth of our blogs exploring the Financial Modelling Code.
Bloomberg highlights importance of Excel skills for employment prospects
Simon responds to a recent media article about the continued demand for basic Excel skills.
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.
