Skip to main content

Ealing ALS


Ealing Council

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.


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  

Visual of the course

Course Summary

Code: MTPY3019MO 

Starting: Monday 03 June 2024 

Duration: 8 sessions over 4 week(s)

Time: 10:00 

Location: Online Delivery  


By continuing you confirm that you are over 19 and have agreed to the the terms and conditions



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.  

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 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


Online Delivery  
Zoom or Google Classroom  
ZZ99 9ZZ  

Find us here