This 10 Minute Guide focuses on the most often used features, covering them in lessons designed to take 10 minutes or less to complete. In addition, this guide teaches the user how to use Excel without relying on technical jargon. It provides straightforward, easy-to-follow explanations and lists of numbered steps that tell the user which options to select.
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.
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.
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.
Understanding Excel Formulas. Order of Operations. Entering Formulas. Using the Status Bar AutoCalculate Feature. Displaying Formulas. Editing Formulas.
Copying Formulas. Using Relative and Absolute Cell Addresses. Recalculating the Worksheet.
What Are Functions? Using the Insert Function Feature.
Moving from Worksheet to Worksheet. Switching Between Workbooks. Moving Within a Worksheet.
Help: What's Available? Using the Ask a Question Box. Using the Office Assistant. Using the Help Window. Getting Help with Screen Elements.
Changing the Worksheet View. Freezing Column and Row Labels. Splitting Worksheets. Hiding Workbooks, Worksheets, Columns, and Rows. Locking Cells in a Worksheet.
Correcting Data. Undoing an Action. Using the Replace Feature. Checking Your Spelling. Copying and Moving Data. Using the Office Clipboard. Deleting Data.
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.
Adding Borders to Cells. Adding Shading to Cells. Using AutoFormat. Applying Conditional Formatting.
What Is a Range? Selecting a Range. Naming Ranges. Creating Range Names from Worksheet Labels. Inserting a Range Name into a Formula or Function.
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.
Selecting Worksheets. Inserting Worksheets. Deleting Worksheets. Moving and Copying Worksheets. Changing Worksheet Tab Names.
Previewing a Print Job. Changing the Page Setup. Printing Your Workbook. Selecting a Large Worksheet Print Area. Adjusting Page Breaks.
Understanding Charting Terminology. Working with Different Chart Types. Creating and Saving a Chart. Moving and Resizing a Chart. Printing a Chart.
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.
Inserting Clip Art into a Worksheet. Sizing and Moving a Picture. Inserting Other Image File Types. Using the Picture Toolbar. Drawing Your Own Pictures.
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.