Learn to master Excel 2007 by watching a master reveal how easy it is to use the most popular and practical features of the world?s most powerful spreadsheet program. Start wherever and whenever you want. These 50 mini-programs add up to over 5 1/2 hours of training for beginning, intermediate and advanced Excel users.

Watch Short Video Tour of “The 50 Best Tips for Excel 2007” DVD

• Customizing AutoFill Options - Runtime: 7:45
• Customizing the QAT - Runtime: 5:30
• Entering Formulas and Functions - Runtime: 6:01
• Entering Data Efficiently - Runtime: 7:34
• Exploring Excel Options - Runtime: 7:49
• Exploring Status Bar Tools - Runtime: 4:42
• Formatting and Aligning Cells - Runtime: 6:24
• Formatting with Cell Styles - Runtime: 6:06
• Getting Started in Excel 2007 - Runtime: 5:49
• Grouping Worksheets - Runtime: 5:50
• Naming Cells and Ranges - Runtime: 6:33
• Pasting Your Data - Runtime: 5:27
• Printing Your Worksheet - Runtime: 6:16
• Sorting Your Data - Runtime: 7:25
• Using Paste Special - Runtime: 5:49
• Working with Templates - Runtime: 5:25

• Annotating Your Workbook - Runtime: 8:22
• Applying Themes - Runtime: 4:27
• Bringing Charts to Life - Runtime: 7:27
• Calculating Time - Runtime: 8:15
• Charting Data - Runtime: 7:23
• Conditional Formatting - Runtime: 8:43
• Consolidating Data - Runtime: 5:19
• Counting Functions - Runtime: 6:07
• Creating Subtotals - Runtime: 6:45
• Decision-Making Formulas - Runtime: 5:04
• Defining Named Constants - Runtime: 6:47
• Editing Charts - Runtime: 6:41
• Extracting Text Strings - Runtime: 6:44
• Filtering Your Data - Runtime: 6:32
• Introducing Excel Tables - Runtime: 6:50
• Joining Text Strings - Runtime: 6:18
• Pasting Links Between Workbooks - Runtime: 7:52
• Preventing Formula Errors - Runtime: 6:21
• Protecting Your Worksheet - Runtime: 5:01
• Removing Duplicate Records - Runtime: 6:58
• Saving Time with Shortcuts - Runtime: 9:17
• Summing Functions - Runtime: 6:34
• Validating Your Data - Runtime: 7:26

• Auditing Formulas - Runtime: 6:43
• Grouping and Charting in Pivot Tables - Runtime: 5:50
• Importing External Data - Runtime: 7:31
• Introducing Pivot Tables - Runtime: 8:23
• Looking Up Information - Runtime: 6:39
• Performing "What-if" Analysis - Runtime: 5:29
• Producing Financial Reports - Runtime: 7:21
• Solving Problems with Goal Seek - Runtime: 5:57
• Using Conditional Sum Wizard - Runtime: 7:36
• Using Lookup Wizard - Runtime: 5:50
• Using New Pivot Table Features - Runtime: 7:46