Microsoft Excel

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

16. Spreadsheet Review slides Do you remember this?

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

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

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

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