Learn Ealing continues to deliver courses face-to-face and through its online offer. We will deliver lessons and support learners through the use of Google Education suite, Zoom, Skype and other digital platforms.
Our 2023-2024 Prospectus is now available. Click here
To participate in online classes you will need an email address, a reliable internet connection, a computer/laptop/tablet/mobile phone with fully updated browser (preferably Google Chrome). Your device will need a microphone and preferably a camera.
Click on the links below for videos on how to join online classes using:
Bookkeeping using spreadsheets
Course Summary
Code: MTPY3019MO
Starting: Monday 03 June 2024
Duration: 8 sessions over 4 week(s)
Time: 10:00
Location: Online Delivery
Cost:
Description
This course provides a solid foundation for individuals seeking to enhance their understanding of financial management.It will equip you with the necessary skills to confidently handle essential accounting responsibilities. By the end of the course, you will be able to perform routine accounting tasks related to sales and purchases, as well as mastering the art of preparing a meticulous cashbook. In addition, you will learn how to generate accurate VAT return figures and create vital accounting reports, including the trial balance, profit and loss account, and balance sheet.
You are required to complete this pre-assessment before starting your course.
Overview
The course is designed for people who want to learn a simple but effective method of
bookkeeping using excel spreadsheets or google sheets. Learners will be able to
carry out routine accounting tasks. These will include processing accounting
information in respect of sales and purchases, understanding how to prepare a cash
book and generate accounting reports such as a trial balance, profit and loss
account and balance sheet.
Learning outcomes
Learning outcomes - By the end of this course, learners should be able to:
- Prepare Day Books
- Process information in respect of sales and purchases, i.e. invoices, credit
notes, receipts and payments.
- Process transactions at different rates of tax.
- Prepare a cash book and reconcile bank accounts
- Generate VAT return figures
- Process payroll, stock, depreciation, prepayments and accrual journals
- Prepare a trial balance, profit and loss account and balance sheet
Suitability and entry requirements
Learners should have a basic understanding of Excel spreadsheets and/or Google
sheets, familiar with a computer keyboard, basic numeracy skills and intermediatelevel English are also recommended. Learners should also be able to follow spoken
and written instructions, add, subtract, multiply and divide.
You are required to complete this pre-assessment before starting your course, please click the link to do so Multiply Pre-Assessment
How you will learn on the course
How will I be taught? This is an online course of 8 modules. Each module has a
number of short videos with step by step instructions as to how to complete each
task. There are short quizzes to test learning in each module, homework and a test
at the end.
How much additional time do you need?
Resources, materials & additional costs?
Resources you will need: Calculator, pen, paper, pdf reader and access to Excel spreadsheet or Google Sheets.
Next steps
When I've finished, what course can I do next? This course will enable you to go
onto Sage 50 Accounts Beginner an online software accounting course.
Please also check on the Learn Ealing website www.learnealing.org.uk or speak to your tutor.
Your Tutor
This course is delivered in partnership with Aqret Training. To start your course, you will need to register on their website and view the introductory videos using the link provided in your registration confirmation email.
Time and duration
Start Date: 03 June 2024
Start Time: 10:00
Day: Monday Morning
First Lesson Duration: 02:30
Total Weeks: 4
Location
Online Delivery
Zoom or Google Classroom
LONDON
ZZ99 9ZZ