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 2024-2025 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:
Intro to Bookkeeping: Using Spreadsheets
Course Summary
Code: ONLD2002TL
Starting: Monday 23 February 2026
Duration: 5 sessions over 5 week(s)
Time: 19:00
Location: Online Delivery
Cost: £50.00
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.
Entry Requirements:
An understanding of basic Excel
Information Session:
Prior to the start of the course, you will be invited to an online information session with the tutor to discuss what is involved. This session will help you understand what to expect and give you a chance to ask any questions before you begin.
Although the course is delivered online, it is not just about watching videos, you will need to complete the modules, do homework and pass a final test to successfully complete the 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
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 intermediate level English are also recommended. Learners should also be able to follow spoken
and written instructions, add, subtract, multiply and divide.
How you will learn on the course
It 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?
Calculator, pen, paper, pdf reader and access to Excel
spreadsheet or Google Sheets
Next steps
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: 23 February 2026
Start Time: 19:00
Day: Monday Evening
First Lesson Duration: 02:00
Total Weeks: 5
Location
Online Delivery
Zoom or Google Classroom
LONDON
ZZ99 9ZZ