January 22, 2021
Calculate how many workdays fall between two dates. Excel’s NETWORKDAYS function does this if you happen to work the five days between Monday and Friday inclusive. This topic will show you how to perform the calculation for a company that works 5, 6, or 7 days a week.
January 20, 2021
You want to build a formula to return the first non-blank cell in a row. Perhaps columns B:K reflect data at various points in time. Due to the sampling methodology, certain items are checked infrequently.
January 6, 2021
When you hand the world’s most flexible software to 750 million people, everyone finds interesting things to do or interesting ways to use Excel. I love traveling to do the in-person Excel seminars because I get to meet these people. At every seminar, someone has an interesting story of how they are using Excel.
January 4, 2021
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 30, 2020
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 28, 2020
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 24, 2020
Consider a few of these settings after you choose File, Options.
December 23, 2020
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 16, 2020
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).
December 14, 2020
Do you want a harmless prank to pull on a co-worker? When he leaves his desk to grab a cup of coffee, add the fifth icon to his Quick Access Toolbar: Speak Cells on Enter. Click the icon once, and the computer will say, “Cells will now be spoken on Enter.”
December 10, 2020
Excel now provides confirmation with gentle sounds when you do many tasks.
December 9, 2020
One of the painful parts about keying in data is that you have to proofread the numbers. So, you are looking at the sheet of paper, then the screen, then the paper, then the screen. You will end up with a sore neck. Wouldn’t it be nice if you had someone to read you the screen so you can keep your eye on the paper? It’s built in to Excel.