1 / 18

Get Going With Microsoft Excel

Get Going With Microsoft Excel. iSquad Software. 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.

tyrell
Download Presentation

Get Going With Microsoft Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Get Going With Microsoft Excel iSquad Software

  2. Focusing Questions • What is a workbook? • What is a worksheet? • How can I work with more than one at the same time?

  3. Instruction

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

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

  6. Workbook vs WorksheetWhat’s the Difference

  7. Workbook Worksheet Workbook vs WorksheetWhat’s the Difference

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

  9. Teaching Navigating Between Worksheets • Ctrl + PgDn next sheet • Ctrl + PgUp previous sheet • Tab scrolling arrows • Click on sheet tab

  10. Guided Practice • Let’s list some examples of workbooks with multiple sheets. • Let’s create one to demonstrate on the smartboard or laptop.

  11. Teaching

  12. Work Time

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

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

  15. Share

  16. 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?

  17. Share • Where else can we find out how to do different things in Excel? • Help Menu • Atomic Learning

  18. How does this work address the questions that began the session? • Answers

More Related