excel courses, excel training
 

Excel Manuals

INTRODUCTION

The download consists of 2 excel 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 MANUALexcel manuals

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

Contact us. The manual is R999. We will email you the manaul once we have received your payment.

 

Articles:

 

 

Home | Testimonials | Terms & Conditions | Contact Us | Manuals | Sitemap | Articles | Links