Hotel Kuretakeso, Jakarta Selatan | 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
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
- June 11th, 2025
- July 3rd, 2025
- August 6th, 2025
- September 10th, 2025
- October 15th, 2025
- November 12th, 2025
- December 10th, 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)