| Title |
Description |
Duration |
 |
| Introducing Excel 2007 |
Take a guided tour of the updated Excel 2007 interface |
3:33 |
| Unlocking the Big Grid |
Build enormous worksheets with the new "big grid" |
2:52 |
| The Improved Printing Process |
Use the page layout tools for more precise printing |
3:42 |
| Adding Headers and Footers |
The new "click zones" make it easier than ever to add consistency |
2:36 |
| Quick Access to Cool Templates |
No need to start from scratch - grab a cool new Excel template |
2:08 |
 |
| Create an Interactive Table |
Design a table with interactive filters and easy sort options |
3:56 |
| Working with Table Styles |
Choose from a gallery of styles to enhance your tables |
2:43 |
| Working with Table Formulas |
Automate the process of entering formulas for new columns in a table |
2:22 |
| Remove Duplicates from a Table |
Filter for unique values and remove duplicate values from tables |
3:25 |
 |
| Conditional Formatting |
Emphasize important values with Data Bars, Color Scales, Icons Sets and more |
3:19 |
| Visualizing Data with Charts |
Create and format impressive charts easily with these new tools |
3:58 |
| Illustrating Excel |
Custom design your worksheet with new Smart Art graphics and shapes |
2:57 |
| Working with Text |
Learn how to work with large blocks of text within a workbook |
2:29 |
 |
| The New Look to Formulas |
Check out a function from the new Function Library |
3:52 |
| Investigating Formulas |
Find formulas, check for errors and more using the Formula Auditing tools |
4:18 |
| Enhancing the Status Bar |
Customize the status bar for a quick view of totals and worksheet statistics |
1:57 |
| Understanding Named Ranges |
Introduction to using range names to reference a range of cells in formulas |
3:21 |
| Data Validation |
Control how and what type of type of data is entered into a cell |
3:47 |
| Conditional Sum Functions |
Learn about the new Functions: SUMIFS, COUNTIFS, and AVERAGEIFS |
3:19 |
| Powerful Array Formulas |
Watch how these super-charged formulas can multiply large ranges of data |
3:21 |
 |
| Summarizing Data with SubTotals |
Use Advanced Subtotals to add summary functions to groups of data |
3:43 |
| Copying Visible Cells Only |
Learn how to to copy ranges with hidden rows or columns |
1:29 |
| Grouping and Outlining Data |
Refine how worksheet data is displayed using Group and Outline tools |
2:16 |
| Data Consolidation |
Summarize results into a master worksheet by consolidating data |
4:46 |
 |
| Pivot Table Features |
Create powerful reports by summarizing data without using formulas |
3:04 |
| Filtering Data in Pivot Tables |
Learn to filter data in Pivot Tables with selected criteria |
3:37 |
| Pivot Table Report Layout Views |
Design attractive pivot tables quickly with the Report Layout View |
3:13 |
 |
| The Trust Center |
Tangled up in security? Create Trusted Locations to store your Excel files |
2:23 |
| Security and Privacy |
Learn how to lock down workbooks to prevent unauthorized changes |
3:00 |
| Sharing Workbooks |
Understanding the new format and how to save in earlier versions of Excel |
2:08 |
| Workbook Collaboration |
Build a shared workbook to allow multiple users to view and track changes |
3:00 |
| Connecting to External Data |
Create a web query to import data from a Web site |
2:31 |
