Excel Tips
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.
September 2, 2014
There is a great Filter by Selection icon in Access. Excel offers the same functionality, but it is hidden and mislabeled!
Convert Excel Dates to Month Names »
September 1, 2014
Need to Subtotal or Group by Month? The TEXT function will take any number or date and convert it to text using a particular custom number format.