In-person, instructor-led class open to the public at TriHealth's Norwood location.  If you are a TriHealth Employee, or a friend or family member of a TriHealth Employee, please remember to use the company's discount code at checkout to ensure you are charged the discounted rate.


Training material for use in class will be provided.  By selecting the option listed, you may purchase a hardcopy of the training manual to take home ($25) which includeds an online Learning Locker with the following: digital copies of the training courseware, pre-post assessment, re-training videos, quick reference guides, on-call training support and much more! (Purchasing the materials after the class session will result in an additional $10 charge.)

Address: 4750 Wesley Ave, 1B Education Center, Norwood, OH 45212.


Course Length: 1 day, 8:30 AM to 4:30 PM


Target Student: This course is designed for individuals who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.


Course Description

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

You will:

* Work with functions

* Work with lists

* Analyze data

* Organize and analyze datasets and tables.

* Visualize data with charts.

* Use PivotTables and PivotCharts


Course Content

Lesson 1: Working with Functions 

Topic A: Work with Ranges 

Topic B: Use Specialized Functions 

Topic C: Work with Logical Functions

Topic D: Work with Date & Time Functions

Topic E: Work with text Functions


Lesson 2: Working with Lists 

Topic A: Sort Data

Topic B: Filter Data

Topic C: Query Data with Database Functions

Topic D: Outline and Subtotal Data 


Lesson 3: Analyzing Data

Topic A: Create and Modify Tables 

Topic B: Apply Intermediate Conditional Formatting 

Topic C: Apply Advanced Conditional Formatting 


Lesson 4: Visualizing Data with Charts 

Topic A: Create Charts 

Topic B: Modify and Format Charts 

Topic C: Use Advanced Chart Features 


Lesson 5: Using PivotTables, and PivotCharts 

Topic A: Create a PivotTable 

Topic B: Analyze PivotTable Data 

Topic C: Present Data with PivotCharts

Topic D: Filter Data by Using Timelines and Slicers 


Excel 2016 Level 2 (TriHealth)

Class Dates
Purchase hardcopy training material?
What version of MS Office are you using?