Kamis, 13 November 2014

116 STRATEGI KUASAI EXCEL 2007, 2010, 2013 + CD TUTORIAL

Insya Allah terbit Tanggal 17 November 2014
Tunggu terbitnya di GRAMEDIA seluruh Indonesia

Daftar Isi


Kata Pengantar............................................................................................................ i
Daftar Isi..................................................................................................................... iii
BAB 1.  8 Strategi Membuat Links....................................................................... 1
Strategi 1. Membuat Links Antar Folder............................................................... 1
Strategi 2. Membuat Links Antar Dokument/File................................................ 5
Strategi 3. Membuat Links Antar Cells.................................................................. 7
Strategi 4. Membuat Links Antar Sheet dan Cells............................................. 10
Strategi 5. Membuat Links dengan objeck Shapes........................................... 14
Strategi 6. Membuat Links Antar Sheet.............................................................. 18
Strategi 7. Dengan Linked Picture di Excel 2010 & 2013................................ 21
Strategi 8. Membuat Links Cells ke Gambar...................................................... 23
BAB 2. 6 Strategi Menyimpan  & Memprotect  Dokumen di Excel.......... 25
Strategi 9. Menyimpan Dokumen dengan Format PDF di Excel 2010 & 2013 25
Strategi 10. Menyimpan Dokumen agar terbaca semua versi Excel............. 27
Strategi 11. Mengunci Dokumen dengan Mark As Final................................. 29
Strategi 12. Mengunci dengan Encrypt With Password.................................... 34
Strategi 13. Mengunci dengan Protect Current Sheet........................................ 38
Strategi 14. Mengunci dengan Protect Workbook Structure............................ 42
BAB 3. 93 Strategi Memahami Dasar Excel................................................... 44
Strategi 15. Copy dan Paste................................................................................... 44
Strategi 16. Cut dan Paste...................................................................................... 46
Strategi 17. Format Painter.................................................................................... 47
Strategi 18. Font ...................................................................................................... 49
Strategi 19. Font Size............................................................................................... 50
Strategi 20. Increase Font Size.............................................................................. 51
Strategi 21. Decrease Font Size............................................................................. 52
Strategi 22. Bold....................................................................................................... 53
Strategi 23. Italic...................................................................................................... 54
Strategi 24. Underline.............................................................................................. 55
Strategi 25. Bottom Borders.................................................................................. 56
Strategi 26. Menampilkan Border dan Menghapus Border pada Cells......... 58
Strategi 27. Fill Color............................................................................................... 59
Strategi 28. Font Color............................................................................................ 60
Strategi 29. Top Align.............................................................................................. 61
Strategi 30. Middle Align........................................................................................ 62
Strategi 31. Bottom Align....................................................................................... 63
Strategi 32. Orientation........................................................................................... 64
Strategi 33. Wrap Text............................................................................................ 65
Strategi 34. Align Left............................................................................................. 65
Strategi 35. Center................................................................................................... 66
Strategi 36. Align Right........................................................................................... 67
Strategi 37. Increase Indent................................................................................... 67
Strategi 38. Decrease Indent.................................................................................. 68
Strategi 39. Merge & Center................................................................................... 69
Strategi 40. Number Format ................................................................................. 71
Strategi 41. Menyamakan jumlah digit angka.................................................. 72
Strategi 42. Accounting Number Format............................................................. 75
Strategi 43. Comma Style...................................................................................... 77
Strategi 44. Increase Decimal................................................................................ 78
Strategi 45. Decrease Decimal............................................................................... 79
Strategi 46. Highlight Cells Rules.......................................................................... 80
Strategi 47. Top/Bottom Rules.............................................................................. 84
Strategi 48. Data Bars............................................................................................. 86
Strategi 49. Colors Scale......................................................................................... 87
Strategi 50. Icon Sets............................................................................................... 88
Strategi 51. Clear Rules........................................................................................... 89
Strategi 52. Insert..................................................................................................... 90
Strategi 53. Insert Sheet Rows............................................................................... 91
Strategi 54. Insert Sheet Columns......................................................................... 92
Strategi 55. Insert Sheet.......................................................................................... 93
Strategi 56. Delete Sheet Rows ............................................................................. 94
Strategi 57. Delete Sheet Columns........................................................................ 95
Strategi 58. Delete Sheet......................................................................................... 96
Strategi 59. Format.................................................................................................. 97
Strategi 60. Mengatur lebar baris (ROW)............................................................ 98
Strategi 61. Auto SUM.......................................................................................... 100
Strategi 62. Fill........................................................................................................ 101
Strategi 63. Clears.................................................................................................. 102
Strategi 64. Sort  and Filter................................................................................... 103
Strategi 65. Find and Select................................................................................. 104
Strategi 66. Pivot Table........................................................................................ 106
Strategi 67. Picture................................................................................................. 108
Strategi 68. Online Picture di Excel 2010 & 2013............................................ 109
Strategi 69. Shapes................................................................................................ 114
Strategi 70. SmartArt............................................................................................ 116
Strategi 71. Screenshot di Excel 2010 & 2013................................................. 118
Strategi 72. Insert Column Chart........................................................................ 120
Strategi 73. Insert Bar Chart................................................................................ 121
Strategi 74. Insert stock, Surface or Radar Chart............................................ 122
Strategi 75. PivotChart......................................................................................... 123
Strategi 76. Margins.............................................................................................. 125
Strategi 77. Orientation......................................................................................... 127
Strategi 78. Size...................................................................................................... 128
Strategi 79. Breaks................................................................................................ 129
Strategi 80. Background....................................................................................... 131
Strategi 81. Print Area........................................................................................... 132
Strategi 82. Print Titles.......................................................................................... 136
Strategi 83. Scale................................................................................................... 138
Strategi 84. Gridlines............................................................................................. 139
Strategi 85. Headings............................................................................................ 140
Strategi 86. Bring Forward................................................................................... 141
Strategi 87.  Send Backward............................................................................... 143
Strategi 88.  Selection Pane.................................................................................. 145
Strategi 89.  Align................................................................................................... 146
Strategi 90.  Group................................................................................................. 148
Strategi 91.  Rotate................................................................................................ 149
Strategi 92.  From Access..................................................................................... 150
Strategi 93.  Existing Connections...................................................................... 153
Strategi 94.  Sort..................................................................................................... 156
Strategi 95.  Text to Columns.............................................................................. 158
Strategi 96.  Remove Duplicates......................................................................... 161
Strategi 97.  Sel Validation................................................................................... 164
Strategi 98.  Group................................................................................................. 166
Strategi 99.  Paste Comments............................................................................. 167
Strategi 100. New Comment dan Delete Comment........................................ 169
Strategi 101. Memasukan gambar pada Comment....................................... 171
Strategi 102. Normal dan Page Layout............................................................. 176
Strategi 103. Page Break Preview....................................................................... 177
Strategi 104. Formula Bar.................................................................................... 178
Strategi 105. Headings.......................................................................................... 179
Strategi 106. Gridlines........................................................................................... 180
Strategi 107. Menggunakan Freeze Panes........................................................ 181
BAB 4. 9 Strategi Penggunaan Logika IF, VLOOKUP & HLOOKUP.. 182
Strategi 108. IF dengan 1 Kriteria....................................................................... 182
Strategi 109. IF dengan 2 Kriteria....................................................................... 183
Strategi 110. IF dengan 3 Kriteria....................................................................... 184
Strategi 111. IF dengan 4 Kriteria....................................................................... 185
Strategi 112. IF dengan 5 Kriteria....................................................................... 186
Strategi 113. IF dengan 6 Kriteria....................................................................... 187
Strategi 114. IF dengan 7 Kriteria....................................................................... 189
Strategi 115. IF dengan VLOOKUP................................................................... 190
Strategi 116. IF dengan HLOOKUP................................................................... 195

