ICAEW.com works better with JavaScript enabled.
Exclusive

Excel Community round up - March 2023

Author:

Published: 04 Apr 2023

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.

Here are all the new Excel blogs and webinars from the Excel Community in March 2023.

Webinars

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

What’s new in Excel from the last year 
This webinar will go through a digest of the new feature in Excel.

Power Tools Part 1: Why Power Query can change your life 
Using Power Query to revolutionise your use of Excel and help make all of your spreadsheets more robust, more automatic and capable of delivering more impact. 

We are now continuing to plan the webinar series for 2023 – check our list of upcoming webinars or refer to the latest newsletter.  

Excel Tips & Tricks

Excel Tips & Tricks #468 – refreshing dealing with objectives 
How to insert and deal with objects including images, charts or files in Excel. 

Other blogs

The search for the lost scrolls 
Simon Hurst goes on the trail of the missing Windows vertical scroll bars and wishes that he’d discovered the simple truth a lot sooner. 

Your questions answered #1 – how can I make custom number formats generally available? 
A recent live webinar allowed community members to pose their questions to the presenters. 

Excel Community round up – February 2023 
Here are all the new Excel blogs and webinars from the Excel Community in February 2023. 

Why Power Query can change your life  
Simon Hurst yet again claims that Power Query can change your life and attempts to prove it in a live webinar. 

Excel, Teams, Power BI, Zoom, Google Sheets++: new tech features for December 22 – February 23 
Our digest of new features across Microsoft 365 and other business tech products in written, images and video format. 

Your questions answered #2 – are there any advantages of still using VLOOKUP over XLOOKUP (or INDEX and MATCH)? 
Liam Bastick answers questions from the “Excel error horrors (and how to avoid them)” webinar, which he was unable to respond to during the session. 
https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2023/your-questions-answered-2 

XLOOKUP Part 4 – partial and exact matching 
The fourth and last part of a series of articles exploring partial and exact matching. 

XLOOKUP 
The first part of a series of articles exploring Excel’s strongest all-round performer – XLOOKUP. 

Accessibility features in Excel – part 1: Overview 
The accessibility features in Microsoft Excel and shedding light on how it can be used to empower users to achieve more. 
https://www.icaew.com/technical/technology/excel-community/excel-community-articles/2023/accessibility-features-in-excel-part-1-overview

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.

Excel polaroid
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
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