Formulas and Functions with Microsoft Excel 2003

Paul McFedries

  • 出版商: QUE
  • 出版日期: 2004-06-21
  • 售價: $1,840
  • 貴賓價: 9.5$1,748
  • 語言: 英文
  • 頁數: 504
  • 裝訂: Paperback
  • ISBN: 0789731533
  • ISBN-13: 9780789731531
  • 相關分類: Excel
  • 已過版

買這商品的人也買了...

相關主題

商品描述

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 jargon-free way. This book not only takes them through Excel's intermediate and advanced options, but also tells them why these options are useful and shows them how to use them in everyday situations and real-world models. This book aims to do all of this with no-nonsense, step-by-step tutorials and lots of practical, useful examples.

 

Table of Contents:

Introduction

I. MASTERING EXCEL RANGES AND FORMULAS.

 1. Getting the Most Out of Ranges.
 2. Using Range Names.
 3. Building Basic Formulas.
 4. Creating Advanced Formulas.
 5. Troubleshooting Formulas.

II. HARNESSING THE POWER OF FUNCTIONS.

 6. Using Functions.
 7. Working with Text Functions.
 8. Working with Logical and Information Functions.
 9. Working with Lookup Functions.
10. Working with Date and Time Functions.
11. Working with Math Functions.
12. Working with Statistical Functions.

III. BUILDING BUSINESS MODELS.

13. Analyzing Data with Lists.
14. Using Excel's Business-Modeling Tools.
15. Using Regression to Track Trends and Make Forecasts.
16. Solving Complex Problems with Solver.

IV. BUILDING FINANCIAL FORMULAS.

17. Building Load Formulas.
18. Building Investment Formulas.
19. Working with Bonds.
20. Building Discount Formulas.
Index.