Рет қаралды 1,515
Before creating a PivotTable, there are three rules you should follow. Two are a must. Rule #1: no blank rows or columns in your data. Rule #2: make sure your data is tabular. Rule # 3: make your data range a Table. I have a free course on Excel Tables located here that I created for the Georgia Society of CPAs (GSCPA). chrismenardtraining.teachable...
In this video, we discuss the three rules and then make a PivotTable. We then show totals for months and car brands in the PivotTable and finally, we find a running total and then the difference.
Excel File you can download and follow along:
chrismenardtraining.com/Files...
Chapters:
0:00 Intro
1:12 tabular format
2:35 no blank columns/rows
3:30 create a table
6:55 create a pivottable
9:45 subtotal in pivottable
10:20 Running total
13:12 Difference
Links to websites:
Chris Menard's website: chrismenardtraining.com
Zoom Resource Center: chrismenardtraining.com/zoom
Cristian's KZbin Channel: / @graphicious
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZbin keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!