Practical Training for a higher standard in Accountancy & Excel

We train accountancy students in all aspects of accounting, bookkeeping and excel in an office environment. We aim to train students in a very short time, flexible attendance and a complete knowledge in all aspects. Our frequent revised modules of workshops provide up to date knowledge in terms of standards of accounting and taxation laws.

Students will use source documents to build complete records of books and to do weekly bank reconciliation, VAT returns, Journals to reflect accruals & prepayments, monthly management accounts, drawing up budgets, variance analysis and to finalise the accounts to auditors.

The workshops also aim to provide the students, skills in analysis and presentation, as the accounting techniques and standards are merely analysis and presentation. Students will get confidence in working on their own with the high analysis skills and thorough book keeping knowledge.

Bookkeeping for Sole Traders / Limited Companies
  • Creating Chart of Accounts
  • Day Book
  • Bank Reconciliation
  • PAYE
  • Management Accounts
  • Audit Preparation
  • Coding & Cost Centres
  • Credit Control
  • VAT Returns
  • Accruals & Prepayments
  • Budgets & Variance Analysis
  • Tax Returns & CT

Our excel training has four stages:

Introduction
Students will learn how to use an electronic spreadsheet to create basic data reports.

Intermediate
Students will learn how to validate data, customise toolbars, use advanced formulas, create pivot tables, create charts from spreadsheet data, and sort and filter data.

Advanced
Students will learn how to add graphics to a worksheet or chart, perform advanced filters and queries on data, create advanced formulas, link files, consolidate data, and record macros.

Visual basic for applications
Students will examine sample code, learn how to create macros from scratch, and add to previously created macros.
A rapid short course of advanced formulas, macros and VBA is available for students

Flexible hours to suit and competitive rates for students.

We will guide you in finding employment and give reference for your CV

AGM Business Solutions
Talbot House Business Centre
204-226 Imperial Drive
Rayners Lane, Harrow
Middlesex HA2 7HH

Tel: 020 8429 5217 / 5218
Mob: 07950 679 142
training@agmtaxadvisers.co.uk