Microsoft Excel 2016 Intermediate Level (2016 and Up)

CLASS TRAINING SCHEDULE IN 2025

• October 21th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan (Confirmed)
• November 11th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
• December 9th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan

ONLINE TRAINING SCHEDULE IN 2025

• October 21th, 2025 | IDR 1 million | Online Training  (via zoom)
• November 11th, 2025 | IDR 1 million | Online Training  (via zoom)
• December 9th, 2025 | 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

Venue

1. Class Training : Hotel Kuretakeso, Jakarta Selatan
2. Online Training : via zoom

Investment Cost

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