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

Using Microsoft Excel to Prepare of Financial Reports

The course is based on practical applications using computers, in addition to implementing a set of practical exercises using computers and under the supervision and guidance of the trainer

Professionals, analysts, financial professionals and accountants working in the field of reporting, analyzing and processing financial and accounting data.