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!
Prerequisite
The prerequisite for this bootcamp includes comfortable knowledge in the following topics: Vlookups, if statements, formatting, basic mathematical operations, and sumifs/countifs/averageifs.

 

 


Course Information
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
  • Slicers

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.

 

 

What's Included:
Certificate of Completion

     

Ready to register? Submit an inquiry form here 
$99.00
Out of stock