Excel.01 - Excel Tutorial 1 Getting Started with Excel...

Info iconThis preview shows pages 1–13. Sign up to view the full content.

View Full Document Right Arrow Icon
COMPREHENSIVE Excel Tutorial 1 Getting Started  with Excel
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Objectives Understand the use of spreadsheets and  Excel Learn the parts of the Excel window Scroll through a worksheet and navigate  between worksheets Create and save a workbook file Enter text, numbers, and dates into a  worksheet Resize, insert, and remove columns and rows New Perspectives on Microsoft Office Excel 2007 2
Background image of page 2
Objectives Select and move cell ranges Insert formulas and functions Insert, delete, move, and rename  worksheets Work with editing tools Preview and print a workbook New Perspectives on Microsoft Office Excel 2007 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Introducing Excel Microsoft Office Excel 2007  (or  Excel ) is a  computer program used to enter, analyze, and  present quantitative data 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 New Perspectives on Microsoft Office Excel 2007 4
Background image of page 4
Introducing Excel New Perspectives on Microsoft Office Excel 2007 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Exploring Excel New Perspectives on Microsoft Office Excel 2007 6
Background image of page 6
Exploring Excel New Perspectives on Microsoft Office Excel 2007 7
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Navigating a Worksheet Excel provides several ways to navigate a  worksheet New Perspectives on Microsoft Office Excel 2007 8
Background image of page 8
Planning a Workbook Before you begin to enter data into a  workbook, you should develop a plan Planning analysis sheet New Perspectives on Microsoft Office Excel 2007 9
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
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 New Perspectives on Microsoft Office Excel 2007 10
Background image of page 10
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 New Perspectives on Microsoft Office Excel 2007 11
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Changing Column Width  and Row Height 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
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/27/2008 for the course IT 41 taught by Professor Clayton during the Spring '08 term at Drake University .

Page1 / 49

Excel.01 - Excel Tutorial 1 Getting Started with Excel...

This preview shows document pages 1 - 13. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online