Rp. 39.800
Daftar Isi
Kata Pengantar............................................................................................................ i
Daftar Isi..................................................................................................................... iii
BAB 1 Aplikasi Raport Bayangan SD....................................................... 1
1.1 Aplikasi Raport Bayangan SD....................................................................... 1
1.2 Penerapan fungsi AVERAGE......................................................................... 3
1.3 Penerapan fungsi ROUND.............................................................................. 4
1.4 Trik Membuat List Kelas................................................................................ 7
1.5 Trik Membuat List Semester.......................................................................... 8
1.6 Trik menciptakan List Tahun Pelajaran.......................................................... 11
1.7 Trik menciptakan List Exskul............................................................................ 13
1.8 Trik Paste Link................................................................................................ 15
1.9 Penandaan dengan Conditional Formatting............................................. 20
1.10 Penerapan fungsi SUM dan AVERAGE................................................... 23
1.11 Trik Copy dan Paste Link........................................................................... 28
1.12 Trik menciptakan List Induk............................................................................ 37
1.13 Penerapan Fungsi VLOOKUP..................................................................... 40
1.14 Pemanfaatan Conditional Formatting..................................................... 45
1.15 Penggunaan Visual Basic............................................................................ 49
1.16 Penggabungan Fungsi Logika IF dengan terbilang................................. 57
1.17 Penulisan campuran fungsi IF dan VLOOKUP....................................... 58
BAB 2 Pembuatan Aplikasi Raport MTs................................................. 61
2.1 Aplikasi Raport MTs..................................................................................... 61
2.2 Pembuatan List Semester............................................................................. 64
2.3 Pemanfaatan Fungsi IF dan VLOOKUP................................................... 77
2.4 Memasukan fungsi terbilang pada Visual Basic dan fungsi campuran
IF........................................................................................................................ 81
2.5 Menandai data dengan Conditional Formatting..................................... 86
BAB 3 Pembuatan Aplikasi untuk Sertifikat...................................... 92
3.1 Aplikasi Nilai Sertifikat Komputer ............................................................. 92
3.2 Menggunakan Paste Link............................................................................. 96
3.3 Membuat List Induk..................................................................................... 98
3.4 Penggunaan fungsi IF dan VLOOKUP.................................................... 101
BAB 4 Pembuatan Aplikasi Nota Kontan.......................................... 107
4.1 Format Aplikasi Nota Kontan................................................................... 107
4.2 List Barang.................................................................................................... 108
4.3 Penggabungan fungsi IF,NOT,ISBLANK dan VLOOKUP................... 112
BAB 5 Pembuatan Aplikasi Daftar Transaksi Penjualan......... 114
5.1 Format Aplikasi Daftar Transaksi Penjualan......................................... 114
5.2 Pembuatan list kode.................................................................................... 115
5.3 Penulisan Fungsi Gabungan IF, ISBLANK, dan HLOOKUP............... 119
BAB 6 Pembuatan Aplikasi Daftar Gaji & Struk Gaji Karyawan 122
6.1 Format Aplikasi Daftar Gaji & Struk Gaji.............................................. 122
6.2 Membuat list arahan karyawan................................................................... 124
6.3 Proses Pengetikan rumus fungsi IF, VLOOKUP dan SUM................... 127
BAB 7 Penerapan Aplikasi untuk SKHUN........................................... 134
7.1 Format Aplikasi SKHUN............................................................................ 134
7.2 Validasi Data................................................................................................ 136
7.3 Penggunaan fungsi IF dan Vlookup......................................................... 138
7.4 Penggunaan banyak sekali campuran fungsi................................................... 139
7.5 Mengunci sheet dan mengaktifkan Cells ............................................... 143
7.6 Mengunci Documen.................................................................................... 146
BAB 8 Kumpulan Berbagai Fungsi Excel......................................... 149
8.1 Penerapan SUM, Average, dan COUNTA.............................................. 149
8.2 Penerapan fungsi COUNT, MAX, dan MIN........................................... 152
8.3 Menerapkan fungsi IF dan COUNTIF..................................................... 153
8.4 Fungsi INT..................................................................................................... 156
8.5 Fungsi ROUND............................................................................................. 157
8.6 Fungsi MOD.................................................................................................. 158
8.7 Fungsi PRODUCT........................................................................................ 159
8.8 Fungsi Gabungan INT dan TODAY........................................................ 160
8.9 Fungsi LEN.................................................................................................... 161
8.10 Fungsi Fungsi Gabungan IF dan AND................................................... 162
8.11 Fungsi Gabungan IF dan OR................................................................... 164
8.12 Penggabungan Karakter........................................................................... 165
8.13 Fungsi POWER........................................................................................... 166
8.14 Fungsi SQRT............................................................................................... 167
8.15 Fungsi FACT............................................................................................... 168
8.16 Fungsi LN.................................................................................................... 169
8.17 Fungsi LOG................................................................................................. 170
8.18 Fungsi LOG10............................................................................................ 171
8.19 Fungsi COS................................................................................................. 172
8.20 Fungsi SIN................................................................................................... 173
8.21 Fungsi TAN................................................................................................. 174
8.22 Fungsi PMT................................................................................................. 175
8.23 Fungsi NPER............................................................................................... 176
8.24 Fungsi RATE.............................................................................................. 177
8.25 Fungsi LOWER.......................................................................................... 178
8.26 Fungsi UPPER............................................................................................ 180
8.27 Fungsi LEFT............................................................................................... 181
8.28 Fungsi RIGHT............................................................................................ 182
8.29 Fungsi MID................................................................................................. 183
8.30 Fungsi CONVERT..................................................................................... 184
8.31 Fungsi DEC2BIN....................................................................................... 185
8.32 Fungsi DEC2HEX...................................................................................... 187
8.33 Fungsi DEC2OCT...................................................................................... 188
8.34 Fungsi SECOND......................................................................................... 189
8.35 Fungsi NOW................................................................................................ 190
8.36 Fungsi TODAY........................................................................................... 191
8.37 Fungsi TIME............................................................................................... 192
8.38 Fungsi MINUTE......................................................................................... 193
8.39 Fungsi HOUR............................................................................................. 194
8.40 Fungsi DATE............................................................................................... 195
8.41 Fungsi DAYS360........................................................................................ 196
Tentang Penulis............................................................................................... 198
info pesanan ke : www.elexmedia.co.id
atau anda sanggup membeli di TB GRAMEDIA tedekat kalau masih tersedia stoknya
Download Hasil Buku
1. Aplikasi Raport SD
2. Aplikasi Raport MTs
3. Aplikasi Gaji Karyawan
4. Aplikasi Kuitansi/Nota
5. Berbagai Trik Rumus fungsi
6. Aplikasi Terbilang Text
7. Aplikasi Terbilang Xls
8. Aplikasi SKHUN
9. Download REVISI BAB 4 (Setelah mendownload lanjutkan pembahasannya ke Hal 108)
PENERAPAN FUNGSI EXCEL UNTUK APLIKASI
Jika anda pernah/punya/membeli buku ini isikan form pelanggan di bawah ini
FORMULIR LANGGANAN klik gambar berikut
0 Komentar untuk "Penerapan Fungsi Excel Untuk Aplikasi"