Excel Database Features and PivotTables

Course Description:

  The Excel 365 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.

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

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation