Computer Academy

FINANCIAL ACCOUNTING WITH EXCEL TRAINING COURSE OUTLINE BY COMPUTER ACADEMY

Enquire Now

Course Information

Schedules
  • 26 Aug 2020 (Wed) - 2 Sep 2020 (Wed) 7:00 PM - 10:00 PM
  • 15 Sep 2020 (Tue) 10:00 AM - 5:00 PM
  • 22 Sep 2020 (Tue) - 29 Sep 2020 (Tue) 10:00 AM - 5:00 PM
  • 15 Oct 2020 (Thu) 10:00 AM - 5:00 PM
Registration period
16 Jul 2020 (Thu) - 21 Sep 2020 (Mon)
Price
HKD 1,680
Course Level
Study Mode
Duration
6 Hour(s)
Language
Cantonese
Location
香港旺角彌敦道721號, 華比銀行大廈604室
390 views

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

Course Contents:

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
  • Setupcustomerdatabase 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

Sales

  • 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


Don't miss the latest courses!

Subscribe to receive information about CT Learning.

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