MrExcel Excel Videos

Jack from Boston sends in a cool Windows trick to change the color of the selected cells. You would this this would solve the problem in Episode 907, but it doesn't. Still, you can watch Episode 914 to see how to enhance Excel 2003 and earlier. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel.Download a new two minute video every workday to learn one of the 377 tips from the book!

Yesterday, I talked about Jason's request to format a grouped pivot field in the row area of a pivot table. There is a solution, but it requires a bit of work in the original data set. Episode 913 will show you about the TEXT function and the other type of VLOOKUP.

Jason from Texas asks about formatting percentages in a pivot table. I thought this would be an easy question, but Jason wants to format the grouped percentages in the row area of the pivot table. Episode 912 talks about grouping in a pivot table but doesn't come up with a good solution to the problem.

Where is it Wednesday? A person in one of my seminars asked me about a feature missing from Excel 2007. While the feature sounded familiar, it was also missing from Excel 2003. In Episode 911, we will take a look at a faster way to start a formula using the mouse. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel.

Patrick has a tricky overtime calculation. Episode 910 will show how to calculate overtime for people who worked over 80 hours and to show a blank for people who worked less than 80 hours. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel.

Roseanne asks about the Scenario Manager in Excel. I hope that she will be able to use the Data Table discussed in Episode 794, because the Scenario Manager is relatively very difficult to use. Episode 909 will show you how. This video is a companion to the book Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

As you approach year end, you might want to calculate compound growth rates. Episode 908 will show you how. This video is the podcast companion to the book Learn Excel 97-2007 from MrExcel.

One of the annoying things about Excel 2007 is that the color for selected sheets and cells is almost identical to the color for unselected sheets and cells. Harry from Culver-Stockton college suggests a simple solution for the tab color in Episode 907.

Take mailing list data from Microsoft Excel and produce labels in Word. Episode 906 will show you how. Watch a new two minute video every workday to learn one of the 377 tips from the book Learn Excel 97-2007 from MrExcel.