MrExcel's Learn Excel #934 - Table Formatting

The every-other-row formatting becomes simple in Excel 2007 using the Table functionality. Choose from 54x20 formats in seconds. Episode 934 shows you how.

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!

MrExcel's Learn Excel #932 - Greenbar II

By the time I answered Lisa's question from yesterday, she had already formatted her spreadsheet, using a clever method that I would not have thought of. Episode 932 will show you how to format every other row using the fill handle.

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!

MrExcel's Learn Excel #931 - Greenbar Formatting

Lisa asks how to shade every other row in the worksheet. While there are several solutions, Episode 931 shows you how to use the old AutoFormat dialog to solve this problem.

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!

Episode 694 - Double Greenbar

As a follow-up to yesterday's podcast, we'll take a look at how to customize the formatting used in the Excel 2007 table formatting. Episode 694 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!

Episode 470 - Conditional Formatting

Today’s guest podcaster is MVP Zack Barresse. Zack shows how to apply a greenbar formatting using a cool conditional formatting formula. Episode 470 shows you how.

Episode 418 - Table Formatting

Excel 2007 adds new table intelligence that you can use in probably 90% of your worksheets. In Episode 418, learn how table functionality can easily apply greenbar formatting, autofilters, and more.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!