Register your product to gain access to bonus material or receive a coupon.
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Excel 2007
Lesson 16: Maneuvering Through Workbooks and Worksheets [9:48]
Lesson 17: Automatic Data Entry Methods [8:59]
Lesson 18: Formatting Cells Manually, with Styles, and with Themes [8:42]
Lesson 19: Conditional Formatting (Data Bars, Color Scales, Icon Sets) [4:56]
Lesson 20: Basic Excel Formulas [3:30]
Lesson 21: Basic Excel Functions [9:44]
Lesson 22: Excel Function Groups (Advanced Function Possibilities) [4:58]
Lesson 23: Troubleshoot Function Errors [8:31]
Lesson 24: Use Tables to Sort and Filter Data [8:17]
Lesson 25: Creating Pivot Tables [7:45]
Lesson 26: Protecting Your Workbook and Worksheets [11:55]
Lesson 27: Illustrations and Smart Art in Excel [10:16]
Lesson 28: Basic Chart Building [10:42]
Lesson 29: Advanced Chart Creation [12:17]
Lesson 30: Printing Your Worksheets [6:13]
Project 3: Working with a Loan Amortization Table [7:14]