COURSE MATERIAL ONLY
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
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