Microsoft Excel

for Accountants

90% of accounting professionals use Excel for budgeting, planning and forecasting day-to-day operations. 

Suitable for all type of business people especially for accounting purpose

40,000+ learners accomplished

About This Course

This comprehensive course is designed especially for the people who want to be accountants and who wants to get spreadsheet skills in accounting knowledge to record, monitor, control accounts activities and prepare reports.

Excel is a very powerful tool for accountants, and it is a key skill that all accountants should try to become familiar with. If you are a newly qualified accountant, accountancy student or just a small business owner who wants a better handle on their finances, Excel is the most suitable tool to use.

This course includes the basic functions of Excel, drawing Cash Flow Statement, Balance Sheet, Income Statement, Trial Balance, etc.

Who is this course for?

It is best fit for accountants, business managers and business owner who want a better handle on their finances. It would be more effective for the learners who have some accounting knowledge background.

 

What you will learn

  • A review of the fundamental tools and techniques available in Microsoft Excel spreadsheet software
  • Setting the workbook and its worksheets
  • How to prepare a final adjust Trial Balance to be used for preparing the financial statements
  • How to add the account balance of the final Trial Balance to the appropriate column in worksheet
  • Step-by-step instructions for creating a Balance Sheet report
  • How to create the Income Statement report using Excel’s worksheet
  • How to create a Cash Flow report using an Excel worksheet
  • About the Notes worksheet
  • How to use carious techniques to customize the workbook according to your needs
  • How to review all the various options you can use to protect your financial information data and files
  • How to print or mail Financial Statements reports
  • How to create the Balance Sheet five-year comparison report
  • How to create the Income Statement five-year comparison report and quarterly comparison reports
  • How to use PivotTable and PivotChart reports to analyze the company’s Financial Statements
  • Techniques for Financial Statement Analysis
  • How to create the company’s Profit Center’s Income Statement reports

Course Outline

  • Chapter 1: Introducing Financial Statements Worksheets
  • Chapter 2: Adjusting the Trial Balance
  • Chapter 3: Updating the Trail Balances Data Worksheet
  • Chapter 4: Balance Sheet
  • Chapter 5: Income Statement
  • Chapter 6: Cash Flow
  • Chapter 7: Notes
  • Chapter 8: Customizing the Financial Statements .xlsx Workbook and Presenting Information
  • Chapter 9: Protecting Financial Data
  • Chapter 10: Printing and Mailing Financial Statements Reports
  • Chapter 11: Balance Sheet Five-year Comparison Reports
  • Chapter 12: Income Statement Five-year and Quarterly Comparison Reports
  • Chapter 13: Analyzing Financial Statements Using PivotTable and PivotChart Reports
  • Chapter 14: Analyzing Financial Statements and Calculating the Ration Analysis
  • Chapter 15: Analyzing Profit Centers
  • Length

8 weeks

  • Effort

8 hours per week

  • Institution

iNet College

  • Price

180,000 MMK

  • Sectons

Weekday Section

Monday to Thursday

(2 hours per day)

Weekend Section

Saturday to Sunday

(4 hours per day)

  • Upcoming class

April 00, 2019

Saturday to Sunday

1 pm – 5 pm

April 00, 2019

Monday to Thursday

5 pm – 7 pm

More Application Courses

B.Sc. in Computing
BTEC HND in Computing
Pre University Program
Programming Course
Networking Course
Application Course
Certification Course

University Partnerships

Diploma Awarding Partner