Teach Yourself Visually Excel 2003

Chapter 1: GETTING STARTED; Introduction to Excel; Start Excel; Parts of the Excel Window; Change the Active Cell; Scroll Through a Worksheet; Enter Data; Select Cells; Complete a Series; Select a Command; Using the Task Pane; Getting Help; Chapter 2: SAVE AND OPEN YOUR WORKBOOKS; Save a Workbook; Create a New Workbook; Switch Between Workbooks; View All Open Workbooks; Compare Workbooks; Close a Workbook; Save a Workbook in a Workspace File; Save a Workbook With a New Name; Open a Workbook; Search for a Workbook; Chapter 3: EDIT YOUR WORKSHEETS; Edit Data; Delete Data; Undo Changes; Move or Copy Data; Check Spelling; Using AutoCorrect; Using the Research Task Panel; Find Data; Replace Data; Link Data; Name Cells; Add a Comment; Insert Symbols; Insert a Stock Quote; Chapter 4: WORK WITH ROWS AND; Change Column With; Change Row Height; Insert a Row or Column; Delete a Row or Column; Insert Cells; Delete Cells; Hide Columns; Freeze Rows and Columns; Split a Worksheet; Chapter 5: WORK WITH FORMULAS AND FUNCTIONS; Introduction to Formulas and Functions; Enter a Formula; Enter a Function; Perform Common Calculations; Copy a Formula; Display All Formulas; Check Errors in Formulas; Create Scenarios; Create a Scenario Summary; Chapter 6: CHANGE YOUR SCREEN DISPLAY; Zoom In or Out; Display Full Screen; Display or Hide the Status Bar; Display or Hide a Toolbar; Move a Toolbar; Resize a Toolbar; Chapter 7: FORMAT YOUR WORKSHEETS; Change Font of Data; Change Size of Data; Change Font for All New Workbooks; Bold, Italicize or Underline Data; Change Horizontal Alignment of Data; Change Vertical Alignment of Data; Change Appearance of Data; Change Data Color; Change Cell Color; Indent Data; Center Data Across Columns; Wrap Text in Cells; Add Borders to Cells; Change Number Format; Copy Formatting; Apply an AutoFormat; Apply Conditional Formatting; Chapter 8: PRINT YOUR WORKSHEETS; Preview a Worksheet Before Printing; Print a Worksheet; Set a Print Area; Center Data on a Printed Page; Change Page Orientation; Change Margins; Change Print Options; Insert a Page Break; Add a Header or Footer; Add a Custom Header or Footer; Change Size of Printed Data; Repeat Labels on Printed Page; Chapter 9: WORK WITH MULTIPLE WORKSHEETS; Switch Between Worksheets; Rename a Worksheet; Insert a Worksheet; Delete a Worksheet; Move a Worksheet; Add Color to a Worksheet Tab; Move or Copy Data Between Worksheets; Enter a Formula Across Worksheets; Using the Watch Window Toolbar; Chapter 10: WORK WITH CHARTS; Introduction to Charts; Create a Chart; Move or Resize a Chart; Print a Chart; Change the Chart Type; Change Chart Titles; Rotate Chart Text; Format Chart Text; Add Data to a Chart; Add a Data Table to a Chart; Change the Way Data is Plotted; Change the Appearance of a Data Series; Chapter 11: WORK WITH OBJECTS; Add WordArt; Add an AutoShape; Add a Text Box; Add a Picture; Add a Clip Art Image; Move or Resize an Object; Change the Color of an Object; Rotate an Object; Add a Shadow to an Object; Make an Object 3-D; Add a Diagram; Chapter 12: MANAGE DATA IN A LIST; Create a List; Add a Record; Delete a Record; Sort Data in a List; Display a Total Row; Filter a List; Chapter 13: PROTECT YOUR DATA; Protect a Workbook; Protect Workbook Elements; Protect a Worksheet; Chapter 14: TIME-SAVING FEATURES; Create a Custom Series; Customize a Toolbar; Create a New Toolbar; Turn on Smart Tags; Using Smart Tags; Create a Macro; Run a Macro; Chapter 15: USING SPEECH RECOGNITION; Set Up Speech Recognition; Using Diction Mode; Using Voice Command Mode; Using Text to Speech; Chapter 16: EXCEL AND THE INTERNET; E-mail a Worksheet; Create a Hyperlink; Preview a Workbook as a Web Page; Save a Workbook as a Web Page