KEMBAR78
Getting Started With Excel: Comprehensive | PDF | Microsoft Excel | Spreadsheet
Scribd
Upload
1K views10 pages

Getting Started With Excel: Comprehensive

This document provides an overview of getting started with Microsoft Excel. It introduces spreadsheets and Excel, describes the parts of the Excel window, and explains how to navigate worksheets. The objectives covered include entering and formatting text, numbers, and dates; selecting and moving cell ranges; inserting formulas and functions; and printing worksheets. Functions in Excel are introduced as named operations that return values, and the AutoSum button is described as a way to quickly insert summation and other statistical functions.

Uploaded by

trevorsum123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1K views10 pages

Getting Started With Excel: Comprehensive

This document provides an overview of getting started with Microsoft Excel. It introduces spreadsheets and Excel, describes the parts of the Excel window, and explains how to navigate worksheets. The objectives covered include entering and formatting text, numbers, and dates; selecting and moving cell ranges; inserting formulas and functions; and printing worksheets. Functions in Excel are introduced as named operations that return values, and the AutoSum button is described as a way to quickly insert summation and other statistical functions.

Uploaded by

trevorsum123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 10

Getting Started

with Excel

COMPREHENSIVE
Objectives XP

• 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


Objectives XP

• 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


Introducing Excel XP

1. Microsoft Office Excel 2007 (or Excel) is a computer


program used to enter, Store and organize data,
Analyze data, and Represent data graphically (e.g., in
bar graphs, histograms, and scatter plots)
• 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 4
Exploring Excel XP

New Perspectives on Microsoft Office Excel 2007 5


XP
Excel Basics
Excel spreadsheets organize information (text and
numbers) by rows and columns:

This is a row.
Rows are represented
by numbers along the
side of the sheet. No of
Rows - 16384
This is a column.
Columns are
represented by letters
across the top of the
sheet. No of Coolums
- 1048576
Entering Text, Numbers, and Dates XP
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 7


Entering Multiple Lines of Text XP
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 8


Introducing Functions XP

• A function is a named operation that returns a


value
• For example, to add the values in the range
A1:A10, you could enter the following long
formula:
=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10
Or, you could use the SUM function to
accomplish the same thing:
=SUM(A1:A10)
New Perspectives on Microsoft Office Excel 2007 9
Entering Functions with AutoSum XP

• The AutoSum button quickly inserts Excel


functions that summarize all the values in a
column or row using a single statistic
– Sum of the values in the column or row
– Average value in the column or row
– Total count of numeric values in the column or row
– Minimum value in the column or row
– Maximum value in the column or row

New Perspectives on Microsoft Office Excel 2007 10

You might also like