CELEBRATE EARTH WEEK
Save 70% on video training and simulators now through April 27*—use code EARTH. Shop now.
Additional sample videos, individual lessons and other formats are available here.
Register your product to gain access to bonus material or receive a coupon.
Actual product comes full screen and in high resolution.
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
34 Date and Time, including time in excess of 24 hours, format as Qtr, NETWORKDAYS
35 Implicit Intersection
36 Array formula for date range