Microsoft Excel 2002
by Julia Kelly
Start the free chapterMicrosoft Excel 2002 offers tools that make it easy to access, connect, and analyze critical data, proving that Excel spreadsheets are no longer just for financial professionals. Virtual Training Company author Julia Kelly will instruct users on how to use this powerful spreadsheet program. Excel 2002 allows users to find and format data more quickly by utilizing context sensitive options as tasks are being performed. The new Error Checking smart tag feature allows users to fix, or ignore an error. Document Recovery automatically saves current workbooks, protecting your work. Refreshable queries allow users to integrate live data from the Web, or any other source. To get started, simply click on one of the movie topics below.
Course content
Introduction6 lessons
Getting Started12 lessons
- Select and Navigate Cells4:261 credit or ad
- Enter Data3:131 credit or ad
- Edit and Delete Data3:391 credit or ad
- Undo and Redo2:591 credit or ad
- Cut/Copy/Paste3:031 credit or ad
- About the Office Clipboard3:191 credit or ad
- Drag and Drop3:211 credit or ad
- AutoFill4:101 credit or ad
- More Ways to Enter Repetitive Data3:331 credit or ad
- AutoCorrect3:411 credit or ad
- Use a Data Entry Form2:581 credit or ad
- Validate Data During Entry3:361 credit or ad
Working With Worksheets7 lessons
- Resize Rows and Columns4:201 credit or ad
- Insert and Delete Rows/Columns/Cells5:041 credit or ad
- Rename Worksheets3:391 credit or ad
- Move and Copy Worksheets3:111 credit or ad
- Insert and Delete Worksheets2:351 credit or ad
- Freeze and Split a Worksheet3:311 credit or ad
- Open Multiple Windows3:321 credit or ad
Simple Calculations11 lessons
- Calculate Without a Formula3:041 credit or ad
- Use AutoSum to Write Formulas3:381 credit or ad
- Formula Structure5:331 credit or ad
- Create Formulas3:571 credit or ad
- Edit Formulas3:071 credit or ad
- AutoFill Formulas5:081 credit or ad
- Relative and Absolute References2:591 credit or ad
- Functions4:141 credit or ad
- Use the Function Wizard4:151 credit or ad
- Name Cells and Ranges3:211 credit or ad
- Use Names in Formulas3:371 credit or ad
Using Advanced Functions6 lessons
Organizing Data7 lessons
Formatting Cells13 lessons
- Text Formatting4:581 credit or ad
- Align and Wrap Text4:191 credit or ad
- Number Formats5:151 credit or ad
- Date and Time Formats3:291 credit or ad
- Custom Formats4:131 credit or ad
- Borders and Shading5:171 credit or ad
- Conditional Formatting4:241 credit or ad
- Format Painter3:531 credit or ad
- Styles5:321 credit or ad
- AutoFormat a Table2:421 credit or ad
- Transpose Tables and Merge Cells3:101 credit or ad
- Format Several Worksheets Identically3:071 credit or ad
- Save a File as a Template4:351 credit or ad
Charting Data13 lessons
- About Charts4:311 credit or ad
- Create a Chart4:161 credit or ad
- Resize and Relocate a Chart3:421 credit or ad
- The Chart Toolbar3:141 credit or ad
- Chart Options3:211 credit or ad
- Legends/Titles/Axes3:131 credit or ad
- Series Orientation and Order3:101 credit or ad
- Create 3-D Charts3:571 credit or ad
- Explode a Pie Chart4:021 credit or ad
- Add Data Labels and a Data Table4:351 credit or ad
- Trendlines3:151 credit or ad
- Secondary Axes3:241 credit or ad
- Format Chart Elements4:281 credit or ad
Printing Data and Charts9 lessons
- Create Page Headers and Footers3:381 credit or ad
- See a Print Preview4:511 credit or ad
- Set the Print Area4:161 credit or ad
- Print a Selection3:001 credit or ad
- Centering/ Margins/Gridlines4:071 credit or ad
- Print on a Specific Number of Pages3:421 credit or ad
- Print Multiple Worksheets/Copy/Collate Pages3:141 credit or ad
- Print Row and Column Labels on Every Page4:191 credit or ad
- Print Charts5:001 credit or ad
Sharing and Protecting Data7 lessons
- Share Data Between Workbooks4:321 credit or ad
- Copying/Linking/Embedding Data6:051 credit or ad
- Share Data with Other Programs4:521 credit or ad
- Share a Workbook with Other Users3:171 credit or ad
- Hide Worksheets3:281 credit or ad
- Protect Cells3:121 credit or ad
- Protect Worksheets and Workbooks5:461 credit or ad
Analyzing Data3 lessons
Customizing Excel7 lessons
Graphics and The Drawing Toolbar8 lessons
- Insert a Picture4:521 credit or ad
- Move/Resize/Crop5:391 credit or ad
- Draw Shapes and Lines5:031 credit or ad
- Draw AutoShapes and Assign Macros4:311 credit or ad
- Arrange and Group Drawing Objects4:391 credit or ad
- Use Drawn Objects in Charts2:471 credit or ad
- Create Text Boxes4:411 credit or ad
- Create Worksheet Comments3:461 credit or ad