ICAEW.com works better with JavaScript enabled.

Excel Community round up – March 2024

Author: Excel Community

Published: 01 Apr 2024

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

Webinars

Power Tools Part 4: Build dynamic dashboards with Power Pivot 
This webinar explores the fundamentals of Power Pivot and how to best use this functionality in Excel to structure and analyse data, based on real-life examples accounting and finance professionals will encounter. 

Model Risk Management: Understanding the Bank of England’s Supervisory Statement 
Model risk is one of the most important risks in a financial institution. It impacts front office, operations, finance, internal and external audit.

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

Check our list of upcoming webinars or refer to the latest newsletter to see what is planned for the rest of the year.

Excel Tips & Tricks

Excel Tips & Tricks #488 – the basics of charts in Excel 
This week, we have a Creator level post exploring the basics of the different chart types in Excel.

Other blogs

Excel, Teams, Power BI, Canva, Zoom, Google Sheets: New tech features for Nov-Feb 2024 
David Benaim presents a digest of new features across Microsoft 365 and other business tech products in written, images and video format, covering the last three months. 

Spreadsheet review – can Power Query help? Part 4 
Legacy Excel supports a range of functions and techniques that can help identify potential errors and problems within a spreadsheet as part of a review process. In part 4 we are looking at the output of those tools in more detail.

Your questions answered #10 – Tips and Tricks Live extended 
In this year’s first 'Excel Tips and Tricks live – your questions answered' webinar, John Yeldham and Ian Pay tackled Excel questions and queries covering best practice, the use of functions and functionality, and a range of techniques for data handling and analysis in Excel. Bani returns to answer some of the unanswered questions from the webinar.

A short introduction to Power Query M code 
While M code in Power Query may look overwhelming and confusing, the functional language is similar to Excel formulas built using the LET function. In this article, Mark Proctor explores how to get started with understanding and using M code in Excel.

Including calculations in Microsoft Word 
Excel might be the obvious application for all sorts of calculations, but Word also has a calculation feature based on Field Codes that can perform simple calculations, use some functions and also format the result.

Simple but effective, part 1 
It’s very easy to format a block of data in your favourite colour scheme by using an Excel Table, but Excel Tables are so much more important than just facilitating formatting.

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