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


Course Description:

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel

data with other applications.


You will:

* Create macros

* Collaborate with others

* Audit and analyze worksheet data

* Incorporate multiple data sources

* Import and export data



Course Content

Lesson 1: Streamlining Workflow

Topic A: Update Workbook Properties

Topic B: Create a Macro

Topic C: Edit a Macro

Topic D: Apply Conditional Formatting

Topic E: Add Data Validation


Lesson 2: Collaborating with Other Users

Topic A: Protect Files

Topic B: Share a Workbook

Topic C: Set Revision Tracking

Topic D: Review Tracked Revisions

Topic E: Merge Workbooks

Topic F: Administer Digital Signatures

Topic G: Restrict Document Access


Lesson 3: Auditing Worksheets

Topic A: Trace Cells

Topic B: Troubleshoot Invalid Data and Formula Errors

Topic C: Watch and Evaluate Formulas

Topic D: Create a Data List


Lesson 4: Analyzing Data

Topic A: Create Trendlines

Topic B: Create Sparklines

Topic C: Create Scenarios

Topic D: Perform a What-If Analysis

Topic E: Perform a Statistical Analysis with the Analysis Toolpack


Lesson 5: Working with Multiple Workbooks

Topic A: Create a Workspace

Topic B: Consolidate Data

Topic C: Link Cells in Different Workbooks

Topic D: Edit Links


Lesson 6: Importing and Exporting Data

Topic A: Export Excel Data

Topic B: Import a Delimited Text File


Lesson 7: Integrating Excel Data with the Web

Topic A: Publish a Worksheet to the Web

Topic B: Import Data from the Web

Topic C: Create a Web Query


Lesson 8: Structuring Workbooks with XML

Topic A: Develop XML Maps

Topic B: Import and Export XML Data



Excel 2010 Level 3 (TriHealth)

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