Excel: Pivot Tables

Excel: Pivot Tables

from 145.00

In this Microsoft Excel 2016 Pivot Tables Training Course, students will learn how to create and manage Pivot Tables, use advanced Pivot Table strategies, create PivotCharts and more. Enroll now!

Date:
Delivery Method:
Module:
Quantity:
Purchase Now

GSA Checkout → GSA

Course ID: A1200e

Duration: 1 Day | 2 Modules (9:00 am - 4:00 pm PST)

Location: In-Person (San Francisco) or Live Online | Click here to schedule private course.

Overview:

This full-day, interactive course will take you from beginning to advanced data analysis techniques. Participants will learn how to properly organize data; analyze and summarize data quickly using data mining techniques, VLOOKUP and PivotTables; develop savvy visualizations with PivotCharts; and analyze data across multiple worksheets and data sets through PowerPivot and data modeling.”

+ Who Should Attend

Microsoft Excel (2010, 2013, 2016), ideally for PC
Mac users are welcome, but note that the Pivot Table interface varies across platforms
Basic experience with Excel functionality (charts & formulas a plus!)

+ Course Outline

Module 1: Creating and Managing Pivot Tables Pivot Tables Basics

  • Organizing Data
  • Inserting Pivot Tables
  • Data Categories
  • List Design Guidelines Data Normalizing Strategies 
  • Common Data Mining Techniques
  • Standardizing Data
  • Adding Related Data with VLOOKUP Function Managing Pivot Tables
  • Naming Pivot Tables
  • Refreshing and Changing Pivot Table Data
  • Layering Fields of Data
  • Filtering and Slicing Pivot Table Data
  • Functions and Number Formats
  • Show Details of Specific Pivot Table Results Creating Pivot Charts
  • Pivoting Data Fields
  • Basic Chart Formatting
  • Filtering and Slicing Pivot Chart Data

Module 2: Advanced Pivot Table Strategies Custom Pivot Table Design

  • Analysis Tables vs. Data Lists
  • Choosing Report Layouts
  • Using and Creating Table Styles
  • Subtotals and Grand Totals
  • Pivot Table Options
  • Calculated Fields and Items Power Pivot 
  • Data Modeling Basics
  • Adding Data to Model 
  • Creating Relationships 
  • Designing Measures 
  • Adding Custom Columns 
  • Using Basic DAX Expressions  Power Pivot Tables
  • Creating Power Pivot Tables
  • Using OLAP Tools
  • Creating Sets
  • Preview: Power Maps, Power View & Power BI

+ Prerequisites

There are no prerequisites for this course.

+ Certifications

N/A

+ More Excel Courses