Download
get going with microsoft excel n.
Skip this Video
Loading SlideShow in 5 Seconds..
Get Going With Microsoft Excel PowerPoint Presentation
Download Presentation
Get Going With Microsoft Excel

Get Going With Microsoft Excel

70 Views Download Presentation
Download Presentation

Get Going With Microsoft Excel

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