top of page
  • Report Writing and Communication Skills for Auditors
    Report Writing and Communication Skills for Auditors
    Multiple Dates
    Report Writing and Communication Skills for Auditors
    Tue, Jul 30
    The course has been designed to provide you and your teams with a strong and practical framework of report writing and communication skills. This training course will utilize a variety of proven learning techniques to ensure maximum understanding, comprehension, and retention of the information.
  • Budgeting and Business Planning
    Budgeting and Business Planning
    Multiple Dates
    Budgeting and Business Planning
    Thu, Aug 01
    This course will provide not only the theoretical background but also the necessary skills to build world-class standards in your planning, budgeting, performance measurement, and reporting system.
  • Cost Control and Cost Reduction in the Upstream PSC Business Activity
    Cost Control and Cost Reduction in the Upstream PSC Business Activity
    Multiple Dates
    Cost Control and Cost Reduction in the Upstream PSC Business Activity
    Thu, Aug 01
    This training course will provide information, and tools to the participants on the urgency of good control-internal control has achieved reference that the company has run its operations effectively and efficiently per and in compliance with company procedures, PSC Agreement, BPMIGAS, etc.
  • Managing Warehouse in the Future
    Managing Warehouse in the Future
    Multiple Dates
    Managing Warehouse in the Future
    Thu, Aug 01
    This training course will examine how the effects of the Coronavirus will force us to manage, and think, differently about warehousing.
  • The AMDAL (Environmental Impact Assessment) for the Executives
    The AMDAL (Environmental Impact Assessment) for the Executives
    Multiple Dates
    The AMDAL (Environmental Impact Assessment) for the Executives
    Mon, Aug 05
    This course will show how an EIA is not just an assessment of the positive or negative impacts that a proposed project may have on the environment, but a process that identifies these potential effects and seeks to avoid, reduce, or offset any adverse effects through mitigation measures if possible.
  • PSC Accounting & Financial Aspect in Production Sharing Contract (PSC)
    PSC Accounting & Financial Aspect in Production Sharing Contract (PSC)
    Multiple Dates
    PSC Accounting & Financial Aspect in Production Sharing Contract (PSC)
    Mon, Aug 05
    This full 3 days training program provides concise and comprehensive learning modules on the application of POD, WP&B, and AFE in the upstream oil industry and all production-sharing contract aspects in Indonesia.
  • Process Safety Management (PSM)
    Process Safety Management (PSM)
    Multiple Dates
    Process Safety Management (PSM)
    Tue, Aug 06
    This training provides an in-depth study of each PSM element.
  • Competencies: Design, Development and Implementation
    Competencies: Design, Development and Implementation
    Multiple Dates
    Competencies: Design, Development and Implementation
    Tue, Aug 06
    You will learn the key aspects of defining terminology related to competency systems, how to develop and refine your system, and finally, the key factors involved with implementing this into the organization as part of the culture.
  • Agile with Scrum Project Management
    Agile with Scrum Project Management
    Multiple Dates
    Agile with Scrum Project Management
    Tue, Aug 06
    This interactive and experiential workshop teaches you how to envision the project goal and develop a path toward delivering it. You will learn how to start with a roadmap, elaborate that into a product backlog, and break the work down into small observable slices at appropriate times.
  • Innovation Through Design: Think, Make, Break, Repeat
    Innovation Through Design: Think, Make, Break, Repeat
    Multiple Dates
    Innovation Through Design: Think, Make, Break, Repeat
    Tue, Aug 06
    Throughout the course, you will gain many insights that will enable you to develop a comprehensive understanding of design and the role it can and does play within the innovation landscape.
  • Problem Solving & Decision Making Skills
    Problem Solving & Decision Making Skills
    Multiple Dates
    Problem Solving & Decision Making Skills
    Tue, Aug 06
    This course is ideal for those seeking new answers to old problems, and those in search of first-time solutions to major new problems.
  • Professional Presentations & Public Speaking
    Professional Presentations & Public Speaking
    Multiple Dates
    Professional Presentations & Public Speaking
    Tue, Aug 06
    This training is intended for both novices and seasoned professionals seeking to improve their communication, presentation, and public speaking skills. This workshop provides fun, dynamic, and engaging training fundamental to ultimate success and achievement.
  • Work Monitoring, Controlling Target & Detecting Issue
    Work Monitoring, Controlling Target & Detecting Issue
    Multiple Dates
    Work Monitoring, Controlling Target & Detecting Issue
    Wed, Aug 07
    Work monitoring, controlling targets, and detecting issues have an essential role in a company to ensure the success of the outcomes. Integrating these three aspects will create an effective and efficient working environment.
  • Confined Space Entry
    Confined Space Entry
    Multiple Dates
    Confined Space Entry
    Wed, Aug 07
    "The Confined Space Training" course is designed to provide awareness of confined space entry hazards and procedures for operating company and contractor personnel involved in controlling entry to confined spaces and rescue procedures, combined with practical training in entry and escape.
  • Service Excellence and Handling Complaint
    Service Excellence and Handling Complaint
    Multiple Dates
    Service Excellence and Handling Complaint
    Wed, Aug 07
    This dynamic, interactive, and engaging one-day workshop has been designed to equip individuals with the necessary competence and “mindset” to consistently meet and, at every possible opportunity, exceed their customers’ expectations.
  • Fireman Level 1
    Fireman Level 1
    Multiple Dates
    Fireman Level 1
    Wed, Aug 07
    Fire Officer termasuk tugas/pekerjaan yang memiliki tingkat bahaya yang tinggi. Petugas Pemadam kebakaran adalah sekelompok orang yang memiliki tugas untuk memadamkan api ketika terjadi kebakaran serta melakukan penyelamatan ketika terjadi bencana/kejadian yang membutuhkan pertolongan.
  • Basic Petroleum Economic and Risk Analysis for Supporting Personels
    Basic Petroleum Economic and Risk Analysis for Supporting Personels
    Multiple Dates
    Basic Petroleum Economic and Risk Analysis for Supporting Personels
    Wed, Aug 07
    This introduction to petroleum economics is an engaging and highly motivating course that allows participants to grasp the fundamentals of how an upstream organization works in financial terms and what is needed to become a successful enterprise.
  • Negotiation Skills in Purchasing and Contract
    Negotiation Skills in Purchasing and Contract
    Multiple Dates
    Negotiation Skills in Purchasing and Contract
    Wed, Aug 07
    This workshop is designed to provide strong competencies in the methods and strategies that will result in successful negotiations with people in business.

