ICAEW.com works better with JavaScript enabled.
Exclusive

Excel Community round up - December 2022

Author:

Published: 04 Jan 2023

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.
All the new Excel blogs and webinars from the Excel Community in December 2022.

Webinars 

You can find our archive of all previous webinars here, available to ICAEW members and members of the Excel Community.

Excel vs Google Sheets: the battle of the spreadsheets

Covering a range of themes including core formulae, collaboration, visualisations and advanced functionality.

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

Excel Tips and Tricks

Excel Tips & Tricks #462 – New text manipulation functions – TEXTBEFORE and TEXAFTER

Looking at specific examples of using the new TEXTBEFORE and TEXTAFTER functions in Excel.

Excel Tips & Tricks #463 – Top Tips of 2022

Pausing to look back at the best content from the Excel Community this year.

Other blogs

Risk Bubble Charts – Part 2

Liam Bastick looks at the Risk Bubble Charts in Excel, This is part two of the article.

Excel, Teams, Power BI, PowerPoint, Zoom, G Sheets, Meet – new tech features for Sep-Dec 2022

Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.

Office applications and GIFs

You might be familiar with GIFs from their use in Social Media applications or as short, silent animations within online training material. As well as demonstrating how much you are laughing out loud at a friend’s latest message, GIFs can be very useful as a training or troubleshooting aid.

Excel – smarten up your dashboards

Investing just a few more minutes on improving the presentation of your dashboard can give it greater impact and help it communicate its message even more effectively.

Taking a break

Looking at the common ‘clean up’ problem in Excel – how to separate text and numbers

The OFFSET() function – can it survive in the era of Dynamic Arrays?

Useful as the OFFSET() function can be, it is ‘volatile’ and breaks the Excel formula auditing chain. The INDEX() function can often be used to replace OFFSET() and now the latest Dynamic Array developments mean that there might be even fewer reasons to stick with the OFFSET() function.

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