Manuals

 INTRODUCTION
 The download consists of 2 manuals and examples on excel. The 1st manual is an explanation of the 31 formulas to use in excel. The 2nd manual is an explanation of 9 detail models.

31 FORMULAS MANUAL
 This explains the 31 formulas in more detail than you will find anywhere else. We do not simply give one definition, one example and move on. We also give explanations of the errors that people always make on the formulas.
 We explain the formulas, errors, examples and where to use them.
This book took 4 years to prepare and is unique to explain how easy these are and where to use them.

 THE MODELS MANUAL
 The following 9 models are explained in detailed. How to prepare them with examples.
1. Using Hlookup and Vlookup together (handy with reporting)
2. How to count with Countif and where to use this function (do thousand of lines reconciliations in seconds)
3. How to use conditional formatting to do reconciliation’s easier
4. Report writing using multiple formulas
5. How to use more than one pivot table together to generate one big one (when you have multiple sources)
6. The growth formula
7. Dates and Reports
8. How to find more than one result with one Vlookup (never been seen)
9. How to converts dates like 20060731 to 31 July 2006 (handy with reporting)
 
HOW TO ORDER



Manual for excel 2003
Manual for excel 2007
Click on the download link on the right

 
sd
sd