Training Center
Computer Training courses online, at your pace !

Computer Training Online


Or call 800 639 0160

Course catalog - Improve Job Skills or Study For Certification Exams.                              








Excel 2007 Advanced
 Join over 1 million people who learn online, with these complete interactive computer training courses.




See How It Works
This online course includes tutorials for: Time Needed
Filtering and Sorting Data 2 hours
Using Pivot Tables 2 hours
Working with Functions 3 hours
Using Data Analysis Tools 1 hours
Automating with VBA Macros 2 hours
Adding Connections and Importing Data 2 hours
Estimated time needed to complete entire course 12 hours


Receive your login ID to take the training courses online, as many times as you wish, for 1 year.  Click here for group orders.

Buy this entire online training course with one easy payment of $37

OR

Buy the Office Value pack, and receive this course plus many more, for only $97



Benefits
  • Unlimited access for 1 year
  • Learn anytime, anywhere
  • You control the pace
  • Start & stop wherever you want
  • No books to read
  • No software needed
  • Value Packs include Free online tech support
  • Double guarantee
  • 100% Money back guarantee
  • One time payment No monthly fee
  • Use the course index for review anytime
  • Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
  • Free status reports for company managers

Requirements
All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer.  Prices shown are per user.




What You will Learn
The Excel 2007 Advanced online training course 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.




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



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



Working With Functions
  • 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



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



Automating With VBA Macros
  • 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



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








 

 

Copyright © 2007 Advanced TrainingCenter.com