Analyze Your Data with Excel's Pivot Tables (No Formulas Required!)

Download the spreadsheet: depictdatastudio.gumroad.com/...
00:00 Welcome & Materials
03:23 Step 0: Excel Tables
09:17 Step 1: Prerequisites for Pivot Tables
12:55 Step 2: Insert a Pivot Table
16:40 Step 3: Drag and Drop!
33:58 Step 4: Refresh
In this session at Good Tech Fest with Ann K. Emery, you'll use pivot tables to analyze a dataset from start to finish.
Pivot tables are a great option for our recurring analyses, like weekly, monthly, or quarterly updates to our boss; or for annual reports to our funders.
You'll create the pivot tables you need just once, so you can save precious time and avoid having to re-do your analyses over and over again for each report deadline.
This session is interactive. The instructor will demonstrate a skill, and then you'll practice (using the sample dataset provided).
First, you'll make sure that both pivot table prerequisites have been met.
Second, you'll insert a brand new pivot table from scratch.
Third, you'll drag-and-drop variables to build a summary table (so you don't have to learn formulas like countifs and sumifs).
Finally, you'll learn some advanced nuances of pivot tables, like how to link pivot tables to charts (and even interactive dashboards) and how to make sure your pivot table keeps working even after you've updated your dataset.
Beginners, you'll have your eyes opened to the time-saving power of pivot tables. Intermediates, you'll get reassurance that you're on the right track.
Download the spreadsheet: depictdatastudio.gumroad.com/...

[@larahporter8123]

I learned PT just 6 yrs ago.... it took a while but totally worth it.

[@LuisPollon]

Is it bad that I love... spreadsheets?!

[@user-yh6ql3yh2q]

Hi, Ann. There are intermittent audio issues throughout this video. Thanks for the content!

[@AnnKEmery]

Yes, LOTS of issues unfortunately. Here's info about why inside the blog post: depictdatastudio.com/how-to-analyze-data-with-excels-pivot-tables-no-formulas-required/