Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Improve your skills while working at home
Online Training options available for all of our courses
Live-Instructor - Online Group Training - On-Demand


Excel Database Features and PivotTables (365/2019/2016) Training Course

Excel Database Features and PivotTables (365/2019/2016) Training Course


Course Description:  The Excel 2019 Database Functions and PivotTables course focuses on managing data and creating PivotTables in Excel. This class will cover the following topics: Using Lists, Formatting a Table, Creating a Slicer, Importing Data from a Text File, Using Database Functions, Creating and Working with PivotTables, Using a Timeline, and Creating a Calculated Field. This class is fitting for students who have a background in either Excel 2019 or 2016 Introduction skills.

Training Dates
(Click on the course name below to view course details and full list of class dates)

Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/15/2020 - 7/15/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/17/2020 - 7/17/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/20/2020 - 7/20/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/23/2020 - 7/23/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/28/2020 - 7/28/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 7/31/2020 - 7/31/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/3/2020 - 8/3/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/5/2020 - 8/5/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/11/2020 - 8/11/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/13/2020 - 8/13/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/19/2020 - 8/19/2020
Course Fee : $299


Excel Database Features and PivotTables (365/2019/2016)
Locations: Available Nationwide and Online
Class Date(s): 8/21/2020 - 8/21/2020
Course Fee : $299


Course Syllabus

Course Outline

Working with Lists
Working with AutoFill
Working with AutoComplete
Working with Data Validation
Inserting and Deleting Rows & Columns
Freezing Panes
Working with Statistical Functions

Working with Table Features
Create a Table
Formatting the Table
Sorting a Table
Filtering a Table
Create a Slicer
Working with the Table Row
Create a Calculated Column

Working with Data
Importing Data from a Text File
Exporting Data
Converting Text to Columns
Working with Text Functions
Working with Flash Fill
Connecting to Data in an Access Database
Create a Web Query
Importing Web Data using a Saved Query
Working with Hypertext Links

Analyzing Data
Working with Automatic Outlining
Grouping Data
Inserting Subtotals
Create an Advanced Filter
Working with Database Functions
Working with the Quick Analysis Tool

Create and Working with PivotTables
Understanding PivotTables
Working with Recommended PivotTables
Create a PivotTable using Worksheet Data
Create a PivotTable using an External Data Connections
Laying out a PivotTable on a Worksheet
Modifying PivotTable Fields
Working with a Report Filter
Refreshing a PivotTable
Formatting a PivotTable

Enhancing PivotTables
Working with Summary Functions
Sorting Items in a PivotTable
Create a Slicer
Grouping Data
Working with a Timeline
Applying Label and Value Filters
Create a Calculated Field
Create a Calculated Item
Create Charts from PivotTables

Onsite excel Training
Small Group Package (up to 6 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 6 students can attend the class for the flat rate course price of $1800/day
  • Additional students can be added for $125/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 6 students: $1800/day (Flat Rate)

Medium Group Package (up to 12 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 12 students can attend the class for the flat rate course price of $2500/day (over 31% off our Individual Training rates)
  • Additional students can be added for $100/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 12 students: $2500/day (Flat Rate)

Large Group Package (up to 18 students)
  • A Professional Instructor will come to your office and train your students
  • Up to 18 students can attend the class for the flat rate course price of $3100 (over 43% off our Individual Training rates)
  • Additional students can be added for $75/person/day
  • Each student receives a Course Manual with Practice Files (Materials will be shipped before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 2-weeks lead time to arrange a training session
  • Training is completed in a convenient 1-day session (Start at 9am and Finish at 4:30pm)
  • Two 15 minute breaks and one hour long break for lunch

Total Cost for 18 students: $3100/day (Flat Rate)




Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Business Computer Skills BBB Profile