David Casuto

9:45 am - PivotTables, PivotCharts & Subtotals

David Casuto

\$00

\$00
Sale Ends Soon!

starting under

\$13/month*

Unlock this classplus 2200+ more >

Lesson Info

20. 9:45 am - PivotTables, PivotCharts & Subtotals

Lesson Info

9:45 am - PivotTables, PivotCharts & Subtotals

So we're going to move away from tables now, and we're going to go into the tables, all right? So let's, go to pivot tables and have fun with that, so we're going to jump back over to the pc side, and we're going to go into pivot table and sub total was going open that up, and we're going to be working with the same broad data to be able to do our pivot table and our sub total. So basically, we have all this all this data here, and then we're also going to be working with a separate sheet that's going to appear, once we create our own, our pivot table, and then we come back, we're going to do our sub totals on this, all right? So let's, talk about what a pivot table is, in fact, why you'd want to use a pivot table, the pivot tables are essentially designed for you to be able to do complex type of statistical analysis on it without actually being a statistical math wizard. So basically, you're wanted looking for themes, right? You're looking for things that are going, you wantto kind of...

Class Materials

bonus material with purchase

Exercises 1
Exercises 2
Exercises 3
Beyond the Basics (PC-Mac)
Mac Quick Reference-Custom Guide
Mac Booklet Part 1
Mac Booklet Part 2
PC Quick Reference-Custom Guide
PC Booklet
Pivot Tables (PC-Mac)
Mac Shortcut Keys
Windows Shortcut Keys

Ratings and Reviews

Arlene Baratta

Even though it's 2021, this course is still amazing. I followed along just fine using the latest version (365). I watched thinking it was just going to be another "basic" overview of Excel. It's not. I learned a lot that could really help me keep track of my business, not just financial aspects either. I HIGHLY recommend this course.

a Creativelive Student

Great class and highly recommended but now out of date. Surely an update is planned?

Przemek Janus

This is Excel for Mac. I think real Excel work is done in Excel for PC as that version offer much more compared to Mac version. Apart from that shortcuts are quite different between versions. Just a note.