January 16, 2020
After you’ve applied a filter, say that you want to see the total of the visible cells.
January 15, 2020
What if you want to see all values greater than $20,000?
January 13, 2020
The filter dropdowns have been in Excel for decades, but there are two faster ways to filter. Normally, you select a cell in your data, choose Data, Filter, open the dropdown menu on a column heading, uncheck Select All, and scroll through a long list of values, trying to find the desired item.
January 9, 2020
People often ask about how to parse data that is all in a single column. Say you wanted to sort the data by zip code.
January 8, 2020
You have thousands of rows of data. You’ve added a new formula in the top row of your data set, something like =PROPER(A2&" "&B2). You need to copy the formula down to all of the rows of your data set.
January 6, 2020
A new Natural Language Query feature is rolling out to Office 365 in late 2019 and early 2020. The feature uses artificial intelligence to answer questions about your data.
December 19, 2019
I published more than 200 ideas since February. While the following ideas did not get much press here, they are self-explanatory in a 140-character tweet.
December 18, 2019
You've always had the ability to select multiple selections in Excel by Ctrl+Dragging to select cells. However, in the past, there was no way to unselect one cell. You can now Ctrl + Click to unselect that cell.
December 16, 2019
As I started polling readers about their favorite Excel tips, a large number of them were keyboard shortcuts. Following keyboard shortcuts are presented in order of popularity.
December 12, 2019
Consider a few of these settings after you choose File, Options.
December 11, 2019
There are several short macros you can add to your Personal Macro Workbook and then add to the QAT. In this tip, you will see how to create the Personal Macro Workbook, type some macros, and then assign them to icons on the QAT.
December 9, 2019
Even though the Excel team does not think many features are Home-tab-worthy, you can add your favorite features to the Quick Access Toolbar (QAT).