Exploring Microsoft Excel Chapter 1 Introduction to Microsoft

Objectives (1 of 2) • Describe what a spreadsheet is and potential applications •

Objectives (2 of 2) • Describe three-dimensional nature of a workbook; distinguish between a

Overview • Introduction to Spreadsheets and Excel • Show wide diversity of spreadsheet applications

Spreadsheet Basics • • • Spreadsheet is a computerized ledger Divided into Rows and

Excel Basics • Common user interface of all Office applications • Worksheet is an

Introduction to Microsoft Excel Hands-On Exercise 1 • • Welcome to Windows Obtain the

Modifying the Worksheet • Insert and Delete Commands for both rows and columns •

Modifying a Worksheet Hands-On Exercise 2 • • • Exploring Excel Open the Workbook

Excel Features and Commands • • • Exploring Excel Active cell Formula bar Shortcut

Chapter 1 Summary • Spreadsheet is computerized accountant’s ledger • Spreadsheet is generic term

Practice with Excel 1. More with Grade books 2. Exotic Gardens Nurseries 3. Residential

Case Studies • Buying a Computer • Portfolio Management • Accuracy Counts • Microsoft

Slides: 13

Download presentation

Exploring Microsoft Excel Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet? Exploring Excel Chapter 1

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 Exploring Excel Chapter 1 2

Objectives (2 of 2) • Describe 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 Exploring Excel Chapter 1 3

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

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 Exploring Excel Chapter 1 5

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 Exploring Excel Chapter 1 6

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 Exploring Excel Chapter 1 7

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

Modifying a Worksheet Hands-On Exercise 2 • • • Exploring Excel 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 9

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

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 Exploring Excel Chapter 1 11

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

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