top of page
  • Service Excellence and Handling Complaint
    Service Excellence and Handling Complaint
    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.
  • Crane Inspector Certification
    Crane Inspector Certification
    Multiple Dates
    Mon, May 13
    Pengoperasian Crane memiliki dampak dan risiko besar pada segmen pekerjaan dimanapun lokasinya. Maka inspeksi terhadap Crane perlu dilakukan secara intensif bahkan setiap saat sebelum pesawat angkat ini dioperasikan.
  • WP&B, FQR, POD, PIS, AFE and AFE Closed out
    WP&B, FQR, POD, PIS, AFE and AFE Closed out
    This course is designed to give participants (concentrated on the secretaries and administrative personnel), an understanding and better picture of how the AFE, WP&B, POD, and FQR which are prepared and compiled in the OIL & GAS companies to be submitted to SKKMIGAS.
  • Basic Petroleum Economic and Risk Analysis for Supporting Personels
    Basic Petroleum Economic and Risk Analysis for Supporting Personels
    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.
  • Managing Warehouse in the Future
    Managing Warehouse in the Future
    Multiple Dates
    Mon, May 13
    This training course will examine how the effects of the Coronavirus will force us to manage, and think, differently about warehousing.
  • BNSP Certified Human Resource Practitioner (CHRP)
    BNSP Certified Human Resource Practitioner (CHRP)
    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.
  • Time Management
    Time Management
    Multiple Dates
    Mon, May 13
    You can be successful at your job without working 60-hour weeks or going home every night feeling exhausted and frustrated. The key to being successful without sacrificing your sanity is by managing your time effectively.
  • Smart Leadership: Achieving Strategy through Leadership and Innovation
    Smart Leadership: Achieving Strategy through Leadership and Innovation
    This course will expose delegates to the concept that innovation and outstanding leadership go hand in hand. Delegates will learn that new ideas can inspire new products, services, and systems that can provide a distinct competitive advantage over competitors, and smart leadership brings those ideas
  • Effective Leadership Skills for Managers
    Effective Leadership Skills for Managers
  • Process Safety Management (PSM)
    Process Safety Management (PSM)
    Multiple Dates
    Tue, May 14
    This training provides an in-depth study of each PSM element.
  • Position & Workload Analysis
    Position & Workload Analysis
    Multiple Dates
    Tue, May 14
    Workload Analysis is a tool to translate business strategies to determine the level of productivity and improve the cost efficiency of an organization or company. Through this course, the participants will learn about calculating the optimum number of HR needs.
  • 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.
  • Agile with Scrum Project Management
    Agile with Scrum Project Management
    Multiple Dates
    Tue, May 14
    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.
  • Microsoft Office Excel 2016 Advanced
    Microsoft Office Excel 2016 Advanced
    Multiple Dates
    Tue, May 14
    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.
  • Microsoft Office Excel 2016 Basic
    Microsoft Office Excel 2016 Basic
    Multiple Dates
    Tue, May 14
    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.
  • The Senior Secretary Development Programme
    The Senior Secretary Development Programme
    The Senior Secretary holds a key position of influence and a powerful partnership with the senior management team. Success in this role has a direct effect on the success of executive operations.
  • Coaching and Mentoring Skills for Managers and Supervisors
    Coaching and Mentoring Skills for Managers and Supervisors
    Every employee can reach higher levels of performance, including your average and best performers. What they need is a manager who can coach: someone who can routinely observe, assess, and interact in ways that develop and maximize their individual effectiveness.
  • Process Mapping for Improvement
    Process Mapping for Improvement
    Multiple Dates
    Wed, May 15
    By the end of this course, through several highly engaging workshops, participants will be able to provide process documentation and illustrations (process maps).

Our Upcoming Trainings

Microsoft Office Excel 2016 Intermediate
Microsoft Office Excel 2016 Intermediate

Tue, Jul 23

|

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

2 more dates

Jul 23, 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