Sesi 1

12m3d

Sesi 1 : Start Exel

Sesi 1 : Finished Excel

BAB 1.0 : Pengenalan Dasar Excel dan Rumus Sederhana

Sesi 2

11m6d

Sesi 2 : Start Excel

Sesi 2 : Finished Excel

BAB 1.1 Pengenalan Konsep Relative dan Absolute Cell serta bagaimana cara Protect Sheet and Wokrbook

Sesi 3

6m17d

Sesi 3 : Start Excel

Sesi 3 : Finished Excel

BAB 2.0 Pengenalan Menu Quick Access Toolbar, dan beberapa setting default pada excel

Sesi 4

6m11d

Sesi 4 : Start Excel

Sesi 4 : Finished Excel

BAB 2.1 : Fungsi Hyperlink

Fungsi COUNT, COUNTA, COUNTIFS, DAN SUMIFS

14m29d

Sesi 5 : Start Excel

Sesi 5 : Finished Excel

BAB 3.0 : Fungsi COUNT, COUNTA, COUNTIFS, DAN SUMIFS

Sesi 6

7m54d

Sesi 6 : Start Excel

Sesi 6 : Finished Excel

BAB 3.1: Fungsi MAXIFS dan MINIFS

Sesi 7

11m26d

Sesi 7 : Start Excel

Sesi 7 : Finished Excel

BAB 4 : Teori Pivot Table Basic dan Menu pada Pivot Table

Sesi 8

13m45d

Sesi 8 : Start Excel

Sesi 8 : Finished Excel

BAB 5.0 : Pivot Table Intermediate Part 1

Sesi 9

8m33d

Sesi 9 : Start Excel

Sesi 9 : Finished Excel

BAB 5.1 : Pivot Table Intermediate Part 2

Sesi 10

13m57d

Sesi 10 : Start Excel

Sesi 10 : Finished Excel

BAB 6.0 : Mengenal Beberapa Fungsi Tanggal dan cara extract data tanggal

Sesi 11

10m0d

Sesi 11 : Start Excel

Sesi 11 : Finished Excel

BAB 6.1 : Menghitung banyak Hari kerja dan Mengenal Format Jam dan Waktu serta cara pengoperasiannya

Sesi 12

8m5d

Sesi 12 : Start Excel

Sesi 12 : Finished Excel

BAB 7.0: Menggabungkan kata-kata dan cara extract sebuah kata dengan fungsi mid,left dan right.

Sesi 13

18m43d

Sesi 13 : Start Excel

Sesi 13 : Finished Excel

BAB 7.1 : Extract data secara dinamis beberapa step dan penggunaan Wilcard di excel.

Sesi 14

8m21d

Sesi 14 : Start Excel

Sesi 14 : Finished Excel

BAB 7.2: Fungsi Wildcard

Sesi 15

15m31d

Sesi 15 : Start Excel

Sesi 15 : Finished Excel

BAB 8.0 : Teori Fungsi IF dan IS

Sesi 16

13m1d

Sesi 16 : Start Excel

Sesi 16 : Finished Excel

BAB 8.2: Studi Kasus IF dan IS Bertingkat

Sesi 17

16m10d

Sesi 17 : Start Excel

16m10d

Sesi 18 : Finished Excel

BAB 8.1: Teori Fungsi AND dan OR

Sesi 18

9m49d

Sesi 18 : Start Excel

Sesi 18 : Finished Excel

BAB 9.0 : Teori Dasar Fungsi VLookup dan Hlookup

Sesi 19

21m51d

Sesi 19 : Start Excel

Sesi 19 : Finished Excel

BAB 9.1 : Studi Kasus Vlookup dan Hlookup

Sesi 20

8m42d

Sesi 20 : Start Excel

Sesi 20 : Finished Excel

BAB 9.2 : Vlookup dinamis banyak table

Sesi 21

11m41d

Sesi 21 : Start Excel

Sesi 21 : Finished Excel

BAB 10 : Teori Excel Tabel dalam sebuah database

Sesi 22

15m13d

Sesi 22 : Start Excel

Sesi 22 : Finished Excel

BAB 11 : Teori Mixed Cell References dan Contoh aplikasinya

Sesi 23

10m55d

Sesi 23 : Start Excel

Sesi 23 : Finished Excel

BAB 12.0 : Belajar Conditional Formating

Sesi 24

6m47d

Sesi 24 : Start Excel

Sesi 24 : Finished Excel

BAB 12.1: Studi Kasus Conditional Formating dan Fungsi Match

Sesi 25

16m42d

Sesi 25 : Start Excel

Sesi 25 : Finished Excel

BAB 13.0 : Pivot Table Advanced Part 1

Sesi 26

8m57d

Sesi 26 : Start Excel

Sesi 26 : Finished Excel

BAB 13.1 : Pivot Table Advanced Part 2

Sesi 27

7m45d

Sesi 27 : Start Excel

sesi 27 : Finished excel

BAB 14 : Relasi antar table vs vlookup

Sesi 28

7m44d

Sesi 28 : Start Excel

Sesi 28 : Finished Excel

BAB 15.0 : Fungsi Sort

Sesi 29

6m46d

Sesi 29 : Start Excel

Sesi 29 : Finished Excel

BAB 15.1 : Fungsi Filter, dan Flash Fill

Sesi 30

7m11d

Sesi 30 : Start Excel

Sesi 30 : Finished Excel

BAB 16.0 : Komponen Pada sebuah Chart

Sesi 31

21m27d

Sesi 31 : Start Excel

Sesi 31 : Finished Excel

BAB 16.1: Membuat Bar, Column, Pie dan Line Chart

Sesi 32

9m6d

Sesi 32 : Start Excel

Sesi 32 : Finished Excel

BAB 16.2: Studi Case Chart Actual vs Target, Serta Chart Dinamis dengan data validation

Sesi 33

10m29d

Sesi 33 : Start Excel

Sesi 33 : Finished Excel

BAB 17: Pengenalan teori dasar rumus INDEX dan MATCH

Sesi 34

13m5d

Sesi 34 : Start Excel

Sesi 34 : Finished Excel

BAB 17.1: Studi Kasus Fungsi Index dan Match

Sesi 35

12m59d

Sesi 35 : Start Excel

Sesi 35 : Finished Excel

BAB 17.2 : Fungsi Xlookup dan Pengaplikasiannya