Excel 2003 Formulas By John Walkenbach

Description: Comes from A SMOKE FREE, PET FREE, LOCATION About this productProduct InformationEverything 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 conceptsProduct IdentifiersPublisher:Wiley & Sons, Incorporated, JohnISBN-10:0764540734ISBN-13:9780764540738 Product Key FeaturesAuthor:John WalkenbachPublication Name:Excel 2003 FormulasFormat:Trade PaperbackLanguage:EnglishPublication Year:2003Type:TextbookNumber of Pages:864 PagesDimensionsItem Length:9.1in.Item Height:1.9in.Item Width:7.2in.Item Weight:44.4 OzAdditional Product FeaturesLc Classification Number: Hf5548.4.M523Table of ContentPreface.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.Copyright Date:2004Target Audience:TradeTopic:Desktop Applications / SpreadsheetsLccn:2003-112631Dewey Decimal:005.54Dewey Edition:22Illustrated:YesGenre:Computers

Price: 18.99 USD

Location: Mount Prospect, Illinois

End Time: 2025-01-01T05:19:04.000Z

Shipping Cost: 5.99 USD

Product Images

Item Specifics

All returns accepted: ReturnsNotAccepted

Country/Region of Manufacture: United States

Subject Area: Exel, Spreadsheets

California Prop 65 Warning: Must document that they have notified retailers of the need to provide warnings and provided all necessary warning materials. HSC § 25600.2.

Series: Exel 2003 Formulas

Educational Level: Adult & Further Education

MPN: 9780764540738

Subject: Spreadsheets, Formulas, Advanced Exel

Personalized: No

Level: Intermediate, Advanced

Item Length: 9.1in.

Item Height: 1.9in.

Item Width: 7.2in.

Author: John Walkenbach

Publication Name: Excel 2003 Formulas

Format: Trade Paperback