top of page
  • Pelatihan Masa Persiapan Pensiun (Retirement Readiness Training)
    Pelatihan Masa Persiapan Pensiun (Retirement Readiness Training)
    Multiple Dates
    Pelatihan Masa Persiapan Pensiun (Retirement Readiness Training)
    Tue, Sep 10
    This training will be aimed at helping companies to change the existing retirement paradigm.
  • Offshore & Marine Projects and Risks Management
    Offshore & Marine Projects and Risks Management
    Multiple Dates
    Offshore & Marine Projects and Risks Management
    Tue, Sep 10
    In this Project Risk Management seminar, you’ll work through the proactive approach to both sides of risk: threats and opportunities.
  • Business Model Innovation
    Business Model Innovation
    Multiple Dates
    Business Model Innovation
    Tue, Sep 10
    The course offers you the opportunity to develop a unique skill set that has helped many leading entrepreneurs and enterprises, as business model innovation is at the center of value creation and many leading companies and social ventures owe much of their success to business model innovation.
  • Mastering Business Negotiation Skills
    Mastering Business Negotiation Skills
    Multiple Dates
    Mastering Business Negotiation Skills
    Tue, Sep 10
    This course has direct application for complex transactions in your professional life, right through advanced negotiation skills.
  • Strengthening Business Acumen and Collaboration
    Strengthening Business Acumen and Collaboration
    Multiple Dates
    Strengthening Business Acumen and Collaboration
    Tue, Sep 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.
  • Supervisory Development Program
    Supervisory Development Program
    Multiple Dates
    Supervisory Development Program
    Tue, Sep 10
    This program provides an understanding of the issues for effective management and supervision, such as proactive planning, understanding customer relations, effective time management, proper communication, and understanding human interaction.
  • Presentation & Negotiation Skills for Sales People in Digital Era
    Presentation & Negotiation Skills for Sales People in Digital Era
    Multiple Dates
    Presentation & Negotiation Skills for Sales People in Digital Era
    Wed, Sep 11
    This course has direct application for complex transactions in your professional life, right through communication skills, negotiation skills, and meeting and presentation skills.
  • Consultative Selling Skills
    Consultative Selling Skills
    Multiple Dates
    Consultative Selling Skills
    Wed, Sep 11
    This course provides the essential selling skills needed in today’s highly competitive arena.
  • Introduction to Oil & Gas EPC and Project Management for Non Engineers
    Introduction to Oil & Gas EPC and Project Management for Non Engineers
    Multiple Dates
    Introduction to Oil & Gas EPC and Project Management for Non Engineers
    Wed, Sep 11
    This course is designed for you who want to enhance your project management skills and to be able to work effectively within your project management teams.
  • Performance Management System
    Performance Management System
    Multiple Dates
    Performance Management System
    Wed, Sep 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.
  • Interpersonal and Workplace Communication Skills
    Interpersonal and Workplace Communication Skills
    Multiple Dates
    Interpersonal and Workplace Communication Skills
    Wed, Sep 11
    Interpersonal skills are considered a major indicator of success in the workplace because they enable employees to communicate effectively with colleagues, help their team solve problems, and improve the general office mood.
  • Innovation & Productivity in the Workplace
    Innovation & Productivity in the Workplace
    Multiple Dates
    Innovation & Productivity in the Workplace
    Wed, Sep 11
    This training course builds an agenda to improve your creativity and productivity, enhance your professional reputation, and enable you to apply innovative work practices. Then, You will realize your strengths and fulfill your true managerial leadership potential.
  • Purchasing Management: A-Z Best Practice
    Purchasing Management: A-Z Best Practice
    Multiple Dates
    Purchasing Management: A-Z Best Practice
    Thu, Sep 12
    This complete training course in purchasing covers the skills required to lead a procurement team to world-class performance.
  • 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.

Our Upcoming Trainings

Microsoft Office Excel 2016 Advanced
Microsoft Office Excel 2016 Advanced

Tue, Oct 08

|

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

Last available date

Oct 08, 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