Tentang Penulis...................................................................................................... 205
Diposting oleh di Tidak ada komentar:

Senin, 07 Juli 2014

MENGUNGKAP RAHASIA FUNGSI EXCEL + CD

Jika anda memiliki buku ini isikan form berikut

BUKU INI MENJELASKAN TENTANG

1.  BAB 1  Solusi Tepat Penggabungan Fungsi Excel + Latihan
2.  BAB 2 Kreatif dengan 67 Fungsi Tunggal Excel + Latihan
3.  BAB 3 Empat Solusi Fungsi Terbilang Excel + Latihan

4.  BAB 4 Otomatisasi Penandaan Data

Contoh Video & Download

5.  BAB 5 Realisasi Fungsi Excel

Daftar Isi

Kata Pengantar............................................................................................................ i
Daftar Isi..................................................................................................................... iii
BAB  1  Solusi Tepat Penggabungan Fungsi Excel.............................. 1
1.1.  Gabungan Fungsi ROUND dan AVERAGE................................................. 2
1.2.  Gabungan Fungsi INT dan TODAY............................................................... 4
1.3.  Gabungan Fungsi IF dan AND........................................................................ 8
1.4.  Gabungan Fungsi IF dan OR........................................................................ 10
1.5.  Gabungan Fungsi SQRT dan ABS............................................................... 11
1.6.  Gabungan Fungsi IF, NOT, ISBLANK, dan VLOOKUP.......................... 12
1.7.  Gabungan Fungsi IF, AND dan OR............................................................. 19
1.8.  Gabungan Fungsi IF, NOT, ISBLANK dan HLOOKUP........................... 21
1.9.  Gabungan Fungsi INT dan AVERAGE....................................................... 29
1.10.  Gabungan Fungsi Aitmatika dan INT...................................................... 30
1.11.  Gabungan Fungsi ROUND dan LN........................................................... 31
1.12.  Gabungan Fungsi IF, NOT dan ISBLANK............................................... 32
1.13.  Gabungan Fungsi IF dan NOT................................................................... 34
1.14.  Penggunaan ARITMATIKA....................................................................... 35
1.15.  Latihan Gabungan Fungsi........................................................................... 37
1.15.1  Gabungan Fungsi INT, AVERAGE, IF, OR dan AND......................... 37
1.15.2  Gabungan Fungsi INT dan TODAY........................................................ 38
1.15.3  Gabungan Fungsi IF, NOT, ISBLANK, dan VLOOKUP..................... 40
BAB  2   Kreatif dengan 67 Fungsi Tunggal Excel........................... 44
2.1.  Fungsi ABS....................................................................................................... 45
2.2.  Fungsi ACOS.................................................................................................... 46
2.3.  Fungsi ACOSH................................................................................................. 47
2.4.  Fungsi AVERAGE........................................................................................... 48
2.5.  Fungsi COMBIN.............................................................................................. 50
2.6.  Fungsi CONVERT........................................................................................... 51
2.7.  Fungsi COS....................................................................................................... 56
2.8.  Fungsi COSH.................................................................................................... 58
2.9.  Fungsi COUNTBLANK.................................................................................. 59
2.10.  Fungsi COUNT.............................................................................................. 60
2.11.  Fungsi COUNTA........................................................................................... 61
2.12.  Fungsi COUNTIF.......................................................................................... 63
2.13.  Fungsi DTE..................................................................................................... 64
2.14.  Fungsi DAYS360........................................................................................... 65
2.15.  Fungsi DEC2HEX......................................................................................... 68
2.16.  Fungsi DEX2DEC......................................................................................... 70
2.17.  Fungsi DEC2BIN.......................................................................................... 71
2.18.  Fungsi DEC2OCT......................................................................................... 72
2.19.  Fungsi DEGREES.......................................................................................... 74
2.20.  Fungsi EVEN.................................................................................................. 75
2.21.  Fungsi EXP..................................................................................................... 76
2.22.  Fungsi FACT.................................................................................................. 77
2.23.  Fungsi GCD.................................................................................................... 78
2.24.  Fungsi HOUR................................................................................................. 80
2.25.  Fungsi IF......................................................................................................... 81
2.26.  Fungsi INT...................................................................................................... 83
2.27.  Fungsi ISBLANK.......................................................................................... 84
2.28.  Fungsi LCM................................................................................................... 86
2.29.  Fungsi LEFT................................................................................................... 88
2.30.  Fungsi LEN..................................................................................................... 91
2.31.  Fungsi LN....................................................................................................... 94
2.32.  Fungsi LOG.................................................................................................... 95
2.33.  Fungsi LOG10................................................................................................ 97
2.34.  Fungsi LOWER.............................................................................................. 98
2.35.  Fungsi MAX................................................................................................... 99
2.36.  Fungsi MID.................................................................................................. 102
2.37.  Fungsi MIN.................................................................................................. 104
2.38.  Fungsi MINUTE.......................................................................................... 106
2.39.  Fungsi MOD................................................................................................. 107
2.40.  Fungsi NOW................................................................................................. 108
2.41.  Fungsi NPER................................................................................................ 109
2.42.  Fungsi ODD.................................................................................................. 111
2.43.  Fungsi PMT.................................................................................................. 112
2.44.  Fungsi POWER............................................................................................ 114
2.45.  Fungsi PRODUCT....................................................................................... 119
2.46.  Fungsi QUOTIENT..................................................................................... 120
2.47.  Fungsi RATE............................................................................................... 121
2.48.  Fungsi RIGHT............................................................................................. 125
2.49.  Fungsi ROUND............................................................................................ 126
2.50.  Fungsi ROUNDDOWN............................................................................... 130
2.51.  Fungsi ROUNDUP...................................................................................... 131
2.52.  Fungsi SECOND.......................................................................................... 132
2.53.  Fungsi SIN.................................................................................................... 133
2.54.  Fungsi SINH................................................................................................ 134
2.55.  Fungsi SQRT................................................................................................ 136
2.56.  Fungsi SUM................................................................................................. 137
2.57.  Fungsi SUMIF............................................................................................. 139
2.58.  Fungsi SUMPRODUCT............................................................................. 143
2.59.  Fungsi SUMSQ............................................................................................ 145
2.60.  Fungsi SUMX2MY2................................................................................... 146
2.61.  Fungsi TAN.................................................................................................. 148
2.62.  Fungsi TIME................................................................................................ 149
2.63.  Fungsi TODAY............................................................................................ 151
2.64.  Fungsi UPPER............................................................................................. 151
2.65.  Fungsi Penggabungan Karakter............................................................... 153
2.66. Fungsi PROPER........................................................................................... 155
2.67. Fungsi RANK................................................................................................ 156
2.68. Latihan Fungsi............................................................................................. 161
2.68.1  Latihan Fungsi SUM, MAX, MIN, AVERAGE dan RANK.............. 161
2.68.2  Latihan COUNT, COUNIF, COUNTA, dan COUNTBLANK.......... 163
2.68.3  Latihan PMT............................................................................................. 166
2.68.4. Latihan RATE.......................................................................................... 167
2.68.5. Latihan NPER........................................................................................... 168
2.68.6. Latihan UPPER, LOWER, RIGHT, LEFT dan LEN.......................... 168
2.68.7. Latihan ROUND, INT, dan MOD......................................................... 169
BAB   3  4 Solusi Mahir Fungsi Terbilang pada Excel.................. 171
3.1. Solusi Penggunaan Fungsi TerbBiasa........................................................ 171
3.2. Terbilang Inggris............................................................................................. 176
3.3. TerbRupiah dan Sen..................................................................................... 180
3.4. Terbilang 3 digit 2 angka dengan memanfaatkn fungsi gabungan..... 185
BAB   4  Otomatisasi Penandaan Data................................................... 189
4.1.   Memanfaatkan  Highlight Cells Ruler..................................................... 189
4.1.1.  Mengatur data dengan Greater Than.................................................... 189
4.1.2.  Mengatur data dengan Less Than......................................................... 193
4.1.3.  Menandai data dengan Between........................................................... 197
4.1.4.  Menandai data dengan Equal to............................................................ 201
4.1.5.  Mengatur data dengan Text That Contains......................................... 205
4.1.6.  Menandai data dengan A Date Occurring............................................ 207
4.1.7.  Menandai data dengan Duplicate Values............................................ 210
4.2.    Memanfaatkan Top/Bottom Rules........................................................ 212
4.2.1.  Menandai data dengan Top 10 Items................................................... 212
4.2.2.  Menandai data dengan Top 10%.......................................................... 214
4.2.3.  Menandai data dengan Bottom 10 Items............................................ 216
4.2.4.  Menandai data dengan Bottom 10%.................................................... 218
4.2.5.  Menandai data dengan Above Average............................................... 220
4.2.6.  Menandai data dengan Below Average................................................ 222
4.3   Menandai data dengan Data Bars............................................................ 225
4.3.1.  Menandai data dengan Gradient Fill..................................................... 225
4.3.2.  Menandai data dengan Solid Fill............................................................ 226
4.4.    Menandai data dengan Colors Scales.................................................... 228
4.5.    Menggunakan Icon Sets............................................................................ 229
4.5.1.  Menandai data dengan Directional....................................................... 229
4.5.2.  Menandai data dengan Shapes.............................................................. 231
4.5.3.  Menandai data dengan Indicators......................................................... 232
4.5.4.  Menandai data dengan Ratings............................................................. 234
4.6.  Menghapus penandaan dengan Clear Rules........................................... 235
BAB  5  Realisasi Fungsi Excel.................................................................. 237
5.1.  Realisasi pada Kuitansi Pembayaran....................................................... 237
5.2.  Realisasi pada Nota Kontan....................................................................... 249
5.3.  Realisasi pada Nilai Sertifikat Komputer................................................. 258
Tentang Penulis............................................................................................... 265

