My Spreadsheet Lab

The site is about Microsoft Excel.

  • Home
  • Templates
  • Excel Blog
  • About Me
  • Contact Kevin

Post Category → Pivot Tables

00127 All Combinations No Formulas No VBA

posted in Pivot Tables on November 24, 2015 by Kevin Lehrbass 4 Comments

This was weird. I stumbled across my video and I thought “WHAT? Get all text combinations using just a pivot? How did I do that?” It seemed like ‘Back To The Future’ as I re-watched my own video. Continue reading →

Video 00019 Pivot Table: How to Group Dates

posted in Pivot Tables on April 7, 2013 by Kevin Lehrbass 0 Comments

Learn how to group a column of dates by Year & Month and sum another field.

Excel’s pivot table ‘Group’ feature only takes a few clicks of the mouse and can save so much time! Continue reading →

Video 00015 Pivot Table: How to use a PIVOT FILTER

posted in Pivot Tables on April 7, 2013 by Kevin Lehrbass 0 Comments

Learn how to exclude data from a pivot by using a report filter. Continue reading →

Video 00014 Pivot Table: Extend the data range

posted in Pivot Tables on April 6, 2013 by Kevin Lehrbass 0 Comments

If you’ve created a pivot table and later added more data then you’ll need to expand the pivot’s data range.  Continue reading →

Video 00013 Pivot Table: Introduction

posted in Pivot Tables on February 18, 2013 by Kevin Lehrbass 0 Comments

If you work with data in Microsoft Excel then you have to learn about Pivot Tables!

Learning Pivot Tables will change the way you work with Excel! Continue reading →