1 / 13

Exploring Microsoft Excel

Exploring Microsoft Excel. Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet?. Objectives (1 of 2). Describe what a spreadsheet is and potential applications Distinguish between a formula and a constant Open, save, print a workbook; insert and delete rows and columns

kellyc
Download Presentation

Exploring 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. ExploringMicrosoftExcel Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet?

  2. Objectives (1 of 2) • Describe what a spreadsheet is and potential applications • Distinguish between a formula and a constant • Open, save, print a workbook; insert and delete rows and columns • Distinguish between a pull-down menu, shortcut menu and toolbar Chapter 1

  3. Objectives (2 of 2) • Describe the three-dimensional nature of a workbook; distinguish between a workbook and a worksheet • Print worksheet with values or formulas • Use Page Setup to print worksheet and preview before printing Chapter 1

  4. Overview • Introduction to Spreadsheets and Excel • Show wide diversity of spreadsheet applications • Fundamentals of spreadsheets using Excel • Worksheet recalculates automatically after changes Chapter 1

  5. Spreadsheet Basics • Spreadsheet is a computerized ledger • Divided into Rows and Columns • Cell References • Constants--entries that do not change • Formulas--combination of constants and functions Chapter 1

  6. Excel Basics • Common user interface of all Office applications • Worksheet is an Excel spreadsheet • Workbook contains one or more worksheets • Toolbars--Standard and Formatting • File menu--Save, Open and Print commands Chapter 1

  7. Introduction to Microsoft Excel Hands-On Exercise 1 • Welcome to Windows • Obtain the Practice Files • Start Microsoft Excel • Open the Workbook • The Active Cell, Formula Bar and Worksheet Tabs • Experiment (What If?) • The Office Assistant • Print and Close the Workbook Chapter 1

  8. Modifying the Worksheet • Insert and Delete Commands for both rows and columns • Page Setup Commands--Portrait versus Landscape, Margins, Header/Footer, and Sheet Tabs Chapter 1

  9. Modifying a Worksheet Hands-On Exercise 2 • Open the Workbook • The Save As Command • Delete a Row • The Undo Command • Insert a Row and Second Row • Insert a Column • Display the Cell Formulas • The Page Setup Command • The Print Preview Command Chapter 1

  10. Excel Features and Commands • Active cell • Formula bar • Shortcut menu • Status bar • Toolbars • ScreenTips • Edit Delete versus Edit Clear • Incompatible File Type from Excel • Save as Command Chapter 1

  11. Chapter 1 Summary • Spreadsheet is computerized accountant’s ledger • Spreadsheet is generic term • Cells contain formulas or constants • Editing worksheets • Print worksheets with values and formulas Chapter 1

  12. Practice with Excel 1. More with Grade books 2. Exotic Gardens Nurseries 3. Residential Colleges 4. Budget Chapter 1

  13. Case Studies • Buying a Computer • Portfolio Management • Accuracy Counts • Microsoft Online Chapter 1

More Related