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
Post Category → Pivot Tables
Video 00019 Pivot Table: How to Group Dates
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
Learn how to exclude data from a pivot by using a report filter. Continue reading
Video 00014 Pivot Table: Extend the data range
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
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