Scribd
Upload
3K views10 pages

Excel Training Manual

This document provides an overview of getting started with Excel. It introduces spreadsheets and the Excel interface, describes how to navigate and enter different types of data, perform basic functions like summing values, and outlines how to format and print worksheets. The key points covered include understanding the use of rows and columns to organize data, using editing tools to enter text, numbers, dates and formulas, and utilizing functions like SUM automatically or with the AutoSum button.

Uploaded by

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

Excel Training Manual

This document provides an overview of getting started with Excel. It introduces spreadsheets and the Excel interface, describes how to navigate and enter different types of data, perform basic functions like summing values, and outlines how to format and print worksheets. The key points covered include understanding the use of rows and columns to organize data, using editing tools to enter text, numbers, dates and formulas, and utilizing functions like SUM automatically or with the AutoSum button.

Uploaded by

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

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

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

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

Exploring Excel

New Perspectives on Microsoft Office Excel 2007

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

XP

Entering Text, Numbers, and


XP
Dates
The formula bar displays the content of
inthe
Cells
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

Entering Multiple Lines of Text


Within a Cell

XP

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

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

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