Maran Illustrated Excel 2003

Description

Produced by the award-winning maranGraphics Group, Maran Illustrated™ Microsoft Excel 2003 is a valuable resource for all readers, regardless of experience. Clear, step-by-step instructions walk the reader through each operation from beginning to end. Helpful topic introductions and useful tips provide additional information and advice to enhance the readers' Excel 2003 experience and help meet their individual needs. Maran Illustrated™ Microsoft Excel 2003 is packed with information useful to readers who have purchased their first computer and are learning Excel 2003 for the first time. Readers who have experience with older versions of Excel will find this book an excellent guide to help them take command of their computing experience, by way of the easy-to-use maranGraphics format. Readers have the option of reading the book from cover to cover, or simply reading the individual topics they are interested in. TABLE OF CONTENTS 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 Workbooks 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 Pane Find Data Replace Data Link Data Name Cells Add a Comment Insert Symbols Insert a Stock Quote Chapter 4 WORK WITH ROWS AND COLUMNS Change Column Width 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 Report 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 Pages 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 Dictation 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 INDEX A B C D E F G H I K L M N O P Q R S T U V W X Z