Minecraft Adventures B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Interviews | August 12, 2015

    Jill Owens: IMG Eli Gottlieb: The Powells.com Interview



    Eli GottliebEli Gottlieb has done something unusual — he's written two novels, 20 years apart, from opposing but connected perspectives. The Boy Who Went... Continue »
    1. $17.47 Sale Hardcover add to wish list

      Best Boy

      Eli Gottlieb 9781631490477

    spacer
Qualifying orders ship free.
$15.50
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside Microsoft Windows- Applications

More copies of this ISBN

Excel 2003 Formulas

by

Excel 2003 Formulas Cover

 

Synopses & Reviews

Publisher Comments:

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

Book News Annotation:

This reference guide explains the principles and techniques for the creation and application of formulas in workbooks, charts, pivot tables, and advanced Excel applications. Walkenback (a consultant) examines financial formulas, considers array formulas and the options they make possible, and offers instructions for developing custom worksheet functions with VBA. A companion CD-ROM contains a trial version of Power Utility Pak 5 and about 90 sample workbooks illustrating key formula concepts.
Annotation 2004 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Excel is the standard among spreadsheet applications and is an indispensable tool in the business community. This book helps readers master the basic formula facts, including absolute and relative references, operators, error values, naming techniques and more.

Synopsis:

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

Synopsis:

Part of the bestselling Power Pack family of technical guides, this book is an excellent resource for learning the tips and techniques about maximizing formulas, one of the most powerful spreadsheet tools Helps the reader master basic formula facts, including absolute vs. relative references, operators, error values, naming techniques, and more Offers practical tips on using Excel' s worksheet functions in formulas, using formulas to enhance charts and pivot tables, developing custom worksheet functions with VBA, using powerful array formulas, and debugging Written by one of the leading authorities on spreadsheet programs who also maintains the popular online Spreadsheet Page CD-ROM includes more than ninety example workbooks that illustrate key concepts for the book, as well as the author' s award-winning Power Utility Pak

About 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.

Table of Contents

Preface.

Acknowledgments.

Part I: Basic Information.

Chapter 1: Excel in a Nutshell.

Chapter 2: Basic Facts about Formulas.

Chapter 3: Working with Names.

Part II: Using Functions in Your Formulas.

Chapter 4: Introducing Worksheet Functions.

Chapter 5: Manipulating Text.

Chapter 6: Working with Dates and Times.

Chapter 7: Counting and Summing Techniques.

Chapter 8: Using Lookup Functions.

Chapter 9: Databases and Lists.

Chapter 10: Miscellaneous Calculations.

Part III: Financial Formulas.

Chapter 11: Introducing Financial Formulas.

Chapter 12: Discounting and Depreciation Financial Functions.

Chapter 13: Advanced Uses of Financial Functions and Formulas.

Part IV: Array Formulas.

Chapter 14: Introducing Arrays.

Chapter 15: Performing Magic with Array Formulas.

Part V: Miscellaneous Formula Techniques.

Chapter 16: Intentional Circular References.

Chapter 17: Charting Techniques.

Chapter 18: Pivot Tables.

Chapter 19: Conditional Formatting and Data Validation.

Chapter 20: Creating Megaformulas.

Chapter 21: Tools and Methods for Debugging Formulas.

Part VI: Developing Custom Worksheet Functions.

Chapter 22: Introducing VBA.

Chapter 23: Function Procedure Basics.

Chapter 24: VBA Programming Concepts.

Chapter 25: VBA Custom Function Examples.

Appendix A: Working with Imported 1-2-3 Files.

Appendix B: Excel Function Reference.

Appendix C: Using Custom Number Formats.

Appendix D: Additional Excel Resources.

Appendix E: What’s on the CD-ROM.

Index.

End-User License Agreement.

Product Details

ISBN:
9780764540738
Author:
Walkenbach, John
Publisher:
Wiley Publishing
Location:
Indianapolis, IN
Subject:
Business
Subject:
Spreadsheets - General
Subject:
Electronic spreadsheets
Subject:
Microsoft Excel for Windows.
Subject:
Microsoft Excel
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Description:
CD
Series:
Microsoft Office/Weekend Crash Course
Series Volume:
GTR-584
Publication Date:
20031017
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Yes
Pages:
864
Dimensions:
9.24x7.38x1.85 in. 2.72 lbs.

Other books you might like

  1. Excel: The Missing Manual (Missing... Used Trade Paper $16.50
  2. Excel 2003 All-in-one Desk Reference... Used Trade Paper $15.00
  3. Fahrenheit 451
    Used Mass Market $3.95
  4. The Psychology of Hate New Hardcover $19.95
  5. New Perspectives on Microsoft... Used Trade Paper $122.00
  6. Access 2003 Power Programming With Vba New Trade Paper $44.95

Related Subjects

Arts and Entertainment » Photography » Photojournalism
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Excel 2003 Formulas Used Trade Paper
0 stars - 0 reviews
$15.50 In Stock
Product details 864 pages Wiley Publishing - English 9780764540738 Reviews:
"Synopsis" by , Excel is the standard among spreadsheet applications and is an indispensable tool in the business community. This book helps readers master the basic formula facts, including absolute and relative references, operators, error values, naming techniques and more.
"Synopsis" by , 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

"Synopsis" by , Part of the bestselling Power Pack family of technical guides, this book is an excellent resource for learning the tips and techniques about maximizing formulas, one of the most powerful spreadsheet tools Helps the reader master basic formula facts, including absolute vs. relative references, operators, error values, naming techniques, and more Offers practical tips on using Excel' s worksheet functions in formulas, using formulas to enhance charts and pivot tables, developing custom worksheet functions with VBA, using powerful array formulas, and debugging Written by one of the leading authorities on spreadsheet programs who also maintains the popular online Spreadsheet Page CD-ROM includes more than ninety example workbooks that illustrate key concepts for the book, as well as the author' s award-winning Power Utility Pak
spacer
spacer
  • back to top

FOLLOW US ON...

       
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.