Are you sure you want to cancel your subscription?

If you cancel, your subscription will remain active through the paid term. You will be able to reactivate the subscription until that date.

Sorry to see you go

Your subscription will remain active until . If you change your mind, you may rectivate your subscription anytime before that date.

Are you sure you want to reactivate?
Welcome Back!

Your subscription has been reactivated and you will continue to be charged on .

Reactivate Subscription

Thank you for choosing to reactivate your subscription. In order to lock in your previous subscription rate, you owe: .

Your Subscription term is from - .

Questions? Call Sales.

Payment Due:

Auto-Renew Subscription

To auto-renew your subscription you need to select or enter your payment method in "Your Account" under Manage Payments.

Click continue to set up your payments.

CBT Nuggets License Agreement

Unless otherwise stated all references to “training videos” or to “videos” includes both individual videos within a series, entire series, series packages, and streaming subscription access to CBT Nuggets content. All references to CBT or CBT Nuggets shall mean CBT Nuggets LLC, a Delaware limited liability company located at 44 Country Club Road, Ste. 150, Eugene, Oregon.

A CBT Nuggets license is defined as a single user license. Accounts may purchase multiple users, and each user is assigned a single license.

  • GRANT OF LICENSE. CBT Nuggets grants you a non-transferable, non-exclusive license to use the training videos contained in this package or streaming subscription access to CBT content (the “Products”), solely for internal use by your business or for your own personal use. You may not copy, reproduce, reverse engineer, translate, port, modify or make derivative works of the Products without the express consent of CBT. You may not rent, disclose, publish, sell, assign, lease, sublicense, market, or transfer the Products or use them in any manner not expressly authorized by this Agreement without the express consent of CBT. You shall not derive or attempt to derive the source code, source files or structure of all or any portion of the Products by reverse engineering, disassembly, decompilation or any other means. You do not receive any, and CBT Nuggets retains all, ownership rights in the Products. The Products are copyrighted and may not be copied, distributed or reproduced in any form, in whole or in part even if modified or merged with other Products. You shall not alter or remove any copyright notice or proprietary legend contained in or on the Products.
  • TERMINATION OF LICENSE. Once any applicable subscription period has concluded, the license granted by this Agreement shall immediately terminate and you shall have no further right to access, review or use in any manner any CBT Nuggets content. CBT reserves the right to terminate your subscription if, at its sole discretion, CBT believes you are in violation of this Agreement. CBT reserves the right to terminate your subscription if, at its sole discretion, CBT believes you have exceeded reasonable usage. In these events no refund will be made of any amounts previously paid to CBT.
  • DISCLAIMER OF WARRANTY AND LIABILITY. The products are provided to you on an “as is” and “with all faults” basis. You assume the entire risk of loss in using the products. The products are complex and may contain some nonconformities, defects or errors. CBT Nuggets does not warrant that the products will meet your needs, “expectations or intended use,” that operations of the products will be error-free or uninterrupted, or that all nonconformities can or will be corrected. CBT Nuggets makes and user receives no warranty, whether express or implied, and all warranties of merchantability, title, and fitness for any particular purpose are expressly excluded. In no event shall CBT Nuggets be liable to you or any third party for any damages, claim or loss incurred (including, without limitation, compensatory, incidental, indirect, special, consequential or exemplary damages, lost profits, lost sales or business, expenditures, investments, or commitments in connection with any business, loss of any goodwill, or damages resulting from lost data or inability to use data) irrespective of whether CBT Nuggets has been informed of, knew of, or should have known of the likelihood of such damages. This limitation applies to all causes of action in the aggregate including without limitation breach of contract, breach of warranty, negligence, strict liability, misrepresentation, and other torts. In no event shall CBT Nuggets’ liability to you or any third party exceed $100.00.
  • REMEDIES. In the event of any breach of the terms of the Agreement CBT reserves the right to seek and recover damages for such breach, including but not limited to damages for copyright infringement and for unauthorized use of CBT content. CBT also reserves the right to seek and obtain injunctive relief in addition to all other remedies at law or in equity.
  • MISCELLANEOUS. This is the exclusive Agreement between CBT Nuggets and you regarding its subject matter. You may not assign any part of this Agreement without CBT Nuggets’ prior written consent. This Agreement shall be governed by the laws of the State of Oregon and venue of any legal proceeding shall be in Lane County, Oregon. In any proceeding to enforce or interpret this Agreement, the prevailing party shall be entitled to recover from the losing party reasonable attorney fees, costs and expenses incurred by the prevailing party before and at any trial, arbitration, bankruptcy or other proceeding and in any appeal or review. You shall pay any sales tax, use tax, excise, duty or any other form of tax relating to the Products or transactions. If any provision of this Agreement is declared invalid or unenforceable, the remaining provisions of this Agreement shall remain in effect. Any notice to CBT under this Agreement shall be delivered by U.S. certified mail, return receipt requested, or by overnight courier to CBT Nuggets at the following address: 44 Club Rd Suite 150, Eugene, OR 97401 or such other address as CBT may designate.

