Excel Tips
April 19, 2017
In Microsoft Excel, can you refresh all pivot tables at once? Read this article to learn how.
April 18, 2017
You have data in Excel. When you type a name, you want all of the cells that include that name to light up in another color. This episode will show you how.
April 17, 2017
How to merge data from several Excel workbooks. Say that you have a folder full of Excel files. Each has one worksheet with a differing number of rows. You can import all of the files in the folder to a single Excel workbook.
April 14, 2017
Some of the questions that come in are pretty difficult. Today, we have a column of cells. Each cell has some words, then a date, then some more words. The goal is to pull the date portion of that text to a new column. This is a dueling episode with ideas from Bill and Mike.
April 13, 2017
How to prevent errors in your Excel pivot table calculated fields. If you are doing some division in a pivot table, you might get some Division by Zero errors.
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.
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.