| 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
|