Take your data analysis skills to the next level and learn pivot tables in Excel!
This Bootcamp is live and instructor led
Why do I need to learn about pivot tables ?!?
Pivot tables allow you to take data from lots and lots of rows and consolidate the data into a compact, digestible report. Need to measure your data with key metrics? Need to find key info from your data? If the answers to these questions are both YES! , then you NEED pivot tables in your life! Pivot tables are simply created from just dragging and dropping, no formulas needed!
The prerequisite for this bootcamp includes comfortable knowledge in the following topics: Vlookups, if statements, formatting, basic mathematical operations, and sumifs/countifs/averageifs.
Taught by: Whitney Pettis, MBA
Course Dates: January 24th - January 27th
Days of the week: Monday - Thursday
Time (EST): 800p - 930p EST
Course 1: Data Connections + Basic Layout
Monday, January 24th | 8:00p - 9:30p
- Connect data source
- Refresh options
- Create first pivot tables
Course 2: Filtering + Sorting
Tuesday, January 25th | 8:00p - 9:30p
- Filter vs. row filter
- Top/bottom filtering
Course 3: Formatting
Wednesday, January 26th | 8:00p - 9:30p
- Report layouts
- Report designs
Course 4: Overview
Thursday, January 27th | 8:00p - 9:30p
Microsoft Excel 2013 or newer required for PC and Mac Laptops
Course materials (including installation guides), access codes, and reminders will be sent 7 days prior to the start of the first course of the Bootcamp.
Certificate of Completion
Refund Policy: No refunds and/or transfers