Microsoft® Excel® 2013: Level 3
< Back to Course Catalog
Duration:
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
