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 2
- 18 Apr 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. In part 1 we considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.
Exclusive
EXCEL COMMUNITY
Simple but effective, part 1
- 27 Mar 2024
- Simon Hurst
It’s very easy to format a block of data in your favourite colour scheme by using an Excel Table, but Excel Tables are so much more important than just facilitating formatting. In this series we are going to see just what they are capable of, starting with looking at how to create Excel Tables and going on to cover some simple examples of their practical use, such as avoiding global austerity.
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
Spreadsheet review – can Power Query help: part 1?
- 13 Feb 2024
- Simon Hurst
Legacy Excel supports a range of functions and techniques that can help identify potential errors and problems within a spreadsheet as part of a review process. However, it’s worth considering the addition of Power Query to your review toolkit on the grounds of simplicity and ease of use.
Filtering and queries
Articles and webinars on filtering and queries.
Exclusive
EXCEL COMMUNITY
A short introduction to Power Query M code
- 25 Mar 2024
- Mark Proctor
While M code in Power Query may look overwhelming and confusing, the functional language is similar to Excel formulas built using the LET function. In this article, Mark Proctor explores how to get started with understanding and using M code in Excel
Exclusive
EXCEL COMMUNITY
Spreadsheet review – can Power Query help? Part 4
- 13 Mar 2024
- Simon Hurst
Legacy Excel supports a range of functions and techniques that can help identify potential errors and problems within a spreadsheet as part of a review process. In part 1 of this series we looked at some of the advantages of adding Power Query to your review toolkit and, in parts 2 and 3, explored some of the available tools. In part 4 we are looking at the output of those tools in more detail.
Exclusive
EXCEL COMMUNITY
Spreadsheet review – can Power Query help? Part 3
- 23 Feb 2024
- Simon Hurst
In part 1 of this series, we looked at some of the advantages of adding Power Query to your review toolkit. This time we are going to move on from the Profile table that we created in Part 2 to rearranging our Table and positioning it above our original data for ease of reference. We will be using a range of techniques that demonstrate the versatility of the Power Query tools.
Exclusive
EXCEL COMMUNITY
Spreadsheet review – can Power Query help? Part 2
- 16 Feb 2024
- Simon Hurst
Legacy Excel supports a range of functions and techniques that can help identify potential errors and problems within a spreadsheet as part of a review process. In part 1 of this series, we looked at some of the advantages of adding Power Query to your review toolkit. In part 2 we are going to look in more detail at some of those tools and techniques.
Formulas and functions
Articles and webinars on formulas and functions.
Exclusive
EXCEL COMMUNITY
Simple but effective, part 2
- 18 Apr 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. In part 1 we considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.
Exclusive
EXCEL COMMUNITY
Top 12 Excel Combinations: 10. SUMPRODUCT SIGN (Multiple Conditions with OR)
- 03 Apr 2024
- Liam Bastick
I the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers . SUMPRODUCT SIGN (Multiple Conditions with OR).
Exclusive
EXCEL COMMUNITY
Including calculations in Microsoft Word
- 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.
Exclusive
EXCEL COMMUNITY
A short introduction to Power Query M code
- 25 Mar 2024
- Mark Proctor
While M code in Power Query may look overwhelming and confusing, the functional language is similar to Excel formulas built using the LET function. In this article, Mark Proctor explores how to get started with understanding and using M code in Excel
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.
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
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.
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.
Worksheet design & formatting
Articles and webinars on worksheet design and formatting.
Exclusive
EXCEL COMMUNITY
Simple but effective, part 2
- 18 Apr 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. In part 1 we considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.
Exclusive
EXCEL COMMUNITY
Including calculations in Microsoft Word
- 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.
Exclusive
EXCEL COMMUNITY
Your Questions Answered #10 – Tips and Tricks Live extended
- 25 Mar 2024
- Bani Lamba
In this year’s first 'Excel Tips and Tricks live – your questions answered' webinar, John Yeldham and Ian Pay tackled Excel questions and queries covering best practice, the use of functions and functionality, and a range of techniques for data handling and analysis in Excel. Bani returns to answer some of the unanswered questions from the webinar.
Exclusive
EXCEL COMMUNITY
Don’t be a check box Charlie
- 26 Jan 2024
- Simon Hurst
In preparation for a very useful enhancement to the Excel check box feature that is currently available to those on the Insider update channel, we take a look at how check boxes work at the moment before seeing how much easier they will be to use in the near future.
Wider productivity tools
Articles on other business tech products and wider productivity tools such as the Microsoft Office suite.
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.
Exclusive
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.
Exclusive
Office Scripts vs VBA: What’s the difference?
- Article
- 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.
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.