top of page
  • OPRC IMO Level 2
    OPRC IMO Level 2
    Multiple Dates
    OPRC IMO Level 2
    Mon, Dec 09
    This is the second level of a comprehensive training program in the field of oil pollution preparedness and response, including the availability of expertise for the development and implementation of training programs.
  • Managing Sales Performance
    Managing Sales Performance
    Multiple Dates
    Managing Sales Performance
    Mon, Dec 09
    Through the Managing Sales Performance course, we invite participants to be able to manage the overall sales team performance so that the team becomes more effective, solid, and synergistic in achieving sales targets.
  • Working at Heights
    Working at Heights
    Multiple Dates
    Working at Heights
    Mon, Dec 09
    The “Working at Heights” Training is designed to provide personnel with the ability to recognize the potential for serious injury when working at heights and determine safe methods available to minimize the risks involved.
  • Energy Isolation
    Energy Isolation
    Multiple Dates
    Energy Isolation
    Mon, Dec 09
    The course will provide authorized workers with step-by-step procedures for isolating equipment using such techniques as lockout tagout, lockbox, blinding, misalignment, double block and bleed, and single valve isolation.
  • Petroleum Project Economics & Risk Analysis
    Petroleum Project Economics & Risk Analysis
    Multiple Dates
    Petroleum Project Economics & Risk Analysis
    Mon, Dec 09
    This course provides practical guidance in the application of the techniques of the economic analysis currently used in the oil & gas industry
  • Electronic Filing & Documentation Management
    Electronic Filing & Documentation Management
    Multiple Dates
    Electronic Filing & Documentation Management
    Tue, Dec 10
    If the concept of a filing document management system is used properly in an organization, it will help maximize the service process, both to internal customers and to external customers, to create a good image and enhance the competitiveness of the organization.
  • Rigging & Manual Lifting
    Rigging & Manual Lifting
    Multiple Dates
    Rigging & Manual Lifting
    Tue, Dec 10
    Most crane accidents can be prevented by field personnel following basic safe hoisting and rigging practices.
  • Mastering Training Needs Analysis & Training Evaluation
    Mastering Training Needs Analysis & Training Evaluation
    Multiple Dates
    Mastering Training Needs Analysis & Training Evaluation
    Tue, Dec 10
    This two-day workshop couples new concepts and proven strategies with critical skill practice needed to prepare you for immediate on-the-job application.
  • Applied Project Management
    Applied Project Management
    Multiple Dates
    Applied Project Management
    Tue, Dec 10
    In this course, participants will learn the fundamentals of project management: how to initiate, plan, organize, control, and execute a project that meets objectives and satisfies stakeholders.
  • Strengthening Business Acumen and Collaboration
    Strengthening Business Acumen and Collaboration
    Multiple Dates
    Strengthening Business Acumen and Collaboration
    Tue, Dec 10
    In today’s increasingly complex business environment, leading organizations recognize superior strategy execution as a critical opportunity. However, the results of this study confirm that many companies are currently constrained by a business acumen gap.
  • Effective Managerial Skills for Middle Management
    Effective Managerial Skills for Middle Management
    Multiple Dates
    Effective Managerial Skills for Middle Management
    Tue, Dec 10
    This program offers an opportunity for team leaders and managers to acquire insights, explore leadership & people management concepts, and examine actionable strategies for building the kind of leaders who are capable of enabling their employees to deliver their optimum performances.
  • Mastering Strategic Planning
    Mastering Strategic Planning
    Multiple Dates
    Mastering Strategic Planning
    Tue, Dec 10
  • Treasury and Risk Management
    Treasury and Risk Management
    Multiple Dates
    Treasury and Risk Management
    Wed, Dec 11
    This course provides the mandatory foundation knowledge required to understand and run business processes for treasury and risk management.
  • Introduction to Upstream Business Process & Practice in Oil & Gas Operations
    Introduction to Upstream Business Process & Practice in Oil & Gas Operations
    Multiple Dates
    Introduction to Upstream Business Process & Practice in Oil & Gas Operations
    Wed, Dec 11
    The workshop provides an overview of the upstream activities, particularly in Indonesia. The workshop provides non-technical support personnel with an overview of the exploration/production process.
  • Logistic Management
    Logistic Management
    Multiple Dates
    Logistic Management
    Wed, Dec 11
    This training will build your understanding of the complexities of logistics management and planning by introducing the processes used, including outsourcing, network design, and distribution center management.
  • Performance Management System
    Performance Management System
    Multiple Dates
    Performance Management System
    Wed, Dec 11
    This course offers participants an in-depth explanation of several systems, their components, and building blocks. The course also tackles an important consideration, namely the proper launch, follow-up, and training of managers and employees responsible for successfully implementing such systems.
  • Achieving Results: Smarter Goal Setting, Planning & Decision Making
    Achieving Results: Smarter Goal Setting, Planning & Decision Making
    Multiple Dates
    Achieving Results: Smarter Goal Setting, Planning & Decision Making
    Wed, Dec 11
    This fast-paced training course will take you step-by-step through from the big-picture thinking and goal setting down to the daily details of planning and achieving results for yourself and your team.
  • Assertive Communication, Excellent Work Behaviour and Proactivity
    Assertive Communication, Excellent Work Behaviour and Proactivity
    Multiple Dates
    Assertive Communication, Excellent Work Behaviour and Proactivity
    Wed, Dec 11
    The main objective of this training is to train managers and supervisors on the assertive and effective communication skills they need to build team cohesion and drive up staff effectiveness in the workplace. In addition, this training aims to strengthen excellent work behavior and proactivity.

