The Excel 2007 QUICK Source Learning Series will show you the advanced features 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.

• Workbooks and Worksheets
  • Introduction
  • Hiding or Displaying Workbooks
  • Hiding or Displaying Worksheets
  • Hiding or Displaying Worksheet Tabs
  • Adding a Background to a Worksheet
  • Working with Custom Views
  • Sharing a Workbook
  • Editing a Shared Workbook
• Cells, Rows, and Columns
  • Introduction
  • Hiding or Displaying Rows and Columns
  • Moving or Copying Rows and Columns
  • Splitting Cell Contents Across Multiple Cells
  • Formatting Cells
  • Adding Conditional Formatting
  • Creating a New Conditional Formatting Rule
  • Finding Cells with Conditional Formatting
  • Creating Cell Styles
  • Creating a 3-D Reference
• Data
  • Introduction
  • Performing a Custom Sort
  • Filtering Data Using Advanced Filter Criteria
  • Importing Data
  • Importing Data from a Web Page
  • Importing a Text File
  • Inserting Symbols and Unicode Characters
  • Creating a Custom Fill Series
  • Copying and Pasting Data
  • Inserting Subtotals in a List
  • Grouping and Outlining Data
  • Inserting a Hyperlink
• Formulas
  • Introduction
  • Creating Array Formulas
  • Creating Conditional Formulas
  • Using the Lookup Wizard
  • Creating Lookup Formulas
  • Using Dates as Values
  • Creating Links
  • Tracing Formula Relationships
  • Correcting Formula Errors
  • Customizing How Formulas are Calculated
• Illustrations and Charts
  • Introduction
  • Inserting a Picture or Clip Art
  • Inserting a Shape
  • Inserting a SmartArt Graphic
  • Working with Text
  • Grouping Objects
  • Creating a Table
  • Creating a Chart
  • Working with Chart Design Tools
  • Working with Chart Layout Tools
  • Working with Chart Format Tools
  • Adding Trendlines and Error Bars to a Chart
• Managing Data
  • Introduction
  • Consolidating Data on Multiple Worksheets
  • Creating a PivotTable Report
  • Using PivotTable Tools
  • Creating a PivotChart Report
  • Using PivotChart Tools
  • Designating Valid Cell Entries
  • Creating a Drop-Down List
  • Creating Data Tables
  • Using Goal Seek
  • Using Solver
  • Creating Scenarios
• Revision and Security
  • Introduction
  • Using a Custom Filter
  • Protecting a Worksheet
  • Protecting a Workbook
  • Protecting and Sharing a Workbook
  • Adding a Comment
  • Tracking Changes in Shared Workbooks
  • Merging Workbooks
  • Using the Trust Center
• Macros and Customization
  • Introduction
  • Displaying the Developer Tab
  • Recording a Macro
  • Running a Macro
  • Deleting a Macro
  • Changing the Macro Security Level
  • Customizing New Workbook Options
  • Customizing Formula and Error Checking Options
  • Customizing Proofing Options
  • Customizing How Workbooks are Saved
  • Customizing Advanced Excel Options

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

• E07A1 - Workbooks and Worksheets
• E07A2 - Cells, Rows, and Columns
• E07A3 - Data
• E07A4 - Formulas
• E07A5 - Illustrations and Charts
• E07A6 - Managing Data
• E07A7 - Revision and Security
• E07A8 - Macros and Customization

• Excel 2007 Advanced