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

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

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