Building Amazing Organizations
Got Questions? 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, discover ways to save time using Excel 2010 by linking data together to create a workspace. Within your workspace, learn how to consolidate data, link data from different workbooks and be able to edit the links.

Discover ways to increase efficiency, by summarizing data from multiple workbooks into one location and learning how to combine portions of lists or tables together into one consolidated table. From there, save the workbook into your own unique workspace so you can view and manipulate data to best fit your needs. Finally, learn to create hyperlinks within your workspace. Save valuable time by using hyperlinks within your spreadsheet to link to existing data in another workbook or even to external documents and websites.

This Video On Demand training expands the skill set of standard spreadsheet users and gives them the ability to do more with the simple data entered in a spreadsheet. This course provides the foundation to now analyze data in various spreadsheets and link them together. All of these skills put you well on your way to becoming an Excel expert!

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

Intermediate to advanced users of Excel 2010

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

© Mastery Technologies, Inc.