Here are all the new Excel articles and webinars from the Excel Community in September 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.
In our latest open questions-and-answers webinar, “Excel Tip of the Week” author David Lyford-Tilley tackles another bevy of your questions and quandaries. You can also read the answers to all the questions we received in the accompanying blog.
Excel Tip of the Week
410 – Installing VBA redux (public)
Got some handy-looking macro or custom function you want to use? Even without coding knowledge, you can access the area in Excel where you can paste the code in, with our handy guide.
Easily make data transformations without writing a single formula, with the AI-driven Flash Fill feature.
Find your way around a large workbook and keep the sheets manageable, with our handy guide.
Whether you need to compress tabular data into one column, or unfold a single column into a table, our handy guide has you covered.
Excel – escaping from cells
In this two-part series, Simon Hurst explores how good data structure and practices can improve database-style storage and manipulation of data in Excel.
New tech features for Jun-Aug 2021 (public)
Microsoft MVP David Benaim is back, with a review of the latest features in Microsoft 365 and other business software, including significant new functionality in Teams, Power BI, and more.
Data validation is one of the key tools to control user input. Modeller and MVP Liam Bastick explores how to use it to its full effect, including dependent dropdowns.
Simon Hurst asks how the lockdown periods have affected our abilities with spreadsheets – for the better, or for the worse?