1 / 20

Microsoft Excel

Microsoft Excel. Workbooks and Worksheets Mrs. Stevens. What is Microsoft Excel?. Microsoft Excel is an electronic spreadsheet developed by Microsoft. Each file created in Excel is called a Workbook. My Grades.xlsx. Familiar Features of Microsoft Excel.

lerato
Download Presentation

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. Microsoft Excel Workbooks and Worksheets Mrs. Stevens

  2. What is Microsoft Excel? • Microsoft Excel is an electronic spreadsheet developed by Microsoft. • Each file created in Excel is called a Workbook. My Grades.xlsx

  3. Familiar Features of Microsoft Excel • Icon – Green and White and a large X • Excel 2010 File Extension - .xlsx My Grades.xlsx

  4. Features of Microsoft backstage in Excel • Green File Tab • Matches Icon color • Same Menu Items as… • Word • Same Menu Items as… • PowerPoint

  5. Familiar Features of Microsoft Command Ribbon in Excel • Home • Insert • Page Layout • Review • View • Home • Insert • Page Layout • Review • View HOME INSERT Watch for new commands on these familiar ribbons… PAGE LAYOUT REVIEW VIEW

  6. new Features of Microsoft Command Ribbon tabs in Excel • Formulas • Data Formulas Data

  7. Familiar Microsoft page layout features in Excel • Title Bar • Save Icon • Undo and Redo Arrows • Quick Access Toolbar (QAT) • Command Ribbons • Title Bar • Save Icon • Undo and Redo Arrows • Quick Access Toolbar (QAT) Undo & Redo Arrows Title Bar Save Icon • Command Ribbons QAT Command Ribbons

  8. New Microsoft page layout features in Excel • Blank Page is a grid • Boxes called Cells • Like Graph Paper • Columns • Up & Down • Named by Letters • Rows • Left to Right • Named by Numbers

  9. New Microsoft page layout features in Excel • Name Box • Identifies the Active Cell • Ex: C3 • Formula Bar • Type in to enter Cell Contents • Ex: Ships • Can enter: • Text • Numbers • Formulas

  10. What are cells in Excel? • Cells – boxes in a worksheet layout • Active Cell - Where a column and row intersect • Cell Name – By Letter of Column & Number of Row • Example: Cell C3 • Each cell can only have ONE piece of data in it • What do you notice about Column C and Row 3?

  11. How to create a workbook • Open Microsoft Excel • Double Click Desktop Icon • Or…Go to “Start” • “All Programs” • “Microsoft Office” • Click the Excel Icon • Can you name a 3rd way?

  12. How to save a workbook • Go to “File” (Backstage View) • Click “Save” • “Save as…” Dialog Box appears • Be sure to save in YOUR folder • Default name is “Book1” • Rename and click “Save”

  13. Your turn… • Open Excel • Go to “File”  “Save” • Navigate to this location: • Project Drive (S:) Drive • Open - “Stevens_ProbSolv” Folder • Open – “Excel Projects” Folder • Name your workbook this way: • Your Last Name_ID#_Xprj1 • Example: Stevens_348242_Xprj1 • Click “Save”

  14. Basic Terms • Excel • Workbook • Worksheet • Cells • Active Cell • Columns • Rows • An electronic spreadsheet application • An Excel file (like a notebook) • Pages in the Workbook • Boxes where a column and row intersect (cross/meet) • Identified by the Column Letter & Cell Number • Cells going up/down – Identified by a letter of the alphabet • Cells going across (left to right) – Identified by a number

  15. Spreadsheet Review slides Do you remember this?

  16. Electronic Spreadsheet • An interactive computer program that… • organizes information into software-defined rows and columns • adds up the data, using a formula, to give a total or sum • can generate charts or graphs of the data.

  17. Excel Worksheet • The pages in the workbook. • Each Workbook has 3 worksheets • Worksheets can be added to or removed from the workbook.

  18. Ledger VS Excel Workbook • Bound Book • Has Paper Pages • Storing Uses Extra Space • Easily Damaged/Lost • Hard to Read - Handwritten • Computer Program • Has Electronic Worksheets • Easily Stored on Local or External Disk • Easy to Read – Computer Fonts Ledger Excel Workbook

  19. Spreadsheet VS Excel Worksheet • Paper Pages in a Ledger • Pages have Columns and Rows • Handwritten Data • Hand Calculated Data • Work is Slow • People make Mistakes • Not easy to add or remove pages • Electronic Worksheets • Worksheets have Columns and Rows • Data Entered Electronically • Computer Calculated Data • Work is Fast • Accurate Computer Formulas • Pages can be added or removed easily Spreadsheet Excel Worksheet

More Related