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

 

 

Excel 2010 Level 2 (TriHealth)

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