Episode 826 - Data in Headers

It is frustrating when section headers contain data that applies to all records in that section. You really want to get that header data down onto every row in the section. Episode 826 shows you one method for doing this.

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!

Episode 493 - Non-Pivotable Data

In just about every pivot table tutorial, the writer tells you to start with a nice clean transactional data set. No blank rows, no blank columns, and no months going across the columns. David from Pennsylvania writes in to ask what to do if your dataset already is in a table – with headings in the rows and columns. In Episode 493 I borrow a trick from Mike Alexander to solve this problem and make your dataset appropriate for use in a pivot table.

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!

Episode 375 - Ad-hoc Reporting

Today's netcast talks about an easy-to-create reporting tool - one that allows you to show the totals for any subset of a dataset. Watch Episode 375 for the complete details.

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!