The Excel 2007 QUICK Source Learning Series will show you the basics of how to use Excel 2007. 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 2007. The testing section involves a variety of test questions with immediate feedback. Trainers can track users’ progress, view test scores, and print out reports.

• Getting Started
  • Introduction
  • Starting and Exiting Microsoft Excel
  • Identifying the Parts of the Word 2007 Window
  • Using the Ribbon
  • Customizing the Quick Access Toolbar
  • Opening a Workbook
  • Creating a New Blank Workbook
  • Creating a New Workbook Based on a Template
  • Saving a Workbook
  • Saving a Workbook in Another Format
• Workbooks and Worksheets
  • Introduction
  • Inserting a Worksheet
  • Renaming a Worksheet
  • Moving or Copying a Worksheet
  • Deleting a Worksheet
  • Color Coding a Worksheet Tab
  • Creating Headers and Footers
  • Viewing Multiple Workbooks or Worksheets
  • Comparing Workbooks or Worksheets Side by Side
• Cells, Rows, and Columns
  • Introduction
  • Selecting Cells, Rows, or Columns
  • Inserting Cells
  • Inserting a Row or Column
  • Adjusting Row Height or Column Width
  • Deleting a Cell, Row, or Column
  • Merging Cells
  • Naming a Cell or Range of Cells
  • Hiding or Displaying Rows or Columns
• Data and Views
  • Introduction
  • Entering Data
  • Using the AutoFill Feature
  • Moving or Copying Data
  • Using the Office Clipboard
  • Using the Repeat, Undo, and Redo Commands
  • Finding and Replacing Text
  • Sorting and Filtering Data
  • Freezing a Row or Column
  • Splitting Worksheet Panes
  • Using the Research Task Pane
• Formatting Cells
  • Introduction
  • Specifying a Number Format for a Cell
  • Changing the Font, Font Size, and Color
  • Applying Bold, Italics, or Underline to Text
  • Using the Mini Toolbar
  • Aligning Text
  • Display Multiple Lines of Text in a Cell
  • Formatting Cell Borders
  • Applying Shading to Cells
  • Using the Format Painter
  • Clearing Cell Formatting or Contents
• Formulas
  • Introduction
  • Creating and Editing a Formula
  • Inserting a Function
  • Using the Function Library
  • Using the Sum Button
  • Moving or Copying a Formula
  • Working with Formulas
  • Using the Watch Window
• Output
  • Introduction
  • Setting Up the Print Area
  • Printing Gridlines and Headings
  • Printing Sheet Names
  • Working with Page Breaks
  • Previewing a Worksheet
  • Printing a Worksheet or Selection
  • E-Mailing a Workbook
  • Running the Compatibility Checker
• Getting Help
  • Introduction
  • Using Excel Help
  • Using the Help Table of Contents
  • Searching for Help Topics
  • Getting Help in a Dialog Box
  • Getting Help from Office Online
  • Printing a Help Topic
  • Displaying Access Keys

For quantity pricing or to order courses: (QUICKsource@QUICKsourceLearning.com)

• E07B1 - Getting Started
• E07B2 - Workbooks and Worksheets
• E07B3 - Cells, Rows, and Columns
• E07B4 - Data and Views
• E07B5 - Formatting Cells
• E07B6 - Formulas
• E07B7 - Output
• E07B8 - Getting Help

• Excel 2007 Basic