- Submitted By: khadijamr
- Date Submitted: 07/14/2010 10:02 PM
- Category: English
- Words: 6756
- Page: 28
- Views: 586

Table of Contents

Table of Contents 1

LESSON 1 – CELL FORMATS 5

How Excel stores numbers and text 5

Entering numbers as text 5

Formats of numbers stored as text 6

Numbers in external data 6

Finding numbers stored as text 6

Numbers aren't displayed or calculated as numeric values 6

LESSON 2 – ENTER REPETITIVE DATA 8

Enter Data Quickly 8

Create linear and growth trends with the Series command 9

LESSON 3 – DATA VALIDATION 10

Introduction 10

Setting a Validation Rule on a Cell 10

Customizing the Warning Message 11

Setting Warning Messages Before Data Entry 12

Copying a Validation to Another Cell 13

Non-Numeric Validations 13

Customized Validations 14

Editing Validations 15

Identifying Cells with Validations 15

Tracing Cells which Violate Validations 16

LESSON 4 – SORTING, GROUPING AN OUTLINING, CONDITIONAL FORMATTING 17

Sorting 17

Grouping and Outlining 17

Conditional Formatting 18

LESSON 5 – TEXT TO COLUMNS 19

LESSON 6 – IMPORT WIZARD 21

Delimited 22

Fixed width 23

LESSON 7 – SUB-TOTALS 26

LESSON 8 – ABSOLUTE VS RELATIVE 28

LESSON 9 – FUNCTIONS 30

What Are Worksheet Functions? 30

The Anatomy of a Function 30

Find Answers by Combining Functions 31

LESSON 10 COMMON FUNCTIONS 32

Math And Trig Functions 32

Countif 32

Counts the number of cells within a range that meet the given criteria. 32

Subtotal 32

Returns a subtotal in a list or database. 32

Sumif 33

Adds the cells specified by a given criteria. 33

Statistical Functions 34

Average 34

Returns the average (arithmetic mean) of the arguments. 34

Averagea 35

Calculates the average (arithmetic mean) of the values in the list of arguments. In addition to numbers, text and logical values such as TRUE and FALSE are included in the calculation. 35

Count 35

Counts the number of cells that contain numbers and numbers within the list of arguments. 35

Counta 36...