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 Intermediate
Microsoft Office Excel 2016 Intermediate

Thu, Dec 12

|

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.

Time & Location

3 more dates

Dec 12, 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