Includes a hard-copy book and access to an online Learning Locker (ebook). If you have taken the respective ProMark class within the past 3 months, you will also receive 90 days of on-call training support for that class. (Please add your class date in either of the text fields below.)


Price includes shipping and handling.

In-person, instructor-led class open to the public at TriHealth's Norwood location. Electronic training material will be provided. You may purchase a hardcopy training manual to take home ($25) by selecting the option listed. Marking in or damaging classroom-use training material will result in a charge. Class will be cancelled 2 business in advance if a minimum # of students is not reached.


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


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 (course material only)