|
|
Title |
Duration |
|
|
|
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.
|
00:23:07 |
|
|
|
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.
|
00:22:24 |
|
|
|
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.
|
00:24:04 |
|
|
|
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.
|
00:19:40 |
|
|
|
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.
|
00:30:41 |
|
|
|
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.
|
00:26:31 |
|
|
|
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.
|
00:21:57 |
|
|
|
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.
|
00:40:16 |
|
|
|
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.
|
00:28:18 |
|
|
|
PivotTables
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.
|
00:31:30 |
|
|
|
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.
|
00:21:43 |
|
|
|
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.
|
00:22:25 |
|
|
|
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.
|
00:35:06 |
|
|
|
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.
|
00:29:52 |
|
|
|
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.
|
00:22:02 |
|
|
|
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.
|
00:27:35 |
|
|
|
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!
|
00:34:31 |
|
|
|
Collaboration
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.
|
00:25:34 |
|
|
|
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.
|
00:28:26 |
