Excel: Getting started with PivotTables
Vložit
- čas přidán 30. 07. 2024
- 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 CZcams 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
○ CZcams 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! - Zábava
You are so good and thorough! Unlike many other CZcamsrs/ tutors! Keep up the good work!
Thanks, will do!
@@ChrisMenardTraining can you also please teach Power BI? We could use someone like you.
fantastic
Thanks
Thank you for your help Chris. Your clear easy to understand walk through helped me, I appreciate you time to make this , thank you.
You're very welcome!
loved it. please given the file in the description...
The link to get the file is in the description now.
Chris - love you videos and pace. appreciate it, was wondering if you are able to help with PIVOT and ability to cleanly show data as annual gain, and XIRR function and total gain for each equity buy and sell source data. I am desperately seeking help to tell you truth. I hope you can provide help even for fees.
I would like to add up receipts monthly. How do I do this?
something like the attached should work drive.google.com/file/d/1m5mRYoJPl7fh0gQDuWcrqd9PNEkBz6NZ/view?usp=drivesdk