Register for Excel 2007 - Advanced


REGISTER EARLY! - Here's Why...
This ILT Series course builds on the skills and concepts taught in Excel 2007: Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web. Comes with CertBlaster exam prep software (download). Also available with a companion CBT program and student data files on CD-ROM. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Excel 2007 exam (77-602). For comprehensive certification training, students should complete Excel 2007: Basic, Intermediate, and Advanced.
Please note that this course in not appropriate for those students using Mac computers running the Mac version of Microsoft Office.  This course is only appropriate for those using PCs running the Windows version of Microsoft Office.

 View Full Course Outline / Additional Class Dates

Attend Class Right From Your Home or Office

  • Live instructor teaches you and gives you hands-on exercises
  • Classes delivered from 10:00AM to 5:00PM Eastern
  • You get a break every 2 hours
  • Students hear and ask questions instantly to the instructor
  • Students see the instructor's live presentation on their own computers
  • The instructor can view and assist students on their local computers
  • All class materials are sent by mail

Download PDF with Full Details & Tech Requirements

Student Testimonials

"I thought online training wouldn't be that accurate, but attending this class change my perspective with it. And I would recommend it to everyone. With this class I learned a lot of things about excel and I didn't realize that we would be able to cover all the pages from the book. Great session!"
Jai R. - Creganna TACTX Medical

"It was great having an interactive class. I feel like I learned a lot...very good instructor!"
Kristi D. - End Stage Renal Disease Network of Texas

"The class was very helpful in teaching the basics of Project 2007. I thought the instructor did a great job of making the class interactive. It was a very conversational and comfortable learning environment. I intend to sign up for another class through Certified Staffing in the future. Thank you."
Pamela K - Individual

"Very knowledgeable instructor, extremely well structured learning atmosphere."
Corey A. - Cumberland County North Carolina

"Jeffry was a great instructor and I can honestly say I enjoyed the course with him. He was very clear, patient, and helpful in answering the additional questions I had for him. I will highly recommend this course and Jeffrey as an instructor to anyone who is interested in taking an Excel course. Thank you Jeffry!"
Kari B. - KaemingK

"Put together really well, I dint feel rushed, or lost. Great course. Thanks!"
Patrick F - Individual

Loading

News:

Attend Class Right From Your Home or Office

  • Live instructor teaches you and gives you hands-on exercises
  • Classes delivered from 10:00AM to 5:00PM Eastern
  • You get a break every 2 hours
  • Students hear and ask questions instantly to the instructor
  • Students see the instructor's live presentation on their own computers
  • The instructor can view and assist students on their local computers
  • All class materials are sent by mail

Register for a Class | Download PDF with Full Details

Private Training for a Group at Your Office

  • A Certified Instructor will come to your office and personally train the students
  • Course can be fully customized to your training needs
  • Each student receives a Course Manual with Practice Files (Materials provided before the class date)
  • Course is scheduled based on dates you provide (Subject to instructor availability)
  • We usually require about 3-4 weeks lead time to arrange a training session
  • Training is completed in a convenient session(s) of your choosing
  • Two 15 minute breaks and one hour long break for lunch daily

Request a Quote