MODUL 1. BEKERJA DENGAN TABEL ..................................................................................................... 4
1. Format Style ...................................................................................................................................... 4
1.1 Conditional Formatting ............................................................................................................ 4
1.2 Format as Table ......................................................................................................................... 5
Untuk merubah tampilan tabel atau sel, perubahan berupa warna, garis, dan sangat cocok
untuk isi tabel yang berupa angka. Hasil akhir bisa Sort dan Filter Data. ...................................... 5
1.3 Cell Styles .................................................................................................................................. 6
MODUL 2. MENGATUR LEMBAR KERJA ................................................................................................. 7
1. Split, Freeze Table ............................................................................................................................ 7
1.1 Split Table .................................................................................................................................. 7
1.2 Frezee Table ............................................................................................................................... 7
MODUL 3. FUNGSI-FUNGSI LANJUTAN .................................................................................................. 9
1. Fungsi-Fungsi Matematika ............................................................................................................. 9
2. Fungsi-fungsi Teks ......................................................................................................................... 10
3. Fungsi-fungsi tanggal dan waktu ............................................................................................... 11
4. Fungsi-fungsi logika ...................................................................................................................... 12
5. Fungsi-fungsi lookup dan Referensi ......................................................................................... 13
6. Fungsi-fungsi Statistik ................................................................................................................. 14
7. Fungsi-fungsi Finansial ................................................................................................................. 15
Modul 4. Mencari data ............................................................................................................................... 19
1. Menggunakan Find ......................................................................................................................... 19
2. Menggunakan Replace .................................................................................................................. 20
3. Mengurutkan data ........................................................................................................................... 20
4. Menyaring data ............................................................................................................................... 21
5. Validasi data .................................................................................................................................... 22
6. Konsolidasi data ............................................................................................................................. 24
7. Mengelompokan data ..................................................................................................................... 25
8. Membuat Subtotal ........................................................................................................................... 26
MODUL 5. SORT, FILTER, SUBTOTAL, PIVOTTABLE ........................................................................ 28
1. Sort .................................................................................................................................................... 28
2. Filter ................................................................................................................................................... 29
3. Group dan UnGroup ....................................................................................................................... 30
4. SubTotal ........................................................................................................................................... 30
5. Pivot Table & Pivot Chart .............................................................................................................. 32
MODUL 6. SHARING WORKBOOK .......................................................................................................... 35
1. Cara membuat sharing workbook adalah sebagai berikut : ................................................ 35
2. Penyuntingan shared workbook : .............................................................................................. 36
3. Menghapus Pengguna dari shared workbook ........................................................................ 37
4. Penyelesaian konflik perubahan di shared workbook .......................................................... 37
5. Menghapus sharing a workbook ................................................................................................ 38
0 komentar: