Hong Kong School of Commerce

會計軟件及程式實務應用 (MYOB and Advanced Excel)

Enquire Now

Course Information

Schedules
  • 4 Dec 2024 (Wed) 7:00 PM - 10:00 PM
Registration period
9 Sep 2024 (Mon) - 3 Dec 2024 (Tue)
Price
HKD 2,700
(學費 :
$1700 第1期;
$1000 第2期)
Course Level
Study Mode
Duration
42 Hour(s)
Language
Cantonese, English
Location
香港尖沙咀柯士甸道81號
4 views

Course Overview

課程簡介

1991年成立於澳洲,MYOB的產品以簡單、易用見稱,並取得多個國際性的系統設計獎項。MYOB為全球最受歡迎的中小企會計及管理系統之一,客戶遍及香港、澳洲、新西蘭、新加坡、馬來西亞及其餘亞洲區,全亞太區擁有超過一百萬客戶及超過一萬會計專業公司使用。MYOB會計軟件深受香港學術界認同,獲認可為HKIAAT(香港財務會計協會)及LCCI電腦會計考試指定軟件,透過這些相關課程及考試,讓僱主在尋找合適的僱員時有更大的選擇。

本課程除了教授一般會計基本流程外,並會同時教授如何充份及有效率地運用MYOB。而課程亦涵蓋Excel之會計功能應用,使學員更能全面掌握及提升工作技能!

* 本課程適合修畢LCCI 基礎會計課程之學生報讀
* 附送精簡講義
* 學員如有75%出席率,可獲頒發證書,申請證書費用$50。

入學資格:須修畢基礎會計課程 或 具有會計工作經驗

 

What You’ll Learn

Table of Contents

1. Create a company file using MYOB accounting system
2. Understand types of account and set up accounts list
3. Set up customers and suppliers cards
4. Set up budgets
5. Set up VAT scheme
6. Set up initial opening balances for accounts, suppliers and customers
7. Process purchases and returns transactions
8. Process pay bills transactions via bank including discounts
9. Process sales and receive payments transactions
10. Process pay bills transactions via bank and credit cards including discounts
11. Process other payments and receipts transactions
12. Process bad debts, contra entries and dishonoured cheques
13. Record transactions relating to the acquisition and disposal of fixed assets
14. Make end of period adjustments including inventory, income, expenses and VAT
15. Generate period end reports
16. Review and analyse period end reports including calculation of accounting ratios
17. MYOB and Excel integration (reporting, transaction import and export)
18. Using formulas and functions
19. Building Charts
20. Using pivot table for data analysis
21. Automate repetitive task to boot efficiency (macro programming)



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