ICAEW.com works better with JavaScript enabled.

Excel Community round up - September 2022

Author: Excel Community

Published: 13 Oct 2022

Here are all the new Excel articles from the Excel Community in September 2022.
Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community subscribers and can be accessed by logging in to your ICAEW account.  

 

Webinars

You can find our archive of all previous webinars here, many of which remain exclusive to Excel Community members.  

How to review a spreadsheet (2022 edition) 
Spreadsheet expert John Tennent explores the Community’s publication ‘How to review a spreadsheet’. John provides examples together with step-by-step instructions for using some of the tools and functions that are available. 

We have a number of further webinars planned for the rest of the year– check our list of upcoming webinars or refer to the latest newsletter.  

 

Excel Tips and Tricks 

Excel Tips and Tricks #454 – Revisiting splitting workbooks with VBA 
A Developer level post in which we are going to work through the VBA code required to take a workbook and cut it into one file for each sheet and save all the resulting files. 

Excel Tips and Tricks #455 - Data Conversion 
Hello all and welcome back to the Excel Tips and Tricks. This week, we have a General User post in which we are taking a closer look at how to convert data types in Excel. 

 

Other blogs

Excel Community round up - August 2022 (public) 
Here are all the new Excel articles from the Excel Community in August 2022. 

Dynamic Arrays – still one leg short of a table? 
Coming soon: some additional functions for manipulating Dynamic Arrays, but will they do anything to rectify existing deficiencies? 

New tech features for Jun-Aug 2022 (public) 
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months. 

Excel how to: speed up data entry 
We look at how to make entering data into an Excel workbook as quick and efficient as possible by knowing the effect of some key Excel options and features, together with some useful keyboard shortcuts. 

How to Review a Spreadsheet Part 4: Design Principles and Formula Errors 
The last three blogs in this series will now look at validating the details within the spreadsheet. The range of these items that should be applied will need to be proportionate to the context, scale and risk of the spreadsheet being reviewed. 

TEXTBEFORE(), TEXTAFTER, TEXTSPLIT() 
Three new text functions have been introduced in Excel to help extract values from text containing some sort of delimiter. We take a detailed look at some of the arguments available as part of these new functions to help you to get the most from them and also highlight some significant changes between the preview and release versions of the functions. 

Clustered stack column chart (Public) 
Pie and donut charts are not recommended for comparatives, this article suggests how to do them with a clustered stack column chart.
Archive and Knowledge Base

This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.

Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250