Areas Of Expertise

Accountants understand that many reconciliation tasks can be partially, but not fully automated.

I have developed several interactive reconciliation procedures with varying degrees of automatic and manual input. These have saved my clients thousands of hours of manual work.

I have twenty year's experience, six as a self-employed consultant, with spreadsheet development including

·Visicalc
·Supercalc
·Lotus 123
·Excel
·VBA
·SQL

I have automated Microsoft Access and Outlook, as well as many non-Microsoft applications using Excel VBA.

Another key area of expertise is the rapid conversion of text reports into usable Excel files and the use of VBA to:

· systematically modify the formulas in existing spreadsheets
· identify protected or unprotected cells

Site Produced & Maintained by MFA