Custom Spreadsheet Solutions
Productivity – powered by Excel

Filter a graph the easy way

You can filter a graph, right on the graph. Select the graph and choose the filter button. Choose which series or categories you want to be able to see. Select Apply.

Two very handy shortcut keys for charts.

There are two particularly useful shortcut keys are when using an Excel chart (graph). Use Ctrl + Left or Right arrow keys to move through selecting each chart element. Great for getting to the point you want when it is close to others and hard to get just right with the mouse. Use Ctrl + […]

Get your information here!

Excel includes Data Types that can get information from the internet and put it straight into your spreadsheet. You can choose from twenty different types of information, including Stocks, Geography, Food and Movies. Type in the thing you are interested in, select which data type you want it to be, and use the Insert Data […]

Be Unique

The UNIQUE formula, in #excel, makes short work of removing duplicates from a list. It comes in two main formats, determined by the third input. You can totally remove any items that appear more than once in your list, as below, or just keep one copy of each item. =UNIQUE(The range that has the values […]

Sorted! Complex sorting with SORTBY

SORTBY is a formula you can use to sort data by multiple columns at once or return one column of data sorted by another column. We can return the Company “Names” in order of market share without having to return the market share column. Anatomy of SORTBY(Array to sort: Just the company names for us, […]

Sorted! Get sorted with SORT function.

Sorting used to have to be done in place, but the Excel SORT functions allows you to present data from one place, in another place sorted by your specifications. Here is a simple example. This is a list of companies, in company order, there listings and market share. What if we want to list the […]

Filter formula for fun.

The filter function enables you to display some information from a list based on specified selection criteria. This simple FILTER formula returns the Names of the people from the list above that are in the team specified in B10, Red in this case. This is an example of a formula that will “SPILL” down into […]

Excel App – productivity on the go – Card View.

To make it easier to read data on a smaller screen, you can use Card View on the Excel app. Your background data needs to be in a table for it to work. Here is the table view of the data And, here is the Card View How to select Card View. Once in Card […]

Excel App – Productivity on the go.

Did you know that the excel app has powers that not even the desktop version has? (Update 20/03/2023: Now on desktop version too!) You can take a photo of some data and the Excel app will turn it into a spreadsheet. It doesn’t always get it 100% correct, but depending on the layout of the […]

XLOOKUP- You have the power!

XLOOKUP allows you to search through a list, find what you are looking for and return a value from a corresponding list…. and some other things that VLOOKUP couldn’t do. =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])  https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 You need to provide the lookup_value – the thing you are trying to find. The lookup_array – where you are looking for […]