Our Upcoming Trainings

Microsoft Office Excel 2016 Advanced
Microsoft Office Excel 2016 Advanced

Tue, May 14

|

Indonesia

Microsoft Office Excel 2016 Advanced

This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting & filtering data, using PivotTables, Slicers & PivotCharts for analyzing data, auditing and analyzing worksheet data, import and export data, protecting data, etc.

Registration is closed
See other events

Time & Location

May 14, 2024, 8:00 AM – 5:00 PM

Indonesia

About The Training

PREREQUISITES

Before starting this course, students are recommended to take the following course or have equivalent knowledge: Microsoft® Office Excel® 2016: Basic & Intermediate Level.

OBJECTIVES

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, protect data, and you will also organize table data.

Upon successful completion of this course, students will be able to:

  • Enhance productivity and efficiency by streamlining the workflow.
  • Organize worksheet and table data using various techniques.
  • Summarizing data using functions.
  • Analyze data using PivotTables, Slicers, and PivotCharts.
  • Audit worksheets.
  • Analyze data.
  • Protecting data.
  • Import and export data.
  • Recording macro.

TARGET PARTICIPANTS

This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting & filtering data, using PivotTables, Slicers & PivotCharts for analyzing data, auditing and analyzing worksheet data, import and export data, protecting data, and record a macro.

COURSE CONTENTS

Lesson 1: Automating Worksheet Functionality

Topic 1A: Apply Conditional Formatting

Topic 1B: Add Data Validation Criteria

Lesson 2: Working with Lists

Topic 2A: Format data as Tables

Topic 2B: Create Sparklines

Topic 2C: Sorting Data

Topic 2D: Filtering data

Lesson 3: Data List Outline

Topic 3A: Create Outline Group

Topic 3B: Create SubTotal

Lesson 4: Using Functions to Summarizing Data

Topic 4A: Use SumIF, AverageIF, CountIF Function

Topic 4B: Use SumIFs, AverageIFs, CountIFs Function

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

Topic 5A: Create a PivotTables

Topic 5B: Analyze PivotTable Data

Topic 5C: Filter Data by Using Timelines and Slicers

Topic 5D: Present Data with PivotCharts

Lesson 6: Auditing Worksheets

Topic 6A: Trace Formulas

Topic 6B: Watch and Evaluate Formulas

Topic 6C: Troubleshoot Formula Errors

Lesson 7: Analyzing and Presenting Data

Topic 7A: Create Scenario

Topic 7B: Analyze Data using Goal Seek Feature

Topic 7C: Analyze Data using Solver Feature

Lesson 8: Enhancing Workbook

Topic 8A: Protecting Data

Topic 8B: Create and Use Template

Lesson 9: Importing and Exporting Data

Topic 9A: Import Data

Topic 9B: Export Data

Lesson 10: Macro

Topic 10A: Recording a Macro

Topic 10B: Editing a Macro

Share this Training

bottom of page