Microsoft Excel Pivot Tables Online Bootcamp
Take your data analysis skills to the next level and learn pivot tables in Excel!
All courses are online and 1:1 instructor led, leading to a more dedicated learning experience for you!
Total hours: 5 hours @ $49/hr
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.
Classroom Style: Virtual - live classroom setting
Type: 1:1 training
Time (EST): One hour time slots available between M - Th 10a - 7p EST
Course 1: Data Connections + Basic Layout
- Connect data source
- Refresh options
- Create first pivot tables
Course 2: Filtering + Sorting
- Filter vs. row filter
- Top/bottom filtering
Course 3: Formatting
- Report layouts
- Report designs
Course 4: Overview
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
Ready to register? Submit an inquiry form here