50 Best Excel® 2007 Tips, Tricks & Techniques

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.Beginning Level Topics

• Customizing AutoFill Options – Runtime: 7:45
• Customizing the QAT – Runtime: 5:30
• Entering Formulas & Functions – Runtime: 6:01
• Entering Data Efficiently – Runtime: 7:34
• Exploring Excel Options – Runtime: 7:49
• Exploring Status Bar Tools – Runtime: 4:42
• Formatting & 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

Intermediate Level Topics

• 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

Advanced Level Topics

• Auditing Formulas – Runtime: 6:43
• Grouping & 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 PivotTable Features – Runtime: 7:46