Table of content

	Table of Contents
	Index

Absolute Beginner's Guide to Microsoft Office Excel 2003
By Joe  Kraynak
Publisher	: Que
Pub Date	: September 15, 2003
ISBN	: 0-7897-2941-5
Pages	: 352

		Copyright
		About the Author
		Acknowledgments
		We Want to Hear from You!
		Introduction
			A Book for the True Beginner
			How This Book Is Organized
			Conventions Used in This Book
		Part I:   Excel Worksheet Orientation Day
			Chapter 1.   Understanding Excel Worksheets (Spreadsheets)
				What Is a Worksheet?
				What Is a Workbook?
				Examining Columns, Rows, and Cells
				Understanding Cell Addresses
				Understanding Formulas and Functions
				Making Data Graphical with Charts
			Chapter 2.   Starting and Navigating Excel
				Starting Excel
				Touring Excel's Program Window
				Touring Excel's Workbook Window
				Using the Toolbars
				Selecting Commands from Menus
				Making Selections in Dialog Boxes
				Maneuvering in Excel's Task Panes
				Getting Help
				Exiting Excel
			Chapter 3.   Working with Workbook Files
				Starting with an Excel Workbook Template
				Creating Workbooks from Scratch
				Saving and Naming Your Workbook
				Saving a Workbook as a Template
				Opening a Saved Workbook
				Managing Worksheets
		Part II:   Creating Your First Worksheet
			Chapter 4.   Entering and Editing Labels and Values
				Understanding Types of Data Entries
				Moving from Cell to Cell
				Entering Data
				Entering Data Quickly with Auto Fill
				Viewing and Using Smart Tags
				Editing Data Entries
				Selecting Cells
				Copying and Moving Data
				Undoing Actions and Commands
			Chapter 5.   Controlling Rows, Columns, and Cells
				Changing Column Widths
				Changing Row Heights
				Wrapping Text in Cells
				Merging Cells
				Locking Headings in Place with Freeze Panes
				Inserting Rows and Columns
				Inserting Cells
				Deleting Rows and Columns
				Deleting Cells
			Chapter 6.   Automating Calculations with Formulas and Functions
				Learning the Order of Operations
				Entering Formulas
				Editing Formulas
				Copying and Pasting Formulas
				Changing the Recalculation Setting
				Using the Auto Calculate Feature
				Doing Higher Math with Functions
				Troubleshooting Errors in Formulas
				Playing "What If?" with Scenarios
		Part III:   Formatting, Charting, and Printing Your Worksheet
			Chapter 7.   Formatting Your Worksheet
				Letting Excel Design Your Worksheet with AutoFormat
				Changing the Appearance of Entries
				Adding Cell Borders
				Adding Shading to Cells
				Using Conditional Formatting to Flag Entries
				Copying Formatting with the Format Painter
				Formatting with Styles
			Chapter 8.   Charting (Graphing) the Worksheet Data
				Understanding Charting Terminology
				Creating a Chart
				Formatting Text on a Chart
				Formatting the Chart Axes
				Enhancing the Chart Frame
				Changing the Appearance of 3-D Charts
			Chapter 9.   Inserting Clip Art and Other Graphics
				Working with Graphic Objects
				Inserting Clip Art and Other Graphics
				Resizing and Reshaping Your Pictures
				Touching Up Images with the Picture Toolbar
				Inserting WordArt Objects
				Adding Text Outside a Cell
				Drawing Your Own Pictures from Scratch
				Working with Layers of Objects
				Changing an Object's Appearance
				Creating an Organization Chart
			Chapter 10.   Printing and Protecting Your Workbook, Worksheets, and Charts
				Previewing Your Worksheets Before Printing
				Changing the Page Setup
				Checking and Adjusting Page Breaks
				Hiding Columns and Rows
				Printing Your Worksheets
				Previewing and Printing Charts
				Preventing Unauthorized Changes to a Workbook
		Part IV:   Going Beyond the Basics
			Chapter 11.   Managing a Database with Excel
				What Is a Database?
				Database Terminology
				Creating Your Database
				Finding Records in Your Database
				Sorting Your Records
				Narrowing Your List with AutoFilter
				Summarizing and Comparing Data with Pivot Tables
			Chapter 12.   Customizing Excel
				Customizing Excel's Toolbars
				Reconfiguring Excel's Menus
				Creating Your Own Menus
				Setting Toolbar and Menu Options
				Changing Excel's Default Settings
				Installing Optional Components
			Chapter 13.   Automating Tasks with Macros
				What Is a Macro?
				Recording a Macro
				Running a Macro
				Creating a Toolbar Button for Your Macro
				Editing Macros in Visual Basic Editor
				Protecting Your System Against Macro Viruses
			Chapter 14.   Using Excel on the Web
				Transforming Worksheets into Web Pages
				Inserting Links on Your Worksheets
				Publishing Your Worksheets on the Web
				Importing Data from the Web into Your Worksheets
				E-mailing Your Worksheet
				Saving Your Workbook as an XML File
			Chapter 15.   Using Excel's Speech and Handwriting Recognition Features
				Making Sure You Have the Essential Equipment
				Checking Your Sound System
				Installing Speech Recognition
				Training Excel to Recognize Your Voice
				Dictating Your Entries
				Entering Voice Commands
				Handwriting Your Entries
		Part V:   Appendixes
			Appendix A.   Excel Shortcut Keys
			Glossary
				A
				B
				C
				D
				E
				F
				G
				H
				I
				J-K-L
				M
				N
				O
				P
				Q-R
				S
				T
				U-V
				W
				X-Y-Z
		Index