Multiple Sheet Referencing

Introduction:

Excel workbooks are designed to store lots of information in worksheets. Combining worksheets from different workbooks allows the user to reutilize data and can be done through moving or copying the worksheet to a new or existing workbook. Likewise, when a worksheet becomes cumbersome, data can be broken out into smaller subsets and placed in separate worksheets within the same, new, or other existing Excel files. Separating or combining spreadsheet data can lead to better data organization within a file and increase its ease of use.

Course Competencies:

1. Understand and describe what Excel is and how it is used to work with quantitative data
2. Design, construct, format, and edit workbooks and worksheets for professional use
3. Create and apply formulas and functions to calculate data using appropriate mathematical principles
4. Construct and design charts and tables to effectively visualize and manipulate data
5. Identify and assess the suitable printing and presentation of workbooks and worksheets
6. Utilize data analysis in determining the best possible outcomes of business-related decisions

Learning Objectives:

Each Outcome shows in parenthesis which Course Competency it aligns with.

1. Construct a workbook by copying and moving worksheets from one workbook to another (2)
2. Group worksheets and demonstrate the application of editing and formatting cells and data to multiple worksheets simultaneously (3)
3. Utilize relative, absolute, and 3-D cell references in combination to create complex mathematical formulas in grouped worksheets (4)
4. Evaluate and determine the appropriate formatting edits for print preparation (5)

To-Do List:

1. Week 5 KnowledgePath
2. Week 5 Learning Materials
3. Week 5 Discussion
4. Course lab project – Exercise 5

Sources:

Image attribution: Adapted from How to Use Microsoft Excel: The Careers in Practice Series, adapted by The Saylor Foundation without attribution as requested by the work’s original creator or licensee, and licensed under CC BY-NC-SA 3.0.