Microsoft Office Excel 2010 Formulas

Name: Microsoft Office Excel 2010 Formulas
Author: John Walkenbach

Paperback Engels 2010 1e druk 9780470475362

Verwachte levertijd ongeveer 8 werkdagen

54,98

In winkelwagen

Samenvatting

Follow Mr. Spreadsheet's formula for Excel success

Experts estimate that barely 10 percent of Excel users understand how to make the most of worksheet formulas. If you already know your way around Excel basics, "Mr. Spreadsheet" John Walkenbach can help you master formulas to gain greater Excel functionality.

First, he shows you exactly what a formula is, how to create one, and what formulas can do. Then you'll learn about using functions in your formulas. Finally you'll explore specific types of formulas that can help you on multiple levels, such as financial and array formulas.
You'll learn how to apply formulas to charts and pivot tables, troubleshoot your formulas, develop custom functions, and much more.

Let Mr. Spreadsheet show you how to:
- Master the new functionality in Excel 2010
- Understand and use various lookup formulas
- Create financial formulas for borrowing or investing
- Work with formulas for conditional formatting
- Develop custom worksheet functions using VBA

CD-ROM INCLUDES:
- Workbook files for all examples used in the book
- The entire book in a searchable PDF file
- See Appendix D for complete system requirements.

Specificaties

ISBN13:9780470475362

Trefwoorden:financiële rapportage, financiële verslaglegging, Spreadsheets, kantoorapplicaties, Microsoft, Excel 2010

Taal:Engels

Bindwijze:paperback

Aantal pagina's:787

Uitgever:John Wiley & Sons

Druk:1

Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Uw cijfer

?

Log in om te stemmen

Inhoudsopgave

Introduction

Part 1: Basic Information.
1. Excel in a Nutshell.
2. Basic Facts about Formulas.
3. Working with Names.

Part 2: Using Functions in Your Formulas.
4. Introducing Worksheet Functions.
5. Manipulating Text.
6. Working with Dates and Times.
7. Counting and Summing Techniques.
8. Using Lookup Functions.
9. Tables and Worksheet Databases.
10. Miscellaneous Calculations.

Part 3: Financial Formulas.
11. Borrowing and Investing Formulas.
12. Discounting and Depreciation Formulas.
13. Financial Schedules.

Part 4: Array Formulas.
14. Introducing Arrays.
15. Performing Magic with Array Formulas.

Part 5: Miscellaneous Formula Techniques.
16. Intentional Circular References.
17. Charting Techniques.
18. Pivot Tables.
19. Conditional Formatting and Data Validation.
20. Creating Megaformulas.
21. Tools and Methods for Debugging Formulas.

Part 6: Developing Custom Worksheet Functions.
22. Introducing VBA.
23. Function Procedure Basics.
24. VBA Programming Concepts.
25. VBA Custom Function Examples.

Part 7: Appendixes.
Appendix A: Excel Function Reference.
Appendix B: Using Custom Number Formats.
Appendix C: Additional Excel Resources.
Appendix D: What's on the CD-ROM.

Index.