Information Technology Skills for Accounting Students

Information Technology Skills for Accounting Students

By: Ian Robertson (author)Paperback

More than 4 weeks availability


IT Skills for Accounting Students is designed for accounting students, or those students taking accounting as part of their course of study, who wish to gain a knowledge of computerised accounting and spreadsheets. The book is designed for students to use with minimal supervision.

Create a review


Part 1 deals with computerised accounting by way of a running case study of a fictional wholesale company, Ascot Enterprises, using Sage Sterling for Windows Version 3 and 3.10. The earlier chapters involve setting up the accounts of a new business, posting ledger transactions and the production of a set of Final Accounts. Later chapters cover report generation, invoicing, stock control and order processing. The accounting entries behind the various transactions are described. Part 2 covers the use of spreadsheets and their application to accounting and finance using Microsoftr Excel version 5. The essential features of worksheet building and formatting are described in the early chapters. This is followed by a description of 3-D facilities leading on to the use of Pivot Tables. The techniques involved in building, sorting, maintaining and filtering a database are also explained, as well as some useful 'tools' and the procedure for transferring data files from Sage to Excel. Accounting-related examples are used throughout with examples where appropriate. The final section contains 20 spreadsheet exercises which can be used to develop students' modelling skills. Solutions for the exercises are given, showing the model itself and the underlying formulae.

Product Details

  • publication date: 23/04/1996
  • ISBN13: 9780273617143
  • Format: Paperback
  • Number Of Pages: 480
  • ID: 9780273617143
  • weight: 1347
  • ISBN10: 0273617141

Delivery Information

  • Saver Delivery: Yes
  • 1st Class Delivery: Yes
  • Courier Delivery: Yes
  • Store Delivery: Yes

Prices are for internet purchases only. Prices and availability in WHSmith Stores may vary significantly