Finance and Accounting

Spreadsheets for Accounting (AATSAH120)


This course is about using spreadsheets to accurately enter, analyse and present information so that informed accountancy judgements can be made. Accounting technicians need to use spreadsheets as it is important that financial information is accurately analysed and presented in an unambiguous way.

Spreadsheets are widely used within industry, commerce and practice, and a variety of spreadsheet packages are available specifically to assist with accounting roles (routine and one-off): Features of spreadsheet packages allow calculations, manipulation of data, analysis, budgeting, preparing financial statements, reporting, forecasting and decision making.

You will add value to your organisation if you are familiar with the underlying principles of such software and can use it competently within their workplace. You will be able to analyse data using your spreadsheet skills and then communicate the most important information to enable appropriate judgements to be made. This means that the information presented needs to be accurate and easily understood by the recipient.

The objective of this course is to equip you with sufficient skills and knowledge to enable you to select the correct information and then accurately input raw data into a spreadsheet. You may need to use spreadsheets developed by others or to produce your own. You will then be able to demonstrate your use of a range of skills to analyse this data in line with accountancy conventions. Skills such as the use of formulas, functions, data analysis tools, sorting and filtering will be vital within accountancy to enable you to perform complex calculations quickly and accurately. After analysis, the data needs to be comprehensively checked and then presented using a range of methods, for example as a structured spreadsheet with pivot tables and charts.

Learning outcomes
Design and structure appropriate spreadsheets to meet customer needs:
1. Use spreadsheet software to record, format and organise data
2. Use relevant tools to manipulate and analyse data
3. Use software tools to verify accuracy and protect data
4. Use tools and techniques to prepare and report accounting information

Tutor support
We will support you every step of the way throughout your AAT learning experience with us. You can contact a tutor and get the help you need quickly and easily.

Provided by our Tutors Support team (our dedicated team of expert tutors):
• Live chat (instant response via online messenger system)
• Email (we'll get back to you within 1 working day)
• Discussion forum (we’ll get back to you within 1 working day)
• Request a call back so you can speak to a tutor (we’ll arrange a call with you within 1 day).

Why study AAT with EIMF?
Study anywhere, anytime on your laptop, phone or tablet through this fully online learning
• Award-winning learner management system (LMS)
• Immediate start
• Access to practice questions and mock assessments
• Topic focused learning modules, containing tutor-led bite-sized videos
• Engaging activities designed for effective online learning
• Integrated programme to guide you efficiently through the whole syllabus

Registration and Access
Once you complete an online purchase you will receive confirmation of account activation. Please allow 48 hours to get access to all the modules and for your eLearning account to be set up.

If you wish to receive an invoice instead of paying online, please contact us at . Access to the course is valid for 365 days.
Completion rules
  • All units must be completed