CBT Nuggets reserves the right, in its sole discretion, to change, modify, add, or remove all or part of the License Agreement at any time, with or without notice.

Billing Agreement

  • By entering into a Billing Agreement with CBT Nuggets, you authorize CBT Nuggets to use automatic billing and to charge your credit card on a recurring basis.
  • You agree to pay subscription charges on a monthly basis, under the following terms and conditions:
    • CBT Nuggets will periodically charge your credit card each monthly billing cycle as your subscription charges become due;
    • All payments are non-refundable and charges made to the credit card under this agreement will constitute in effect a "sales receipt" and confirmation that services were rendered and received;
    • To terminate the recurring billing process and/or arrange for an alternative method of payment, you must notify CBT Nuggets at least 24 hours prior to the end of the monthly billing cycle;
    • You will not dispute CBT Nugget’s recurring billing charges with your credit card issuer so long as the amount in question was for periods prior to the receipt and acknowledgement of a written request to cancel your account or cancel individual licenses on your account.
  • You guarantee and warrant that you are the legal cardholder for the credit card associated with the account, and that you are legally authorized to enter into this recurring billing agreement.
  • You agree to indemnify, defend and hold CBT Nuggets harmless, against any liability pursuant to this authorization.
  • You agree that CBT Nuggets is not obligated to verify or confirm the amount for the purpose of processing these types of payments. You acknowledge and agree that Recurring Payments may be variable and scheduled to occur at certain times.
  • If your payment requires a currency conversion by us, the amount of the currency conversion fee will be determined at the time of your payment. You acknowledge that the exchange rate determined at the time of each payment transaction will differ and you agree to the future execution of payments being based on fluctuating exchange rates.

CBT Nuggets reserves the right, in its sole discretion, to change, modify, add, or remove all or part of the Billing Agreement at any time, with or without notice.

Microsoft Office 2010 Excel 77-882

Exam 77-882

