In this tutorial, we see how to sort by drop down list in Excel.

We have a table containing details about pizza and their performance such as the feedback rating, how many have been sold and the % change from the previous pizza data.

We want to be able to select the column to sort by from a drop down list, and then the table will be automatically sorted by the chosen column.

Watch the video, or read on for the full tutorial.

The tutorial uses the power of the array engine of Excel to sort by drop down list. However, there is another video at the end of the tutorial that shows how to do this in all versions of Excel.

Download the sample workbook to follow along.

[Read more…] about Sort by Drop Down List in Excel

This tutorial shows some advanced SUM function examples. The SUM function is far more powerful than many people realise, and this tutorial will demonstrate its power.

We will see five examples of the SUM function being a BOSS and handling tasks that we often rely on functions such as SUMIFS, XLOOKUP, SUMPRODUCT etc to accomplish.

However, trusty old SUM can take care of them alone.

[Read more…] about Advanced SUM Function Examples – The Power of SUM

Excel does not display negative time. So if you are working with negative times, there is a problem. Fortunately, there are ways to work around this issue.

This tutorial will show two ways to display a negative time in Excel.

For this example, we have the fastest times for the last six London Marathons for the men’s category. And we want to see the time difference compared to the previous year.

If the time is faster than the previous year, the result will be a negative time. A slower time would return a positive time.

[Read more…] about Display Negative Time in Excel

In this tutorial, we will use Excel formulas to lookup multiple values and combine the results into a single cell, or row. We will also order the returned values in two different ways.

The formulas used in this tutorial are only available in Excel 365 and Excel Online. They take advantage of the array engine of modern Excel. This video show you how to lookup multiple values in all Excel versions.

Watch the video below, or read on. This tutorial covers three examples of a lookup formula to return multiple values.

Lots of information, so let’s dive into the action.

[Read more…] about Lookup Multiple Values in Excel