Advanced Excel Course

Program	Advanced Excel Course (for Accountants and Finance Professionals)
Teaching hour	7 hours per day x 3 days
Duration	3 days teaching
Program fee	80,000 mmk per program
Lecturer	#
Learning Objectives	To increase proficiency of Accounting Skills
Module Outline To construct useful and complicated Excel Functions by Powerful tools and use Data Base efficiently. Usage of Logical Functions (If and Ifs functions ) Usage of Date and Time Formulas Usage of Math and Statistical Formulas ( SUM, MAX, MIN , COUNT , AVERAGE , SUMIF & SUMIFS ) Construction of Chart of Account and Cash Book and Cash Summary General Ledger Receivable & Payable Ledger Inventory Control and Inventory Database Sale & Purchase Ledger Non-Current Asset Ledger And How to build final report.
Learning Outcomes Analyze , Summarize daily/ weekly/ monthly sales records in order efficiently effectively. To obtain the reports from datas in anyway anytime necessary.

Certificate Classes