Course Duration: 08:35:42
Installing Office 2010
As with any new application suite, it's always good to review the installation. With Office 2010 there are a few gotchas and things to watch out for, however the most important part of this training will be how you customize the installation if necessary.
Excel Workspace Fundamentals
There are definitely similarities in the look and feel of Excel 2010 compared to Excel 2007, however there are differences between the two as well as a HUGE difference between Excel 2010 and older versions such as 2003 and 2000. The Office Ribbon remains as does the QAT (Quick Access Toolbar), however the Office Button is gone replaced by the File tab and "Backstage." With this training video, we will look at what changes Microsoft has made to assist you in your document and work flow.
Data and Content Fundamentals
When you look at the screen after opening up Excel 2010, you'll notice that it's blank. Nothing there? You need to fill in the worksheets with data and content, but what does Excel handle when it comes to content? Learn how text, numbers, symbols, and even graphics can be manipulated, calculated, and just plain discombobulated with this training video on Excel 2010.
Data and Content Formatting - Cells
Once you get some numbers or text into a cell, what else can you do with them? In this Nugget we see how we can change the look and feel with different Fonts, adding borders to the sells, aligning the text to the top, bottom, left, or right, and finally looking at Quick Styles.
Data and Content Formatting - Cells Advanced
For the certification exam, there are a few things Microsoft expects you to know and understand when it comes to cell formatting. We'll look at how to merge cells and their content together, use format painter, advanced styles, and even put some hyperlinks into play.
Data and Content Formatting - Rows, Columns, Worksheets
There's more to Excel than just cells. You have rows, columns, even multiple worksheets that can be formatted and manipulated. We look at how we resize our rows and columns, insert and delete, freeze, and even hide rows and columns. We'll also take a look at Worksheet behaviors and formatting.
Print and Page Setup
Most people look at Excel on their monitors or laptops, however there are occasions when you are going to want to print out a report on that spreadsheet or perhaps show everyone the charts that are produced by your data. Excel 2010 has upped the ease of use when it comes to printing and you'll find out how and why in this Nugget.
Database Functionality
While you can use a SQL database, Access, or some other database program, Excel 2010 has many of the functions that are performed by databases and you can just as easily sort, filter, hunt for duplicates, and other database features. We'll also look at functions that produce different results and look at creating new datasets.
Charts and Graphics - Basic
Images can really help people understand the information that is in front of them on their Excel spreadsheets. The impact a chart or graph brings to the table is huge! Check out this Nugget for some great ways to bring your data to life.
This training Nugget will cover pivot tables. This is a great feature that really lets you create flexibility and analyze data better than ever before. You will never look at Excel the same again.
Charts and Graphics - Advanced
Not only can you put in histograms, pie-charts, and Venn diagrams into Excel 2010, but now there are ways for you to put a small graphic WITHIN a cell to showcase trends (trendlines) and also runcharts (Sparklines). Plus we look at PivotCharts, taking a PivotTable to the next level.
Introduction to Formulas and Functions
You can have a lot of data, especially numbers, all over the place. What if you want to add them up, average them out, count how many cells are filled? That's where the calculating side of Excel comes into play as we look at basic formulas and functions.
Advanced Functions and Formulas
Ready to calculate payments on your house? Want to find out the future value of something? Advanced functions take a look at the Financial side of things as well as showing the structure of a functional argument in a slightly different perspective.
Conditional Formulas
Many people never took logic as a class in high school or college, but logic is important when it comes to conditional formulas. That is why we will go over some login in this training video. We'll look at "if" "and" "or" statements to help create situational and logical functions.
Data Summarization
Organizing your data can be tough sometimes, but Excel 2010 is all about helping you make sense of the information on the screen. With the help of Subtotals and Outlines, users can more clearly see what it happening on their page.
Securing Data
Sometimes you don't want people messing with your numbers, changing your Excel Workbooks, or even allowing them access to the files. In this training video, we will cover; encryption, you can password protect your files, assign digital signatures to identify appropriate users and to keep the integrity of the data intact.
What-If Analysis
There are many times you would like to see if the results change on your spreadsheet if there are different scenarios or perhaps changed data. With Goal Seek, Data Tables, and Scenario manager, you can perform these "pretend" situations on your data without harming the original data!
We all need help sometimes on our spreadsheets and Excel 2010 along with the rest of the Office 2010 series makes it easy for users to interact with each others work. Whether it's just putting a few comments on the worksheet or actually tracking changes on a shared file, Excel 2010 has you covered.
Advanced Customization
If you plan on taking the Microsoft 77-882 Certification exam, you'll need to know the tips in this CBT Nugget. We look at customizing our Ribbon, QAT, and even do Data Validation. For a little extra bonus, we also look at Macros and how these VBA scripts can help automate things we do over and over again.

No Bookmarks

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

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 Chris Ward's Excel 2010 video series, you'll be the data wiz 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.

This forum is for community use – trainers will not participate in conversations. Share your thoughts on training content and engage with other members of the CBT Nuggets community. 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
Community Standards

We encourage you to share your wisdom, opinions, and questions with the CBT Nuggets community. To keep things civil, we have established the following policy.

We reserve the right not to post comments that:
contain obscene, indecent, or profane language; contain threats or defamatory statements; contain personal attacks; contain hate speech directed at race, color, sex, sexual orientation, national origin, ethnicity, age, religion, or disability; contributes to a hostile atmosphere; or promotes or endorses services or products. Non-commercial links, if relevant to the topic, are acceptable. Comments are not moderated, however, all comments will automatically be filtered for content that might violate our comment policies. If your comment is flagged by our filter, it will not be published.

We will be continually monitoring published comments and any content that violates our policies will be removed. Users who repeatedly violate our comments policy may be prohibited from commenting.
Chris Ward

Chris Ward

CBT Nuggets Trainer

A+ 2003, Network+, iNet +, MCSE Windows 2000 CCNA, CCDA, CCNP, CWLSS, PMP

Area of Expertise:
Project Management. Microsoft Office, Cisco Wireless, End User training, Train the Trainer skills

Course Features

Speed Control

Play videos at a faster or slower pace.


Pick up where you left off watching a video.


Jot down information to refer back to at a later time.

MP3 Downloads

Listen to videos anytime, anywhere


Files/materials that supplement the video training
Your browser cannot access Virtual Labs
Add training to a playlist
or create a new list
Add to current playlist
or add to an existing list
Add to new playlist