Excel 2010 Formulas

by Walkenbach, John

• ISBN13: 9780470475362
• ISBN10: 0470475366
• Edition: 1st
• Format: Paperback
• Copyright: 2010-05-24
• Publisher: Wiley

Summary

Take your Excel formulas to the next level with this updated referenceJohn Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010.You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else. Demonstrates how to use all the new features of Excel 2010 to maximize your formulas Shows how to develop custom worksheet functions with VBA, debug formulas, create financial formulas, and more Serves as an indispensable reference no matter your skill level Includes a valuable CD-ROM with sample files, templates and worksheets from the book, plus John Walkenbach's award-winning Power Utility PakPrepare to excel with Excel when you have John Walkenbach and Excel 2010 Formulas by your side!

Author Biography

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include Excel 2010 Power Programming with VBA, John Walkenbach's Favorite Excel 2010 Tips & Tricks, and the Excel 2010 Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.

Table of Contents

Introduction

Basic Information

Excel in a Nutshell

Basic Facts about Formulas

Working with Names

Using Functions in Your Formulas

Introducing Worksheet Functions

Manipulating Text

Working with Dates and Times

Counting and Summing Techniques

Using Lookup Functions

Tables and Worksheet Databases

Miscellaneous Calculations

Financial Formulas

Borrowing and Investing Formulas

Discounting and Depreciation Formulas

Financial Schedules

Array Formulas

Introducing Arrays

Performing Magic with Array Formulas

Miscellaneous Formula Techniques

Intentional Circular References

Charting Techniques

Pivot Tables

Conditional Formatting and Data Validation

Creating Megaformulas

Tools and Methods for Debugging Formulas

Developing Custom Worksheet Functions

Introducing VBA

Function Procedure Basics

VBA Programming Concepts

VBA Custom Function Examples

Appendixes

Excel Function Reference

Using Custom Number Formats

Additional Excel Resources

What's on the CD-ROM?

Index

Table of Contents provided by Publisher. All Rights Reserved.