Excel Tips

Nested Function Arguments Dialog »

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.

Pivot Table Defaults »

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).