View All Courses

Microsoft Excel 2010: Working with Multiple Workbooks

4 Lessons
19-24 Minutes
5 Quiz Questions

Course 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.

Microsoft Excel 2010: Working with Multiple Workbooks thumbnails on a slider
Microsoft Excel 2010: Working with Multiple Workbooks thumbnails on a slider
Microsoft Excel 2010: Working with Multiple Workbooks thumbnails on a slider
Microsoft Excel 2010: Working with Multiple Workbooks thumbnails on a slider

    Key Audience


    Intermediate to advanced users of Excel 2010

    Course Topics


    Working with Multiple Workbooks
    Creating a Workspace
    Consolidating Data
    Using Hyperlinks

    Workplaces


    Not Specified

    Course Detail


    Course ID
    soniewmw_vod

    Time

    19-24 Min
    Questions
    5

    Languages

    en

    video format

    HD

    captions

    No

    Resources

    No

    Lessons

    4

    Remediation

    Yes

    Bookmarking

    Yes

    Feedback

    Yes

    Microlearning

    no