Charts and graphs
Articles and webinars on Excel charts and graphs.
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.
Exclusive
EXCEL COMMUNITY
Histogram Hiccoughs Part 1
- 27 Oct 2023
- Liam Bastick
The Histogram chart helps us to analyse the distribution of the data, where we have many data points that can be grouped into categories, or “buckets”. We begin by looking at the standard Excel Histogram chart, which is available in Excel 2016 onwards.
EXCEL COMMUNITY
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Jun-Aug 2023
- 11 Sep 2023
- David Benaim
David Benaim presents a digest of new features across Microsoft 365 & other business tech products in written, images & video format covering the last three month.
Data tables
View our helpful guidance and advice on using data tables.
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 Tips & Tricks 482 – Get Data From Picture
- 30 Oct 2023
- Ian Pay
Hello all and welcome back to Excel Tips and Tricks! This week, we have a Creator level post in which we're covering some relatively new functionality that allows users to capture data into a spreadsheet from an image.
Exclusive
EXCEL COMMUNITY
Advanced conditional formatting – part 3: the horror of peril sensitivity
- 02 Oct 2023
- Simon Hurst
Applying default conditional formats is very straightforward and can be accomplished with just a couple of clicks, but delving a little deeper can help you to use conditional formatting in additional ways and to tailor your format to your own requirements. After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting and in part 2 at the graphical conditional formats, this time we will look at some other uses of conditional formatting including how it works with PivotTables and Power Query tables as well as some more unusual applications of con...
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
Filtering and queries
Articles and webinars on filtering and queries.
Exclusive
EXCEL COMMUNITY
Advanced conditional formatting – part 3: the horror of peril sensitivity
- 02 Oct 2023
- Simon Hurst
Applying default conditional formats is very straightforward and can be accomplished with just a couple of clicks, but delving a little deeper can help you to use conditional formatting in additional ways and to tailor your format to your own requirements. After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting and in part 2 at the graphical conditional formats, this time we will look at some other uses of conditional formatting including how it works with PivotTables and Power Query tables as well as some more unusual applications of con...
Exclusive
EXCEL COMMUNITY
Excel Tips & Tricks #479 – Advanced Filter redux
- 15 Sep 2023
- Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week we have a Creator level post where we will take another look at the ‘Advanced Filter’ feature.
EXCEL COMMUNITY
Excel Community round up - August 2023
- 01 Sep 2023
- Tracy Gray
Here are all the new Excel blogs from the Excel Community in August 2023.
Exclusive
EXCEL COMMUNITY
Power Query – matching lists part 2
- 24 Aug 2023
- Simon Hurst
In the first part of this two-part article, we looked at using lists in Power Query to create a list of articles that matched a set of keywords within the existing archive portal, in order to support a new Excel Community project. After seeing how we could create a table containing the relevant information in part 1, this time we will see how to use those techniques to add our filter in Power BI.
Formulas and functions
Articles and webinars on formulas and functions.
Exclusive
EXCEL COMMUNITY
Advanced Data Validation – part 4: optimise data input dropdown lists with dynamic arrays
- 24 Nov 2023
- Simon Hurst
Having covered the basics of the Excel Data Validation feature in the first part of this series, the use of the Custom option to construct more complex data validation rules in part 2, and working with basic lists in part 3, in this final part we look at using Dynamic Arrays to filter and sort lists automatically.
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
Advanced Data Validation – part 3: lists
- 10 Nov 2023
- Simon Hurst
Having covered the basics of the Excel Data Validation feature in the first part of this series and the use of the Custom option to construct more complex data validation rules in part 2, this part looks at using Data Validation to allow users to select from lists.
EXCEL COMMUNITY
Your Questions Answered #9 – What is the purpose of # when using dynamic arrays?
- 09 Nov 2023
- Thomas Edmunds
In a recent webinar “Dynamic Arrays refreshed”, Tom Edmunds introduced Dynamic Arrays and explored some of the latest dynamic array functions. In this article Tom returns to answer some questions from the webinar he was unable to respond to during the session.
PivotTables
Articles and webinars on PivotTables.
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?
Exclusive
EXCEL COMMUNITY
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.
Exclusive
EXCEL COMMUNITY
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
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.
Exclusive
Displaying reports by date – Excel versus Power BI
- 09 Dec 2021
- Simon Hurst
When working with reports interactively, it's often useful to be able to set a date or range of dates to filter the information. Here, we are going to compare the way date filtering works in Excel and in the free Power BI Desktop app.
VBA and macros
Articles and webinars on VBA and macros.
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.
EXCEL COMMUNITY
Add-ins or bad-ins? The dangers of Excel XLL files.
- 02 Feb 2023
- Simon Hurst
Most Excel users know about the dangers of running macros received from an untrusted source. However, as Microsoft strengthens its security procedures relating to macros, the danger might increasingly come from another direction: Excel add-ins and, in particular, .XLL files.
Exclusive
Excel Tips and Tricks #454 – Revisiting splitting workbooks with VBA
- 13 Sep 2022
- Ian Pay
A Developer level post in which we are going to work through the VBA code required to take a workbook and cut it into one file for each sheet, and save all the resulting files.
Worksheet design & formatting
Articles and webinars on worksheet design and formatting.
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.
Exclusive
EXCEL COMMUNITY
Excel Tips & Tricks #481 – Refreshing Cell Styles
- 20 Oct 2023
- Ian Pay
Hello all and welcome back to Excel Tips and Tricks! This week, we have a General User post in which we're revisiting the topic of cell styles to help support consistency of formatting.
Exclusive
EXCEL COMMUNITY
Advanced conditional formatting – part 3: the horror of peril sensitivity
- 02 Oct 2023
- Simon Hurst
Applying default conditional formats is very straightforward and can be accomplished with just a couple of clicks, but delving a little deeper can help you to use conditional formatting in additional ways and to tailor your format to your own requirements. After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting and in part 2 at the graphical conditional formats, this time we will look at some other uses of conditional formatting including how it works with PivotTables and Power Query tables as well as some more unusual applications of con...
EXCEL COMMUNITY
Excel Community round up - September 2023
- 02 Oct 2023
- Tracy Gray
Here are all the new Excel blogs from the Excel Community in September 2023.
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.