top of page
  • Project Management & CAPM-PMP Preparation
    Project Management & CAPM-PMP Preparation
    Multiple Dates
    Project Management & CAPM-PMP Preparation
    Mon, Jan 06
    This comprehensive course is designed to provide participants with a strong foundation in project management principles and prepare them for the Certified Associate in Project Management (CAPM®) and Project Management Professional (PMP®) certifications. Participants will gain knowledge of project ma
  • Customer Service Professional
    Customer Service Professional
    Multiple Dates
    Customer Service Professional
    Mon, Jan 06
    At the end of the program, each participant will have the knowledge and understanding of customer service excellence, with which they develop the excellent service mentality required by them to gain high-quality performance when they deliver services to their customers.
  • Service Excellence and Handling Complaint
    Service Excellence and Handling Complaint
    Multiple Dates
    Service Excellence and Handling Complaint
    Tue, Jan 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.
  • 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
    Tue, Jan 07
    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.
  • Work Monitoring, Controlling Target & Detecting Issue
    Work Monitoring, Controlling Target & Detecting Issue
    Multiple Dates
    Work Monitoring, Controlling Target & Detecting Issue
    Tue, Jan 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.
  • Treasury Management & Money Market
    Treasury Management & Money Market
    Multiple Dates
    Treasury Management & Money Market
    Wed, Jan 08
    This course will emphasize the understanding of money market instruments and how money market products are traded. You will learn about Certificate of Deposits, Commercial Paper, Repurchase Agreements, and Federal Funds.
  • International Oil & Gas Business Management
    International Oil & Gas Business Management
    Multiple Dates
    International Oil & Gas Business Management
    Wed, Jan 08
    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.
  • Agile with Scrum Project Management
    Agile with Scrum Project Management
    Multiple Dates
    Agile with Scrum Project Management
    Wed, Jan 08
    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.
  • Electronic Filing & Documentation Management
    Electronic Filing & Documentation Management
    Multiple Dates
    Electronic Filing & Documentation Management
    Wed, Jan 08
    If the concept of a filing document management system is used properly in an organization, it will help maximize the service process, both to internal customers and to external customers, to create a good image and enhance the competitiveness of the organization.
  • Lean Six Sigma
    Lean Six Sigma
    Multiple Dates
    Lean Six Sigma
    Wed, Jan 08
    Six Sigma is a tried-and-tested methodology that has helped many organizations to increase profits through improved business efficiency and customer satisfaction. In this course, you will learn how Six Sigma can benefit your company.
  • Professional Presentations & Public Speaking
    Professional Presentations & Public Speaking
    Multiple Dates
    Professional Presentations & Public Speaking
    Wed, Jan 08
    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.
  • Foreign Exchange Market and Deritatives
    Foreign Exchange Market and Deritatives
    Multiple Dates
    Foreign Exchange Market and Deritatives
    Thu, Jan 09
    This course provides the answers by examining the latest tools and techniques, giving delegates a detailed understanding of Forwards, Options, Futures, and Swaps as well as more exotic derivatives such as Swaptions.
  • Contract Administration: Understanding and Implementing Contractual Obligation
    Contract Administration: Understanding and Implementing Contractual Obligation
    Multiple Dates
    Contract Administration: Understanding and Implementing Contractual Obligation
    Thu, Jan 09
    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.
  • Effective Leadership Skills for Managers
    Effective Leadership Skills for Managers
    Multiple Dates
    Effective Leadership Skills for Managers
    Thu, Jan 09
    IPDC Training Institute offers a dynamic Management & Leadership Training Program, empowering professionals with strategic skills, effective communication, and visionary leadership techniques, fostering business excellence and innovation.
  • Developing Effective Habits Toward Excellent Leaders
    Developing Effective Habits Toward Excellent Leaders
    Multiple Dates
    Developing Effective Habits Toward Excellent Leaders
    Fri, Jan 10
    Overview Effective leadership is built on intentional habits that drive personal growth, inspire teams, and achieve organizational success. This course explores the critical habits that distinguish excellent leaders, focusing on practical steps to develop consistent behaviors that foster strong lead
  • Presentation Design & Delivery
    Presentation Design & Delivery
    Multiple Dates
    Presentation Design & Delivery
    Fri, Jan 10
    This practical course is designed for participants to learn how to write presentations, e-mails, memorandums, minutes, reports, and other business documents that are comprehensive, concise, informative, and professional.
  • Coaching and Mentoring Skills for Managers and Supervisors
    Coaching and Mentoring Skills for Managers and Supervisors
    Multiple Dates
    Coaching and Mentoring Skills for Managers and Supervisors
    Mon, Jan 13
    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.
  • Treasury and Risk Management
    Treasury and Risk Management
    Multiple Dates
    Treasury and Risk Management
    Mon, Jan 13
    This course provides the mandatory foundation knowledge required to understand and run business processes for treasury and risk management.

Our Upcoming Trainings

Microsoft Office Excel 2016 Advanced
Microsoft Office Excel 2016 Advanced

Tue, May 14

|

Indonesia

Microsoft Office Excel 2016 Advanced

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.

Registration is closed
See other events

Time & Location

4 more dates

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

Indonesia

About The Training

PREREQUISITES

Before starting this course, students are recommended to take the following course or have equivalent knowledge: Microsoft® Office Excel® 2016: Basic & Intermediate Level.

OBJECTIVES

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, protect data, and you will also organize table data.

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

  • Enhance productivity and efficiency by streamlining the workflow.
  • Organize worksheet and table data using various techniques.
  • Summarizing data using functions.
  • Analyze data using PivotTables, Slicers, and PivotCharts.
  • Audit worksheets.
  • Analyze data.
  • Protecting data.
  • Import and export data.
  • Recording macro.

TARGET PARTICIPANTS

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, and record a macro.

COURSE CONTENTS

Lesson 1: Automating Worksheet Functionality

Topic 1A: Apply Conditional Formatting

Topic 1B: Add Data Validation Criteria

Lesson 2: Working with Lists

Topic 2A: Format data as Tables

Topic 2B: Create Sparklines

Topic 2C: Sorting Data

Topic 2D: Filtering data

Lesson 3: Data List Outline

Topic 3A: Create Outline Group

Topic 3B: Create SubTotal

Lesson 4: Using Functions to Summarizing Data

Topic 4A: Use SumIF, AverageIF, CountIF Function

Topic 4B: Use SumIFs, AverageIFs, CountIFs Function

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

Topic 5A: Create a PivotTables

Topic 5B: Analyze PivotTable Data

Topic 5C: Filter Data by Using Timelines and Slicers

Topic 5D: Present Data with PivotCharts

Lesson 6: Auditing Worksheets

Topic 6A: Trace Formulas

Topic 6B: Watch and Evaluate Formulas

Topic 6C: Troubleshoot Formula Errors

Lesson 7: Analyzing and Presenting Data

Topic 7A: Create Scenario

Topic 7B: Analyze Data using Goal Seek Feature

Topic 7C: Analyze Data using Solver Feature

Lesson 8: Enhancing Workbook

Topic 8A: Protecting Data

Topic 8B: Create and Use Template

Lesson 9: Importing and Exporting Data

Topic 9A: Import Data

Topic 9B: Export Data

Lesson 10: Macro

Topic 10A: Recording a Macro

Topic 10B: Editing a Macro

Share this Training

bottom of page