Topic: Project management and advanced excel training (primavera,ms-proect, excel)2016

ELDEMUZ ENGINEERING CONSULTING IS A registered LOCAL CONTENT PARTNER with the federal government of Nigeria IN CAPACITY DEVELOPMENT for the oil and gas industry. We offer training to, consultant, engineers, managers, senior and junior staff in the oil and gas industry as well as fresh graduates and focused undergraduates. Our interest is for those pursuing excellence and improvement in their career. Our work force is made up of young Nigerian engineering graduates who have acquired software skills through the PTDF scheme. Our goal is to transfer knowledge at its best. The software’s we offer are used mostly by SHELL, MOBIL, SCHLUMBERGER, TOTAL, ELF, AGIP,chevron, AND other major oil companies in Nigeria.we have experience in training and field operations.we have evolved over the years to be a brand name in oil and gas training and other computer based courses.enrol today.

TRAINING BROCHURE







BASIC,INTERMEDIATE & ADVANCED EXCEL- 5 DAYS






PRIMAVERA(P6)-project management - 3DAYS






MS-PROJECT- project management - 3DAYS






1. Comprehensive Microsoft Excel 2013

Class Description (comprehensive)

Class Overview

On the first day of this comprehensive Microsoft Excel 2013 training course, students will learn to use Excel 2013 to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The second day of class will focus on using advanced formulas, working with lists, working with illustrations and charts, and using advanced formatting techniques. And on the third, fourth and final day of class, students will learn to work with pivot tables, audit worksheets, work with data tools, protect documents for collaboration with others, and work with macros.

This Comprehensive Microsoft Excel 2013 Training class is a combination of the following courses:





Introduction to Microsoft Excel 2013 Training

Intermediate Microsoft Excel 2013 Training

Advanced Microsoft Excel 2013 Training





Class Goals





Create basic worksheets using Microsoft Excel 2013.

Perform calculations in an Excel worksheet.

Modify an Excel worksheet.

Modify the appearance of data within a worksheet.

Manage Excel workbooks.

Print the content of an Excel worksheet.

Learn to use formulas and functions.

Create and modify charts.

Convert, sort, filter, and manage lists.

Insert and modify illustrations in a worksheet.

Learn to work with tables.

Learn to use conditional formatting and styles.

Create pivot tables and charts.

Learn to trace precedents and dependents.

Convert text and validate and consolidate data.

Collaborate with others by protecting worksheets and workbooks.

Create, use, edit, and manage macros.

Import and export data.







Class Outline





Creating a Microsoft Excel Workbook

The Ribbon

The Backstage View (The File Menu)

The Quick Access Toolbar

Entering Data in Microsoft Excel Worksheets

Formatting Microsoft Excel Worksheets

Using Formulas in Microsoft Excel

Working with Rows and Columns

Editing Worksheets

Microsoft Excel 2013 New Features 1

Advanced Formulas

Working with Lists

Visualizing Your Data

Working with Tables

Advanced Formatting

Microsoft Excel 2013 New Features

Using Pivot Tables

Auditing Worksheets

Data Tools

Working with Others

Recording and Using Macros





2. Project Management with Oracle Primavera (P6)



Projects and programs are becoming increasingly complex. Economic uncertainty is putting a new level of pressure on teams and programs to execute well. Businesses are struggling to react quickly to fluctuating markets and changing business demands. Executives are demanding more project visibility. Distributed teams require around the-clock collaboration and coordination, as well as the ability to successfully navigate change throughout the project lifecycle. Today’s project and program managers need tools that deliver the necessary project insight to maintain project schedule and budget commitments. And they need the ability to integrate project and program resources with other departments and at other locations to ensure project success.





Oracle’s Primavera enterprise project portfolio management solutions enable project-driven organizations to intelligently manage their programs and projects—from small and simple to large and complex. Primavera solutions can help you make better portfolio management decisions by providing end-to-end, real-time visibility into all relevant information. You can determine whether you have sufficient resources and team members with the right skills to accomplish the work. Primavera solutions help you evaluate the risks and rewards associated with projects and programs. You get the project management, collaboration, and control capabilities you need to manage change and successfully deliver projects on time, within budget, and with the intended quality and design. Plus, you can interoperate with ease—across the enterprise—with Primavera’s flexible integration capabilities.

COURSE CONTENT



Part 1:

Overview and Configuration

Understanding Project Management........................................ .........3

Quick Tour.............................................. ............................................13

