Using Excel for Windows 95 Book

	Introduction	1
	Everyday Worksheet Tasks	11
1	Spreadsheet Power in Excel for Windows 95	13
2	Getting Around in Excel and Windows	31
3	Navigating and Selecting in a Workbook	71
4	Entering and Editing Data	95
5	Formatting Worksheets	135
6	Working with Formulas	197
7	Using Functions	243
8	Moving or Copying Data and Formulas	305
9	Reorganizing Workbooks and Sheets	327
10	Managing Files	339
11	Creating Templates and Controlling Excel's Startup	373
12	Printing Worksheets	387
	Creating and Formatting Charts	419
13	Creating Charts	421
14	Modifying Charts	441
15	Formatting Charts	489
16	Building Complex Charts	519
17	Using Maps to Analyze Data	547
	Optimizing Excel	573
18	Managing the Worksheet Display	575
19	Adding Graphics Elements to Sheets	595
20	Outlining Worksheets	637
21	Creating Automatic Subtotals	651
22	Taking Advantage of Excel's Add-Ins	661
	Analyzing the Worksheet	671
23	Manipulating and Analyzing Data	673
24	Building Forms with Controls	699
25	Using the Power of Pivot Tables	721
26	Analyzing and Reporting with Pivot Tables	749
27	Linking, Embedding, and Consolidating Worksheets	779
28	Auditing Workbooks and Worksheets	813
29	Solving with Goal Seeking and Solver	833
30	Testing Multiple Solutions with Scenarios	855
31	Using the Analysis ToolPak	875
	Managing Lists or Databases	899
32	Designing a List or Database	901
33	Entering Data in a List or Database	913
34	Entering Data with the Template Wizard	927
35	Sorting Data	939
36	Finding, Filtering, and Editing Lists and Databases	953
37	Working with Filtered Data	985
38	Retrieving Data from External Databases	999
	Using Excel with Office and Networks	1037
39	Using Excel with Office Applications	1039
40	Working with a Group of People	1077
41	Using Excel with DOS and Mainframe Applications	1093
	Customizing and Automating Excel	1113
42	Customizing the Excel Screen	1115
43	Creating Custom Toolbars and Menus	1131
44	Introducing Visual Basic for Applications	1151
	Index of Common Problems	1171
	Index	1177