Excel 2010 Formulas

==================================================
1/13/2012 5:53:31 AM By: Mr. Jean Kobeis
==================================================
E-book Title:
-------------
Excel 2010 Formulas
--------------------------------------------
Author: John Walkenbach
Copyright: Wiley Publishing
ISBN: 978-0-470-47536-2
==================================================
Contents at a Glance:
---------------------
* Part I: Basic Information
+ Chapter 1: Excel in a Nutshell
+ Chapter 2: Basic Facts about Formulas
+ Chapter 3: Working with Names

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

* Part III: Financial Formulas
+ Chapter 11: Borrowing and Investing
Formulas
+ Chapter 12: Discounting and Depreciation
Formulas
+ Chapter 13: Financial Schedules

* Part IV: Array Formulas
+ Chapter 14: Introducing Arrays
+ Chapter 15: Performing Magic with
Array Formulas

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

* Part VI: Developing Custom Worksheet
Functions
+ Chapter 22: Introducing VBA
+ Chapter 23: Function Procedure Basics
+ Chapter 24: VBA Programming Concepts
+ Chapter 25: VBA Custom Function Examples

* Part VII: Appendixes
+ Appendix A: Excel Function Reference
+ Appendix B: Using Custom Number Formats
+ Appendix C: Additional Excel Resources
==================================================
Overall:
--------

The book contain 818 pages including the
intro, about the Author, and the Index Book,
in addition of the code source that is
available with the package.

P.S:
----

To get the most knowledge and experience
and skills, i recomend that you work hard
before viewing the source code,
at least; This is my opinion thanks.
==================================================
Chapter Outline:
----------------
There are dozens of ways to organize this
material, but I settled on a scheme that
divides the book into six main parts.
In addition, I’ve included a few appendixes
that provide supplemental information that
you may find helpful.

Part I: Basic Information:
--------------------------
This part is introductory in nature;
it consists of Chapters 1 through 3.
Chapter 1 sets the stage with a quick and
dirty overview of Excel. This chapter is
designed for readers who are new to Excel
but who have used other spreadsheet
products. In Chapter 2, I cover the
basics of formulas.
This chapter is absolutely essential
reading in order to get the most out
of this book. Chapter 3 deals with names.
If you thought names were just for cells
and ranges, you’ll see that you’re
missing out on quite a bit.
--------------------------------------------
Part II: Using Functions in Your Formulas:
------------------------------------------
This part consists of Chapters 4
through 10. Chapter 4 covers the basics
of using worksheet functions in your
formulas. I get more specific in
subsequent chapters. Chapter 5 deals
with manipulating text, Chapter 6
covers dates and times, and Chapter 7
explores various counting techniques.
In Chapter 8, I discuss various types
of lookup formulas. Chapter 9 deals
with tables and worksheet databases,
and Chapter 10 covers a variety of
miscellaneous calculations such as unit
conversions and rounding.
--------------------------------------------
Part III: Financial Formulas:
-----------------------------
Part III consists of three chapters
(Chapters 11 through 13) that deal
with creating financial formulas.
You’ll find lots of useful formulas
that you can adapt to your needs.
--------------------------------------------
Part IV: Array Formulas:
------------------------
This part consists of Chapters 14 and
15. The majority of Excel users know
little or nothing about array formulas
— a topic that happens to be dear to me.
Therefore I devote an entire part to this
little-used yet extremely powerful
feature.
--------------------------------------------
Part V: Miscellaneous Formula Techniques:
-----------------------------------------
This part consists of Chapters 16
through 21. They cover a variety of
topics — some of which, on the surface,
may appear to have nothing to do with
formulas. Chapter 16 demonstrates that a
circular reference can be a good thing.
In Chapter 17, you’ll see why formulas
can be important when you work with
charts, and Chapter 18 covers formulas
as they relate to pivot tables. Chapter
19 contains some very interesting
(and useful) formulas that you can use
in conjunction with Excel’s conditional
formatting and data validation features.
Chapter 20 covers a topic that I call
“megaformulas.” A megaformula is a huge
formula that takes the place of several
intermediary formulas. And what do you
do when your formulas don’t work
correctly? Consult Chapter 21 for some
debugging techniques.
--------------------------------------------
Part VI: Developing Custom Worksheet
Functions:
------------------------------------
This part consists of Chapters 22
through 25. This is the part that
explores Visual Basic for Applications
(VBA), the key to creating custom
worksheet functions. Chapter 22
introduces VBA and the VB Editor, and
Chapter 23 provides some necessary
background on custom worksheet functions.
Chapter 24 covers programming concepts,
and Chapter 25 provides a slew of worksheet
function examples that you can use as-is,
or customize for your own needs.
--------------------------------------------
Part VII: Appendixes:
---------------------
What’s a computer book without
appendixes? This book has four appendixes.
In the appendixes, you’ll find a quick
reference guide to Excel’s worksheet
functions, tips on using custom number
formats, and a handy guide to Excel
resources on the Internet. The final
appendix describes all the files on the CD-ROM.
--------------------------------------------

P.S:
----

Secure Torrent Downloas:
http://➡.ws/Excel-2010-Formula
==================================================