New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

Excel - Level 3 On-Site Training

This on-site training class is also available as Public Schedule Seminar.

In this course students 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.

Course Description/Agenda


Duration
Classroom Learning - 1 Day(s)
Online LIVE - 1 Sessions

Overview
The students will learn to 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.

Who Should Attend
This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Prerequisite(s) or equivalent knowledge
Excel 2010 - Level 1
Excel 2010 - Level 2

Prerequisite Comments
Students enrolling in this class should have experience working in Excel, creating, editing, and managing workbooks.

Outline
Lesson 1: Streamlining Workflow
Update Workbook Properties
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Lesson 2: Collaborating with Other Users
Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signatures
Restrict Document Access
Lesson 3: Auditing Worksheets
Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Lesson 4: Analyzing Data
Create a Trendline
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPak
Lesson 5: Working with Multiple Workbooks
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links
Lesson 6: Importing and Exporting Data
Export Excel Data
Import a Delimited Text File
Import and Export XML Data
Lesson 7: Integrating Excel Data with the Web
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

 On-Site Training On-Site Training

Also Available As

 Seminar Seminar

  		Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!