Excel Tips
Calculation Bug When Changing VLOOKUP Table »
February 23, 2018
There is an odd bug that can cause calculation errors in Excel when you make changes to the lookup table. Given that the Excel team's motto is "Recalc or Die", I am not sure why they won't patch this bug.
Double Click the Fill Handle to Copy a Formula »
February 22, 2018
My favorite Excel trick of all time: You have thousands of rows of data and have to copy the formula to the end. Don't try to drag the formula to the end. There is a better way.
Unpivoting Data in Power Query »
February 21, 2018
Unpivoting in Excel solves something that was a 200-keystroke nightmare and makes it be just a few clicks.
Discover Insights About Your Excel Data »
February 20, 2018
Insights is a new feature coming to Excel and Office 365. Office Insiders can take the new artificial-intelligence feature for a spin soon.
Quickly Selecting Your Data Using Ctrl + Shift + Arrow »
February 19, 2018
"Hands off the mouse!", advises German Nande of training powerhouse Adkins, Matchett & Toy Ltd. If you want to be amazingly fast at Excel, you have to learn how to use Excel without reaching for the mouse every few seconds. I couldn't agree more.
When It Makes Sense to Use Option Explicit »
February 17, 2018
It seems that I have caused some angst over the years because of my controversial stance that Option Explicit is not useful in VBA. I was reminded of this recently when I did a Skype session at Excel Weekend of Brazil. I've written a book on Excel VBA for QUE. That book has been translated to Portuguese for the Brazil market. So, apparently, I've taught the fine people of Brasil about Excel VBA for 15 years. Now that I am 15 years older and wiser, I will concede that there might be good reasons to use Option Explicit.
What Characters are Legal in a Worksheet Name »
February 16, 2018
Worksheet names can be changed to almost anything. It is the *almost* part that is fuzzy for me. There are a few characters that aren't allowed in a worksheet tab. But how do you figure out which characters they are? Today, I will show you how.
How Many Days Between X and Y »
February 15, 2018
Counting the numbers of days between two dates in Excel seems deceptively simple. But if you simply subtract the earlier date from the later date, you might be mis-counting the number of days.
Distinct Count in Pivot Tables with the Data Model »
February 14, 2018
Today's tip is from Excel project manager Ash Sharma. I asked Ash for his favorite Excel tips and will feature them for the next seven Wednesdays. His first tip involves a really simple way to calculate a distinct count in an Excel pivot table. It all comes down to one simple check box.