Sinopsis

Mengulas berbagai trik solusi tepat dalam menguasai Excel secara cepat. Pembahasannya mencakup penggabungan fungsi Excel, fungsi Tunggal Excel, fungsi Terbilang, otomatisasi penandaan data, realisasi fungsi Excel. Selain itu, juga disertai latihan fungsi Excel untuk membantu penguasaan materi yang diberikan. Contoh-contoh kasus diolah secara sederhana dan step by step sehingga pembaca dapat memahami isi materi dengan cepat.
Setelah mempelajari Mengungkap Rahasia Fungsi Excel, Anda akan dapat menguasai materi Excel yang sering dicari secara otodidak. Buku ini dapat digunakan pada berbagai versi Excel, terutama Excel 2007, 2010, dan 2013.

DETAIL

JudulMengungkap Rahasia Fungsi Excel + Cd
SeriMicrosoft Excel
ISBN/EAN9786020236124 / 9786020236124
PengarangHamdan Lugina Jaya , S.Pd
PenerbitELEX MEDIA
Terbit9 April 2014
Pages260
Berat250 gram
Dimensi(mm)140 x 210
Tagsaplikasi perkantoran,contoh kasus,fungsi excel,materi,pembahasan,solusi,trik
KategoriKomputer
Jika anda pernah/punya/membeli buku ini isikan form pelanggan di bawah ini

