Sage & Excel Accounting Software Workshop

The aim of this workshop is to increase the employability prospects of business and accounting students by giving them practical experience of the use of accounting software packages.

Outline of Activity

The workshop will provide students with training on how Excel and Sage software is utilised by accountants in practice and industry. Students will work on real life business simulations and will enter business transactions onto the accounting packages. Students will prepare working papers; financial statements and the business case file for review by qualified accountants in practice. This workshop is targeted at business and accounting students who are in their final degree year.

Learning Outcomes

  • Learn how to use accounting software packages
  • Gain commercial and business awareness
  • Consolidate their academic financial accounting knowledge gained from year 1 & 2 accounting modules.
  • Employability skills
  • Gain an insight into the working environment of the accountancy profession.

Assessment Details

A business case study will be given to students which will include details of business transactions incurred throughout the accounting period. Students will be required to submit a case file incorporating:

  • Excel spread sheets summarising sales and purchases invoices
  • Formatted trial balance
  • Nominal ledger activity
  • Final financial statements and
  • Completed HM Revenue & Customs self assessment tax return.

Level of Commitment

30 hours in total:

2 Day workshop7 hours X 2
Case Study Progress meeting1 hour
Self study to include practising Sage activities provided in workshop handbook and preparation of case file for submission and review.14 hours
Feedback Workshop1 hour

Related Staff

Claire Scott-Mcateer

Lecturer in Accounting and Taxation
Department of Global Bus. & Enterprise
+44 28 7167 5560
ML011 - Magee campus

Find out more about Claire Scott-Mcateer

Clodagh Hegarty

Lecturer in Accounting
Department of Global Bus. & Enterprise
+44 28 7167 5332
ML012 - Magee campus

Find out more about Clodagh Hegarty

Dr Helen Shiels

Lecturer in Management
Department of Global Bus. & Enterprise
+44 28 7167 5344
ML203 - Magee campus

Find out more about Dr Helen Shiels