Our Upcoming Trainings

Microsoft Office Excel 2016 Intermediate
Microsoft Office Excel 2016 Intermediate

Thu, Mar 14

|

Indonesia

Microsoft Office Excel 2016 Intermediate

You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also present data as charts, and collaborate on worksheets.

Registration is closed
See other events

Time & Location

2 more dates

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

Indonesia

About The Training

PREREQUISITES

To ensure success, students should have completed Logical Operations’ Microsoft® Office Excel® 2016: Basic level or have the equivalent knowledge and experience.

OBJECTIVES

You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also present data as charts, and collaborate on worksheets.

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

  • Working with Multiple Worksheets and Workbooks.
  • Analyze Data with Logical Functions.
  • Visualizing Data with Charts.
  • Using Text Functions.
  • Using Date and Time Functions.
  • Analyzing Data with Lookup Functions.

TARGET PARTICIPANTS

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

COURSE CONTENTS

Lesson 1: Working with Multiple Worksheets and Workbooks

Topic 1A: Moving or Copying Sheet to Other Workbooks

Topic 1B: Creating and editing a range name

Topic 1C: Using range names in a formula

Topic 1D: Calculate Data Across Worksheets

Topic 1E: Consolidate Data

Topic 1F: Linking Cells in Different Workbooks

Topic 1G: Inserting Hyperlinks

Lesson 2: Analyze Data with Logical Caption

Topic 2A: Use IF Function

Topic 2B: Use AND Function

Topic 2C: Use OR Function

Topic 2D: Combine the AND with the IF Function

Topic 2E: Combine the OR with the IF Function

Lesson 3: Visualizing Data with Charts

Topic 3A: Create a Chart

Topic 3B: Modify Charts

Topic 3C: Format Charts

Lesson 4: Using Text Functions

Topic 4A: Functions to Convert between Upper and Lower Case

Topic 4B: Cutting & Piecing Together Text Strings

Topic 4C: Substituting Parts of a Text String

Topic 4D: Removing Extra Spaces

Lesson 5: Using Date and Time Functions

Topic 5A: Using Current Date & Time

Topic 5B: Extracting the Components of a Time

Topic 5C: Extracting the Components of a Date

Topic 5D: Performing Calculations with Dates

Lesson 6: Analyzing Data with Lookup Functions

Topic 6A: VLookup Function

Topic 6B: HLookup Function

Topic 6C: Index and Match Function

Share this Training

bottom of page