Accounting Using Excel

Programme Aim

This course is aimed at those with basic Excel skills who wish to explore the package further and use the package for basic accounting within their business. Templates for recording basic set of books will be provided on disk for all participants.

Programme Content

Processing Purchase/Sales Invoices
Processing Direct Debits/Standing orders
Processing receipts/other income
Preparation of Bi-monthly VAT Return
Processing of Wages & Salaries information
Bank Reconciliation
Extracting information for Nominal Ledger/Trial Balance/Balance Sheet
Explanation of all Books of Account