ICAEW.com works better with JavaScript enabled.

Excel Community articles

Read the latest support and guidance from the Excel Community, including our very popular Tip of the Week series.
Displaying 1-30 of 1138 results
Simon Hurst
Exclusive Is there anything that Power Query can't do?
  • 30 May 2023
  • Simon Hurst
There are many things that Power Query can't do but, in this occasional series, we will be looking at some of the less obvious techniques available. In this episode we look at automating the changing of column heading text.
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #473 – Refreshing customising the ribbon
  • 30 May 2023
  • Jonelle Johnson Turner
This week, we have a Creator level post in which we're dipping our toes back into the pool of customisation options available through Excel.
Simon Hurst
Exclusive Avoiding another Find mess
  • 26 May 2023
  • Simon Hurst
A seemingly simple question during a lecture reveals the benefits of delving beneath the surface of Excel’s user interface in order to help find what you are looking for.
Liam Bastick
Exclusive OFFSET
  • 26 May 2023
  • Liam Bastick
In recent months, I have covered VLOOKUP, LOOKUP, INDEX MATCH and XLOOKUP – yet there are still others that can help us look up or find data. I now move on to one of my favourites – OFFSET – which it’s true to acknowledge is not admired universally. This is a function modellers either love or hate. It considers disposition or displacement and has the following syntax:
John Tennent
Exclusive Building an Excel model to test if you are a going concern
  • 25 May 2023
  • John Tennent
At times of uncertainly and high inflation the assessment of an organisation’s going concern is going to be high on the agenda for the Board and in particular the accounts sign off meeting with the auditor.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #472 – Conditional formatting components
  • 18 May 2023
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post where we explore how to use different components of conditional formatting including data bars, colour scales and icon sets.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #471 – Refreshing GETPIVOTDATA
  • 12 May 2023
  • Bani Lamba
A Creator level post where we’re refreshing our coverage of the PivotTable extraction function GETPIVOTDATA
Liam Bastick
Exclusive TECH NEWS LOOKUP
  • 04 May 2023
  • Liam Bastick
Regular readers will recall I took VLOOKUP and HLOOKUP to task recently, before moving on to the INDEX MATCH combination and then XLOOKUP. You don’t always need the latest and greatest though: LOOKUP may seem a less versatile function upon first glance, but it is quite useful for modelling. It’s an “oldie but goodie”.
Simon Hurst
Exclusive TECH NEWS Excel fundamentals training – what should be included?
  • 04 May 2023
  • Simon Hurst
Should basic Excel training stick to simple formulas and functions or should it extend the horizons of learners to consider the likes of Dynamic Arrays, PivotTables and Power Query?
Lego graph image
Exclusive Excel Community round up - April 2023
  • 03 May 2023
  • Excel Community
Here are all the new Excel blogs from the Excel Community in April 2023.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tips & Tricks #470 – Introducing Office Scripts in Excel
  • 28 Apr 2023
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week we have a Developer level post where provide a high-level overview of Office Scripts in Excel, a potential replacement for VBA to help automate tasks.
Simon Hurst
Exclusive Power Query – building in checks and controls – part 3
  • 27 Apr 2023
  • Simon Hurst
In this three-part mini-series we are going to see how Power Query can help identify potential problems in our output tables. In the first part we looked at the creation of check totals from the original file and the output table and in part 2 we created the queries needed to help reconcile our two totals. In this final part, we will build our reconciliation using our totals and exception queries.
Simon Hurst
Exclusive Power Query – building in checks and controls – part 2
  • 25 Apr 2023
  • Simon Hurst
In this three-part mini-series we are going to see how Power Query can help identify potential problems in our output tables. In the first part we looked at the creation of check totals from the original file and the output table. In part 2 we start the process of reconciling our two totals.
Simon Hurst
Exclusive Power Query – building in checks and controls – part 1
  • 21 Apr 2023
  • Simon Hurst
