Home > Store

Power Excel 2007: Formulas, Downloadable Version

Register your product to gain access to bonus material or receive a coupon.

Power Excel 2007: Formulas, Downloadable Version

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.

Not for Sale

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.

Description

  • Copyright 2010
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-7897-4614-X
  • ISBN-13: 978-0-7897-4614-6

Formulas are the miracle of Excel. Enter one formula and copy it to 50,000 rows. Change one number and all of the formulas recalculate. In these 13 lessons, you will learn fast ways to enter formulas, some arcane of formula references, how to instantly discover an answer. You will also learn about the powerful VLOOKUP and array formulas.

  • AutoSum Tricks
  • Formula Auditing
  • 3 Ways of Entering Formulas
  • Relative vs Absolute Formulas
  • Discovering Functions
  • Goal Seek
  • Unusual Functions
  • IF Formulas
  • VLOOKUP
  • New Functions - IFERROR
  • New Functions - SUMIFS
  • Super Formulas
  • Date & Time

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.