Three quick tips and a quiz question. It is a holiday weekend in the United States, but Episode 795 strings together a few tips that are too short for their own podcast, plus a viewer challenge at the end.

This blog is the video 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!

Run many what-if scenarios at once using the Data Table command. Episode 794 will show you how to set up and use this powerful command.

This blog is the video 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!

Normally, you can not use AutoFilter within a pivot table. Today, Dan from Philly shares an amazing hack that allows you to filter the results of the pivot table. Episode 793 shows you how.

This blog is the video 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!

Another way to solve yesterday's problem is to use the =SUBSTITUTE function instead of LEFT and LEN. Episode 792 will show you how.

This blog is the video 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!

After adding Subtotals, Excel will append the word " Total" to the field being subtotaled. In Episode 791, we take a look at how to use a formula to remove the totals so that the data can be used as a lookup table.

This blog is the video 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!

Kathy asks how to type numbers in a diagonally split cell. Episode 790 shows you how.

This blog is the video 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!

Rather than use a custom view, Episode 789 shows how to create a 3-line macro to unhide all worksheets.

This blog is the video 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!

You can hide 20 worksheets in a single command, but it is very tedious to unhide all worksheets. Episode 788 shows how to use a custom view to unhide all worksheets.

This blog is the video 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!

A question from a seminar... how can you use the consolidate command to subtract one data set from another data set? Episode 787 shows you the workaround.

This blog is the video 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!

An introduction to using Data Consolidate to add two data sets. Episode 786 introduces the concept. Tomorrows episode will throw in an interesting twist.

This blog is the video 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!