Lewati ke konten utama

pelatihan.orgBelajar. Praktik. Berkembang.

pelatihan.org

Belajar web development dengan peta materi yang jelas, latihan kode, dan kuis yang langsung memberi umpan balik.

Katalog Masuk Langganan

Kursus Excel Online: 102 Lesson + Kuis — pelatihan.org

Beranda/Katalog/Excel

ExcelSemua level

Excel

Belajar Excel online lewat 102 lesson terstruktur, contoh kode, dan 510 soal kuis.

102 lesson 9 bab 510 soal

Kurikulum

9 bab · 102 lesson

Lihat kurikulum lengkap

Klik lesson untuk melihat ringkasan dan poin kunci gratis.

01

Excel Tutorial

17 lesson

01Excel HOME 02Excel Introduction 03Excel Get Started 04Excel Overview 05Excel Syntax

Langganan semua course

Rp 50.000 / 30 hari

Akses semua course, lesson, dan kuis. Progress otomatis tersimpan.

Masuk untuk mulai

102 lesson materi

510 soal

Akses semua 47 course

Perpanjang kapan saja

08Excel Move Cells

09Excel Add Cells

10Excel Delete Cells

11Excel Undo Redo

12Excel Formulas

13Excel Relative Reference

14Excel Absolute Reference

15Excel Arithmetic Operators

16Excel Parentheses

17Excel Functions

02

Excel Data Analysis

11 lesson

01Excel Sort 02Excel Filter 03Excel Tables 04Excel Conditional Format 05Excel Highlight Cell Rules 06Excel Top Bottom Rules 07Excel Data Bars 08Excel Color Scales 09Excel Icon Sets 10Excel Manage Rules (CF)11Excel Charts

03

Excel Formatting

8 lesson

01Excel Formatting 02Excel Format Painter 03Excel Format Colors 04Excel Format Fonts 05Excel Format Borders 06Excel Format Numbers 07Excel Format Grids 08Excel Format Settings

04

Excel PivotTables

7 lesson

01Excel PivotTable Intro 02Excel Create PivotTable 03Excel PivotTable Values 04Excel PivotTable Filter 05Excel PivotTable Group 06Excel Calculated Field 07Excel PivotChart

05

Excel Case

2 lesson

01Case: Poke Mart 02Case: Poke Mart, Styling

06

Excel Functions

50 lesson

01AND 02AVERAGE 03AVERAGEIF 04AVERAGEIFS 05CONCAT 06COUNT 07COUNTA 08COUNTBLANK 09COUNTIF 10COUNTIFS 11DATEDIF 12FILTER 13HLOOKUP 14IF 15IFERROR 16IFS 17INDEX 18INDEX MATCH 19LEFT 20LEN 21LOWER 22MATCH 23MAX 24MEDIAN 25MID 26MIN 27MODE 28NETWORKDAYS 29NPV 30OR 31PROPER 32RAND 33RIGHT 34ROUND 35SORT 36STDEV.P 37STDEV.S 38SUBSTITUTE 39SUM 40SUMIF 41SUMIFS 42SUMPRODUCT 43TEXTJOIN 44TODAY 45TRIM 46UNIQUE 47UPPER 48VLOOKUP 49XLOOKUP 50XOR

07

Excel How To

4 lesson

01Convert Time to Seconds 02Difference Between Times 03NPV (Net Present Value)04Remove Duplicates

08

Excel Examples

3 lesson

01Excel Syllabus 02Excel Study Plan 03Excel Training