ICAEW.com works better with JavaScript enabled.
Exclusive

Excel Community round up - April 2023

Author: Excel Community

Published: 03 May 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 April 2023.

Webinars

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

We continue 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 #469 – Exploring the ‘Info’ view in Excel
Exploring document properties and version history in the ‘Info’ view in Excel to help manage spreadsheets, and show why it’s really important to use it correctly.

Excel Tips & Tricks #470 – Introducing Office Scripts in Excel
A high-level overview of Office Scripts in Excel, a potential replacement for VBA to help automate tasks.

Other blogs

Teams Premium: add-on with better meeting functionality
Workplace staple Microsoft teams has now released a paid tier which has additional meeting features. In this blog I explain through written, image and video which additional features the paid tier gets you.

Data Validation change – the secret enhancement?
A few months ago, a significant update to the way that the Data Validation feature worked made using dropdown lists much more user-friendly. It seems that Microsoft might have sneaked in a further enhancement to also make lists much easier to set up in the first place.

XLOOKUP Part 3 – useful features of XLOOKUP
Exploring useful features of XLOOKUP.

Your questions answered #3 – Questions on the life-changing opportunities of Power Query?
In this post we delve deeper into Power Query.

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

Power Query – building in checks and controls – part 1
In part 1 we examine the importance of total checks and see how to construct them.

Power Query – building in checks and controls – part 2
In part 2 we start the process of reconciling our two totals.

Power Query – building in checks and controls – part 3
In this final part, we will build our reconciliation using our totals and exception queries.

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