Advanced Excel Course from Myanmar Institute of Business

Advanced Excel Course from Myanmar Institute of Business

Myanmar Institute Of Business, Yangon, Myanmar (Burma)

Description

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

-nventory Control and Inventory Database

-Sale & Purchase Ledger

-Non-Current Asset Ledger And How to build final report.

Duration:3 days teaching, 7 hours per day x 3 days

Learning Outcomes

-Analyze , Summarize daily/ weekly/ monthly sales records in order efficiently effectively.

-To obtain the reports from datas in anyway anytime necessary.

Add A Review

Enquiry

Your enquiry submitted successfully

Enquiry Submission failed

Please enter input field(s)

Claim this course

To manage this course details kindly claim this course.