Information Technology Skills for Accounting Students

by Robertson, Ian

• ISBN13: 9780273617143
• ISBN10: 0273617141
• Format: Paperback
• Copyright: 1996-03-01
• Publisher: Ft Pr

Summary

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.

Table of Contents

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

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

Table of Contents provided by Publisher. All Rights Reserved.