Charts and graphs
Articles and webinars on Excel charts and graphs.
Exclusive
EXCEL COMMUNITY
Bringing financial reports alive in Excel with visualisation – comparing data sets
- 14 Feb 2025
- John Tennent
This article is part of a series that supports the lunch and learn webinars on how to bring financial reports alive in Excel with visualisation. This third article will explore how to compare two data sets using a Waterfall Chart in Excel.
Exclusive
EXCEL COMMUNITY
Excel Lunch and Learn series: Visualisation with Excel
- 09 Jan 2025
- ICAEW Excel Community
Transform raw data into insightful visualisations and easy-to-read reporting with our lunch and learn series of five 30 minute webinars, presented by John Tennent, Corporate Edge.
Exclusive
EXCEL COMMUNITY
Simple but effective tables, part 9
- 09 Sep 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. The previous two-part article looked at the use of structured references to refer to all or part of an Excel Table, from cells outside of the Table as well as cells within the Table. We are going to conclude our exploration of Tables by looking at Filtering and Sorting, and using Sparklines and check boxes in Table columns. Then, in the next part of the series, we will look at how Tables work with Power Query.
Exclusive
EXCEL COMMUNITY
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.
Data tables
View our helpful guidance and advice on using data tables.
Exclusive
EXCEL COMMUNITY
Running totals in filtered tables
- 27 Oct 2025
- Liam Bastick
In this article, Liam Bastick considers the problem of ensuring running totals still work, whether an Excel table is filtered or not.
Exclusive
EXCEL COMMUNITY
Bringing financial reports alive in Excel with visualisation – comparing data sets
- 14 Feb 2025
- John Tennent
This article is part of a series that supports the lunch and learn webinars on how to bring financial reports alive in Excel with visualisation. This third article will explore how to compare two data sets using a Waterfall Chart in Excel.
Exclusive
EXCEL COMMUNITY
Simple but effective Tables. Part 10
- 23 Sep 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. We are going to conclude our series of articles on the practical use of Excel Tables by looking at how Tables work with Power Query.
Exclusive
EXCEL COMMUNITY
Simple but effective tables, part 9
- 09 Sep 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. The previous two-part article looked at the use of structured references to refer to all or part of an Excel Table, from cells outside of the Table as well as cells within the Table. We are going to conclude our exploration of Tables by looking at Filtering and Sorting, and using Sparklines and check boxes in Table columns. Then, in the next part of the series, we will look at how Tables work with Power Query.
Filtering and queries
Articles and webinars on filtering and queries.
EXCEL COMMUNITY
Power Query tips and tricks live: your questions answered
- 02 Dec 2025
- Excel Community
Discover lesser-known features, shortcuts, and best practices to elevate your Excel skills.
EXCEL COMMUNITY
This year’s 10 best Excel highlights
- 24 Nov 2025
- Bani Lamba
As we approach a new year, it’s time to reflect on some of the content and highlights from the Excel Community in 2025 and look ahead as Excel continues to change and develop with new functionality. Whether you’re new or an existing member, in this article we invite you to explore the insights and learnings the community has delivered for you over this last year.
Exclusive
EXCEL COMMUNITY
Partial Unpivoting
- 20 Nov 2025
- Liam Bastick
Sometimes, when you work with pivoted data that has a structure similar to a PivotTable, it is difficult to look up a value based on multiple column and row criteria. To make it simpler, we usually unpivot the data. Most of the time, you may choose to use the ‘Unpivot columns’ function in Power Query.
Exclusive
EXCEL COMMUNITY
Add column vs. transform column in Power Query
- 29 Sep 2025
- Mark Proctor
In this Creator level article, Mark Proctor returns to go beyond the basic Power Query interface and discover how to perform advanced transformations on existing columns.
Formulas and functions
Articles and webinars on formulas and functions.
EXCEL COMMUNITY
This year’s 10 best Excel highlights
- 24 Nov 2025
- Bani Lamba
As we approach a new year, it’s time to reflect on some of the content and highlights from the Excel Community in 2025 and look ahead as Excel continues to change and develop with new functionality. Whether you’re new or an existing member, in this article we invite you to explore the insights and learnings the community has delivered for you over this last year.
Exclusive
EXCEL COMMUNITY
Partial Unpivoting
- 20 Nov 2025
- Liam Bastick
Sometimes, when you work with pivoted data that has a structure similar to a PivotTable, it is difficult to look up a value based on multiple column and row criteria. To make it simpler, we usually unpivot the data. Most of the time, you may choose to use the ‘Unpivot columns’ function in Power Query.
EXCEL COMMUNITY
A practical guide to using dynamic arrays in Excel
- 19 Nov 2025
- Excel Community
This webinar will cover a practical introduction to Dynamic Arrays in Excel and how dynamic arrays address the common problems faced when using traditional Excel formulas in financial modelling.
Exclusive
EXCEL COMMUNITY
Dealing with complex conditional formatting rules simply
- 10 Nov 2025
- Simon Hurst
Last time, we continued our exploration of some of the advanced options available for working with Conditional Formatting Icon Sets.
PivotTables
Articles and webinars on PivotTables.
Exclusive
EXCEL COMMUNITY
This month’s highlights
- 18 Sep 2025
- Simon Hurst
Perhaps every month you wonder how sales have gone compared to the same month last year. This post demonstrates one way of automatically highlighting the comparison using conditional formatting. Also, just because we can, we’ve used an example based on a PivotTable to demonstrate the technique.
Exclusive
EXCEL COMMUNITY
Power BI Tips & Tricks Live: your questions answered
- 16 May 2025
- Excel Community
Attend this webinar to gain a better understanding of using Power BI and its applications in accounting.
EXCEL COMMUNITY
Is this the end of Pivot Tables
- 21 Mar 2025
- PDF (1,340kb)
- ICAEW Excel Community
This webinar will explore the basics of Pivot Tables before diving into new and alternative functionality that can also be used to analyse and work with data in Excel.
Exclusive
EXCEL COMMUNITY
Is this the end of Pivot Tables?
- 21 Mar 2025
- Excel Community
This webinar will explore the basics of Pivot Tables before diving into new and alternative functionality that can also be used to analyse and work with data in Excel.
Reports and dashboards
Articles and webinars on reports and dashboards.
Exclusive
EXCEL COMMUNITY
Bringing financial reports alive in Excel with visualisation – building the report
- 11 Apr 2025
- John Tennent
This article is part of a series that supports the lunch and learn webinars on how to bring financial reports alive in Excel with visualisation. This fifth and final article will cover bringing together the visualisations to build a financial report.
Exclusive
EXCEL COMMUNITY
Bringing financial reports alive in Excel with visualisation – speedometers
- 25 Feb 2025
- John Tennent
In this fourth blog we will look at ways to report achievements of plans in the form of a speedometer. It’s a graphic that should be used sparingly so one or two of them have impact rather than a cluster of them where it becomes difficult to conclude the relative importance of each. They are ideal for reporting achievement of KPIs or year to date progress against targets. The more details added to the dial the easier it is to interpret. A plain dial is just a proportional assessment, a calibrated dial enables interpretation. The blog will guide you through drawing this example.
Exclusive
EXCEL COMMUNITY
Bringing financial reports alive in Excel with visualisation – comparing data sets
- 14 Feb 2025
- John Tennent
This article is part of a series that supports the lunch and learn webinars on how to bring financial reports alive in Excel with visualisation. This third article will explore how to compare two data sets using a Waterfall Chart in Excel.
Exclusive
EXCEL COMMUNITY
Bringing financial reports alive in Excel with visualisation – visualising monthly results
- 22 Jan 2025
- John Tennent
This article is part of a series that supports the lunch and learn webinars on how to bring financial reports alive in Excel with visualisation. This second article will explore how to visualise monthly results with a range of charts and chart features in Excel.
VBA and macros
Articles and webinars on VBA and macros.
Exclusive
EXCEL COMMUNITY
A beginner's guide to automating in Excel using Office Scripts
- 26 Nov 2024
- ICAEW Excel Community
Office Scripts is a feature that allows users to automate repetitive Excel tasks.
Exclusive
EXCEL COMMUNITY
Excel Tips & Tricks #493 - How to add a custom ribbon to your workbook part 2
- 14 Aug 2024
- Ruth Butler-Lee
This week, we have a developer level post which explores how to set up your custom ribbon with tailored buttons.
Exclusive
EXCEL COMMUNITY
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
EXCEL COMMUNITY
Your Questions Answered #6 – Financial Modelling and Scenario Planning continued: What are your thoughts on incorporating macros into models?
- 31 Jul 2023
- Ben Ducker
In a recent webinar on 'Financial Modelling and Scenario Planning: Mastering Effective Decision-Making', Craig Stirk and Ben Ducker explored why scenario planning is important and why structured models can help. Ben returns to answer some questions from the webinar they were unable to respond to during the session.
Worksheet design & formatting
Articles and webinars on worksheet design and formatting.
Exclusive
EXCEL COMMUNITY
Condition formatting - beyond icons
- 17 Nov 2025
- Simon Hurst
Having covered some of the advanced options available for working with conditional formatting Icon Sets in previous posts, this time we will look at the advanced options available for the other graphical conditional formats: Data Bars and Colour Scales.
Exclusive
EXCEL COMMUNITY
Dealing with complex conditional formatting rules simply
- 10 Nov 2025
- Simon Hurst
Last time, we continued our exploration of some of the advanced options available for working with Conditional Formatting Icon Sets.
Exclusive
EXCEL COMMUNITY
Making conditional formatting more interactive and more automatic
- 27 Oct 2025
- Simon Hurst
Last time, we delved into the advanced options available for working with Conditional Formatting Icon Sets. This time we will make use of the extra flexibility that putting the value in a cell allows us, and use an Excel Spin Button to set the value more easily. We will then explore the use of a formula to calculate the threshold value automatically.
Exclusive
EXCEL COMMUNITY
Running totals in filtered tables
- 27 Oct 2025
- Liam Bastick
In this article, Liam Bastick considers the problem of ensuring running totals still work, whether an Excel table is filtered or not.
Wider productivity tools
Articles on other business tech products and wider productivity tools such as the Microsoft Office suite.
Excel, Teams, Google Sheets, Chat GPT, M365, Power BI, Canva, Zoom ++: New tech features for June-Sept 2025
- Article
- 10 Oct 2025
- David Benaim
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format.
Excel, Teams, Google Sheets, Chat GPT, M365, Power BI, Canva, Zoom ++: New tech features for Mar-May 2025
- Article
- 11 Jun 2025
- David Benaim
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months
Is Canva Sheets the new green?
- Article
- 08 May 2025
- David Benaim
The Canva Suite has become a force of nature with 1 billion designs being produced monthly, and now it finally launched Canva Sheets, but how does that compare to Excel or Google Sheets.
Critical Skills Series: Modern PowerPoint speed up tricks
- Video
- 31 Mar 2025
- Helen Windget
PowerPoint MVP David Benaim shares tips on speeding up formatting, using shortcuts, and AI tools.
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.
