Course of Professional Use of Microsoft Excel for Data Design and Analysis

To whom this course:

This course offered to those interested in the field of work on computers, administrators within government institutions and accountants as Excel program is one of the best accounting programs. In addition, anyone who has a private business or a project wants to organize his financial statements using modern methods.

Course Objectives:

• Acquiring trainees for many skills that enable them to work on Excel and Access programs.
• Organize data in electronic tables.
• Teaching methods of developing electronic accounting.
• Teaching the principles of evaluating the financial and administrative performance of the establishments.
• Preparation of accounting and financial budgets.
• Give the trainee a special competence to use the computer within the work and expand their horizons for practice.

Basic aspects of the course:

• A brief description of computer programs and its applications in accounting matters.
• The use of Access program in accounting system design.
• Clarifying the purposes of the system.
• Clarifying key elements and components of the system.
• Design files for the system.
• Create special models for data and how to enter them into the system.
• Brief about Microsoft Excel program.
• Brief about Microsoft Access program.
• Specialized accounting applications.
• Uses of Excel program.
• Cost regulation.
• Prepare profit in maps.
• Use a solution wizard.
• Create informational reports of the system.
• Create a network linking system information using micro modules and modules.

Computer as a developer of accounting work:

• Apply accounting work in an integrated manner.