Table of contents

[ LiB ]

 

	Table of Contents

 

Microsoft Office Excel 2003 fast&easy
By Diane Koers
Publisher	: Premier Press
Pub Date	: 2003
ISBN	: 1-59200-079-7
Pages	: 400

		Dedication
		Acknowledgments
		About the Author
		Introduction
			How This Book Is Organized
			Who Should Read This Book?
			Added Advice to Make You a Pro
		Part I:  Building a Basic Worksheet
			Chapter 1.  Exploring the Excel Screen
				Starting Excel
				Exploring the Worksheet Screen
				Moving around the Worksheet Screen
				Using Excel Help
			Chapter 2.  Creating a Simple Worksheet
				Entering Data
				Saving a Worksheet File
				Closing a Worksheet
				Enabling AutoRecover
				Opening an Existing File
				E-Mailing a Worksheet
				Starting a New Worksheet
			Chapter 3.  Editing a Worksheet
				Editing Data
				Learning Selection Techniques
				Inserting Areas
				Deleting Areas
				Using Undo and Redo
				Moving Data Around
				Copying Data
				Using the Office Clipboard
				Using the Fill Feature
			Chapter 4.  Making the Worksheet
				Using AutoFormat
				Formatting Numbers
				Formatting with Fonts
				Adjusting Column Width
				Adjusting Row Height
				Setting Worksheet Alignment
				Adding Cell Borders
				Adding Background Color
				Using Cell Patterns
				Copying Cell Formatting
			Chapter 5.  Selecting Printing Options
				Setting Up the Pages
				Creating a Header or Footer
				Selecting a Print Area
				Printing a Worksheet
				Review Questions
		Part II:  Working with Formulas and Larger Worksheets
			Chapter 6.  Working with Formulas
				Creating Formulas
				Editing Formulas
				Copying Formulas
				Creating an Absolute Reference in a Formula
				Viewing Formulas
				Understanding Common Formula Error Messages
			Chapter 7.  Using Excel Functions
				Understanding Function Syntax
				Creating a Total with the SUM Function
				Using Other Functions
				Getting Help with Excel Functions
			Chapter 8.  Working with Larger Workbooks
				Moving from Worksheet to Worksheet
				Inserting Worksheets
				Naming Worksheets
				Hiding a Worksheet
				Deleting Worksheets
				Creating a Reference to Another Worksheet
				Creating Links to Other Workbooks
			Chapter 9.  Worksheets Managing Larger
				Modifying Worksheet Views
				Working with Ranges
				Using Find and Replace
				Review Questions
		Part III:  Adding Visual Interest
			Chapter 10.  Working with Art Images
				Inserting Images
				Customizing Art
				Adding WordArt
				Making Adjustments to the WordArt
				Deleting an Art Image
			Chapter 11.  Creating Charts from Excel Data
				Creating a Chart
				Modifying a Chart
				Deleting a Chart
			Chapter 12.  Using the Drawing Toolbar
				Drawing Shapes
				Editing the Drawing Object
				Review Questions
		Part IV:  Analyzing Data
			Chapter 13.  Working with Data
				Sorting
				Using Filters
				Data Subtotals
				Conditional Formatting
			Chapter 14.  Discovering Tools for Speed and Quality
				Checking the Spelling
				Working with AutoCorrect
				Using the Excel Research Tools
				Translating Words
				Checking for Errors
				Understanding Smart Tags
			Chapter 15.  Customizing Excel
				Setting Preferences
				Working with Templates
				Review Questions
		Part V:  Integrating Excel Technology
			Chapter 16 .  Integrating Excel with Word
				Using Excel Worksheets in Word
				Inserting an Existing Excel Worksheet into Word
				Inserting Word Data into Excel
			Chapter 17.  Using Excel with Access
				Exporting an Access Table or Query to Excel
				Importing Excel Data into Access
				Linking an Excel Worksheet to Access
			Chapter 18.  Collaborating with Others
				Working with Comments
				Working with Revisions
				Sharing a Workbook
				Securing a Workbook
				Review Questions
		Appendix A .  Excel Shortcut Keys
			Learning the Basic Shortcuts
			Working inside Workbooks
			Moving around a Workbook
			Typing and Editing Cell Data
			Selecting Ranges of Cells
			Formatting Data
			Miscellaneous Commands
		Glossary
			Symbols
			A
			B
			C
			D
			F
			G
			H
			I
			J
			L
			M
			N
			O
			P
			R
			S
			T
			U
			V
			W
			X
			Y
			Z

[ LiB ]