Home > Store

Part III: Formulas, Downloadable Version

Part III: Formulas, Downloadable Version

Downloadable Video

  • Your Price: $9.99
  • About this video
  • 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.

Audio & Video

Your browser doesn't support playback of this video. Please download the file to view it.

Actual product comes full screen and in high resolution.


  • Copyright 2013
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-344817-7
  • ISBN-13: 978-0-13-344817-7

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


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership