Cost Management using Microsoft Excel

calcul tabelar

  • Duration of course: 2 days, 6h of study/day
  • Working method: methodology based on practical experience in projects
  • Location: Onsit, Infinity Business Center HQ or online

For

  • The course addresses to project \ program managers and cost controllers, and anyone who wants to acquire the skills required to use MS Excel intermediate – advanced – in a quick, pleasant and efficient.

Benefits

  • Excel gives businesses strong tools, but can be equally helpful for individuals who need to process and manage personal data
  • When creating a budget for a small product, you can list expense categories in a spreadsheet, update it monthly and create a chart to show how close the product is to budget across each category.
  • This means that they need a quick and efficient way to gather the data together and analyze it.
  • Excel allows users to build a variety of great charts including pie charts, clustered column charts and graphs
  • Data can be imported and exported from a variety of files.

What you will learn

  • The course brings a completely new approach to how advanced knowledge of Microsoft Excel can be transmitted to participants, by avoiding the usual pattern of a Excel course and combining basic knowledge of Cost Management in projects with proper use of Excel features \ functions.

About the trainer

Eng. Mircea TARASSOFF
loc si rol al managementului proiectelor

  • Graduated from the Facualty of Mechanical Engineering and the Master of Integrated Design in Mechanical Engineering from the Polytechnic University of Bucharest. He had the opportunity to learn Project Management in a course in college and instantly became his favorite course
  • More than 7 years in Project Management, covering roles such as project planner and cost controller, in projects in Oil&Gas and Engineering&Design:
    • Project Planner for the entire portofilo of investment projects OMV Petrom – Asset Buzau, Moinesti and Targoviste
    • Cost Controller for Field Redevelopment Program Oprisenesti – OMV Petrom
    • Project Planner for modernization and maintenance projects for cruise ships – Consorzio IDC
    • Training and implementation of MS Project for Professional Tools Production Department – Grupul Electroprecizia S.A.
    • Project Planner & Cost Controller in the framework between Enereco S.p.a. with Lukoil Mid-East for the projects:
      • Gas Sweetening Unit
      • Additional Flare system
      • Design Optimisation of Wellpad 11
  • Trainer for Project \ Portfolio Management Solutions – Primavera P6 EPPM and MS Project Professional

Course structure:

• Presenting a case study consisting of several related projects, developed in numerous locations

• Aims:

  • Data conversion
  • Formatting tables
  • Conditional Formatting
  • Filters
  • Subtotals
  • Text or data functions
  • Vlookup
  • Pivot table
  • Graphs
  • links between tables

• In addition, basic project cost manangement concepts are presented:

  • budget
  • forecast
  • actuals
  • cost deviations
  • S curves

• It will also be explained in detail the most important models for economic analysis for projects:

  • Pay Back Period – PB
  • Net Present Value – NPV
  • Internal Rate of Return – IRR

Form for requesting a customized course offer

Course

Location
OnsiteInfinity Business Center HQOnline