会计软件及程式实务应用.PDFVIP

Software Applications in Practical Accounting (MYOB and Advanced Excel) 會計軟件及程式實務應用 課程簡介: MYOB會計應用軟件，已於各大小企業使用了接近十年，亦是香港最流行的會計應用軟件之一。 本課程除了教授一般會計基本流程外，並會同時教授如何充份及有效率地運用MYOB，從而可 應考LCCI公開考試。而課程亦涵蓋Excel之會計功能應用，使學員更能全面掌握及提升工作技能! 課程大綱: 1. Create a company file using MYOB 11. Process other payments and receipts accounting system transactions 2. Understand types of account and set 12. Process bad debts, contra entries and up accounts list dishonoured cheques 3. Set up customers and suppliers cards 13. Record transactions relating to the 4. Set up budgets acquisition and disposal of fixed assets 5. Set up VAT scheme 14. Make end of period adjustments including 6. Set up initial opening balances for inventory, income, expenses and VAT accounts, suppliers and customers 15. Generate period end reports 7. Process purchases and returns 16. Review and analyse period end reports transactions including calculation of accounting ratios 8. Process pay bills transactions via bank 17. MYOB and Excel integration (reporting, including discounts transaction import and export) 9. Process sales and receive payments 18. Using formulas and functions transactions 19. Building charts 10. Process pay bills transactions via bank 20. Using pivot table for data analysis and credit cards including discounts 21. Automate repetitive task to boot efficiency (macro programming) 入學資格: 須修畢基礎會計課程 學費: HK$1,700 (第一期), HK$1,000 (第二期) (42 小時) 開課日期﹑時間: 詳情請參閱上課時間表 以上課程: 附送精簡講義 證書:凡學員出席率達75%，可獲香港商業專科學校頒發「聽講證書」，申請聽講證書費HK$50。