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 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

1 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