In the first of a three-part mini-series we are going to see how Power Query can help identify potential problems in our output tables. In part 1 we examine the importance of total checks and see how to construct them.
Liam Bastick
Exclusive XLOOKUP Part 4 - Partial and Exact Matching
  • 17 Apr 2023
  • Liam Bastick
The fourth and last part of a series of articles exploring Partial and Exact Matching.
Simon Hurst
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #3 – Questions on the life-changing opportunities of Power Query?
  • 17 Apr 2023
  • Simon Hurst
Our latest live webinar saw Simon Hurst drill into the capabilities of Excel Power Tools and, in particular, Power Query. The webinar provoked many questions. We dealt with some of the more straightforward questions as part of the post that announced the availability of the Webinar recording. This time we delve deeper into Power Query.
Liam Bastick
Exclusive XLOOKUP Part 3 - Useful Features of XLOOKUP
  • 12 Apr 2023
  • Liam Bastick
The third part of a series of articles exploring useful features of XLOOKUP
Simon Hurst
Exclusive Data Validation change - the secret enhancement?
  • 05 Apr 2023
  • Simon Hurst
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.
Excel Community pin
Exclusive Teams Premium: Add-on with better meeting functionality
  • 05 Apr 2023
  • David Benaim
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.
Lego graph image
Exclusive EXCEL COMMUNITY ROUND UP Excel Community round up - March 2023
  • 04 Apr 2023
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in March 2023.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tips & Tricks #469 – Exploring the ‘Info’ view in Excel
  • 04 Apr 2023
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week we have a General User post where we explore 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.
Liam Bastick
Exclusive XLOOKUP Part 2 - Comparisons with LOOKUP
  • 03 Apr 2023
  • Liam Bastick
The second part of a series of articles exploring comparisons with LOOKUP
Andrew Paw
Exclusive Accessibility Features in Excel - Part 1: Overview
  • 29 Mar 2023
  • Andrew Paw
In this blog series, Andrew Paw will examine and walkthrough the accessibility features in Microsoft Excel and shed light on how it can be used to empower users to achieve more.
Liam Bastick
Exclusive XLOOKUP
  • 27 Mar 2023
  • Liam Bastick
The first part of a series of articles exploring Excel's strongest all-round performer - XLOOKUP
Liam Bastick
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #2 - Are there any advantages of still using VLOOKUP over XLOOKUP (or INDEX and MATCH)?
  • 27 Mar 2023
  • Liam Bastick
Liam Bastick answers questions from the "Excel Error Horrors (and how to avoid them)" webinar, which he was unable to respond to during the session.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tips & Tricks #468 – Refreshing dealing with Objects
  • 16 Mar 2023
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week we have a General User post where we take a look at how to insert and deal with objects including images, charts, or files in Excel.
Excel Community pin
NEW TECH FEATURES Excel, Teams, Power BI, Zoom, Google Sheets++: New tech features for Dec 2022-Feb 2023
  • 15 Mar 2023
  • David Benaim
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
Simon Hurst
Exclusive 'Why Power Query can change your life' - webinar recording now available
  • 13 Mar 2023
  • Simon Hurst
Simon Hurst yet again claims that Power Query can change your life and attempts to prove it in a live webinar. This is the first of two posts dealing with the questions that the webinar provoked.
Lego graph image
Exclusive EXCEL COMMUNITY ROUND UP Excel Community round up – February 2023
  • 09 Mar 2023
  • Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in February 2023.
Simon Hurst
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #1 - How can I make custom number formats generally available?
  • 06 Mar 2023
  • Simon Hurst
A recent live webinar allowed community members to pose their questions to the presenters. A question on the display of zero values sparked a discussion on the use of custom number formats and how to apply them as easily and widely as possible. This is the first part of a series where we look at dealing with your questions and includes details of how to submit any questions that you might have.
Displaying 1-30 of 1138 results

Search the Excel Community archive

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.

Search the archive Access the knowledge base
Excel polaroid