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
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.
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.
Data tables
View our helpful guidance and advice on using data tables.
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.
Exclusive
EXCEL COMMUNITY
Simple but effective tables, part 8
- 07 Aug 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. Last time we started looking at the use of structured references to refer to all or part of an Excel Table, using examples based on referring to the Table from cells outside the Table. This time we will look at structured references within a Table and some more advanced examples of how to use structured references.
Filtering and queries
Articles and webinars on filtering and queries.
Exclusive
EXCEL COMMUNITY
Your Questions Answered #12 – Getting started with Office Scripts
- 11 Dec 2024
- Mark Proctor
Following on from ‘A beginner's guide to automating in Excel using Office Scripts’ webinar, Mark Proctor, Microsoft MVP and Director at Excel Off The Grid, returns to address more of the questions that came out of the webinar on how to get started with Office scripts to automate tasks and processes 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.
EXCEL COMMUNITY
Your Questions Answered #11 – Tips and Tricks Live extended
- 11 Jul 2024
- David Benaim
In last month’s ‘Excel Tips and Tricks live – your questions answered’ webinar, David Benaim and Ian Pay tackled Excel questions and queries covering best practices when using Power Query, the use of formulas such as XLOOKUP, and a range of techniques for data handling and analysis in Excel. In this article, David returns to answer some of the unanswered questions from the webinar.
Formulas and functions
Articles and webinars on formulas and functions.
EXCEL COMMUNITY
Excel Community round up - January 2025
- 03 Feb 2025
- Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in January 2025.
Exclusive
EXCEL COMMUNITY
Going Deep with REDUCE
- 27 Jan 2025
- Mark Proctor
In this article, Mark Proctor explores the REDUCE function in Excel and dives into its power for achieving advanced calculations.
Exclusive
EXCEL COMMUNITY
Excel, what’s occurrin’ – it doesn’t add up
- 20 Jan 2025
- Simon Hurst
This series looks at some of the things that can go wrong in an Excel spreadsheet and at what we can do to avoid or resolve the issue. We start with the basics of making sure our numbers add up.
EXCEL COMMUNITY
100 new Excel features from the first half of the 2020s
- 13 Jan 2025
- David Benaim
We’re halfway through the decade and Excel has released so many features that its hard to keep track, so here is a whistle stop tour with over 100 features. Items marked with * are released on the current channel but not all channels, so these items may not be available to all now but should be by July 2025. Click File > Account to see which channel you are on.
PivotTables
Articles and webinars on PivotTables.
EXCEL COMMUNITY
Excel’s GROUPBY and PIVOTBY functions vs PivotTables
- 29 Nov 2024
- David Benaim
One of Excel’s most significant updates this decade is without a doubt the new GROUPBY and PIVOTBY functions, these can replicate PivotTables functionality through formulas, so here I will compare and contrast both methods whilst providing possibly the most complete guide on the internet currently of GROUPBY.
EXCEL COMMUNITY
Excel’s GROUPBY & PIVOTBY functions vs PivotTables
- 29 Nov 2024
- David Benaim
One of Excel’s most significant updates this decade is without a doubt the new GROUPBY and PIVOTBY functions, these can replicate PivotTables functionality through formulas, so here I will compare and contrast both methods whilst providing possibly the most complete guide on the internet currently of GROUPBY.
Exclusive
Power Tools Part 4: Build dynamic dashboards with Power Pivot
- 04 Mar 2024
- ICAEW
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.
EXCEL COMMUNITY
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.
Reports and dashboards
Articles and webinars on reports and dashboards.
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.
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
Bringing financial reports alive in Excel with visualisation
- 26 Nov 2024
- John Tennent
This is the first article of a series that supports the lunch and learn webinars that will show you how to bring the financial reports alive in Excel with visualization. This article will explore the journey from raw data to actionable insights.
VBA and macros
Articles and webinars on VBA and macros.
Exclusive
EXCEL COMMUNITY
Your Questions Answered #12 – Getting started with Office Scripts
- 11 Dec 2024
- Mark Proctor
Following on from ‘A beginner's guide to automating in Excel using Office Scripts’ webinar, Mark Proctor, Microsoft MVP and Director at Excel Off The Grid, returns to address more of the questions that came out of the webinar on how to get started with Office scripts to automate tasks and processes in Excel.
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’s real-life superpowers
- 24 Oct 2024
- Simon Hurst
Useful as some features are when used in a spreadsheet, they could be even more empowering if available in real-life. In this article we consider some examples and explore the use of AI in illustrating the possibilities.
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.
Worksheet design & formatting
Articles and webinars on worksheet design and formatting.
Exclusive
EXCEL COMMUNITY
Excel, what’s occurrin’ 2 – Precision as displayed
- 24 Jan 2025
- Simon Hurst
This series looks at some of the things that can go wrong in an Excel spreadsheet and at what we can do to avoid or resolve the issue. We start with the basics of making sure our numbers add up. Having looked at the use of the ROUND() function in part 2, this time we move on to a far simpler and easier method with only one drawback, it could destroy the accuracy of your spreadsheet.
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
Your 2025 Excel Community Guide
- 11 Dec 2024
- Bani Lamba
As we step into a new year, we’re delighted to welcome all our members to the growing Excel Community. With over 1,000 articles, over 490 tips, 4 thought leadership guides and an extensive archive of webinar recordings, we realise that it can sometimes be tricky to find what you’re looking for. So, here is a guide that you can use as a starting point to make the best use of your community.
Exclusive
EXCEL COMMUNITY
Excel’s real-life superpowers
- 24 Oct 2024
- Simon Hurst
Useful as some features are when used in a spreadsheet, they could be even more empowering if available in real-life. In this article we consider some examples and explore the use of AI in illustrating the possibilities.
Wider productivity tools
Articles on other business tech products and wider productivity tools such as the Microsoft Office suite.
Exclusive
Your Questions Answered #12 – Getting started with Office Scripts
- Article
- 11 Dec 2024
- Mark Proctor
Following on from ‘A beginner's guide to automating in Excel using Office Scripts’ webinar, Mark Proctor, Microsoft MVP and Director at Excel Off The Grid, returns to address more of the questions that came out of the webinar on how to get started with Office scripts to automate tasks and processes in Excel.
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Sep-Dec 2024
- Article
- 09 Dec 2024
- David Benaim
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three months.
Exclusive
Power tools part 5: Transform work processes with Power apps
- Webinar
- 28 Oct 2024
- ICAEW Data Analytics and Excel Communities
This webinar will cover use cases and show how Power Apps connects with common data sources like SharePoint.
Exclusive
Unsend your emails
- Article
- 09 Oct 2024
- Simon Hurst
Inspired by a recent catastrophic email event that made the national news, we once again abandon Excel to look at another Office application, this time Microsoft Outlook. In particular, we see how Outlook can help to protect us from ourselves.
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.