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
 
Course Objectives
Upon successful completion of this course, students will be able to:
* Use advanced formulas.
* Organize worksheet and table data using various techniques.
* Create and modify charts.
* Analyze data using PivotTables, Slicers, and PivotCharts.
* Insert and modify graphic objects in a worksheet.
* Customize and enhance workbooks and the Microsoft Office Excel environment.
 
Course Content
Lesson 1: Calculating Data with Advanced Formulas
Topic 1A: Apply Cell and Range Names
Topic 1B: Calculate Data Across Worksheets
Topic 1C: Use Specialized Functions
Topic 1D: Analyze Data with Logical and Lookup Functions
 
Lesson 2: Organizing Worksheet and Table Data
Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort or Filter Data
Topic 2D: Use Functions to Calculate Data
 
Lesson 3: Presenting Data Using Charts
Topic 3A: Create a Chart
Topic 3B: Modify Charts
Topic 3C: Format Charts
 
Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
Topic 4A: Create a PivotTable Report
Topic 4B: Filter Data Using Slicers
Topic 4C: Analyze Data Using PivotCharts
 
Lesson 5: Inserting Graphic Objects
Topic 5A: Insert and Modify Pictures and ClipArt
Topic 5B: Draw and Modify Shapes
Topic 5C: Illustrate Workflow Using SmartArt Graphics
Topic 5D: Layer and Group Graphic Objects
 
Lesson 6: Customizing and Enhancing the Excel Environment
Topic 6A: Customize the Excel Environment
Topic 6B: Customize Workbooks
Topic 6C: Manage Themes
Topic 6D: Create and Use Templates