Back  
Course Information PDF
   
Course Category: Information Technology
Course Title: Microsoft Excel in the Accounting and Financial Applications


Course Code: IT037
Medium of Instruction: Cantonese
Duration: 30.0 hour(s)
 Course Fee:
Macao Resident: MOP2,250
Non-Macao Resident: MOP2,250
Certificate: Students who have obtained an overall passing grade of the course and met the attendance requirement will be issued a course certificate by UTM. The passing grade of the course is 50.
Course CodeSub CodeCourse Start DateCourse End DateClass Schedule
IT03724012024/03/132024/04/17View



Objective: This course is designed to let students learn how to use Microsoft Excel spreadsheets and process accounting and financial management operations using the computer.

Outline:
  • Interface introduction on Microsoft Excel, Microsoft worksheet editing, formulas and functions
  • Create accounting entry form
  • Accounting spreadsheet practice
  • Practical application of income statement
  • Balance sheet analysis application
  • Cash flow forecast analysis
  • Personnel and payroll management

Teacher: Please refer to the schedule

Remarks: English version of the software is used.

  Last Updated: 2023/05/31

  Back