Custom Spreadsheet Solutions
Productivity – powered by Excel

Use Center Across Selection instead of Merge and Center.

Instead of using Merge and Center, try using Center Across Selection. It makes highlighting easy and formulas more logical. The results look the same, but what is happening in the background is different. Below is how most people will put a title across multiple cells, by using the Merge & Center button. Notice the green […]

Filter a chart the easy way.

You can filter a chart, right on the chart. Select the graph and choose the filter button, the one that looks like a funnel. Choose which series or categories you want to be able to see. Select Apply. Here is the original chart. And here is the chart with North and South unselected.

Two very handy shortcut keys for charts.

There are two particularly useful shortcut keys when using an Excel chart (graph). Use Ctrl + Left or Right arrow keys to move through selecting each chart element. From the whole chart area, to Plot area, legend, y-axis, x-axis, title, all points in the series, and then each individual point in the series. Great for […]

Data Types: Get your information here!

Excel includes Data Types that can get information directly from the internet and put it straight into your spreadsheet. You can find the Data Types on the Data Menu. 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 […]

Be Unique

The UNIQUE formula, in Excel, makes short work of removing duplicates from a list. It comes in two main formats. You can totally remove any items that appear more than once in your list, or just keep one instance of each item from the list. Here is an example where the duplicated items are removed […]

Sorted! Get sorted with SORT function.

Sorting used to have to be done in place, but the Excel SORT function 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, their listings and market share. This is our original data. What if […]

Filter function: Return just the data you want to see.

A lot of users of Excel know about the filter buttons. You can read about them here: The filter function allows you to filter data into another place in your workbook, leaving your original data as is. Just like the filter buttons you can display some information from a list based on specified selection criteria. […]

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. A table is a formal structure in Excel. To put your data into a table choose Format as table from the Home […]

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. (To see a shorter introduction to XLOOKUP and how it compares to other LOOKUPS, see Hookups with data. =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 […]

Hookups with data: (x, v, h) lookup and index match.

When you have data in one place, and you want to collect a certain piece of that information and return it somewhere else based on a given value, you probably want a lookup. Depending on the situation there are options about how to do that. The VLOOKUP (the V stands for Vertical) formula used to […]