Excel Book

	Introduction	1
	Conventions Used in This Book	2
Pt. I	Understanding Excel
	The Excel Interface	4
	Task Panes	8
	Workbook, Workspace, and Template Files	11
	The Anatomy of an Excel File	14
	Formatting	17
	Shortcut Menus	25
	How Excel Tries to Help	26
Pt. II	Excel Tasks
	Working with Files	30
	Printing	33
	Moving Around in a Workbook or Worksheet	37
	Manipulating Workbooks and Worksheets	40
	Manipulating Rows, Columns, and Cells	42
	Entering and Editing Data	45
	Formatting Cells	54
	Working with Hyperlinks	59
	Working with Headers and Footers	60
	Summarizing Data	62
	Using Named Ranges	65
	Defining Alternative Data Sets	66
	Controlling How Data is Displayed	68
	Protecting All or Part of a Workbook	72
	Spelling and Other Tools	72
	Customizing Excel	75
	Collaborating	78
	Working with the Web	81
	Summarizing Data with Charts	82
	Summarizing Data with PivotTables and PivotCharts	83
Pt. III	Excel Reference
	Command Reference	88
	Native Formats	89
	Startup Switches	90
	Wildcards in Filters and Searches	91
	Default File Locations	92
	Keyboard Shortcuts	93
Pt. IV	Excel Resources
	Internet Sites	101
	Books	102
	Excel Utilities	103
	Index	105