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)

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