Myanmar Institute of Business > Certificate Classes > Advanced Excel Course

Advanced Excel Course


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



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.
Scroll to top