Online Training | 800‑258‑3837
Back to Course List

Microsoft Excel 2010: Working with Multiple Workbooks

Preview video
Preview Video
Product ID
soniewmw_vod
Training Time ?
19 to 24 minutes
Language(s)
English
Video Format
High Definition
Required Plugins
None
Number of Lessons
4
Quiz Questions
5
Question Feedback
Wrong Answer Remediation
Lesson Bookmarking
Downloadable Resources
Course screen Course screen Course screen
Overview

In this course, learners are taught how to create and utilize the Workspace features in Excel. Easy to follow instruction is provided on how to combine data from separate worksheets or workbooks together to create one workspace. Learn how to link and consolidate data whether working with one large spreadsheet or multiple tables.

This online video training demonstrates how to consolidate data, link cells in different workbooks, edit the links and summarize data from multiple workbooks into one location. Finally, understand how to insert hyperlinks directly into a spreadsheet. Hyperlinks are used in Excel to link data from within a spreadsheet, link to an existing file, or even link to an external document.

A quiz is included at the conclusion of the training module to ensure learners understand the skills taught. Utilizing the workspace feature is taking basic spreadsheet knowledge to the next level. Use this online training and become a more efficient Excel user.

Video on Demand   This course is in the Video On Demand format, to read about Video On Demand features click here.

  • Install on any SCORM LMS
  • Full-screen video presentation
  • Print certificate and wallet card
  • You have 30 days to complete the course
Audience

Those looking to expand their skill level regarding data analysis and Excel 2010

Topics
The course presents the following topical areas:
  • Working with Multiple Workbooks
  • Creating a Workspace
  • Consolidating Data
  • Using Hyperlinks

© Mastery Technologies, Inc.