Formulas and Functions with Microsoft Excel 2003

Name: Formulas and Functions with Microsoft Excel 2003
Price: 5.02 USD
Availability: InStock
ISBN: 9780789731531

ISBN-10: 0789731533

ISBN-13: 9780789731531

Edition: 2004

Authors: Paul McFedries

List price: $44.99

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $5.02

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

The old "80/20" rule for software - that 80 percent of users use only 20 percent of a program's features - doesn't apply to Microsoft Excel. Instead, this program operates under what could be called the "95/5" rule: 95 percent of Excel users use a mere 5 percent of the program's features. Most of those users know that they could be getting more out of Excel by using more of its commands and options, but aren't sure where to start. Excel is big and complex, and most of its intermediate-to-advanced features are shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon. This Business Solutions title demystifies the program's features and presents them in a…

Book details

List price: $44.99
Copyright year: 2004
Publisher: Pearson Education
Publication date: 6/11/2004
Binding: Paperback
Pages: 504
Size: 7.25" wide x 9.00" long x 1.25" tall
Weight: 1.848
Language: English



Introduction



Mastering Excel Ranges And Formulas



Getting the Most Out of Ranges



Using Range Names



Building Basic Formulas



Creating Advanced Formulas



Troubleshooting Formulas



Harnessing The Power Of Functions



Using Functions



Working with Text Functions



Working with Logical and Information Functions



Working with Lookup Functions



Working with Date and Time Functions



Working with Math Functions



Working with Statistical Functions



Building Business Models



Analyzing Data with Lists



Using Excel's Business-Modeling Tools



Using Regression to Track Trends and Make Forecasts



Solving Complex Problems with Solver



Building Financial Formulas



Building Loan Formulas



Building Investment Formulas



Working with Bonds



Building Discount Formulas


Index