Microsoft Excel 2002 Formulas (With CD-ROM)

Microsoft Excel 2002 Formulas (With CD-ROM), 9780764548000 (076454800X), John Wiley & Sons, 2001

Excel 2002 Formulas Unleash the Power of Excel Formulas Now revised to cover the new features of Excel 2002 and expanded with two all-new chapters on financial formulas, this one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-so-typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets — and make the most of Excel. Your Road Map to High-Performance Excel Formulas

Get a concise overview of Excel's many features, including cell formatting, analysis tools, and protection options
Master basic formula facts — including absolute vs. relative references, operators, error values, naming techniques, and more
Get practical tips on using Excel's worksheet functions in your formulas
Find expanded coverage of discounting, depreciation, and other financial formulas
Perform magic with powerful array formulas
Use your formulas to enhance charts and pivot tables
Debug formulas and take advantage of Excel's auditing tools
Develop custom worksheet functions with VBA

Bonus CD-ROM Includes

A trial version of the author's award-winning Power Utility Pak 2000
A demo of the author's Sound-Proof 2000
Example Excel workbooks from the book

System Requirements Pentium PC with Windows 98 or greater; 32 MB RAM; Microsoft Excel 2002. See About the CD appendix for details and complete system requirements. www.mandtbooks.com

About the Author
John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Power Programming with VBA. He maintains "The Spreadsheet Page," a popular Web resource at www.j-walk.com/ss.

Comments

Amazing Books

Electronic Commerce (Networking Series)

Charles River, 2003

The fourth edition of this best-selling title gives a complete overview of the electronic commerce environment. It has been revised and completely updated to reflect the most recent trends in e-commerce, including new material on security technologies, server options, enterprise applications, and investing online. Covering everything from...

101 Ways to Advertise Your Business: Building a Successful Business with Smart Advertising

Allen & Unwin, 2004

Practical tips on advertising products and services simply, effectively, and without a big budget abound in this conversational business book. Step-by-step advice is offered on creating an advertisement, buying advertising space, and ensuring that advertisements are effective. Advertising in newspapers, magazines, on the radio, television, the...

Fundamental Forces of Nature: The Story of Gauge Fields

World Scientific Publishing, 2007

In this book I want to tell the story of gauge fields, the messengers that transmit signals among elementary particles, enabling them to interact. They work in the quantum realm of quarks, the deepest level of the structure of matter we have reached so far.

The basic interaction at this level percolates upwards, through hierarchies of...

Introduction to Data Mining Using SAS Enterprise Miner

SAS Institute, 2006

If you have an abundance of data, but no idea what to do with it, this book was written for you! Packed with examples from an array of industries, Introduction to Data Mining Using SAS Enterprise Miner provides you with excellent starting points and practical guidelines to begin data mining today. Author Patricia Cerrito encourages you to...

Hacking Photoshop CS2

John Wiley & Sons, 2005

You think you know Photoshop? Wait until you see how these over-the-top hacks and mods bring out its hidden power! Create a workflow customized for your specific needs. Superimpose type in half the time. Make Bridge work for you. Hack Camera Raw and get even more from your images. Print your projects without losing precision. When you can command...

Pro SQL Server 2008 Administration

Apress, 2009

Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and...