Discover Classes. Earn Rewards.

Excel Database Features & PivotTables (365/2019/2016)

at ONLC Training Centers - Schaumburg

Course Details
$295 1 seat left
Start Date:

Thu, Oct 03, 9:00am - 3:45pm

Next start dates (1)

Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
All classes are live, hands-on training via remote instructor
Purchase Options
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment, it is best to register for this class at least three weeks in advance.

Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables.

Target Student

The course is for individuals who are responsible managing data and creating PivotTables in Excel.

Excel 2013 or 2016 Introduction or equivalent skills.

Course Outline

Using Lists
  • Using AutoFill
  • Using AutoComplete
  • Using Data Validation
  • Inserting and Deleting Rows & Columns
  • Freezing Panes
  • Using Statistical Functions
Using Table Features
  • Creating a Table
  • Formatting the Table
  • Sorting a Table
  • Filtering a Table
  • Creating a Slicer
  • Working with the Table Row
  • Creating a Calculated Column
Working with Data
  • Importing Data from a Text File
  • Exporting Data
  • Converting Text to Columns
  • Using Text Functions
  • Using Flash Fill
  • Connecting to Data in an Access Database
  • Creating a Web Query
  • Importing Web Data using a Saved Query
  • Working with Hypertext Links
Creating and Working with PivotTables
  • Understanding PivotTables
  • Working with Recommended PivotTables
  • Creating a PivotTable using Worksheet Data
  • Creating a PivotTable using an External Data Connections
  • Laying out a PivotTable on a Worksheet
  • Modifying PivotTable Fields
  • Using a Report Filter
  • Refreshing a PivotTable
  • Formatting a PivotTable
Enhancing PivotTables
  • Working with Summary Functions
  • Sorting Items in a PivotTable
  • Creating a Slicer
  • Grouping Data
  • Using a Timeline
  • Applying Label and Value Filters
  • Creating a Calculated Field
  • Creating a Calculated Item
  • Creating Charts from PivotTables

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.


Google Map

ONLC Training Centers

All classes at this location

Start Dates (2)
Start Date Time Teacher # Sessions Price
9:00am - 3:45pm ONLC Remote Instructor 1 $295
9:00am - 3:45pm ONLC Remote Instructor 1 $295

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

Similar Classes

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Ready to take this class?
Taking this class for work? Get exclusive perks & discounts for free.