Computer Academy


Enquire Now

Course Information

  • 24 Jan 2022 (Mon) - 31 Jan 2022 (Mon) 7:00 PM - 10:00 PM
  • 21 Feb 2022 (Mon) 10:00 AM - 5:00 PM
  • 24 Feb 2022 (Thu) - 3 Mar 2022 (Thu) 7:00 PM - 5:00 PM
  • 22 Mar 2022 (Tue) - 29 Mar 2022 (Tue) 7:00 PM - 10:00 PM
  • 26 Mar 2022 (Sat) - 2 Apr 2022 (Sat) 2:00 PM - 5:00 PM
Registration period
6 Dec 2021 (Mon) - 5 Mar 2022 (Sat)
HKD 1,680
Course Level
Study Mode
6 Hour(s)
Room 603 Dominion Centre, 43-59 Queen's Road East Wanchai, Hong Kong

Course Overview

Everyday we are facing much competition from internal and external of a corporation. Who can maintain the quality and lower costing should be the winner. Due to use much manpower to handle data, it is difficult to keep lower costing

This course use Microsoft Excel features, which can help Accountant, Management people to store information of customers, products, account details, tracking of transaction, preparing purchasing order, sales invoice etc. So they can save their time and do it more accurate.

You can learn the features of Microsoft Excel step by step through different kind of examples. These can give you a clear picture of Excel.


What You’ll Learn

What you’ll learn

How to setup customer database

  • How to setup product database
  • How to setup chart of account General entry
  • How to prepare sales invoice
  • How to prepare purchasing order
  • How to prepare trial balance
  • How to prepare profit & loss and balance sheet

Database setup

  • Database setup
  • Setup customer database system
  • Assign customer ID
  • Edit, search, and sorting of customer
  • Setup manufacturer database system
  • Setup products database

Account setup

  • Accounting setup
  • Chart of account
  • Double-entry system for assets and liabilities
  • The Asset of stock
  • Double entry system for expenses and revenues
  • The effect of profit or loss on capital
  • Setup General Journal
  • General Journal Entry
  • Editing General Journal item
  • The sales journal
  • The Purchases Journal


  • Setup purchasing order
  • Setup sales invoice
  • Setup quotation
  • Trial Balance

Profit & Loss accounts and balance sheet

  • Setup Profit & Loss accounts
  • Setup Balance Sheet
  • Setup Monthly Balance
  • Protect your account system

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed