Quick Course in Microsoft Excel 2000 Book

Part 1	Learning the Basics
1	Getting Started	2
	An Overview of Workbooks	6
	Entering Data	6
	Entering Text	7
	Entering Numbers as Text	9
	Entering Values	11
	Entering Dates and Times	12
	Moving Around	13
	Selecting Ranges	14
	Giving Excel Instructions	15
	Using Menus	16
	Using Shortcut Menus	19
	Using Toolbars	20
	Saving Workbooks	23
	Getting Help	24
	Quitting Excel	27
2	Editing and Formatting Worksheets	28
	Opening Existing Workbooks	30
	Editing Basics	31
	Changing Entries	31
	Copying Entries	31
	Moving Entries	33
	Inserting and Deleting Cells	36
	Clearing Cells	38
	Checking Spelling	39
	Editing Workbooks	39
	Inserting and Deleting Worksheets	40
	Copying Worksheets	40
	Naming Sheets	41
	Moving Worksheets	42
	Formatting Basics	43
	Changing Character Formatting	44
	Changing Alignment	44
	Changing Column Widths	45
	Wrapping Text in Cells	46
	Adding Titles	48
	Specifying How Values Should Be Displayed	50
	Copying Formatting	52
	Creating Templates	54
3	Performing Calculations	56
	Simple Calculations	58
	Doing Arithmetic	58
	Totaling Columns of Values	60
	Using the AutoSum Button	60
	Using the Sum Function	61
	Referencing Formula Cells in Other Formulas	62
	Naming Cells and Ranges	62
	Creating a Calculation Area	65
	More Calculations	68
	Averaging Values	68
	Identifying Highest and Lowest Values	70
	Calculating with Names	71
	Formulas That Make Decisions	72
	Copying Formulas	74
	Linking Worksheets with Formulas	75
	Printing and Publishing Worksheets	78
	Previewing Worksheets	78
	Setting Up the Pages	79
	Printing Worksheets	82
	Publishing on an Intranet or the World Wide Web	83
Part 2	Building Proficiency
4	Graphing Worksheet Data	88
	Setting Up the Worksheet	90
	Automatic Formatting	91
	Plotting Graphs	92
	Sizing and Moving Graphs	96
	Updating Graphs	96
	Changing the Graph Type	97
	Using Graph Custom Types	102
	Fine-Tuning Graphs	103
	Adding and Formatting Text	104
	Enhancing the Graph's Border	107
	Adding Gridlines	107
	Previewing and Printing Graphs	108
5	Extracting Information from a List	110
	Sorting Data	113
	Adding Sort Codes	114
	Using One Sort Column	115
	Using Two Sort Columns	116
	Using Three Sort Columns	116
	Keeping Headings in View	117
	List Basics	118
	Finding Records	120
	Adding and Deleting Records	121
	Filtering Records	122
	Customizing Filters	123
	Summarizing Data	126
	Consolidating Data	126
	Creating Pivot Tables and Pivot Charts	128
	Modifying a Pivot Table	131
	Plotting the Pivot Table as a Pivot Chart	133
6	More Advanced Calculations	134
	Creating the Supporting Tables	137
	Counting Entries	140
	Creating an Estimate Worksheet	141
	Looking Up Information	142
	Completing the Estimate	144
	Projecting Profit Margin with Iteration	145
	What-If Analysis	148
	Using Goal Seek to Find One Unknown Value	148
	Using Data Tables to Calculate the Effects of One or Two Variables	149
	Using Scenario Manager to Test Multiple Scenarios	152
	Creating Scenarios	153
	Changing Scenarios	155
	Creating Scenario Reports	156