Microsoft® Excel® 2013: Level 3

1 Day (6.5 instructional hours)

Excel 2013
Course Number: 091053

Course Objective:
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.
Target Student:
This course is intended for students who are experienced Excel 2013 users and have a desire or need to advanced their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Course Objective: To ensure success, students will need to be familiar with or have the equivalent knowledge and experience of Microsoft® Office Excel® 2013: Part 1 (Second Edition) and Microsoft® Office Excel® 2013: Part 2 (Second Edition).

Course Outline
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Topic A: Use 3-D References

Topic B: Use Links and External References

Topic C: Consolidate Data
Lesson 2: Sharing and Protecting Workbooks
Topic A: Collaborate on a Workbook

Topic B: Protect Worksheets and Workbooks
Lesson 3: Automating Workbook Functionality
Topic A: Apply Data Validation

Topic B: Work with Forms and Controls Topic C: Work with Macros
Lesson 4: Applying Conditional Logic
Topic A: Use Lookup Functions

Topic B: Combine Functions

Topic C: Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
Topic A: Trace Cells

Topic B: Search for Invalid Data and Formulas with Errors

Topic C: Watch and Evaluate Formulas
Lesson 6: Using Automated Analysis Tools
Topic A: Determine Potential Outcomes Using Data Tables

Topic B: Determine Potential Outcomes Using Scenarios

Topic C: Use the Goal Seek Feature

Topic D: Activate and Use the Solver Tool

Topic E: Analyze Data with Analysis Tool Pak Tools
Lesson 7: Presenting Your Data Visually
Topic A: Use Advanced Chart Features

Topic B: Create Sparklines

Ready for training on other Microsoft Office products? Contact ExcelHelp at (800) 682-0882 or visit us online at www.ExcelHelp.com