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

## Monday, April 27, 2009

### MrExcel's Learn Excel #1001 - Horizontal Subtotals 2

Several people wrote in with a 15-second method to add horizontal subtotals - much faster than the method that Mike and Bill discussed in episode 990. Episode 1001 shows you how to add horizontal subtotals.

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!

Labels:

## Friday, April 10, 2009

### MrExcel's Learn Excel #990 - Dueling: Horizontal Subtotals

Mike from ExcelIsFun throws down this week's challenge: adding horizontal subtotals. Bill and Mike duel it out in Episode 990.

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!

Labels:

## Monday, October 06, 2008

### Episode 861 - Subtotal Anomolies

The subtotal command is a fantastic time-saver, but it occasionally behaves erratically. In Episode 861, I will show two situations which can cause the subtotal command to whack out.

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!

Labels:

## Thursday, July 10, 2008

### Episode 799 - Quick Hide/Unhide

Travis has a spreadsheet where you can quickly hide and unhide detail rows using the tiny "1" and "2" buttons. In Episode 799, I will show how to add these Group and Outline symbols to your worksheet.

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!

Labels: ,

## Tuesday, July 01, 2008

### Episode 792 - Substitute Total

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!

Labels: ,

## Tuesday, May 20, 2008

### Episode 762 - Chart Top Customers

A combination of six cool tricks allow you to take detailed transactional data and produce a chart of the top five customers in about 12 clicks. Episode 762 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!

Labels: , ,

## Monday, April 07, 2008

### Episode 731 - Copying Subtotals Only

Kerry asks: after adding automatic subtotals, how can you copy only the subtotal rows? Episode 731 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!

Labels: ,

## Wednesday, May 23, 2007

### Episode 514 - Subtotals Count

Why does the automatic subtotals command sometimes choose to Sum and sometimes choose to Count? Episode 514 shows you why Excel seems to arbitrarily count or sum.

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, May 07, 2007

### Episode 502 - Color Pivot

There is a cool but subtle way to select all of the subtotal rows in your pivot table in order to format them with a different color. Episode 502 shows you how. This tip came from an audience member at the 33rd annual Meonske Accounting Conference at Kent State. Thanks to Dr. Norm for inviting me back as a speaker at this excellent conference.

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, November 03, 2006

### Episode 376 - Select Visible Cells

When you have created automatic subtotals and want to format the subtotals rows, you will probably be visiting the Edit - Goto - Special - Visible Cells only setting. However, by customizing your toolbar, you can select the subtotals using a single button click. Episode 376 shows you how. Also - see how to move buttons on a toolbar without displaying the customize dialog.

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 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: ,