Register your product to gain access to bonus material or receive a coupon.
Part III: Formulas, Downloadable Version
- By Bill Jelen
- Published Mar 21, 2013 by Que. Part of the LiveLessons series.
Downloadable Video
- Sorry, this book is no longer in print.
- 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.
Description
- 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
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
More Information
Other Things You Might Like
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
- eBook $35.19