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

CLASS TRAINING SCHEDULE IN 2025
January 6th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
February 5th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
March 5th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
April 9th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
May 7th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan

ONLINE TRAINING SCHEDULE IN 2025
January 6th, 2025 | IDR 1 million | Online Training  (via zoom)
February 5th, 2025 | IDR 1 million | Online Training  (via zoom)
March 5th, 2025 | IDR 1 million | Online Training  (via zoom)
April 9th, 2025 | IDR 1 million | Online Training  (via zoom)
May 7th, 2025 | IDR 1 million | Online Training  (via zoom)

Course Objective:

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

Target Student:

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, audit and analyze worksheet data, import and export data, protecting data, and record a macro.

Prerequisites:

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

Course Objectives

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.

Course Content

Lesson 1: Automating Worksheet Functionality
Topic 1A: Apply Conditional Formatting
Topic 1B: Add Data Validation Criteria

Lesson 2: Organizing Worksheet data with Tables
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: Filter Data with Slicers
Topic 5C: Analyze 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

Facilitator

Abdul Gofur

CLASS & ONLINE TRAINING SCHEDULE

Schedule in 2025

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