Analyze purchases using Excel worksheetsPurchases & Warehouses / Analyze purchases using Excel worksheets

  Start : May 20-2021
  End : May 22-2021
  Trainer : Eng. Saad Hamad
  Course Fee : 450.00$
  No. Of Places : 5 Of 12
  Location : Apt #7 ,Floor 11, Tower 4, Empire Business Towers, Erbil, Kurdistan Region, Iraq.

Analyze purchases using Excel worksheets
The course will discuss the skills of dealing with spreadsheet programs such as MS Excel and database management programs such as MS Access How to use these programs in the development and design of electronic applications, as well as providing them with the skills of how to use these programs in the analysis of data and information, and analysis of lists in order to assess the administrative performance of the facility, and provide information that helps in management decision-making, as well as the use of these programs in planning. Refine applied skills and support the experience of participants and expand the horizons of their practice in the use of computers for the purposes of raising the level of professional performance of work in various aspects.

who should attend?

 

Employees who are competent in the departments of procurement, needs, logistics and catering in ministries, institutions, authorities, companies, different departments, banks, and others.

Chairmen and members of the envelope opening committees and tenders decision committees in the entities described above.

Secretaries of tenders and auctions committees.

Employees in contract departments.

Advisers and legal scholars and legal departments.

Personnel departments of sales and marketing departments.

Project Management Specialists.

Employees in warehouse and warehouse departments.

Specialists in the departments of administrative affairs.

Chairmen and members of committees, which constitute acts of tenders and procurement.

objective

 

How to assess the competitiveness of supplier pricing through developing “Should Cost Models”

How to assess all elements of supplier capabilities by creating weighted average supplier scorecards

How to use Excel’s sophisticated decision support features for procurement analysis

How to visually compare bids, analyze spend, and track supplier performance by creating charts

How to use PivotTables, functions, and subtotals to summarize large amounts of purchasing data

How to develop “Target Pricing Models” for negotiation strategy

How to import data from other systems into Excel for analysis

How to drill down into complex purchasing spreadsheets by using filtering, conditional formatting, VLOOKUP and more

How to use macros to free up time for strategic purchasing work

content

 

Introduction to MS Excel

Introduction to MS Access

Applied software specialized in procurement

Use the Excel S M program in the chart:

Cost Planning.

Forecast and plan using the Solver Solution Wizard

Analysis and trade-off between decision alternatives using Scenarios scenarios

Systems design using MS Access

Define the objectives of the system.

Identify the main components and components of the system.

Preparation and design of system files.

Designing data entry documents (input forms).

Design of system outputs (information reports).

Linking system elements using Macros macros and Modules modules

Business Development Using Computer 1

Implementation of the full cycle of procurement work

Workshop: Analyzing, recording and summarizing procurement processes and preparing lists using computer

Development of computerized procurement work 2

Audit of procurement elements Result: Audit program and collection of evidence

Full Workshop: Using structured programs to review income and expenditure items, assets items, and obligations prepared electronically

Developing computer procurement work 3

Planning budget and preparation problems

Stages of the criteria and procedures for preparing the current budget

Work development using computer 4

Balancing projects and evaluation survey tasks

Performance Measurement, evaluation and improvement planning

Complete Workshop: Using Computer in Analysis and Criticism

Complete Workshop: Using a computer in the preparation, writing, and presentation of procurement reports




how can we help you?

 

Apply Now

(Bachelor - Master - Doctorate )