I truly enjoyed my Advanced Javascript Programming class with Steve Claflin. His breadth of information added... More Testimonials »

Excel 2007 Advanced eLearning Course

  1. Overview
  2.  | 
  3. Catalog
  4.  | 
  5. Packages
  6.  | 
  7. Benefits
  8.  | 
  9. FAQs
  10.  | 
  11. Try Free
  12.  | 
  13. Cancellation
  14.  | 
  15. Login
  16.  | 
  17. Support
Click here for Microsoft Official Curriculum eLearning courses
Save money by buying eLearning courses in packages.

Packages include multiple eLearning courses that are bundled together for a great value.

Of course, you can buy this Excel 2007 Advanced eLearning course individually as well. Just click on the "Register Now" button below.

Excel 2007 Advanced eLearning Course Series (12 hours)

The Excel 2007 Advanced series teaches you to apply filters, use formulas and analyze data. You will be able to apply your knowledge to create complex business applications and analyses in Microsoft Excel.

Self-Paced eLearning Course Benefits

Only $99.95

12-month subscription!

Register Now

  • Learn online with these interactive online courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the courses
  • Retake the courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Excel 2007 Advanced:1 Filtering and Sorting Data (Time: 2 hours)

This eLearning course provides information on how to filter and sort your worksheets in Excel 2007.

Course Objectives

  • Remove duplicate records from an Excel worksheet
  • Apply filters to an Excel worksheet
  • Apply one-click, multiple-level, and custom sorts to your data

Course Topics

  • Removing duplicate records
  • Using filters
  • Setting filter options
  • Sorting data
  • One-click and custom sorting

2. Excel 2007 Advanced:2 Using Pivot Tables (Time: 2 hours)

This eLearning course explains how to create and use pivot tables in Excel 2007.

Course Objectives

  • Create pivot tables
  • Modify pivot tables
  • Use pivot tables to quickly and easily analyze complex data sets
  • Apply pivot tables for common uses

Course Topics

  • Creating Pivot Tables
  • Viewing Pivot Tables
  • Formatting Pivot Tables
  • Grouping and Filtering Data in Pivot Tables
  • Exploring Pivot Tables

3. Excel 2007 Advanced:3 Working with Functions (Time: 3 hours)

This eLearning course introduces the use of Excel 2007 functions.

Course Objectives

  • Calculate results with math functions
  • Use date and time functions
  • Adjust text with functions
  • Work with logic and information functions
  • Use lookup functions to locate data
  • Determine payments with financial functions
  • Use statistical functions to determine relationships

Course Topics

  • Using functions in Excel
  • Calculating with math functions
  • Using date and time functions
  • Using functions to adjust text
  • Making decisions with logical functions
  • Testing with information functions
  • Finding data with lookup functions
  • Calculating payments with financial functions
  • Finding relationships with statistical functions

4. Excel 2007 Advanced:4 Using Data Analysis Tools (Time: 1 hours)

This eLearning course provides an introduction to the commands used to analyze data in Excel 2007.

Course Objectives

  • Use What-If analysis in Excel 2007
  • Create analyses with Scenario Manager
  • Analyze data using Goal Seek
  • Install Solver

Course Topics

  • Using What-If Analysis
  • Creating Analyses with Scenario Manager
  • Using Goal Seek
  • Exploring Solver

5. Excel 2007 Advanced:5 Automating with VBA Macros (Time: 2 hours)

This eLearning course introduces the use of macros in Excel 2007.

Course Objectives

  • Enable the Developer tab on the Ribbon
  • Modify macro security settings
  • Record and run macros
  • Record a macro that uses an advanced filter
  • Customize macros for everyday use
  • Combine elements of written code with recorded code

Course Topics

  • Setting VBA security
  • Recording and Running Macros
  • Using the End Key
  • Filtering with Macros
  • Understanding VBA Code
  • Writing Macros
  • Controlling and Combining Macros

6. Excel 2007 Advanced:6 Adding Connections and Importing Data (Time: 2 hours)

This eLearning course provides detail about connecting worksheets and workbooks for automatic sharing and updating. It also provides detail about importing information from the Web, text files, XML data, Access documents, and other files from external data sources.

Course Objectives

  • Connect two worksheets in separate workbooks
  • Use the Links tab on the Trust Center
  • Set up a connection to a Web page
  • Import an XML file
  • Connect to an Access database using Microsoft Query

Course Topics

  • Connecting Two Worksheets
  • Connecting Two Workbooks
  • Connecting to Data on a Web Page
  • Connecting to a Text File
  • Connecting to a Database
Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Contact Us
  7. Sitemap
  8. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Compare Webucator to leading Competitors
Microsoft Certified Learning Solutions

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723