top of page
25 ok-fa.png
  • BNSP Certified Human Resource Practitioner (CHRP)
    BNSP Certified Human Resource Practitioner (CHRP)
    Multiple Dates
    BNSP Certified Human Resource Practitioner (CHRP)
    Mon, Jan 20
    This training exists as a provider of competency certification for HR practitioners. Competency certification is intended to be used as the competency certification scheme of the National Professional Certification Agency (BNSP) and refers to the applicable SKKNI in the field of HRM.
  • Negotiation Skills in Purchasing and Contract
    Negotiation Skills in Purchasing and Contract
    Multiple Dates
    Negotiation Skills in Purchasing and Contract
    Wed, Jan 22
    This workshop is designed to provide strong competencies in the methods and strategies that will result in successful negotiations with people in business.
  • Recruitment, Behavioural Interviewing and Selection
    Recruitment, Behavioural Interviewing and Selection
    Multiple Dates
    Recruitment, Behavioural Interviewing and Selection
    Wed, Jan 22
    In this course, you will learn about the methods of interviewing that allow interviewees to prove their worth.
  • Certification in HR Professional (BNSP)
    Certification in HR Professional (BNSP)
    Multiple Dates
    Certification in HR Professional (BNSP)
    Wed, Jan 22
    This professional program is designed to provide intermediate and advanced level knowledge, for the management of human resources in an organization. It offers a good blend of theories, practices, case studies, and individual assignments in the HR field.
  • Change Management & The Role of Leaders
    Change Management & The Role of Leaders
    Multiple Dates
    Change Management & The Role of Leaders
    Wed, Jan 22
    This workshop will give any leader the tools to implement changes more smoothly and to have those changes better accepted. This workshop will also give all participants an understanding of how change is implemented and some tools for managing staff's reactions to change.
  • Managing the Collections and Credit Control Team
    Managing the Collections and Credit Control Team
    Multiple Dates
    Managing the Collections and Credit Control Team
    Thu, Jan 23
    This course explores options for structuring the collections department; how to manage, what to manage, and what to measure. The result is more impactful management information, better-organized departments, and enhanced efficiency of collectors.
  • Business Process Improvement For Supervisors and Managers
    Business Process Improvement For Supervisors and Managers
    Multiple Dates
    Business Process Improvement For Supervisors and Managers
    Thu, Jan 23
    This two-day course introduces the core principles and practices of Business Process Management.
  • Microsoft Office Excel 2016 Basic
    Microsoft Office Excel 2016 Basic
    Multiple Dates
    Microsoft Office Excel 2016 Basic
    Fri, Jan 24
    In this workshop participants are taught to perform: opening and closing applications, navigating basic file structures, and managing files and folders in Microsoft Excel 2016. This course is intended for anyone who wishes to gain a foundational understanding of Microsoft Office Excel 2016.
  • Interpersonal and Workplace Communication Skills
    Interpersonal and Workplace Communication Skills
    Multiple Dates
    Interpersonal and Workplace Communication Skills
    Mon, Jan 27
    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.
  • Marketing Strategy for Sales Professionals
    Marketing Strategy for Sales Professionals
    Multiple Dates
    Marketing Strategy for Sales Professionals
    Thu, Jan 30
    Whether you aim to market or sell, the programs will help your sales and marketing team to optimize your results. This hands-on, exercise-driven program teaches skills that boost sales and profitability through an increased understanding and implementation of the need-satisfaction sales process.
  • Pedoman Pelaksanaan Pengadaan Barang Dan Jasa K3S - PTK 007 Rev. 4/2017
    Pedoman Pelaksanaan Pengadaan Barang Dan Jasa K3S - PTK 007 Rev. 4/2017
    Multiple Dates
    Pedoman Pelaksanaan Pengadaan Barang Dan Jasa K3S - PTK 007 Rev. 4/2017
    Thu, Jan 30
    Tujuan program ini untuk mendapatkan pemahaman mengenai filosofi dan tujuan ketentuan TKDN, prinsip dasarnya, komponen dalam barang dan jasa dalam negeri serta ketentuan-ketentuan dasar serta pihak yang terkait dengan TKDN beserta perannya masing-masing.
  • Managing Multiple Tasks, Priorities & Deadlines
    Managing Multiple Tasks, Priorities & Deadlines
    Multiple Dates
    Managing Multiple Tasks, Priorities & Deadlines
    Thu, Jan 30
    This training course will support you in developing practices and techniques to manage this pressure proactively, allowing you to meet deadlines and deliver against your objectives. You will also develop skills in working well with others to ensure success.
  • Procurement Management in Oil & Gas Industry
    Procurement Management in Oil & Gas Industry
    Multiple Dates
    Procurement Management in Oil & Gas Industry
    Mon, Feb 03
    This program explores key concepts of strategic approaches to Procurement in the Oil and gas Industry and shows how today’s supply management organizations need to move from their traditional tactical focus to the strategic focus needed to successfully implement the processes and methods required.
  • 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
    Tue, Feb 04
    This course has direct application for complex transactions in your professional life, right through communication skills, negotiation skills, and meeting and presentation skills.
  • Cash Flow and Treasury Management
    Cash Flow and Treasury Management
    Multiple Dates
    Cash Flow and Treasury Management
    Tue, Feb 04
    This course is designed to provide information about an entity’s investing and financing activities during the accounting period, as well as show how much cash was generated by the period’s operations. The course will familiarize the participants with relevant financial information to make decisions
  • H2S Safety Awareness
    H2S Safety Awareness
    Multiple Dates
    H2S Safety Awareness
    Tue, Feb 04
    This course aims to provide all course candidates with a firm understanding of the hazards & effects of H2S, gas detection systems, protection systems, and safe operating procedures in the H2S area.
  • Achieving Results: Smarter Goal Setting, Planning & Decision Making
    Achieving Results: Smarter Goal Setting, Planning & Decision Making
    Multiple Dates
    Achieving Results: Smarter Goal Setting, Planning & Decision Making
    Tue, Feb 04
    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.
  • Consultative Selling Skills
    Consultative Selling Skills
    Multiple Dates
    Consultative Selling Skills
    Wed, Feb 05
    This course provides the essential selling skills needed in today’s highly competitive arena.

Our Upcoming Trainings

Microsoft Office Excel 2016 Intermediate
Microsoft Office Excel 2016 Intermediate

Thu, Apr 17

|

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

Apr 17, 2025, 7:00 PM – 11: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