Week 5 - Consolidating and Linking Data and Inserting Object (Ch5)

Overview

When multiple worksheets have identical layouts and labels, you can summarize data with the Consolidate command. You can also link to data in a different workbook to build a formula or display information. In this chapter, you will learn how to consolidate data from multiple sheets in the same workbook and how to link multiple workbooks with an external reference formula. You will also insert SmartArt graphics, illustrations, and hyperlinks in a worksheet.

Objectives

At the end of this week, you will be able to:

• Create a static data consolidation.
• Create a dynamic data consolidation.
• Consolidate data by category.
• Group worksheets for editing and formatting.
• Link workbooks to consolidate data.
• Insert illustrations using SmartArt, screenshots, and pictures in a worksheet.
• Insert hyperlinks in a worksheet.
• Safeguard work by marking it as final or by setting a password.

Learning Activities

1. Read Ch 5 (SIMBook) in SIMnet.
2. Complete the end-of-chapter questions to check your knowledge (you are not required to submit these).

Assignments

1. Complete Excel Ch 5 SIMBook 'Let Me Try' in-reading tasks.
2. Complete Excel Ch 5 SIMnet Project 1.
3. Complete Excel Ch 5 SIMnet Project 2.