Request a Callback

Call us on 0208 776 9500

Free Newsletter

  • Book a Free Consultation
  • Get a Fixed Quote

Find out how to Make more, Keep more and Work less

How Big is Your Business?

  • Start-up
  • Small Business
  • Medium Business
  • Large Business

Spreadsheet (Excel)

Use of Spreadsheet for client's record keeping and preparation of financial account.

Aim

The course will demonstrate the Spreadsheet accounting. Various elements within the Spreadsheet will be demonstrated to the participants. Comprehensive practice session will follow immediately after each element to illustrate the various functions.

Duration

5 days/3 months/ (Weekend/Evening also available)

Fee

Please see fee schedule

Eligibility

Accountancy students (AAT,CAT,ACCA,CIMA) and individuals who are seeking future in bookkeeping, finance or want to reduce accountants bill to look-after their own day to day business accounts. It also helps those who do not have prior spreadsheet knowledge.

Syllabus

  1. Design of page, format etc.
  2. Preparation of day books from source documents
  3. The maintenance of Ledgers on Excel spreadsheets
  4. Extended trail balance
  5. Link of sheets, formulas and use of IF command
  6. Preparation of Trail Balance, Profit and Loss, Balance Sheet
  7. Importing and exporting data from computerised accounting package

Awards

  1. Certificate of completion
  2. Job reference letter
  3. Sing student training record

Next Step:

Please contact us if you need further advice, have any questions about our services, would like a free consultation or a fixed fee quote.