Charts and graphs
Articles and webinars on Excel charts and graphs.
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.
Exclusive
EXCEL COMMUNITY
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.
Exclusive
EXCEL COMMUNITY
Enhancing data display and entry with Excel Form Controls
- 13 Nov 2023
Form Controls are objects that can be used to display data or make it easier for users to enter data, to perform an action or to make a selection.
Exclusive
EXCEL COMMUNITY
Histogram Hiccoughs part 2
- 27 Oct 2023
- Liam Bastick
Last time, I provided several reasons why Excel’s built-in Histogram charts can cause problems. This time, I consider workarounds to achieve the same visualisations.
Data tables
View our helpful guidance and advice on using data tables.
Exclusive
EXCEL COMMUNITY
Simple but effective, 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.
Exclusive
EXCEL COMMUNITY
Simple but effective, part 7
- 24 Jul 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.
Exclusive
EXCEL COMMUNITY
The underused Table feature in Excel & Google Sheets
- 04 Jul 2024
- David Benaim
From my experience, every spreadsheet user already considers their data to be in tables, simply by virtue of data being in rows & columns, but very few have ever used the actual feature called “Tables” which means sadly that almost every regular user is missing out on one of spreadsheets’ most useful features.
Exclusive
EXCEL COMMUNITY
Simple but effective, part 6
- 03 Jul 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 last article finished with a brief introduction to the use of Slicers as interactive filters for Excel Tables. This time we show how Slicers can be used in practice to create an interactive dashboard from an Excel Table.
Filtering and queries
Articles and webinars on filtering and queries.
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.
Exclusive
EXCEL COMMUNITY
Avoid Column Name errors in Power Query
- 24 May 2024
- Mark Proctor
Changing column names are a frequent cause of Power Query errors. This article explores a few techniques to avoid those errors and ensure Power Query refresh runs smoothly.
Exclusive
EXCEL COMMUNITY
Finding the missing link – Edit links enhanced
- 25 Apr 2024
- Simon Hurst
Links to cells in other workbooks are a frequent cause of confusion. It can be particularly difficult to track down some of the more elusive ways in which one spreadsheet can be linked to another. A Find Next command available as part of an enhancement to the previous Edit Links command might now be able to help.
EXCEL COMMUNITY
Excel Community round up – March 2024
- 01 Apr 2024
- Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in March 2024.
Formulas and functions
Articles and webinars on formulas and functions.
Exclusive
EXCEL COMMUNITY
Top 12 Excel Combinations: 5. SCAN LAMBDA
- 29 Aug 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers SCAN LAMBDA.
Exclusive
EXCEL COMMUNITY
Simple but effective, 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.
Exclusive
EXCEL COMMUNITY
Top 12 Excel Combinations: 6. MAP LAMBDA
- 18 Jul 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers MAP LAMBDA.
Exclusive
EXCEL COMMUNITY
Top 12 Excel Combinations: 7. OFFSET MATCH
- 24 Jun 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers OFFSET MATCH.
PivotTables
Articles and webinars on PivotTables.
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.
Exclusive
EXCEL COMMUNITY
Formatting Slicers
- 30 Aug 2023
- Liam Bastick
In earlier versions of Microsoft Excel, you can use report filters to filter data in a PivotTable report, but it is not easy to see the current filtering state when you filter on multiple items. In Microsoft Excel 2010 and later versions (that is, from when Slicers were introduced), you have the option to use Slicers to filter the data
Exclusive
EXCEL COMMUNITY
Coming soon: graphic details in PivotTables
- 24 Jul 2023
- Simon Hurst
An imminent Excel enhancement will allow you to include Data Types and images in your PivotTables. Is this your chance to build PivotTables containing employee photos and product pictures?
Reports and dashboards
Articles and webinars on reports and dashboards.
Exclusive
EXCEL COMMUNITY
Enhancing data display and entry with Excel Form Controls
- 13 Nov 2023
Form Controls are objects that can be used to display data or make it easier for users to enter data, to perform an action or to make a selection.
Exclusive
EXCEL COMMUNITY
Excel – smarten up your dashboards
- 19 Dec 2022
- Simon Hurst
It might have taken you hours, or even days, to turn your data into an interactive Excel dashboard, driven by multiple Slicers, but investing just a few more minutes on improving the presentation of your dashboard can give it greater impact and help it communicate its message even more effectively.
Exclusive
Traffic cameras - incorporate real traffic lights in your Excel reports
- 22 Nov 2022
- Simon Hurst
Although the imminent new Excel IMAGE() function provides additional options for displaying pictures that change dynamically based on values in cells, there is already a way to do this using the Excel Camera. The examples in this article show you how to display product pictures and real traffic lights.
EXCEL COMMUNITY
Dynamic Arrays and Charts – bigger and better Excel dashboards await
- 03 Nov 2022
- Simon Hurst
The latest Excel enhancement to the working of Charts and Dynamic Arrays reinforces the suspicion that the Excel development team could indeed be avid followers of the Excel Community. In this article, we’ll see how the new ability for charts to use Dynamic Arrays dynamically as their data source allows Excel dashboards to be even more automatic and exciting.
VBA and macros
Articles and webinars on VBA and macros.
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.
Exclusive
EXCEL COMMUNITY
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.
Worksheet design & formatting
Articles and webinars on worksheet design and formatting.
Exclusive
EXCEL COMMUNITY
Simple but effective, part 6
- 03 Jul 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 last article finished with a brief introduction to the use of Slicers as interactive filters for Excel Tables. This time we show how Slicers can be used in practice to create an interactive dashboard from an Excel Table.
Exclusive
EXCEL COMMUNITY
Simple but effective, part 5
- 24 Jun 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. As part of our journey through the capabilities of Tables, this time we are going to examine some of the options available in the contextual Table Design Ribbon tab.
EXCEL COMMUNITY
The easy way to implement Excel principles
- 13 Jun 2024
- PerfectXL
What unites accountants? Excel, of course! I’m sure you'll agree that Excel's integral role in accountancy demands that spreadsheets meet certain standards, but that is easier said than done. In this article, PerfectXL explore what exactly you should be mindful of when working in Excel.
Exclusive
EXCEL COMMUNITY
Excel Tips & Tricks #490 – Revisiting data entry shortcuts
- 21 May 2024
- Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post revisiting simple keyboard shortcuts that helps expedite entry of data into Excel.
Wider productivity tools
Articles on other business tech products and wider productivity tools such as the Microsoft Office suite.
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Mar-May 2024
- Article
- 14 Jun 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.
Exclusive
Including calculations in Microsoft Word
- Article
- 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.
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Nov-Feb 2024
- Article
- 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.
Microsoft Loop: Edit things from multiple entry points
- Article
- 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.
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.