CHAPTER 7 Introduction to Microsoft Excel 2007 OBJECTIVES

CHAPTER 7 Introduction to Microsoft Excel 2007

OBJECTIVES 1. Identify uses of the spreadsheet in general as well as for healthcare applications 2. Define basic terminology related to spreadsheets 3. Review selected functions for using Excel 2007

Common Spreadsheet Terms • Rows • Run horizontally across the spreadsheet • Columns • Go vertically down the spreadsheet • Cell • Placeholder for data • Cell Address (Cell Reference) • Label for each cell

Common Spreadsheet Terms • Active Cell • Cell that is currently being used • Range (Block) • Group of cells in a rectangular pattern • Workbook (Notebook) • A collection of spreadsheet pages • Worksheet • Spreadsheet made up of labels, values, lines or borders, and formulas

Spreadsheet Screen Display • Current Cell Address • Indicates the active cell • Formula Toolbar • Data entered appears in this location • Message Area • Shows which actions will occur when a function is activated

Getting Ready to Use a Spreadsheet • Which type of data is needed in the spreadsheet • Are monthly, quarterly, or yearly intervals needed • Is there a need to make comparisons of data • How many data elements or time intervals are there

Accomplishing Tasks in the Worksheet • Entering Data • Saving Worksheets • Using Charts • Axis • Categories • Chart type • Data series • Legend

Introduction to Excel 2007 • The Ribbon in Excel: Microsoft’s “Fluent User Interface: • Entering Data and Correcting Errors • The Mouse Pointer • Using Auto. Fill • Moving Around in the Worksheet • Viewing the Worksheet

Introduction to Excel 2007 • Working with Multiple Worksheets • Working with Multiple Workbooks • Numbers and Formulas • Formulas and Functions • Absolute Cell Addresses • Sorting Data • Scenarios