Learn Excel 2010 – “Two Subtotals At Top”: Podcast #1498

Add Two sets of Subtotals at the top of each group

Learn Excel 2010 – “Add Totals”: Podcast #1447

Add totals to the bottom and right of a large Spreadsheet

Excel Rev Up – Sorting Subtotals: Podcast #1325

Show the Subtotals of greatest value at the top of your results . . .

Excel in Depth – Copying Subtotal Rows: Podcast #1264

Excel 2010: Copying only Subtotal Rows . . .

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!

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!

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!

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!

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!

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!