HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
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.
Additional sample videos, individual lessons and other formats are available here.
Register your product to gain access to bonus material or receive a coupon.
Part III: Formulas
These 13 lessons are lucky for you! You’ll spend less than 90 minutes learning terrific tricks of the formula trade. Lessons include:
24 AutoSum Tricks
25 Formula Auditing
26 Three Ways of Entering Formulas
27 Relative Versus Absolute Formulas
28 Tables and Table Formulas
29 Discovering Functions such as PMT
30 Goal Seek
31 What-If with Data Table
32 IF Formulas, including IFERROR & SUMIFS
33 VLOOKUP
34 Date and Time, including time in excess of 24 hours, format as Qtr, NETWORKDAYS
35 Implicit Intersection
36 Array formula for date range