top of page
  • Strategic Key Account Management
    Strategic Key Account Management
    Multiple Dates
    Mon, Jun 24
    This program is tailored to help you identify hidden opportunities for improving the health of the account.
  • Accounting For Non-Accountants
    Accounting For Non-Accountants
    Multiple Dates
    Mon, Jun 24
    This 2-day course introduces accounting principles for non-accountants.
  • 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.
  • Offshore & Marine Projects and Risks Management
    Offshore & Marine Projects and Risks Management
    In this Project Risk Management seminar, you’ll work through the proactive approach to both sides of risk: threats and opportunities.
  • Creative and Innovative Thinking
    Creative and Innovative Thinking
    Multiple Dates
    Tue, Jun 25
    Creativity and Innovation Training Course covers creative thinking and problem-solving methods that generate new ideas and solve problems.
  • Effective Communication Skills in New Era
    Effective Communication Skills in New Era
    This training will provide participants with a framework for communicating more effectively by understanding other people’s points of view, and by customizing our messages to reach them effectively.
  • Distributed Control System
    Distributed Control System
    Multiple Dates
    Wed, Jun 26
    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
  • Introduction to Oil & Gas EPC and Project Management for Non Engineers
    Introduction to Oil & Gas EPC and Project Management for Non Engineers
    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.
  • Electronic Filing & Documentation Management
    Electronic Filing & Documentation Management
    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.
  • 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.
  • 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.
  • 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, Jul 02
    Primavera P6 solutions can assist you in making enhanced project management decisions by providing start-to-end, real-time visibility into all significant information.
  • Project Management Fundamentals for Administrative Professionals
    Project Management Fundamentals for Administrative Professionals
    This Project Management training course will provide a practical approach that gives participants the basic knowledge, processes, skills, tools, and techniques to succeed in their respective industries.
  • Strategic Management in Disruptive Times
    Strategic Management in Disruptive Times
    This program is designed to help you expand your strategic mindset, acquire the skills needed to gain stakeholder buy-in and translate strategy into value-driven decisions.
  • Mastering Strategic Planning
    Mastering Strategic Planning
    Multiple Dates
    Tue, Jul 02
  • HR for Non HR Executives/Non HR Managers
    HR for Non HR Executives/Non HR Managers
    HR for Non-HR Managers course highlights the full employee lifecycle from pre-employment to post-termination and includes the main labor laws that affect the employer-employee relationship.
  • 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.

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

2 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