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