The Excel 2002 QUICK Source Learning Series will show you the advanced features of how to use Excel 2002. The QUICK Source Learning Series combines three levels of training: Teaching, Trying, and Testing. The teaching section includes high-quality video so you are able to see what the instructor is teaching you to do. The trying section allows you to practice what you have learned right in our program. There is no need to switch between our software and Excel 2002. The testing section involves a variety of test questions with immediate feedback. Trainers can track users' progress, view test scores, and print out reports.

• WORKBOOKS AND WORKSHEETS
  • Viewing Multiple Worksheets or Workbooks at Once
  • Hiding or Displaying Workbooks
  • Hiding or Displaying Worksheets
  • Hiding or Displaying Worksheet Tabs
  • Changing the Color of Cell Gridlines
  • Hiding Cell Gridlines
  • Printing Cell Gridlines
  • Creating a Custom View
  • Displaying and Printing a Custom View
• ROWS, COLUMNS, AND CELLS
  • Hiding or Displaying Rows or Columns
  • Moving Rows or Columns
  • Using Row and Column Labels in Formulas
  • Naming a Cell or Range of Cells
  • Naming Cells on Multiple Worksheets
  • Formatting Cells
  • Adding Conditional Formatting
  • Finding Cells with Conditional Formatting
  • Creating Styles
• DATA
  • Importing Data
  • Importing Data from a Web Page
  • Importing a Text File
  • Inserting Symbols and Unicode Characters
  • Creating a Custom Fill Series
  • Using a Data Entry Form to Edit a List
  • Copying and Pasting Data
  • Merging or Splitting Data or Cells
  • Grouping and Outlining Data
• FORMULAS
  • Working with Formulas
  • Creating Array Formulas
  • Creating Conditional Formulas
  • Creating Lookup Formulas
  • Using Dates as Values
  • Creating Links
  • Using the Watch Window
  • Auditing Formulas
  • Correcting Formula Errors
• MANAGING DATA
  • Consolidating Data
  • Creating Data Tables
  • Creating PivotTable Reports
  • Creating PivotChart Reports
  • Formatting Reports
  • Adding Data Validation
  • Using Goal Seek
  • Using Solver
  • Creating Scenarios
• PICTURES, DIAGRAMS, AND CHARTS
  • Adding a Shape or Drawing
  • Insert Pictures or Clip Art
  • Working with Text
  • Moving or Grouping Objects
  • Creating a Diagram or Organizational Chart
  • Creating a Chart
  • Formatting a Chart
  • Editing Chart Data
  • Adding Trendlines or Error Bars to Charts
• REVISION, SHARING, AND SECURITY
  • Filtering a List
  • Adding a Comment
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Merging Workbooks
  • Tracking Changes in Shared Workbooks
  • Protecting a Worksheet or Workbook
  • Adding Digital Signatures
  • Removing Protection from a Worksheet or Workbook
• MACROS AND CUSTOMIZATION
  • Creating a Macro
  • Running a Macro
  • Starting Macros from a Graphic Object or Button
  • Working with Macros
  • Creating Forms
  • Working with Forms
  • Customizing Toolbars and Menus
  • Creating a Custom Toolbar
  • Customizing Excel Options

• E02A1 - Workbooks and Worksheets
• E02A2 - Rows, Columns, and Cells
• E02A3 - Data
• E02A4 - Formulas
• E02A5 - Managing Data
• E02A6 - Pictures, Diagrams, and Charts
• E02A7 - Revision, Sharing, and Security
• E02A8 - Macros and Customization

• Microsoft Excel 2002 XP Advanced