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.

Exam 77-882

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

This OfficeSuite video training with Chris Ward covers Microsoft’s powerful spreadsheet application, including data and content formatting, securing data, and more....
This OfficeSuite video training with Chris Ward covers Microsoft’s powerful spreadsheet application, including data and content formatting, securing data, and more.

Related area of expertise:
  • Office productivity

Recommended skills:
  • Familiarity with Microsoft Excel 2010
  • Familiarity with previous versions of Microsoft Excel

Recommended equipment:
  • Microsoft Excel 2010

Related certifications:
  • Microsoft Office Specialist: Microsoft Excel 2010

Related job functions:
  • Office professionals
  • Accountants
  • Information workers
  • Salespeople
  • Students

Businesses need employees who can turn financial data, sales numbers, and production values into spreadsheets, charts, graphs, and images. After watching this Excel 2010 video training, you'll be the data pro they're looking for.

Excel 2010 is more than just a facelift from the previous version of Excel. It includes some serious new tools, including:

* Sparklines - summarize report data with small single-cell charts.
* Slicers - show the hidden values in your PivotTables.
* Improved Conditional Formatting - databars, custom Icon sets and more.
* Better image editing.
* Better Math Equation Editor.
* Better customizations.
 show less
1. Installing Office 2010 (23 min)
2. Excel Workspace Fundamentals (22 min)
3. Data and Content Fundamentals (24 min)
4. Data and Content Formatting - Cells (19 min)
5. Data and Content Formatting - Cells Advanced (30 min)
6. Data and Content Formatting - Rows, Columns, Worksheets (26 min)
7. Print and Page Setup (21 min)
8. Database Functionality (40 min)
9. Charts and Graphics - Basic (28 min)
10. PivotTables (31 min)
11. Charts and Graphics - Advanced (21 min)
12. Introduction to Formulas and Functions (22 min)
13. Advanced Functions and Formulas (35 min)
14. Conditional Formulas (29 min)
15. Data Summarization (22 min)
16. Securing Data (27 min)
17. What-If Analysis (34 min)
18. Collaboration (25 min)
19. Advanced Customization (28 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
Entry 9 hrs 19 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.