Excel Tips
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.
Faster Field Settings in 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.
UserVoice - What is your Idea to Improve Excel? »
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.
Why Haven't You Adopted Power Pivot Yet? »
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.
Make Font Red If It Meets a Condition - Without Conditional Formatting »
September 12, 2014
Before there was conditional formatting, there was custom number formatting. You can still add a condition to your custom number formats.
Data Pasted to Excel Starts Splitting at Comma? »
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!
Prevent #N/A! in Excel VLOOKUP »
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.
Add Any Excel Icon to the QAT »
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).
September 8, 2014
If you need to insert part of a web page... or anything... into Excel. This feature is new in Excel 2010.