Excel 2003 Formulas

Excel 2003 Formulas

4.0 17
by John Walkenbach
     
 

Everything you need to know about

• Mastering operators, error values, naming techniques, and absolute versus relative references

• Debugging formulas and using the auditing tools

• Importing and exporting XML files and mapping the data to specific cells

• Using Excel 2003's rights management feature

• Working magic with array

Overview

Everything you need to know about

• Mastering operators, error values, naming techniques, and absolute versus relative references

• Debugging formulas and using the auditing tools

• Importing and exporting XML files and mapping the data to specific cells

• Using Excel 2003's rights management feature

• Working magic with array formulas

• Developing custom formulas to produce the results you need

Here's the formula for Excel excellence

Formulas are the lifeblood of spreadsheets, and no one can bring a spreadsheet to life like John Walkenbach. In this detailed reference guide, he delves deeply into understanding, creating, and applying formulas in everything from basic workbooks to charts, pivot tables, and more advanced Excel applications. He examines financial formulas, explores the many options made possible with array formulas, teaches you to develop custom worksheet functions with VBA, and much more. Once again, "Mr. Spreadsheet" will astound you with the breadth and depth of Excel's capacity.

CD-ROM Includes

• Trial version of the author's award-winning Power Utility Pak 5

• More than 90 sample workbooks illustrating key formula concepts

Product Details

ISBN-13:
9780764540738
Publisher:
Wiley
Publication date:
10/06/2003
Edition description:
BK&CD-ROM
Pages:
864
Product dimensions:
7.35(w) x 9.20(h) x 1.80(d)

Meet the Author

John Walkenbach, principal of JWalk and Associates Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 spreadsheet books and over 300 articles and reviews for publications including PC World, InfoWorld, and Windows, and maintains the popular Spreadsheet Page at www.j-walk.com/ss.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Excel 2003 Formulas 4.1 out of 5 based on 0 ratings. 15 reviews.
Anonymous 11 months ago
Walks in
Anonymous 11 months ago
Jacob watched them, fingering the thin hem of his hood. He shifted his weight, readjusting the heavy bag on his shoulders. He was waiting to see if anyone would notice him, or if they were just going to ignore him like the others.
Anonymous 11 months ago
Pads in and looks around.
Anonymous 11 months ago
((Umm i posted a bio an im just letting you know im joining this rp sooooooo yeah. Wwana cleaner picture of who addison is! Look up on google 'Vivziepop Zoophobia Addison'))
Anonymous 11 months ago
She looked up again and saw people. She was startled. Maybe they had found her. So much for being on the lam. But one of them looked at her and smiled.
Anonymous 12 months ago
Climbs up and walks in. "Hello." He says in a russian accent. "This is runaway homes, correct?"
Anonymous 12 months ago
I walk in. "Hi. Am I interuputing anything? My names Dove." I say with a smile.
Anonymous 12 months ago
She walked in, with a sad look on her face and her eyes a dark blue instead of its usual emerald green.
Anonymous 12 months ago
Are you to one who created the rp?
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Guest More than 1 year ago
A very well written tutorial on using Excel formulas. Easy to read and follow - not too technical, but gives an in-depth understanding of what you can accomplish. This has made me a John Walkenbach fan. He does a great job in helping learn Excel principles.
Guest More than 1 year ago
If you're starving for the little nuances of this program that are there, but you just can't seem to get it then get this book! This book is an EXCELLENT READ! Three thumbs up! (Depending on which planet you're from of course.) Excel 2003 Formulas will skyrocket your programming potential and step you into a world of spreadsheets you thought did not exist. GET THIS BOOK!