ICAEW.com works better with JavaScript enabled.
Exclusive

Excel Community round up - January 2023

Author:

Published: 08 Feb 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 January 2023.

Webinars

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

Excel Tips and Tricks Live – your questions answered

Join our experts as they tackle your Excel questions, quandaries and more.

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 and Tricks

Excel Tips & Tricks #464 – refreshing keyboard shortcuts

Taking a look at keyboard shortcuts that will improve your experience of using Excel.

Excel Tips & Tricks #465 – using #N/A in charts redux

How to make use of the #N/A error to help customize charts. This was previously covered in Tip #297.

Other blogs 

Your 2023 Excel Community

We’re delighted to welcome all of our members – new and old alike – to our bigger, better Excel Community for 2023.

Excel Community round up – December 2022

All the new Excel blogs and webinars from the Excel Community in December 2022.

Welcome to the Excel Community: Twenty principles for good spreadsheet practice

Simon Hurst introduces this, and other key publications, to members who have recently joined the Excel Community.

Using Power BI bookmarks to highlight report content

We’ve added a bookmark navigator to our Power BI archive article portal. This will allow the display of the list of articles relevant to a publication with a single click.

Lookout for VLOOKUP and HLOOKUP

Do you realise it’s very easy to make a mistake with these functions? Liam Bastick explains.

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