Excel Community resources

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.

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.

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...

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

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...

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.

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.

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.

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.

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.

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

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?

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.

A Creator level post where we’re refreshing our coverage of the PivotTable extraction function GETPIVOTDATA

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.

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.

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.

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.

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.

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.

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.

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.

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.

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...