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 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?