Microsoft Excel 2016 Intermediate Level (2016 dan atau tahun release lainnya) – Available Online

Hotel Kuretakeso, Jakarta Selatan | January 3rd, 2025 | IDR 1.5 million
Hotel Kuretakeso, Jakarta Selatan | February 4th, 2025 | IDR 1.5 million
Hotel Kuretakeso, Jakarta Selatan | March 4th, 2025 | IDR 1.5 million
Hotel Kuretakeso, Jakarta Selatan | April 8th, 2025 | IDR 1.5 million
Hotel Kuretakeso, Jakarta Selatan | May 6th, 2025 | IDR 1.5 million

IDR 1 million | Online Training  (via zoom)

 

Course Objective:

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.

 

Target Student:

This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, collaborate with others, and incorporate multiple data sources.

 

Prerequisites:

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

 

Course Objectives

Upon successful completion of this course, students will be able to:
• Work with multiple workbooks.
• Analyze Data with Logical Functions.
• Create and modify charts.
• Using Text Functions.
• Analyzing Data with Lookup Functions.

 

Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks
Topic 1A: Creating and Editing a Range Name
Topic 1B: Using Range names in a Formula
Topic 1C: Calculate Data Across Worksheets
Topic 1D: Consolidate Data
Topic 1E: Linking Cells in Different Workbooks
Topic 1F: Inserting Hyperlinks

Lesson 2: Analyze Data with Logical Functions
Topic 2A: Use IF Function
Topic 2B: Use AND Function
Topic 2C: Use OR Function
Topic 2D: Combine the AND with IF Function
Topic 2E: Combine the OR with 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: Analyzing Data with Lookup Functions
Topic 5A: VLookup Function
Topic 5B: HLookup Function
Topic 5C: Index And Match Function

 

Facilitator

Abdul Gofur

 

CLASS & ONLINE TRAINING SCHEDULE

Schedule in 2025

  • June 10th, 2025
  • July 2nd, 2025
  • August 5th, 2025
  • September 9th, 2025
  • October 14th, 2025
  • November 11th, 2025
  • December 9th, 2025

Venue

  • Class Training : Hotel Kuretakeso, Jakarta Selatan
  • Online Training : via zoom

Investment Cost

  • Class Training : IDR 1.5 million per participant (excluding VAT)
  • Online Training : IDR 1 million per participant (excluding VAT)

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.