1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 

"I would like to take the opportunity to let you know how much we enjoyed our instructor. She was ver..." More quotes

Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe Training
◊ ONLINE EXCEL 2007 ADVANCED TRAINING

Save money by buying series in packages. This course series is included with the following package:

Packages include 24/7 access to subject matter experts.

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

Overview | Catalog | Benefits | FAQs | Try Free Course | Buy | Log in | Support

Online Training

Only $99.95
12-month subscription

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.

Excel 2007 Advanced Series (12 hours)

ONLINE TRAINING FEATURES

  • 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. Filtering and Sorting Data

Time: 2 hours
This course provides information on how to filter and sort your worksheets in Excel 2007.

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

Topics

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

2. Using Pivot Tables

Time: 2 hours
This course explains how to create and use pivot tables in Excel 2007.

Objectives

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

Topics

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

3. Working with Functions

Time: 3 hours
This course introduces the use of Excel 2007 functions.

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

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. Using Data Analysis Tools

Time: 1 hours
This course provides an introduction to the commands used to analyze data in Excel 2007.

Objectives

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

Topics

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

5. Automating with VBA Macros

Time: 2 hours
This course introduces the use of macros in Excel 2007.

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

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. Adding Connections and Importing Data

Time: 2 hours
This 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.

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

Topics

  • Connecting Two Worksheets
  • Connecting Two Workbooks
  • Connecting to Data on a Web Page
  • Connecting to a Text File
  • Connecting to a Database
home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2009 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA