Analyze purchases using Excel worksheets
Register

• The course will discuss the skills of dealing with spreadsheet programs such as MS Excel and database management programs such as MS Access
And how to use these programs in the development and design of electronic applications, as well as to provide them with the skills of how to use these programs in the analysis of data and information, and analysis of the lists in order to assess the management performance of the facility, and provide information that helps in the management decision, and the use of these programs in planning.
And improve the skills of the application and support the experience of participants and expand the horizons of their practice in the use of computers for the purpose of raising the level of professional performance to work in various aspects.

Introduction to software programs used in procurement:
• Introduction to M S Excel
• Introduction to M S Access
• Specialized software in procurement
Use the Excel S M program in the chart:
Cost planning.
Prediction and planning using Solver Solution Wizard
Analysis and differentiation between decision alternatives using scenarios Scenarios
Design of systems using the M S Access program
Set the system objectives.
Identify key components and components of the system.
System Files and Design.
Design of data entry documents (input forms).
Design of system outputs (information reports).
Link system elements using Macros macros and Modules modules

10. Development of computer work
Implementation of the full cycle of procurement work
Workshop: Analyzing, recording and summarizing procurement processes and preparing lists using computer
20. Development of computer procurement
Audit of procurement items Result: Audit program and evidence collection
Full workshop: Use of structured programs to review revenue items, expenses, assets and liabilities electronically
30. Development of computer procurement
Planning budget and preparation problems
Stages of current budget preparation criteria and procedures
40. Development of computer work
• Project balancing and evaluation review tasks
• Performance measurement, evaluation and planning for improvement
• Full workshop: Using computer in the field of analysis and criticism
• Full workshop: Use of computers in the preparation, writing and presentation of procurement reports
• Introduction to M S Excel
• Introduction to M S Access
• Specialized software in procurement
Use the Excel S M program in the chart:
• Cost planning.
• Predict and plan using the Solver Solution Wizard
• Analysis and differentiation between decision alternatives using scenarios Scenarios
• Systems design using M S Access software
• Set the system objectives.
• Identify key components and components of the system.
• System Files.
• Design of data entry documents (input forms).
• Design of system outputs (information reports).
• Link system elements using macros, macros, and modules


• Developing computer-based work
تنفيذ Implementation of the full procurement work cycle
Workshop: Analyzing, recording and summarizing procurement processes and preparing lists using computer
• Development of computer procurement
Audit of procurement items Result: Audit program and evidence collection
Full workshop: Use of structured programs to review revenue items, expenses, assets and liabilities electronically
• Development of computer procurement
Planning budget and preparation problems
Stages of current budget preparation criteria and procedures
• Developing computer-based work
Project Balancing and Evaluation Review Tasks
Performance Measurement, evaluation and planning for improvement
Full workshop: Using computer in the field of analysis and criticism
Full workshop: Use of computers in the preparation, writing and presentation of procurement reports


- Distributed non-intensive course and comfortably and schedules evening and Meret halls.
- The cost of training we are the least in the Kingdom of Saudi Arabia.
- Lecturers and professional trainers and experts in their specialization.
- Accredited by the Saudi Council of Engineers and the General Organization for Technical and Vocational Training session.
- Continuous contact with the lecturer after the course and during the course.
- You can re-attend the course free of charge.
- Present in all parts of the Kingdom.

35 training hours

No upcoming courses are scheduled
Contact Info
  • Phone

    0541323774-0542341634-0562646555

  • Mobile - KSA

    0541323774-0542341634-0562646555

  • whatsapp

    0541323774-0542341634-0562646555

  • E mail

    [email protected]

Our Branches
  • Jeddah
  • Dammam
  • Makkah
  • Madina
  • Cairo
  • Riyadh
  • Qassim

Copyright © 2015 - All Rights Reserved by professionalengineers.us

PfMP®, PgMP®, PMP®, PMI-RMP®, PMI-SP®, PMI-ACP®, PMI-PBA®, CAPM® are registered marks of the Project Management Institute, Inc.