top of page
  • Train the Trainer: From Design to Delivery
    Train the Trainer: From Design to Delivery
    Multiple Dates
    Train the Trainer: From Design to Delivery
    Tue, Sep 17
    "Training the Trainers" covers key areas in which prospective trainers have the responsibility of preparing, developing, delivering, and evaluating training programs.
  • Distributed Control System
    Distributed Control System
    Multiple Dates
    Distributed Control System
    Wed, Sep 18
    This training course has been designed with these recent trends in mind while covering the most important components of a DCS in detail. Emphasis is placed on DCS operation, networking, HMI, and Alarms
  • PSC Taxation Update
    PSC Taxation Update
    Multiple Dates
    PSC Taxation Update
    Wed, Sep 18
    This workshop sets out the theory and best practices in developing strategies and defining management responsibilities and implementation procedures for the management of risk and performance from the use of contractors.
  • Intergeneration Team Synergy and Collaboration
    Intergeneration Team Synergy and Collaboration
    Multiple Dates
    Intergeneration Team Synergy and Collaboration
    Wed, Sep 18
    Nowadays, people from different generations are often required to interact with each other in the workplace. This workshop provides insights into the right approach in place to managing generational differences, so organizations can develop effective team synergy and collaboration.
  • Problem Solving with DMAIC
    Problem Solving with DMAIC
    Multiple Dates
    Problem Solving with DMAIC
    Wed, Sep 18
    This two-day workshop is challenging from the outset. It is a blend of Tutor-led and experiential learning. It identifies the key concepts of creative thinking and problem-solving.
  • Fraud Investigation
    Fraud Investigation
    Multiple Dates
    Fraud Investigation
    Thu, Sep 19
    In this course, you will learn all the skills needed to conduct an effective and proactive fraud investigation. You will look at the key enablers of fraud and learn how to apply the Fraud Investigation Model.
  • Corporate (B2B) Selling Skills
    Corporate (B2B) Selling Skills
    Multiple Dates
    Corporate (B2B) Selling Skills
    Mon, Sep 23
    B2B Selling training enables salespersons to learn skills of building rapport, branding themselves, discovering customer needs and aspirations, influencing customers, using social networks for B2B sales, and building solutions for customers.
  • Building Agile, Solid and High Performing Team Working Remotely
    Building Agile, Solid and High Performing Team Working Remotely
    Multiple Dates
    Building Agile, Solid and High Performing Team Working Remotely
    Mon, Sep 23
    Teams of all shapes and sizes have found themselves working remotely during the coronavirus pandemic. With tight timelines, low budgets, and stress on employees to produce superior results, organizations are looking for ways to transform yesterday’s in-office teams into high-performance remote teams
  • Mastering Training Needs Analysis & Training Evaluation
    Mastering Training Needs Analysis & Training Evaluation
    Multiple Dates
    Mastering Training Needs Analysis & Training Evaluation
    Tue, Sep 24
    This two-day workshop couples new concepts and proven strategies with critical skill practice needed to prepare you for immediate on-the-job application.
  • Mastering Contracts Management
    Mastering Contracts Management
    Multiple Dates
    Mastering Contracts Management
    Tue, Sep 24
    You will learn how to manage relationships with the supplier; manage governance, probity, and compliance issues throughout all stages of the procurement cycle; understand stakeholder requirements; and ensure compliance with contract requirements.
  • Diversity and Inclusion in the Workplace
    Diversity and Inclusion in the Workplace
    Multiple Dates
    Diversity and Inclusion in the Workplace
    Tue, Sep 24
    Diversity is a big part of organizations and businesses and has been a high-profile issue since the late twentieth century — but much has changed in how we understand it. This course explores diversity and inclusion in the workplace on many levels.
  • OPRC IMO Level 2
    OPRC IMO Level 2
    Multiple Dates
    OPRC IMO Level 2
    Wed, Sep 25
    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.
  • Risk Management & Corporate Governance
    Risk Management & Corporate Governance
    Multiple Dates
    Risk Management & Corporate Governance
    Wed, Sep 25
    This course provided insights regarding the main factors that are essential to the successful financial management of corporations.
  • Working at Heights
    Working at Heights
    Multiple Dates
    Working at Heights
    Wed, Sep 25
    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
    Wed, Sep 25
    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.
  • Logistic Management
    Logistic Management
    Multiple Dates
    Logistic Management
    Wed, Sep 25
    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.
  • Certification in HR Professional (BNSP)
    Certification in HR Professional (BNSP)
    Multiple Dates
    Certification in HR Professional (BNSP)
    Tue, Oct 01
    This professional program is designed to provide intermediate and advanced level knowledge, for the management of human resources in an organization. It offers a good blend of theories, practices, case studies, and individual assignments in the HR field.
  • Pelatihan Masa Persiapan Pensiun (Retirement Readiness Training)
    Pelatihan Masa Persiapan Pensiun (Retirement Readiness Training)
    Multiple Dates
    Pelatihan Masa Persiapan Pensiun (Retirement Readiness Training)
    Tue, Oct 01
    This training will be aimed at helping companies to change the existing retirement paradigm.

Our Upcoming Trainings

Microsoft Office Excel 2016 Advanced
Microsoft Office Excel 2016 Advanced

Thu, Aug 15

|

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

1 more dates

Aug 15, 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