Microsoft Excel

Microsoft Excel

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

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...