10 Minute Guide to Microsoft Excel 2002

Joe Habraken is a computer technology professional and best-selling author with more than fifteen years of experience in the information technology field as a network administrator, consultant, and educator. His recent publications include Microsoft Office XP 8-in-1, The Absolute Beginner's Guide to Networking (Second Edition), and Practical Cisco Routers. Joe currently serves as the Director of UNEit, an IT training center for computer industry professionals at the University of New England in Portland, ME.

1. What's New in Excel 2002.


Introducing Excel 2002. What's New in Excel 2002. Introducing Task Panes. Introducing Voice Dictation and Voice Commands. Training the Speech Feature.



2. Creating a New Workbook.


Starting Excel. Understanding the Excel Window. Starting a New Workbook. Saving and Naming a Workbook. Saving a Workbook Under a New Name or Location. Opening an Existing Workbook. Closing Workbooks. Exiting Excel.



3. Entering Data into the Worksheet.


Understanding Excel Data Types. Entering Text. Entering Numbers. Entering Dates and Times. Copying (Filling) the Same Data to Other Cells. Entering a Series of Numbers, Dates, and Other Data. Entering a Custom Series. Taking Advantage of AutoComplete. Dictating Worksheet Information.



4. Performing Simple Calculations.


Understanding Excel Formulas. Order of Operations. Entering Formulas. Using the Status Bar AutoCalculate Feature. Displaying Formulas. Editing Formulas.



5. Manipulating Formulas and Understanding Cell References.


Copying Formulas. Using Relative and Absolute Cell Addresses. Recalculating the Worksheet.



6. Performing Calculations with Functions.


What Are Functions? Using the Insert Function Feature.



7. Getting Around in Excel.


Moving from Worksheet to Worksheet. Switching Between Workbooks. Moving Within a Worksheet.



8. Getting Help in Microsoft Excel.


Help: What's Available? Using the Ask a Question Box. Using the Office Assistant. Using the Help Window. Getting Help with Screen Elements.



9. Different Ways to View Your Worksheet.


Changing the Worksheet View. Freezing Column and Row Labels. Splitting Worksheets. Hiding Workbooks, Worksheets, Columns, and Rows. Locking Cells in a Worksheet.



10. Editing Worksheets.


Correcting Data. Undoing an Action. Using the Replace Feature. Checking Your Spelling. Copying and Moving Data. Using the Office Clipboard. Deleting Data.



11. Changing How Numbers and Text Look.


Formatting Text and Numbers. Using the Style Buttons to Format Numbers. Numeric Formatting Options. How You Can Make Text Look Different. Changing Text Attributes with Toolbar Buttons. Accessing Different Font Attributes. Aligning Text in Cells. Copying Formats with Format Painter.



12. Adding Cell Borders and Shading.


Adding Borders to Cells. Adding Shading to Cells. Using AutoFormat. Applying Conditional Formatting.



13. Working with Ranges.


What Is a Range? Selecting a Range. Naming Ranges. Creating Range Names from Worksheet Labels. Inserting a Range Name into a Formula or Function.



14. Inserting and Removing Cells, Rows, and Columns.


Inserting Rows and Columns. Removing Rows and Columns. Inserting Cells. Removing Cells. Adjusting Column Width and Row Height with a Mouse. Using the Format Menu for Precise Control.



15. Managing Your Worksheets.


Selecting Worksheets. Inserting Worksheets. Deleting Worksheets. Moving and Copying Worksheets. Changing Worksheet Tab Names.



16. Printing Your Workbook.


Previewing a Print Job. Changing the Page Setup. Printing Your Workbook. Selecting a Large Worksheet Print Area. Adjusting Page Breaks.



17. Creating Charts.


Understanding Charting Terminology. Working with Different Chart Types. Creating and Saving a Chart. Moving and Resizing a Chart. Printing a Chart.



18. Making Your Charts Look Better.


Selecting a Chart Object. The Chart Toolbar. Changing the Chart Type. Adding a Title and a Legend. Formatting Chart Text, Colors, and Alignment. Enhancing the Chart Area.



19. Adding Graphics and Other Objects to Worksheets.


Inserting Clip Art into a Worksheet. Sizing and Moving a Picture. Inserting Other Image File Types. Using the Picture Toolbar. Drawing Your Own Pictures.



20. Saving and Publishing Files to the Web.


Saving a Workbook for the Web. Creating an FTP Location. Publishing an Excel Worksheet to the Web. Static Versus Interactive Data. Viewing Excel Data in a Web Browser. Adding Hyperlinks to a Worksheet.