Project management(primavera&ms-project) & advanced excel training in ph-jan-may 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

1. BASIC,INTERMEDIATE & ADVANCED EXCEL- 5 DAYS
   

1. PRIMAVERA(P6)-project management - 3DAYS

1. MS-PROJECT- project management - 3DAYS

1. Comprehensive Microsoft Excel 2013
[IMG]file:///C:\Users\ELDEMU~1\AppData\Local\Temp\msohtmlclip1\ 01\clip_image001.png[/IMG]
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

1. Creating a Microsoft Excel Workbook
2. The Ribbon
3. The Backstage View (The File Menu)
4. The Quick Access Toolbar
5. Entering Data in Microsoft Excel Worksheets
6. Formatting Microsoft Excel Worksheets
7. Using Formulas in Microsoft Excel
8. Working with Rows and Columns
9. Editing Worksheets
10. Microsoft Excel 2013 New Features 1
11. Advanced Formulas
12. Working with Lists
13. Visualizing Your Data
14. Working with Tables
15. Advanced Formatting
16. Microsoft Excel 2013 New Features
17. Using Pivot Tables
18. Auditing Worksheets
19. Data Tools
20. Working with Others
21. 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.


[IMG]file:///C:\Users\ELDEMU~1\AppData\Local\Temp\msohtmlclip1\ 01\clip_image001.png[/IMG]
What will be learned
[IMG]file:///C:\Users\ELDEMU~1\AppData\Local\Temp\msohtmlclip1\ 01\clip_image001.png[/IMG]
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
[IMG]file:///C:\Users\ELDEMU~1\AppData\Local\Temp\msohtmlclip1\ 01\clip_image001.png[/IMG]
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
[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.

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


3. Microsoft project 2013
[IMG]file:///C:\Users\ELDEMU~1\AppData\Local\Temp\msohtmlclip1\ 01\clip_image001.png[/IMG]
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
[IMG]file:///C:\Users\ELDEMU~1\AppData\Local\Temp\msohtmlclip1\ 01\clip_image001.png[/IMG]

1. Easily plan & manage your projects with intuitive controls and flexible team tools to help your organization deliver the intended business value.
2. be efficient and prioritize by aggregating everyday work, project tasks, important details, and timelines in a visually rich and contextual interface.
3. Manage anywhere with tools to keep you connected with your team and on top of your projects while you’re on the go.
4. Deliver effective presentations that offer immediate insight into task planning, resource allocation, cost efficiencies, and the many important details of your projects.
5. Anticipate Change with forward-looking views into the everyday work going into your projects and the resources needed to get that work done.
6. 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
JAN 2016-MAY 2016

MONDAY -4^TH JANUARY-2016-TRAINING BEGINS
-----------11^TH JAN
--------------25^TH JAN..2016
FEBRUARY 2016
-----------1^ST FEB 2016
-----------15^TH FEB
MONDAY -29^TH FEB 2016
MARCH 2016
TUESDAY-8^TH MARCH 2016
MONDAY-14^TH MARCH 2016
MONDAY 28^TH MARCH 2016
APRIL 2016/MAY 2016
WEDNESDAY 6^TH MARCH 2016
MONDAY 18^TH MARCH 2016
MONDAY 2^ND MAY 2016.

Contact;
Telephone -07051852201,08064673745,08038812638
Email;[email protected],[email protected]

Office address-Eldemuz engineering centre,
1^st floor ,60 Aba road ,by craft centre busstop ,portharcourt,
Rivers state, Nigeria

08038812638

pls call 08038812638

call 08038812638

08038812638

08038812638

08038812638

08038812638

08038812638

08038812638

pls call 08038812638

pls call 08038812638

call 08038812638