iSquad

Software

Get Going With Microsoft Excel

Focusing Questions

What is a workbook?What is a worksheet?How can I work with more than one at the same time?

Instruction

Framing The Session

• Using several worksheets in the same workbook.

• Using it to work with the same data in different contexts at the same time.

• Using more than one workbook at the same time.

Teaching

• How might we use the same data to show different outcomes or relationships in a spreadsheet?

• • • • •

Workbook vs WorksheetWhat’s the Difference

Workbook vs WorksheetWhat’s the Difference

Workbook• • • • •

Worksheet• • • • •

Workbook vs WorksheetWhat’s the Difference

• Workbook contains up to 255 worksheets within the same workbook.

• Add or remove sheets from a book.

• Copy information from sheet to sheet, or book to book.

Teaching

Navigating Between Worksheets

• Ctrl + PgDn next sheet

• Ctrl + PgUp previous sheet

• Tab scrolling arrows• Click on sheet tab

Guided Practice

• Let’s list some examples of workbooks with multiple sheets.

• Let’s create one to demonstrate on the smartboard or laptop.

Teaching

Work Time

Getting Started

• You will now have 20 minutes to create two separate workbooks and swap information from one to the other.

Work Time• Step 1: Open Microsoft Excel and create spreadsheet

workbooks with the given information.• Step 2: Rename sheets in Workbook 1 and save to

My documents.• Step 3: Copy information from Sheet 1 to Sheet 2

and 3 (Click in grey cell to the left of column A to highlight entire sheet, click on sheet 2, cell A1, click Edit, paste. Click on Sheet 3, cell A1, press Enter.

• Step 4: Click on Insert in menu bar, Worksheet, to add another worksheet. Rename new sheet.

• Step 5: Transfer all information from first to second workbook

Share

• Today we learned to work with multiple workbooks and worksheets.

• Now we will look at how this skill will be effective in the classroom.

• Where else can we find out how to do different things in Excel?

Share

• Where else can we find out how to do different things in Excel?

• Help Menu

• Atomic Learning

Share

How does this work address the questions that began the session?

• Answers