Microsoft Excel Pivot Tables Online Bootcamp

Take your data analysis skills to the next level and learn pivot tables in Excel!

This Bootcamp is live and instructor led
Price $49
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.

Taught by: Whitney Pettis, MBA

 


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

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.

 

 

What's Included:
Certificate of Completion

     

Refund Policy: No refunds and/or transfers

 

$49.00