Microsoft Office Excel 2010 Course Advanced Training

"Very knowledgeable - lots of energy and patience.  Kept the class on track - Excellent instructor!"

-Barbara Conover

Get your Training Quote

• May 23 - May 23, 2012
• Jun 20 - Jun 20, 2012
• Aug 01 - Aug 01, 2012
• Aug 29 - Aug 29, 2012

Can't travel or you want to stay with your family or business. No problem! Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.

Remote Classroom Training

Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

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.

Course Content

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 and Sharing 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 Trendlines, Sparklines, and 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

Lesson 7: Integrating Excel Data with the Web

• Publish a Worksheet to the Web
• Import Data from the Web
• Create a Web Query

Lesson 8: Structuring Workbooks with XML

CED Solutions is your best choice for Excel 2010 Advanced , Excel 2010 Advanced training, Excel 2010 Advanced certification, Excel 2010 Advanced boot camp, Excel 2010 Advanced certification training, Excel 2010 Advanced certification course, Excel 2010 Advanced course, Excel 2010 Advanced class.