Back to
Online Training Institute Home


Course CatalogDemo CourseUpcoming CoursesTechnical SupportTraining Center   Back to Training Home


 Other Courses in the Curriculum  Price
 Getting Started with Microsoft Word 2007  $49
 Advanced Features of Microsoft Word 2007  $49
 Getting Started with Microsoft Excel 2007  $49
 Getting Started with Microsoft PowerPoint 2007  $49
 Advanced Features of Microsoft PowerPoint 2007  $49
 Fundamentals of Microsoft Outlook 2007  $49
 Contacts and Messages in Microsoft Outlook 2007  $49
 Advanced Features of Microsoft Outlook 2007  $49
 New Features in Microsoft Office 2007  $49
Price: $49  Back
Course Name Advanced Features of Microsoft Excel 2007
Audience Users who desire to gain the necessary skills to share, print, review, and manage data in workbooks.
Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above.

Plug-in Requirements
  ØMacromedia Flash plug-in for Windows for IE/NN
Pre-requisites
- Familiarity with basic concepts of Windows
- Getting Started with Microsoft Excel 2007 (WBT)
Course Duration 4 hours
Course Objectives This course covers advanced features of Excel 2007 that enable you to specify workbook properties and print workbooks. It also teaches the procedures of sharing, reviewing, and managing workbooks and customizing the Excel 2007 interface. Additionally, the course covers various types of formulas and functions provided by Excel 2007 and the ways to use them.
Course Outline
  1. Managing Workbooks
    1. Specifying File Properties
    2. Printing Workbooks
    3. Quiz
  2. Using Workbooks for Collaboration
    1. Reviewing and Fixing Workbooks
    2. Sharing Workbooks
    3. Recall
    4. Quiz
  3. Working with Formulas and Functions
    1. Creating Formulas
    2. Using References, Constants, and Functions
    3. Quiz
  4. Managing Data
    1. Filtering Data
    2. Sorting Data
    3. Finding and Selecting Data
    4. Quiz
  5. Customizing Excel
    1. Specifying Basic Customization Settings
    2. Specifying Advanced Customization Settings
    3. Do It Yourself
    4. Quiz