Excel Tutorial 1

Getting Started with Excel
Introducing Excel * Microsoft Office Excel 2007 (or Excel) is a computer program used to enter, analyze, and present quantitative data * A spreadsheet is a collection of text and numbers laid out in a rectangular grid. * Often used in business for budgeting, inventory management, and decision making * What-if analysis lets you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values
Introducing Excel
Exploring Excel
Navigating a Worksheet * Excel provides several ways to navigate a worksheet
Planning a Workbook * Before you begin to enter data into a workbook, you should develop a plan * Planning analysis sheet
Entering Text, Numbers, and Dates in Cells * The formula bar displays the content of the active cell * Text data is a combination of letters, numbers, and some symbols * Number data is any numerical value that can be used in a mathematical calculation * Date and time data are commonly recognized formats for date and time values
Entering Multiple Lines of Text
Within a Cell * Click the cell in which you want to enter the text * Type the first line of text * For each additional line of text, press the Alt+Enter keys (that is, hold down the Alt key as you press the Enter key), and then type the text
Changing Column Width and Row Height * A pixel is a single point on a computer monitor or printout * The default column width is 8.38 standard-sized characters * Row heights are expressed in points or pixels, where a point is 1⁄72 of an inch * Autofitting eliminates any empty space by matching the column to the width of its longest cell entry or the row to the height of its tallest cell entry
Changing the Column Width and Row Height * Drag the right border of the