FORMULIR ISIAN PELANGGAN

Sample Buku :

3.1.1.   Mengatur  data dengan Greater Than

Greater Than berfungsi untuk mengatur suatu data dengan kriteria tertentu pada cells atau  untuk mengatur format sel jika kondisi sel memiliki nilai lebih besar dari suatu nilai tertentu. Misalnya batas nilai tertinggi yang ditentukan adalah 70, maka nilai diatas 70 akan  berwarna/memiliki tanda sesuai dengan kriteria yang ditentukan.
Berikut contoh penggunaan Greater Than di bawah ini. Ketiklah data berikut ini kemudian lakukanlah langkah berikutnya.

Lakukan langkah berikutnya yang perlu dilakukan adalah
1.  Bloklah semua kolom nilai
2.  Klik menu HOME
3.  Klik Conditional Formatting
4.  Klik Highlight Cells Rules
5.  Klik Greater Than
Untuk lebih jelasnya perhatikanlah gambar di bawah ini.

Gambar 4.1 Proses pencarian Greater Than
Pada kotak dialog Greater Than lakukanlah langkah berikut ini.
1.  Pada Format cells that are GREATER THAN ketiklah 70 atau kita juga dapat mengklik cells yang berisi batas nilai.
2.  Pada With pilihlah salah satu kriteria penandaan yang diinginkan
3.  Klik OK.
Untuk lebih jelasnya perhatikalnah gambar berikut ini.

