Microsoft Office Excel 2010 Course Advanced Training

Excel 2010 - Level 3

Class Schedule 05/23/12 - 05/23/12 Info/Enroll 06/20/12 - 06/20/12 Info/Enroll 08/01/12 - 08/01/12 Info/Enroll 08/29/12 - 08/29/12 Info/Enroll

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

MCSEClasses.com is your best choice for Excel 2010 Advanced, Excel 2010 Advanced training, Excel 2010 Advanced certification, Excel 2010 Advanced certification boot camp, Excel 2010 Advanced boot camp, Excel 2010 Advanced certification training, Excel 2010 Advanced boot camp training, Excel 2010 Advanced boot camp certification, Excel 2010 Advanced certification course, Excel 2010 Advanced course, training Excel 2010 Advanced, certification Excel 2010 Advanced, boot camp Excel 2010 Advanced, certification Excel 2010 Advanced boot camp, certification Excel 2010 Advanced training, boot camp Excel 2010 Advanced training, certification Excel 2010 Advanced course.

mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us