hassen
2009-08-16, 03:17 AM
Hi
For Rf optimization:DUseful guide beleave me !
PartI 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
Thanks to John Wiley & Sons
http://rapidshare.com/files/267711188/Excel_2007_Formulas.rar
Br Hassen
For Rf optimization:DUseful guide beleave me !
PartI 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
Thanks to John Wiley & Sons
http://rapidshare.com/files/267711188/Excel_2007_Formulas.rar
Br Hassen