Gambar 4.2 kotak dialog GREATER THAN

Gambar 4.3  Hasil GREATER THAN
Selain cara diatas fungsi ini dapat juga digunakan untuk text. Berikut contoh penggunaan Greater Than untuk kriteria text huruf. Tambahkanlah kriteria prestasi di samping nama siswa berikut ini.

Langkah selanjutnya adalah
1.  Bloklah kolom Prestasi kemudian klik Menu HOME
2.  Klik Conditional Formatting
3.  Klik Highlight Cells Rules
4.  Kliklah Greater Than
5.  Pada kotak dialog GREATER THAN di kolom Format cells that are GREATER THAN ketiklah karakter yang diinginkan selain angka misalnya huruf B, maka data selain huruf B dan A akan tetap dan yang lainnya akan berwarna sesuai dengan kriteria.
6.  Pada bagian with pilih dan kliklah kriteria penandaan yang diinginkan.
7.  Klik OK.
Agar lebih memperluas pemahaman kita lihatlah gambar di bawah ini.

Gambar 4.4 Kotak dialog GREATER THAN


Gambar 4.5  Hasil GREATER THAN

Buku lain yang telah terbit
Diposting oleh di Tidak ada komentar:

PENERAPAN FUNGSI EXCEL UNTUK APLIKASI

Jika anda pernah/punya/membeli buku ini isikan form pelanggan di bawah ini
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 membuat List Tahun Pelajaran.......................................................... 11
1.7    Trik membuat 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 membuat 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 gabungan 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 gabungan
         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 kode 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 berbagai gabungan 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 dapat membeli di TB GRAMEDIA tedekat jika 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




Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)