The Excel 2003 QUICK Source Learning Series will show you the advanced features of how to use Excel 2003. 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 2003. 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
  • Hiding or Displaying Workbooks
  • Hiding or Displaying Worksheets
  • Hiding or Displaying Worksheet Tabs
  • Adding a Background to a Worksheet
  • Creating a Custom View
  • Displaying and Printing a Custom View
  • Sharing a Workbook
  • Editing a Shared Workbook
  • Displaying or Hiding Scroll Bars or the Status Bar
  • Creating Custom Headers and Footers
• Rows, Columns, and Cells
  • Hiding or Displaying Rows or Columns
  • Moving Rows or Columns
  • Using Row and Column Labels in Formulas
  • Creating a 3-D Reference
  • Formatting Cells
  • Merging 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
  • Grouping and Outlining Data
• Formulas
  • Working with Formulas
  • Creating Array Formulas
  • Creating Conditional Formulas
  • Creating Lookup Formulas
  • Using Dates as Values
  • Creating Links
  • Auditing Formulas
  • Correcting Formula Errors
  • Customizing How Formulas are Calculated
• Managing Data
  • Consolidating Data on Multiple Worksheets
  • Creating PivotTable Reports
  • Creating PivotChart Reports
  • Formatting PivotTable Reports
  • Formatting PivotChart Reports
  • Designating Valid Cell Entries
  • Creating Data Tables
  • Working with Data Tables
  • Using Goal Seek
  • Using Solver
  • Creating Scenarios
• Pictures, Diagrams, and Charts
  • Inserting a Shape
  • Inserting Pictures or Clip Art
  • Working with Text
  • Grouping Objects
  • Creating a Diagram or Organization Chart
  • Creating a Chart
  • Formatting a Chart
  • Editing Chart Data
  • Adding Trendlines or Error Bars to Charts
• Revision and Security
  • Filtering a Range
  • Adding a Comment
  • Merging Workbooks
  • Tracking Changes in Shared Workbooks
  • Protecting a Worksheet
  • Protecting a Workbook
  • Adding Digital Signatures
• Macros and Customization
  • Changing the Macro Security Level
  • Creating a Macro
  • Assigning a Macro to a Button or Menu Item
  • Running a Macro
  • Deleting a Macro
  • Customizing Toolbars and Menus
  • Creating a Custom Toolbar
  • Customizing Excel Options

• E03A1 - Workbooks and Worksheets
• E03A2 - Rows, Columns, and Cells
• E03A3 - Data
• E03A4 - Formulas
• E03A5 - Managing Data
• E03A6 - Pictures, Diagrams, and Charts
• E03A7 - Revision and Security
• E03A8 - Macros and Customization

• Microsoft Excel 2003 Advanced