Excel 2010 Level 3
CLASS DATE(s):
Request a Class

COURSE LENGTH: 1 Day

COURSE COST: $295

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

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.

Certification: MOS: Microsoft Office Excel 2010 Exam 77-882, MOS: Microsoft Office Excel 2010 Expert Exam 77-888

Course Objectives:
Upon successful completion of this course, students will be able to:
*Enhance productivity and efficiency by streamlining the workflow.
*Collaborate with other workbook users.
*Audit worksheets.
*Analyze data.
*Work with multiple workbooks.
*Import and export data.
*Integrate Excel data with the web.

AUDIENCE AND PREREQUISITES

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 COURSESFOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware. Course to run is subject to a minimum enrollment. For questions, please contact: learn@vtec.org or call: 207-775-0244.

COURSE TOPICS:


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