Excel.01 - XP XP COMPREHENSIVE Excel Tutorial 1 XP XP New...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: XP XP COMPREHENSIVE Excel Tutorial 1 XP XP New Perspectives on Microsoft Office Excel 2007 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 22 XP XP New Perspectives on Microsoft Office Excel 2007 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 33 XP XP New Perspectives on Microsoft Office Excel 2007 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 New Perspectives on Microsoft Office Excel 2007 44 XP XP New Perspectives on Microsoft Office Excel 2007 Introducing Excel New Perspectives on Microsoft Office Excel 2007 55 XP XP New Perspectives on Microsoft Office Excel 2007 Exploring Excel New Perspectives on Microsoft Office Excel 2007 66 XP XP New Perspectives on Microsoft Office Excel 2007 Exploring Excel New Perspectives on Microsoft Office Excel 2007 77 XP XP New Perspectives on Microsoft Office Excel 2007 Navigating a Worksheet Excel provides several ways to navigate a worksheet New Perspectives on Microsoft Office Excel 2007 88 XP XP New Perspectives on Microsoft Office Excel 2007 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 99 XP XP New Perspectives on Microsoft Office Excel 2007 Entering Text, Numbers, and Dates 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 New Perspectives on Microsoft Office Excel 2007 10 XP XP New Perspectives on Microsoft Office Excel 2007 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 XP XP New Perspectives on Microsoft Office Excel 2007 Changing Column Width and Row Height A pixel is a single point on a computer...
View Full Document

This note was uploaded on 03/09/2011 for the course BCIS 2610 taught by Professor Sidorova during the Spring '08 term at North Texas.

Page1 / 49

Excel.01 - XP XP COMPREHENSIVE Excel Tutorial 1 XP XP New...

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