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

CLASS TRAINING SCHEDULE IN 2025
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 | Hotel Kuretakeso, Jakarta Selatan

ONLINE TRAINING SCHEDULE IN 2025
January 3rd, 2025 | IDR 1 million | Online Training  (via zoom)
February 4th, 2025 | IDR 1 million | Online Training  (via zoom)
March 4th, 2025 | IDR 1 million | Online Training  (via zoom)
April 8th, 2025 | IDR 1 million | Online Training  (via zoom)
May 6th, 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

1. June 10th, 2025
2. July 2nd, 2025
3. August 5th, 2025
4. September 9th, 2025
5. October 14th, 2025
6. November 11th, 2025
7. December 9th, 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)