Microsoft® Excel® 2010: Level 3
< Back to Course Catalog
Duration:
1 Day (6.5 instructional hours)
Excel 2010
CourseNumber:084678S3
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.
TargetStudent:
This course is meant for those desiring to gain skills necessary to create macros,collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Prerequisites:
To ensure success, students will need to be familiar with using personal computers and should have experience with Microsoft Office Excel 2010: Level 1 (Second Edition) and Microsoft Office Excel 2010: Level 2 (Second Edition).
Course Outline
Lesson 1: Streamlining Workflow
Topic A: Updated Workbook Properties
Topic B: Create a Macro
Topic C: Edit a Macro
Topic D: Apply Conditional Formatting
Topic E: Add Data Validation Criteria
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: Administrator Digital Signatures
Topic G: Restrict Document Access
Lesson 3: Auditing Worksheets
Topic B: Troubleshoot Invalid Data and Formula Errors
Topic C: Watch and Evaluate Formulas
Topic D: Create a Data List Outline
Lesson 4: Analyzing Data
Topic A: Create a Trendline
Topic B: Create Sparklines
Topic C: Create Scenarios
Topic D: Perform a What-If Analysis
Topic E: Perform a Statistical Analysis with the Analysis Tool Pak
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
Lesson6: Importing and Exporting Data
Topic A: Export Excel Data
Topic B: Import a Delimited Text File
Topic C:Import and Export XML Data
Topic B:Troubleshoot Invalid Data and Formula Errors
Topic D: Watch and Evaluate Formulas
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
Ready for training on other Microsoft Office products? ContactExcelHelpat(800)682-0882orvisitusonlineatwww.ExcelHelp.com