At the end of this course, the participants should be able to:
- prepare reports and financial statements using Excel
Accounting and Financial System
Accounting Cycle
Theory of Double-Entry
Financial Reports
Basic Concepts in Microsoft Excel
- Functions of Microsoft Excel
- Types of toolbars and their uses
- Used functions with Excel
Design of Excel Spreadsheets
- Enter data in a spreadsheet
- Accounting and financial formulas used in the data
- The preparation and Formatting of excel spreadsheets
- The use of excel spreadsheets as a database
Practical Applications in the Preparation of Financial Reporting Using Excel Spreadsheets
- Cash Report
- Bank Reconciliation
- Portfolio Report
- Inventory Report
- Customer receivables Report
- Suppliers payables Report
- Sales Report
- Purchases Report
- Trail Balance
- Adjusted Trial Balance
Practical Applications in the Preparation of Financial Statements Using Excel Spreadsheets
- The Balance Sheet
- The Income Statement
- Cash Flow Statement
- Statement of changes in Equity
-
