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

CLASS TRAINING SCHEDULE IN 2025
January 2nd, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
February 3rd, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
March 3rd, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
April 7th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan
May 5th, 2025 | IDR 1.5 million | Hotel Kuretakeso, Jakarta Selatan

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

Course Objective:

You will start to create and edit basic Microsoft Excel 2016 worksheets and workbooks.

Target Student:

This course is designed to gain the necessary skills to create, edit, format, and print basic.

Prerequisites:

You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders

Course Objectives :

Upon successful completion of this course, students will be able to:
• Create a basic worksheet by using Microsoft Excel 2016.
• Format a worksheet.
• Modify an Excel worksheet.
• Perform calculations in an Excel worksheet.
• Manage an Excel workbook.
• Print the content of an Excel workbook.

Course Content

Lesson 1: Working with Worksheets and Workbooks
Topic 1A: Identify the Elements of the Excel Interface
Topic 1B: Exploring the Excel Window
Topic 1C: Entering and Editing Data
Topic 1D: Working with Pictures
Topic 1E: Saving and Closing Workbooks

Lesson 2: Formatting Worksheet Information
Topic 2A: Modify Fonts
Topic 2B: Apply Number Format
Topic 2C: Add Borders and Color to Cells
Topic 2D: Align Cell Contents
Topic 2E: Apply Cell Styles
Topic 2F: Apply Table Formats

Lesson 3: Modifying an Excel Worksheet
Topic 3A: Moving and Copying Data
Topic 3B: Insert, Manipulate, and Delete Cells, Columns, and Rows
Topic 3C: Search for and Replace Data
Topic 3D: Spell Check a Worksheet

Lesson 4: Performing Calculations
Topic 4A: Create Formulas in a Worksheet
Topic 4B: Moving and Copying Formulas
Topic 4C: Reuse Formulas
Topic 4D: Insert Functions in a Worksheet
Topic 4E: Common Functions in Excel

Lesson 5: Managing Large Workbooks
Topic 5A: Changing View Workbooks
Topic 5B: Format Worksheet Tabs
Topic 5C: Manage Worksheets
Topic 5D: Manage the View of Worksheets and Workbooks
Topic 5E: Using Multiple Workbooks

Lesson 6: Printing
Topic 6A: Define the Basic Page Layout for a Workbook
Topic 6B: Define the page Layout and Apply Print Options

Facilitator

Abdul Gofur

CLASS & ONLINE TRAINING SCHEDULE

Schedule in 2025

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