Videos with tag pivot All | Novice | Advanced | Expert
Learn Excel Episode 592: Missing Pivot Dates
  • Video is free for view
  • Video is available for download

Learn Excel Episode 592: Missing Pivo...

Today’s question is a follow-up to yesterday’s question. How can you make sure that a pivot table shows you one row per day, even if there were no sales on a given day? Episode 592 show... read more »

Level: any Jul 10, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 503: Pivot Sections
  • Video is free for view
  • Video is available for download

Learn Excel Episode 503: Pivot Sections

Say that you have a pivot table with region and product in the row area. If you would like a blank row between each region, or even a page break between each region, change the Layout properties fo... read more »

Level: any Jul 08, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 377: GetPivotData Function
  • Video is free for view
  • Video is available for download

Learn Excel Episode 377: GetPivotData...

In Excel 2002+, try to create a formula next to your pivot table. When you copy this formula down to other cells, the formula keeps pointing at the original cells! Is this a bug? No, it's a feature... read more »

Level: any Jul 04, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 294: Pivot Charts
  • Video is free for view

Learn Excel Episode 294: Pivot Charts

Posted in Microsoft, Screencasts...

Instead of creating Pivot Tables, create your summary as a flexible chart. Episode 294 shows you how to create a pivot chart. read more »

Level: any Jul 01, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 292: Calculated Pivot Field
  • Video is free for view

Learn Excel Episode 292: Calculated P...

Posted in Microsoft, Screencasts...

Add a calculated field to a pivot table. Episode 292 shows you how. read more »

Level: any Jul 01, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 291: Show Pages
  • Video is free for view

Learn Excel Episode 291: Show Pages

Posted in Microsoft, Screencasts...

Szilvia from California calls in today with a great question.... How could I have written an entire book on pivot tables and never mentioned the Show Pages feature? We will try it out on today's po... read more »

Level: any Jul 01, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 290: Comparing Lists
  • Video is free for view

Learn Excel Episode 290: Comparing Lists

Posted in Microsoft, Screencasts...

I use this trick all of the time. Say that you have two versions of a list. You have the current version and an old version. You want to see what changed between the two versions. Rather than try t... read more »

Level: any Jul 01, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 288: No Pivot Totals
  • Video is free for view

Learn Excel Episode 288: No Pivot Totals

Posted in Microsoft, Screencasts...

Sometimes you need to take the results of your pivot table to another system. There are a few problems with the default outline view of a pivot table. First - the subtotal rows can get in the way, ... read more »

Level: any Jul 01, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 285: Formatting Pivots
  • Video is free for view

Learn Excel Episode 285: Formatting P...

Posted in Microsoft, Screencasts...

While pivot tables are incredibly powerful, they generally look absolutely horrible. Rather than continuously formatting the pivot table after every change, you can use the Pivot Table AutoFormats ... read more »

Level: any Jul 01, 2008 Votes: 0 Dmytro Shteflyuk

 
Learn Excel Episode 284: Order Leadtime Report
  • Video is free for view

Learn Excel Episode 284: Order Leadti...

Posted in Microsoft, Screencasts...

If you are trying to plan inventory in the warehouse or material scheduling at the manufacturing plant, you will want to create an order leadtime report. Episode 284 shows how to use a pivot table ... read more »

Level: any Jul 01, 2008 Votes: 0 Dmytro Shteflyuk