top of page
  • Risk Management & Corporate Governance
    Risk Management & Corporate Governance
    This course provided insights regarding the main factors that are essential to the successful financial management of corporations.
  • PSC Cost Recovery and Gross Split
    PSC Cost Recovery and Gross Split
    Multiple Dates
    Mon, Mar 04
    This course covers the basic concepts and principles of Production Sharing Contract (PSC) Cost Recovery and Gross Split mechanisms in the Oil and Gas industry.
  • Sustainable Supply Chain Management
    Sustainable Supply Chain Management
    Multiple Dates
    Mon, Mar 04
    This course has a unique focus on sustainability and ethical trading. We’ll help you become a professional capable of making decisions that consider the full range of economic, social, and environmental impacts of supply chains.
  • Recruitment, Behavioural Interviewing and Selection
    Recruitment, Behavioural Interviewing and Selection
    In this course, you will learn about the methods of interviewing that allow interviewees to prove their worth.
  • Offshore Oil and Gas Development Projects, Concepts and Facilities
    Offshore Oil and Gas Development Projects, Concepts and Facilities
    Participants in this training seminar will gain a good understanding of the concept selection, engineering, functional, processing, construction, project management, and cost aspects of oil and gas production and export facilities.
  • Leaders as a Coach
    Leaders as a Coach
    Multiple Dates
    Mon, Mar 04
    Coaching and mentoring is an increasingly critical aspect of the leader’s role. As the trend towards blended learning for staff accelerates, managers are required to take a greater role in the informal side of learning, most commonly in the form of on-the-job coaching and mentoring.
  • International Oil & Gas Business Management
    International Oil & Gas Business Management
    This course will provide a basis for functional managers and those whose experience has been limited to a particular area of the industry, to prepare for additional responsibilities by providing a broad base of knowledge covering the total spectrum of the Oil and Gas business and related skills.
  • Working at Heights
    Working at Heights
    Multiple Dates
    Tue, Mar 05
    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.
  • Train the Trainer: From Design to Delivery
    Train the Trainer: From Design to Delivery
    "Training the Trainers" covers key areas in which prospective trainers have the responsibility of preparing, developing, delivering, and evaluating training programs.
  • Strategic Human Resources & Talent Management
    Strategic Human Resources & Talent Management
    "The Strategic Human Resources Management" course is based on a proactive approach to the management of people. Using your workplace as the starting point, you will walk through a strategic, competency-based human resource management facilitation model.
  • Pelatihan Masa Persiapan Pensiun (Retirement Readiness Training)
    Pelatihan Masa Persiapan Pensiun (Retirement Readiness Training)
    This training will be aimed at helping companies to change the existing retirement paradigm.
  • Contract Administration: Understanding and Implementing Contractual Obligation
    Contract Administration: Understanding and Implementing Contractual Obligation
    The overall aim of this course is to provide participants with the knowledge, concepts, skills, and tools necessary to manage and administer contracts post-award.
  • Project Management with Primavera
    Project Management with Primavera
    Multiple Dates
    Tue, Mar 05
    Primavera P6 solutions can assist you in making enhanced project management decisions by providing start-to-end, real-time visibility into all significant information.
  • Microsoft Office Excel 2016 Advanced
    Microsoft Office Excel 2016 Advanced
    Multiple Dates
    Tue, Mar 05
    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.
  • Simplification of Work Processes & Procedures
    Simplification of Work Processes & Procedures
    This practical and highly engaging course will prepare all participants to design, develop, manage, control, implement, simplify, and monitor work processes and procedures and associated management system documents such as work instructions, forms, labels, and tags.
  • Achieving Results: Smarter Goal Setting, Planning & Decision Making
    Achieving Results: Smarter Goal Setting, Planning & Decision Making
    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.
  • Creative and Innovative Thinking
    Creative and Innovative Thinking
    Multiple Dates
    Tue, Mar 05
    Creativity and Innovation Training Course covers creative thinking and problem-solving methods that generate new ideas and solve problems.
  • Assertive Communication, Excellent Work Behaviour and Proactivity
    Assertive Communication, Excellent Work Behaviour and Proactivity
    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.

Time & Location

3 more dates

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