Here are all the new Excel articles and webinars from the Excel Community in July 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-Tilley explores Microsoft’s list of the ten most asked-about formulas – and adds a few of his own. You can also see the accompanying blog post breaking down all your questions here.
Excel Tip of the Week
401 – Excel on Reddit (public)
We examine the Excel resources and support available on the popular social news site.
402 – VBA case study: Capitalising titles
We develop a function for consistent capitalising of titles, including not capitalising words such as “an”.
403 – Power Query – Merge kinds
An in-depth exploration of the different kinds of merging data in Power Query, and what you can use each for.
Automate mass communication via letter or email, with this handy collaboration between Excel and Word.
Other blogs
Modeller Liam Bastick shows how wildcards can be used to make more powerful searches.
Data visualisation – small multiples
Simon Hurst shows how to use Power BI to easily make a large number of small charts for better data comparison.
Community Power BI project – rescuing the lost archive – they think it’s all over
Simon continues to add functionality and depth to his index of the Excel Community’s content.
Intro to Financial Modelling – Part 18: Sensitivities and Scenarios (public)
Modelling expert Alex Carse brings us the latest in the free series exploring the Financial Modelling Code, with a look at how to switch between scenarios easily and measure your model’s sensitivity to changes in its inputs.
Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.
