Microsoft Excel 2007: Beyond the Basics


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number

Overview/Description
This course introduces learners to the advanced features and functions of Excel 2007. Learners will be able to demonstrate competence in using Excel 2007 to perform tasks such as working with built-in functions, presenting data, auditing and exporting data, and using analytical options and macros.

Target Audience
The audience for this course consists of small office/home office (SOHO) users to all levels of business users. These users possess basic to intermediate PC skills and want to use Excel 2007 as a productivity tool. They have a couple of years of experience using a PC and have limited experience with Excel.

Expected Duration (hours)
4.0

Lesson Objectives

Microsoft Excel 2007: Beyond the Basics

  • Use Decision-Making Functions.
  • Use Lookup and Database Functions.
  • Work with Data.
  • Work with PivotTables and Pivot Charts.
  • Audit Data.
  • Export Data.
  • Use Analytical Options.
  • Work with Macros.

    • Course Number:
    KN00076031_ng