Defining Administrative Preferences and Categories.....................29

Setting User Preferences....................................... .............................49

Part 2:

Structuring Projects

Setting Up the Enterprise Project Structure...................................67

Setting Up the Organizational Breakdown Structure....................97

Defining Resources and Roles............................................. ............109

Reviewing Work Breakdown Structures.......................................1 33

Defining Budgets........................................... .................................

Part 3:

Implementing the Schedule

Establishing Activity Codes............................................. ...............

Working with Activities........................................ ...........................

Working with Cost Accounts and Project Expenses....................





Part 4:

Updating and Managing the Schedule

Managing Baselines......................................... ................................

Updating, Scheduling, and Leveling.......................................... .....

Summarizing Projects.......................................... ...........................

Managing Risks............................................. ...................................

Project Issues and Thresholds........................................ ................

Maintaining a Project’s Document Library..................................359

Tracking Projects.......................................... ...................................365

Comparing Projects with Claim Digger........................................375

Creating and Using Reflections....................................... ...............391

Checking Projects In and Out............................................... .........397

Part 5:

Customizing Projects

Working with Layouts........................................... ..........................407

Grouping, Sorting, and Filtering Data...........................................417

Customizing Layouts .................................................. .....................427

Customizing Reports........................................... ............................455

Printing Layouts and Reports........................................... ..............491

Publishing a Project on the World Wide Web...............................501

Linking the Project Management and Contract Manager





Who needs this training





All staff at managerial and supervisory level.

Project department staff

All engineers.

Accounts and financial department staff.




3. Microsoft project 2013



Microsoft Project Professional 2013 gives you powerful new ways to effectively manage important projects. Unlock easy collaboration capabilities to quickly start and deliver winning projects while leveraging the power of Office 365 or SharePoint to work from virtually anywhere. Make communication instantaneous through seamless integration of Lync 2013 to call or instant message team members from Project Professional. Extend Project’s functionality with Apps for Office to meet your specific business needs

What will be learned





Easily plan & manage
your projects with intuitive controls and flexible team tools to help your organization deliver the intended business value.

be efficient and prioritize
by aggregating everyday work, project tasks, important details, and timelines in a visually rich and contextual interface.

Manage anywhere
with tools to keep you connected with your team and on top of your projects while you’re on the go.

Deliver effective presentations
that offer immediate insight into task planning, resource allocation, cost efficiencies, and the many important details of your projects.

Anticipate Change
with forward-looking views into the everyday work going into your projects and the resources needed to get that work done.

Explore the Office Store
to quickly innovate with flexible options to customize and extend out-of-thebox capabilities



Course content



1: Projects: In the Beginning

2: Planning a Project

3: Getting to Know Microsoft Project.

4: Creating a Simple Project 5: Setting Up a Project File.

6: Identifying the Work to Be Done

7: Building a Schedule

8: Building a Team for Your Project

9: Assigning Resources to Tasks 10: Setting Up a Project Budget.

11: Reviewing and Fine-Tuning Your Plan.

.

12: Saving the Project Plan..



13: Tracking Status. ..



14: Evaluating and Correcting Project Performance



15: Managing Change.



16: Reporting on Projects. .

Who needs this training

[IMG]file:///C:\Users\ELDEMU~1\AppData\Local\Temp\msohtmlclip1\ 01\clip_image001.png[/IMG]

1.All staff at managerial and supervisory level.

2.project department staff

3.All engineers.

4.accounts and financial department staff.



Contact& TRAINING BATCH START DATES;

Each of the programs below fit into this schedule call us to enroll

MAY 2016-AUGUST 2016

MAY 2016

MONDAY -2ND MAY

----------- 16<sup>TH MAY

------------30TH MAY2016

JUNE 2016

-----------7TH JUNE 2016

-----------14TH JUNE

MONDAY -27TH JUNE 2016

JULY 2016

MONDAY-4TH JULY 2016

MONDAY-11TH JULY 2016

MONDAY -25TH JULY 2016

AUGUST 2016

MONDAY -1TH AUGUST 2016

MONDAY 8TH AUGUST 2016

MONDAY-29TH AUGUST 2016.



Contact;

Telephone -,08038812638,07051852201,08064673745

Email;[email protected],[email protected]



Office address-Eldemuz engineering centre,

1st floor ,60 Aba road ,by craft centre busstop ,portharcourt,

Rivers state, Nigeria</sup>

08038812638