Log into Training View Cart Home Page

Learning Resources

Course Categories

Student Login

Username
Password

Login Help

Information

Risk Free Guarantee

7-Day Money Back Guarantee. If you are not completely satisfied with the quality of our online training courses we'll refund your money

more>>

Excel 2007 Advanced Course

Total Topics: 6 Total Time: 12.00 hour(s) Subscription Term: 12 month(s)

Summary:
The Excel 2007 Advanced 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.

Certification:


Audience:

This course is for anyone interested in learning about advanced data analysis features of Excel 2007.

Features:

  • Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
  • Audio accompanies each lesson page throughout the topic.
  • Show Me Hows allow learners to access instructional demonstrations from all topics in the course.
  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • Activities allow learners to apply topic concepts in an interactive questioning environment.
  • Full-page images allow learners to experience an application as if it were open on their computer.
  • Exercises allow learners to practice in the actual application being studied.
  • A Course topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same topic.
  • Search text enables learners to rapidly search all text within a topic to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks a learner's progress in a topic.
Excel 2007 Advanced Training
6 topic(s)
$38.99

Topics Include:
Excel 2007 Advanced Course: Filtering and Sorting Data
2.0 hour(s)
07ae01
Excel 2007 Advanced Course: Using Pivot Tables
2.0 hour(s)
07ae02
Excel 2007 Advanced Course: Working with Functions
3.0 hour(s)
07ae03
Excel 2007 Advanced Course: Using Data Analysis Tools
1.0 hour(s)
07ae04
Excel 2007 Advanced Course: Automating with VBA Macros
2.0 hour(s)
07ae05
Excel 2007 Advanced Course: Adding Connections and Importing Data
2.0 hour(s)
07ae06