Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

Specialist training for Microsoft Office Excel 2007 77-602: MCAS

This course will be retired in 294 days. If you have questions, please contact us.

This video training with Emily Barry covers the 2007 edition of Microsoft Excel, including spreadsheet formatting, data integrity, and more....
This video training with Emily Barry covers the 2007 edition of Microsoft Excel, including spreadsheet formatting, data integrity, and more.

Recommended skills:
  • Familiarity with Excel 2007
  • Experience using previous editions of Excel

Recommended equipment:
  • Microsoft Excel 2007

Related certifications:
  • Microsoft Office Specialist: Microsoft Office Excel 2007

Related job functions:
  • Office professionals
  • Information workers
  • Instructors

Excel is a powerful spreadsheet tool. With the release of Excel 2007, it's become even more powerful -- including lots of new features and a dramatically changed interface.

CBT Nuggets' detailed video course carefully explains this new interface and how to make the most out of Excel 2007's updated features.

Trainer Emily Berry fast-forwards you through the program. She shows you exactly what you need to know to accomplish your familiar tasks within the changed interface, while carefully mapping her training to Microsoft MCAS certification exam 77-602.

All trademarks and copyrights are the property of their respective holders.
 show less
1. Introduction to Excel (26 min)
2. Excel 2007 Basics (26 min)
3. Spreadsheet Formatting (26 min)
4. Use Excel as a Database (28 min)
5. Charts (24 min)
6. Collaborate Data (28 min)
7. Consolidate Data (25 min)
8. Pivot Tables (28 min)
9. Basic Formulas (27 min)
10. Conditional Formulas (24 min)
11. Data Integrity (27 min)
12. Summarize Data (26 min)
13. Prepare for Printing and Distribution (29 min)
14. Data Security (24 min)
15. What-If Analysis (24 min)

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
7 hrs 15 videos


Training Features

Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Included in this course
Pick up where you left off watching a video.

Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.