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.