April 11, 2017
The fx button in Excel helps you to build a function, one argument at a time. But what happens when you have to nest one function inside of another function? There is a way to use the Function Arguments for each of the nested functions.
April 10, 2017
Hot Tip Alert! I waited seven years for this feature. If you love pivot tables, you will love this feature. Starting in 2017, you can change the format for all future pivot tables.
April 7, 2017
Excel Pivot Table trick for changing calculation in a field. I've been click the Field Settings button for years. Probably thousands of wasted clicks in a lifetime of using Excel. Finally, in one of my live seminars, someone asked why don't I just do the trick in this article.
November 8, 2015
I just returned from the Microsoft MVP Summit where I spent a few days with the Excel team. Would you like a way to communicate your Excel improvement ideas to the people who build Excel? There is a new way.
October 15, 2014
It is late 2014, almost 4 years after PowerPivot reached general availability. This product is a game-changer. It enables people to do dramatically more powerful analyses than regular pivot tables.
September 12, 2014
Before there was conditional formatting, there was custom number formatting. You can still add a condition to your custom number formats.
September 11, 2014
Usually, you grab text from Notepad or Email or a web page, paste to Excel, and it all stays in one column. But...one day, late in the afternoon, the pasted data starts automatically parsing into separate columns!
September 10, 2014
You have a nice little VLOOKUP formula. But in order to prevent the #N/A! error when something is not found, you used to have to do the VLOOKUP twice.
September 9, 2014
Have you found a great Excel feature that is buried three clicks deep? Make it always be 1 click away by adding it to the Quick Access Toolbar (QAT).