Excel Community articles

Exclusive Simple but effective, part 2

18 Apr 2024
Simon Hurst

In this series we are going to examine some of the capabilities of Excel Tables. In part 1 we considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.

Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #489 – The basics of charts in Excel part 2: Combo charts

08 Apr 2024
Tom Edmunds

Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the concept of a combo chart in Excel that can be used for two or more series of data.

Exclusive Top 12 Excel Combinations: 10. SUMPRODUCT SIGN (Multiple Conditions with OR)

03 Apr 2024
Liam Bastick

I the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers . SUMPRODUCT SIGN (Multiple Conditions with OR).

Exclusive Excelators Ready!

01 Apr 2024
Simon Hurst

In breaking news, there are rumours that a major Excel update might be on the way that could allow you to create and use your own Excel nickname within Excel’s personalisation options. If this is true, you’d be a fool not to give it a try.

Exclusive Simple but effective, part 1

27 Mar 2024
Simon Hurst

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. In this series we are going to see just what they are capable of, starting with looking at how to create Excel Tables and going on to cover some simple examples of their practical use, such as avoiding global austerity.

Exclusive Including calculations in Microsoft Word

27 Mar 2024
Simon Hurst

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.

Exclusive A short introduction to Power Query M code

25 Mar 2024
Mark Proctor

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

Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #10 – Tips and Tricks Live extended

25 Mar 2024
Bani Lamba

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.

Exclusive Spreadsheet review – can Power Query help? Part 4

13 Mar 2024
Simon Hurst

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 1 of this series we looked at some of the advantages of adding Power Query to your review toolkit and, in parts 2 and 3, explored some of the available tools. In part 4 we are looking at the output of those tools in more detail.

Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #488 – The basics of charts in Excel

11 Mar 2024
Thomas Edmunds

Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the basics of the different chart types in Excel.

NEW TECH FEATURES Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Nov-Feb 2024

08 Mar 2024
David Benaim

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.

Excel's new functions might change data analysis forever

29 Feb 2024
Liam Bastick

Excitement is building, as a range of new functions introduced by Microsoft towards the end of last year are – hopefully – edging closer to general release. Here, Microsoft MVP Liam Bastick explores how they work and what they might mean for you.

Exclusive Spreadsheet review – can Power Query help? Part 3

23 Feb 2024
Simon Hurst

In part 1 of this series, we looked at some of the advantages of adding Power Query to your review toolkit. This time we are going to move on from the Profile table that we created in Part 2 to rearranging our Table and positioning it above our original data for ease of reference. We will be using a range of techniques that demonstrate the versatility of the Power Query tools.

Exclusive Top 12 Excel Combinations: 11. IF ISERROR (Error Trapping)

19 Feb 2024
Liam Bastick

I the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick examines IF ISERROR (Error Trapping).

Exclusive Spreadsheet review – can Power Query help? Part 2

16 Feb 2024
Simon Hurst

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 1 of this series, we looked at some of the advantages of adding Power Query to your review toolkit. In part 2 we are going to look in more detail at some of those tools and techniques.

Exclusive Microsoft Loop: Edit things from multiple entry points

14 Feb 2024
David Benaim

Collaborating between apps has always been one of the weakest points of Microsoft Office. Loop Components allows users to edit a bullet list whilst in an Outlook email, whilst others edit in Teams’ meeting notes and it will update simultaneously in all places.

Exclusive Office Scripts vs VBA: What’s the difference?

13 Feb 2024
Mark Proctor

Office Scripts are a new scripting language for automating Excel. In this article, Mark Proctor explores how Office Scripts differ to VBA and what we can or cannot do with each.

Exclusive Spreadsheet review – can Power Query help: part 1?

13 Feb 2024
Simon Hurst

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. However, it’s worth considering the addition of Power Query to your review toolkit on the grounds of simplicity and ease of use.

Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #487 – An Introduction to Slicers

09 Feb 2024
Thomas Edmunds

Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post exploring the basics of setting up, customising and using slicers in Excel to filter and sort through data.

EXCEL COMMUNITY ROUND UP Excel Community round up - January 2024

01 Feb 2024
Tracy Gray

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

Benefits of membership

Becoming a member

Pay fees and subscriptions

Member rewards

Support throughout your career

Member Insights Survey

Digital learning materials via BibliU

Take a look at ICAEW training films

Volunteering roles

Advertise with ICAEW

"How to guides" for ACA students

Exam resources

Digital learning materials

My online training file

Student Insights

UK groups and societies

Worldwide support and services

Strengthening trust in the profession

Regulatory applications

Excel Community articles

Meet the authors