Want more information?

Use Spreadsheets for Accounts

Course aims

To be able to use Excel Spreadsheets to keep accounts for a business.

Course length

8 hours - usually 4 weekly sessions of 2 hours.

Who is this course for?

The course is suitable for those who want to begin using spreadsheets and apply their new knowledge to accounts.

Will I gain any qualifications?

No, but you will receive a BAES certificate of attendance.

Do I need any prior knowledge, skills or qualifications?

You need to have used IT before (perhaps for word processing or surfing the internet) but you don’t need any spreadsheet experience. The course is not suitable for complete beginners to IT.

Course content

By the end of the course you will be able to:

  • Create a new spreadsheet
  • Use basic formulae eg add, subtract, multiply, divide
  • Create a spreadsheet with 3 tabs: Cash Book, Sales Day Book and Purchase Day Book
  • Work on a spreadsheet for your own accounts

What could this course lead to?

Creating a spreadsheet to record your accounts. You could consider doing a further IT qualification, depending on your skill level, such as Level 1 or 2 IT Skills or ECDL.

How will I learn?

You will be taught in a group and through individual practice, with assistance from your tutor.

What materials or equipment will I need to provide?

You will need a pen, notepad, and a folder to store hand-outs and completed exercises.

Your commitment as a learner

To achieve success on the course you will need to attend regularly, and on time. If you need to miss a class, please let us know in advance.

Useful websites

Microsoft Support website:  https://support.microsoft.com/en-gb

More information

If you would like more information about this course contact Sukhdev Tatter on 0121 464 9148

Print Friendly, PDF & Email
Go to top

We use cookies to improve our website and your experience when using it. Cookies used for the essential operation of the site have already been set. To find out more about the cookies we use and how to delete them, see our Privacy Policy.

I accept cookies from this site