Home   »   Microsoft Excel Intermediate – Advance

Microsoft Excel Intermediate – Advance

OVERVIEW

In this course, participants will work with Microsoft Office Excel to create spreadsheets and workbooks that can be used to store, manipulate, and share data. In the higher levels, the participants will work with charts and tables along with other useful formatting tools. They will also learn to create formulas that use built-in functions to perform advanced analysis. The class also covers the creation of shared workbooks and the tracking of changes within them.

OUTLINE COURSE

1. Intermediate Level

• Create and Customise Charts
• Create and Manage Tables
• Present, Sort Data in a Table
• Automatic Calculations in a Table, Filtering
• Blank Cells and Duplicates
• Advanced filtering and statistics with a Criteria Range
• Copy Rows Filtered Using a Criteria Range
• Display Several Lines of data in One Cell
• Absolute Reference in a Formula
• Copy Values, Copy With a Link, Transposing
• Move, Copy, Hide Sheets
• Select, Delete, Copy and Move Objects
• Format Chart Items; Modify Chart’s Text Items; Legend and Plot Area; Data Series and Chart Axes; Manage Series, Chart Templates
• Create and Manage Sparklines
• Modify a Text Box, Drawing
• Rotate, Align, Stack and Group Objects
• Apply, Manage Conditional, Custom Formats
• Validation Criteria
• Convert Data; Create a Data Series
• Use Cell Ranges in Functions
• Summarize Data with an Outline
• Attach a Comment to a Cell
• Calculate with Copied Values

2. Advance Level

• Pivots Tables and Charts
• Advanced Formulas (Lookup, Date Functions)
• IF statements, AND and OR
• Nested, Arrays and Conditions Formulas
• Scenarios, Goal Seek and other Advanced Functions
• Auditing and Error Checking
• Templates and Themes
• Protecting Workbooks
• Sharing Workbooks

TRAINING METHOD

Presentation

Discussion

Case Study

Evaluation

FACILITY

Training Kit

Handout

Certificate

Lunch + 2x Coffee Break

Souvenir

Form Pre-Registrasi

	Data Materi Training
Topik Training	: Microsoft Excel Intermediate – Advance
Link
*Jumlah Peserta
*Nama Peserta Yang Didaftarkan
	Personal Data
*Nama
*Jabatan
*Nama Perusahaan
*Alamat Perusahaan
*Email Perusahaan
*Email Alternatif
*Telepon Kantor
Ekstensi
*Handphone
	* Harus di isi

SIMILAR ARTICLES

Pembinaan dan Sertifikasi Kompetensi Koordinator Unit Penanggulangan Kebakaran Level B (Blended)

November 6, 2026

Sertifikasi Pengarsipan Digital (Digital Filing) by BNSP

November 6, 2026

Sertifikasi Human Resource Manager by BNSP

November 6, 2026