Learn Excel from Bill Jelen with this daily 2 minute video podcast.

## Friday, September 29, 2006

### Episode 351 - Maddening Subtotals

What if you had to total 168 different fields using the Subtotal command? The maddening Subtotal box only lets you choose three fields before scrolling to see three more fields. In Episode 351, learn the cool way to quickly add the subtotals.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: ,

## Thursday, September 28, 2006

### Episode 350 - Total Visible Rows

There is another way to use the AutoSum icon in the standard toolbar. This alternate method will show you the totals of the visible cells, ignoring cells in hidden rows. Episode 350 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: ,

## Wednesday, September 27, 2006

### Episode 349 - Chart Data

In Episode 349, learn a cool way to add new data to an existing chart. My book usually shows the drag and drop method to add data, but in Episode 349, you can learn how to drag the selection handle to add or remove data from a chart.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Tuesday, September 26, 2006

### Episode 348 - Max or If

Calculate Sales over Quota using either the IF or MAX functions. Episode 348 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: , ,

## Monday, September 25, 2006

### Episode 347 - Andy's Problem

Andy "Cyber" Walker once asked me what seemed like a simple question - he wanted to use conditional formatting to change records to green if the total of all records for that day exceeded \$1000. While this sounds simple, it actually is incredibly complex to set up. Episode 347 walks you through the amazing conditional formatting option to allow this to happen.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Friday, September 22, 2006

### Episode 346 - Fractions

Change the decimals in your spreadsheet to display as fractions. Excel offers options for halves, quarters, etc., but Episode 346 shows you how to create a custom format to display in thirty-secondths or even five-hundred-eighty-eighths.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Thursday, September 21, 2006

### Episode 345 - Shrink To Fit

How to make a value that is slightly too large for a column automatically fit. Episode 345 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Wednesday, September 20, 2006

### Episode 344 - Border Details

The complete guide to applying borders to a selection. Learn what all of those icons actually do on the borders tab. Episode 344 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Tuesday, September 19, 2006

### Episode 343 - Double Underline

Tricks for adding a double underline to your cells. Episode 343 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels:

## Monday, September 18, 2006

### Episode 342 - Without Borders

Do you get annoyed when you copy a formula and the borders get copied along with the formula? Episode 342 shows you a cool trick to prevent the borders from being copied as you extend a formula.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: ,

## Friday, September 15, 2006

### Episode 341 - Printing Row Numbers

How to print your worksheet with the row and column headings visible. Episode 341 shows you how to make your printout look just like your Excel screen, plus two reasons why you would want to do this. Learn how to print formulas instead of values and how to print your cell comments at the bottom of the sheet.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: , , , ,

## Thursday, September 14, 2006

### Episode 340 - True SmartTags

Why does every TRUE value in your worksheet get a little purple triangle? You can thank some out-of-business company with the stock ticker of TRUE for that one. In Episode 340, we'll take a look at how to selectively turn off SmartTags for one company.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: , ,

## Wednesday, September 13, 2006

### Episode 339 - Format Painter

Today I show you a great trick for copying formatting from one place to another. Unlike Paste Special Formats, this technique also brings over column widths and row heights. Episode 339 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

## Tuesday, September 12, 2006

### Episode 338 - Tab Color

Change your worksheet tab colors - a new feature in Excel 2002. Episode 338 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book

## Monday, September 11, 2006

### Episode 337 - Hiding Errors

Need to print a report quickly but don't want the error cells to show? Episode 337 will show you how to hide the errors by changing them to blank cells.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

## Friday, September 08, 2006

### Episode 336 - Fitting Report

How to make a report fit to one page wide by hundreds of pages tall. Episode 336 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

## Thursday, September 07, 2006

### Episode 335 - Page Break Preview

How to use Page Break Preview mode to see all of your page breaks. Episode 335 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

## Wednesday, September 06, 2006

### Episode 334 - Page Breaks

The difference between automatic page and manual page breaks. Removing all page breaks. Quickly adding many page breaks. Episode 334 shows it all.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

## Tuesday, September 05, 2006

### Episode 333 - Watch Window

If you are using Excel 2003, use the new Watch Window tool to watch the values of far-away cells. Episode 333 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

## Monday, September 04, 2006

### Episode 332 - Far Out

Keep an eye on some distant far-off cells. Rather than scroll back and forth between your input cells and the the result cells, use a picture link to see those far-away cells. Episode 332 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

## Friday, September 01, 2006

### Episode 331 - Complex Printouts

What if the top section of your worksheet has column widths that don't line up with the bottom section of your worksheet? Episode 331 shows how to overcome this problem.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!