Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20

Microsoft Office Excel 2010 Formulas

Paperback Engels 2010 9780470475362
Verwachte levertijd ongeveer 8 werkdagen

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
Taal:Engels
Bindwijze:paperback
Aantal pagina's:787
Druk:1
Hoofdrubriek:IT-management / ICT

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Geef uw waardering

Zeer goed Goed Voldoende Matig Slecht

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.

Alle 100 bestsellers

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Microsoft Office Excel 2010 Formulas