June 26, 2020

Serial Lengkap Microsoft Office



Serial Lengkap Microsoft Office
Mau Tahu Rahasia Cara Menguasai Microsoft Office Dengan Cepat?  Di sini akan dikupas secara tuntas, lugas dengan cara sederhana. Dibahas berbagai versi 2010-2019. Anda akan mendapatkan Serial Ebook Microsoft Office (Word, Excel, PowerPoint, Access, Rumus & Fungsi Excel). Menguasai atau mampu mengoperasikan Software Microsoft adalah suatu keharusan. Suatu tuntutan zaman yang tidak bisa dihindari. Dengan adanya Serial Ebook Lengkap Microsoft Ovffice ini. Anda bisa mempelajarinya lewat Komputer atau melalui Hand Phone Sendiri. Jadi bisa anda manfaatkan untuk mempelajari atau mempermahirnya dari mana saja dan kapan saja. Kesempatan Yang Sangat Langka.

Microsoft Word
Microsoft Word merupakan salah satu software Ms.Office yang paling sering digunakan. Boleh jadi setiap laptop dan perangkat komputer setiap orang pasti memiliki aplikasi ini. Aplikasi ini diterbitkan pada tahun 1983 dengan berbagai versi, saat ini Ms. Ms.word merupakan aplikasi pengolah kata, dalam artian semua pekerjaan yang berhubungan dengan pengolahan kata dapat dilakukan dengan menggunakan Ms.Word. Contoh nya, membuat surat, membuat tabel, input gambar, membuat desain sederhana, membuat dokumen, dan berbagai macam pengolahan data lainnya. Ms. Word sudah dikenal dan dimamfaatkan secara luas mulai dari anak sekolah tingkat dasar hingga anak kuliahan untuk menyelesaikan skripsinya dan orang awam sekalipun.
Microsoft Excel
Microsoft Excel merupakan aplikasi microsoft office yang berfungsi sebagai pengolah data berupa perhitungan angka maupun grafik. Dengan Ms.Excel pengguna dapat membuat lembar kerja spreadsheet dengan berbagai fitur kalkulasi akurat dan mudah dioperasikan.
Ms. Excel dapat membantu pengguna dalam membuat laporan keuangan seperti laporan akuntansi, baik berupa laporan angka maupun grafik. Namun untuk melakukan perhitungan secara otomatis pengguna harus menggunakan rumus dan logika. Microsoft Excel sebagai program populer memiliki kelebihan dibandingkan dengan aplikasi sejenis antara lain:
  •   Antarmuka pengguna yang user friendly.
  •   Tersedianya fitur untuk membuat grafik data.
  •   Adanya fitur pemrograman VBA.
  •   Kemampuan menyimpan data dalam jumlah besar.
  •   Mudah dioperasikan jika paham rumus dan logika dalam Excel.
Microsoft Powerpoint
Ms.Power point merupakan aplikasi dari Microsoft Office yang berfungsi sebagai media presentasi dengan menggunakan slide. Dengan menggunakan aplikasi ini pengguna dimudahkan untuk melakukan presentasi, selain itu dalam Power Point juga terdapat fitur-fitur yang dapat digunakan untuk membuat slide presentasi menjadi lebih menarik.
Kehadiran powerpoint membuat sebuah presentasi berjalan lebih mudah dan menggantikan cara presentasi kuno yaitu dengan transparansi proyektor atau biasa disebut OHP (Over Head Projector). Dengan menggunakan Microsoft Power Point berbagai macam tools dan template yang memberikan efek tertentu pada sebuah presentasi. Kelebihan Microsoft Power Point antara lain:
  •   Mudah untuk dioperasikan
  •   Tersedia berbagai macam desain dan animasi
  •   Tersedia berbagai macam template menarik
  •   Dapat dibuat dalam berbagai format
Microsoft Office Access
Program aplikasi komputer dari Office lainnya adalah Acces. Program ini digunakan untuk perusahaan kecil dan juga rumahan untuk mengolah data dengan Microsoft Jet Database Engine. Program ini juga bisa menampilkan grafis yang sempurna sehingga mudah dipahami pengguna dan mengelola basis data atau lebih dikenal dengan database.
Microsoft Access mempunyai banyak sekali fungsi yang membantu kinerja seseorang dalam mengolah data sehingga lebih mudah dan mengefektifkan waktu. Apalagi aplikasi ini juga mudah digunakan dan praktis. Sayangnya, banyak fitur yang masih berbayar. Biasanya program ini sudah di-bundling dengan program besutan Microsoft Office lainnya.
Kenapa Harus Menguasai Microsoft Office
Banyak di antara kita yang mungkin sering mengabaikan betapa pentingnya menguasai microsoft office (aplikasi perkantoran). Ketrampilan memakai Microsoft Office, sebenarnya perlu untuk siapa saja, tidak hanya bagi pelajar/mahasiswa yang memang dituntut harus menguasinya  karena faktor ujian praktek computer. Tetapi sebenarnya pada saat memasuki dunia kerja skill menguasai microsoft office terutama microsoft excel dan microsoft word sangatlah penting.
Tapi Bagaimana Caranya Agar Saya Bisa Mahir dan Menguasai Microsoft Office?
Nah itu dia Kita menyediakan Serial Ebook MICROSOFT OFFICE Anda akan mendapatkan Serial Ebook Microsoft Office yang terdapat 5 Ebook keseluruhannya (Microsoft Word, Microsoft Excel, Microsoft Powerpoint, Microsoft Access, Rumus & Fungsi Microsoft Excel)
Panduan Lengkap Microsoft Word
Serial Ebook ini Sangat Cocok Untuk Semua Kalangan Yang Ingin Mahir Microsoft Office
Pelamar Kerja. Sangat cocok untuk pelamar kerja, karena di sini membahas semua tentang microsoft office yang akan digunakan di dalam dunia pekerjaan dan pendidikan

Keryawan. Sangat cocok untuk karyawan membantu dalam membuat laporan, baik keuangan maupun analisis dan lain, sehingga sangat menghemat waktu dan tenaga

Guru/Dosen. Tidak hanya untuk pelamar kerja dan karyawan, guru dan dosen sangat bermanfaat, apalagi pekerjaan dosen atau guru tidak bisa lepas dari ms office

Siswa/Mahasiswa. Sangat membantu sekali dalam membuat tugas seperti analisis penelitian, laporan, dan lain. Cocok banget deh untuk siswa atau mahasiswa

Peneliti. Salah satu aplikasi yg dipakai untuk menganalisis dan membuat laporan adalah excel dan word, dengan excel kita bisa menganalisis data sangat cepat

Umum. Tidak hanya orang yang bekerja di perkantoran yang bisa mempelejari ebook ini, siapapun bisa mempelajarinya.


INI DAFRA ISINYA  


DAFTAR ISI

Daftar  Isi

Kata Sambutan ............................................................................
Kata Pengantar ............................................................................
Daftar Isi .....................................................................................
BAB 1 PENGENALAN MICROSOFT WORD ..................................1
Sejarah Microsoft Word ........................................................................3
Versi Microsoft Word .....................................................................5
Fitur Terbaru Microsoft Word 2016 ...............................................6
BAB 2 PENGENALAN TOOLS WORD 2016 .............................8
Membuka Aplikasi Word 2016 .............................................................8
Mengenal Tools Word 2016 ................................................................11
Mengenal Tab Ribbon Word 2016 ......................................................14
File ......................................................................................................14
Home ................................................................................................17
Insert .................................................................................................22
Design ...............................................................................................28
Layout ...............................................................................................31
References ........................................................................................34
Mailings ............................................................................................38
Review ...............................................................................................42
View ..................................................................................................47
Pintasan Keyboard Yang Umum ......................................................51
BAB 3 MEMULAI DENGAN WORD ......................................56
Membuat Dokumen Baru ............................................................56
Membuat Dokumen Dengan Template ........................................57
Menyimpan Dokumen .................................................................59
Menyimpan Dokumen Dalam Format Lain..................................61
Membuka Dokumen Yang Telah Ditutup ....................................65
Menutup Dokumen ......................................................................67
BAB 4 BEKERJA DENGAN FORMAT DOKUMEN ...............69
Memindahkan Teks ......................................................................69
Menyalin Teks .............................................................................71
Menggunakan Format Painter......................................................72
Font .............................................................................................73
Mengubah Font Teks ...................................................................73
Mengubah Ukuran Font Teks ......................................................75
Membuat Teks Tebal ...................................................................76
Membuat Teks Miring .................................................................78
Membuat Teks Garis Bawah .........................................................79
Membuat Teks Strikethrough .......................................................80
Mengubah Teks Huruf Besar & Kecil ..........................................81
Mengubah Warna Background Teks ...........................................84
Mengubah Warna Teks ..................................................................85
Membuat Efek Teks ........................................................................87
Menghapus Seluruh Format ..........................................................88
BAB 5 BEKERJA DENGAN PARAGRAF .................................90
Paragraf .........................................................................................90
Menambah Bullets .........................................................................90
Menambah Numbering .................................................................92
Menambah & Mengurangi Lekukan Teks ....................................94
Men-Sorting Teks ...........................................................................95
Membuat Teks Rata Kiri, Tengah, Kanan, & Kiri Kanan .........97
Menggunakan Spasi Teks ........................................................100
Mem-Border Teks ....................................................................101
Mencari & Me-Replace Teks ...................................................103
Memakai Style Teks .................................................................106
BAB 6 BEKERJA DENGAN GAMBAR & ILUSTRATOR ...........108
Membuat Halaman Cover .................................................................108
Menambahkan Halaman Kosong .................................................110
Tabel .............................................................................................112
Menambah Tabel ..........................................................................112
Menambah Tabel Dengan Quick Tables ......................................115
Menghapus Tabel ...........................................................................117
Menyisipkan Kolom Dan Baris .....................................................119
Menyisipkan Tabel Menggunakan Draw Table .............................121
Memasukkan Gambar .......................................................................123
Memasukkan Gambar Secara Online ...............................................125
Mengubah Style Gambar ..................................................................127
Mengoreksi Gambar .........................................................................129
Mengubah Warna Gambar ............................................................130
Memberi Efek Gambar ..................................................................132
Mengatur Posisi Gambar ...............................................................134
Menggunakan Wrap Text ..............................................................135
Memotong Gambar ........................................................................137
Memasukkan Gambar dari Screenshot ...........................................139
Bentuk ............................................................................................141
Menambah Bentuk .........................................................................141
Mengedit Bentuk .............................................................................143
Menghapus Bentuk .........................................................................145
Memasukkan Teks Ke Dalam Bentuk .............................................147
SmartArt ......................................................................................149
Menambah SmartArt ..................................................................149
Memasukkan Teks Ke Dalam SmartArt ......................................151
Mengubah Warna SmartArt ........................................................153
Memberi Efek Pada SmartArt .....................................................155
Menghapus SmartArt ..................................................................156
Grafik ..........................................................................................158



Menambah Grafik .........................................................................158
Menambah Elemen Grafik ............................................................160
Mengubah Style & Warna Grafik .................................................162
Mengubah Tipe Grafik ...................................................................164
Mengedit Data Grafik ....................................................................167
Menghapus Grafik ..........................................................................169
Media ..............................................................................................170
Memasukkan Video Online ..........................................................170
Mencari Bahan Dari Wikipedia ....................................................173
BAB 7 MENGELOLA DOKUMEN TINGKAT LANJUT .........175
Hyperlink ......................................................................................175
Menambah Hyperlink Pada Teks ..................................................175
Mengedit Hyperlink ......................................................................177
Menghapus Hyperlink ...................................................................178
Komentar .......................................................................................180
Menambah Komentar ....................................................................180
Membalas Komentar ......................................................................182
Mengedit Komentar .......................................................................183
Menghapus Komentar ....................................................................184
Menyembunyikan & Menampilkan Komentar ..............................185
Header ............................................................................................187
Menambah Header .........................................................................187
Mengedit Header ............................................................................190
Menghapus Header .........................................................................192
Footer ..............................................................................................194
Menambah Footer ..........................................................................194
Mengedit Footer ..............................................................................197
Menghapus Footer ..........................................................................199
Nomor Halaman ..............................................................................201
Menambah Nomor Halaman .......................................................201
Mengubah Format Nomor Halaman ...........................................203
Menghapus Nomor Halaman .......................................................205
WordArt ......................................................................................207
Memasukkan WordArt ..................................................................207
Mengedit WordArt .........................................................................209
Mengubah Warna WordArt ..........................................................210
Memberi Efek WordArt .................................................................212
Menghapus WordArt .....................................................................214
Memasukkan Text Box Ke Dalam Dokumen .............................216
Drop Cap ......................................................................................218
Membuat Dokumen Drop Cap .....................................................218
Mengedit Drop Cap ......................................................................221
Menghapus Drop Cap ...................................................................223
Simbol ...........................................................................................225
Memasukkan Rumus Persamaan .................................................225
Mengedit Rumus Persamaan ........................................................227
Menghapus Rumus Persamaan ....................................................229
Memasukkan Simbol ....................................................................230
Watermark .....................................................................................232
Menambah Watermark ..................................................................232
Mengedit Watermark .....................................................................235
Menghapus Watermark .................................................................237
Mengubah Page Color ........................................................................238
Menambah Page Borders ....................................................................240
BAB 8 BEKERJA DENGAN REFERENSI .......................................243
Footnote ..............................................................................................243
Menambah Footnote ......................................................................243
Mengedit Footnote .........................................................................245
Menghapus Footnote ......................................................................246
Endnote ...........................................................................................247
Menambah Endnoote .....................................................................248
Mengedit Endnote ..........................................................................249
Menghapus Endnote .......................................................................251
BAB 9 MENGELOLA LAYOUT DOKUMEN ...............................253
Membuat Kolom Teks .......................................................................253
Mengatur Margin Dokumen ..............................................................255
Mengatur Orientasi Dokumen............................................................257
Mengatur Ukuran Kertas ...................................................................261
Memperbesar Tampilan Dokumen ....................................................262
Mengembalikan ke 100% Tampilan Dokumen .................................264
Membuat Tampilan Multiple Pages ...................................................265
Menyusun Tampilan Dokumen ..........................................................267
BAB 10 KEAMANAN DOKUMEN ................................................269
Mengunci Pengeditan Dokumen ........................................................269
Mengunci Dokumen ...........................................................................273
Menghilangkan Penguncian Dokumen ..............................................279
BAB 11 MEMBAGI DAN MENCETAK DOKUMEN ....................282
Berbagi Dokumen Dengan OneDrive ................................................282
Mencetak Dokumen ...........................................................................286
Pengaturan Percetakan .......................................................................286
Daftar Pustaka ....................................................................................292



PANDUAN LENGKAP MICROSOFT EXCEL


DAFTAR ISI


Daftar Isi

Kata Sambutan ....................................................................
Kata Pengantar .....................................................................
Daftar Isi ..............................................................................

BAB 1 PENGENALAN MICROSOFT EXCEL .........................................1
Sejarah Microsoft Excel .............................................................................2
Versi Microsoft Excel ..................................................................................5
Format Berkas Microsoft Excel ..............................................................7
BAB 2 PENGENALAN TOOLS EXCEL 2016 .......................................11
Membuka Aplikasi Excel 2016 ..............................................................11
Mengenal Tools Excel 2016 ...................................................................15
Mengenal Tab Ribbon Excel 2016 ......................................................18
File .....................................................................................................18
Home .................................................................................................20
Insert .................................................................................................26
Page Layout ......................................................................................32
Formulas ...........................................................................................36
Data ...................................................................................................40
Review ...............................................................................................46
View ..................................................................................................50
BAB 3 MULAI BEKERJA DENGAN WORKBOOK ....................54
Workbooks .....................................................................................54
Membuat Workbook Baru .............................................................54
Menyimpan Workbook ..................................................................55
Menutup Workbook .......................................................................57
Membuka File Workbook ..............................................................58
Mengunci Workbook ......................................................................60
BAB 4 MULAI BEKERJA DENGAN WORKSHEET ....................68
Worksheet ........................................................................................68
Menambah Worksheet Baru .........................................................68
Mengedit Nama Worksheet ..........................................................70
Memberi Warna Pada Worksheet ................................................71
Memindahkan Atau Menyalin Worksheet ..................................73
Menghilangkan Worksheet ...........................................................75
Menghapus Worksheet ..................................................................77
Mengunci Worksheet .....................................................................78
Menyeleksi Worksheet ...................................................................81
BAB 5 MULAI BEKERJA DENGAN SEL ......................................83
Sel .......................................................................................................83
Jenis-jenis Pointer ............................................................................83
Tombol Penggerak Pointer ............................................................84
Instruksi-instruksi Seleksi Sel ........................................................87
Menyeleksi Beberapa Sel ................................................................88
Mengatur Ukuran Sel .....................................................................89
Menyisipkan Sel ..............................................................................91
Menghapus Sel .................................................................................94
Menghilangkan Baris Dan Kolom ................................................97
Memasukkan Data Pada Sel ...........................................................98
Mengedit Data Sel ...........................................................................99
Memindahkan Data Sel ..................................................................100
Men-Sorter Teks ..............................................................................101
Menemukan Dan Me-Replace Teks ..............................................103
Menghapus Data Sel .......................................................................106
Copy & Paste Data Sel .....................................................................107
Transpose Data Sel ..........................................................................109
BAB 6 MENGELOLA FORMAT DATA .........................................112
Font ....................................................................................................112
Memilih Font Dan Ukuran Font ...................................................112
Membuat Teks Bold, Italic, Dan Underline .................................115
Mem-Border Sekitar Sel ..................................................................118
Mengubah Warna Teks Dan Sel ...................................................120
Paragraf .............................................................................................123
Membuat Teks Lurus Atas, Tengah, Dan Bawah ......................123
Membuat Teks Rata Kiri, Tengah, Dan Kanan ...........................123
Mengubah Orientasi Teks ..............................................................131
Menambah Dan Mengurangi Lekukan Teks ...............................136
Warp Text Di Dalam Sel ................................................................137
Merge & Center ...............................................................................139
Format Nomor ................................................................................140
Menambah Format Mata Uang .....................................................140
Menambah Format Persen ............................................................142
Menambah Dan Mengurangi Desimal .........................................143
Style ...................................................................................................145
Menggunakan Condition Format .................................................146
Menggunakan Format Table .........................................................150
Menggunakan Style Sel ...................................................................152
Komentar .........................................................................................154
Menambah Komentar ....................................................................154
Mengedit Komentar ........................................................................156
Menghapus Komentar ....................................................................157
Menampilkan & Menyembunyikan Komentar ..........................158
Hyperlink .................................................................................................160




Memasukkan Hyperlink Ke Dalam Sel .....................................160
Mengedit Hyperlink .........................................................................163
Menghapus Hyperlink .....................................................................164
Header & Footer .................................................................................165
Menambah Header .............................................................................165
Menambah Footer ..............................................................................168
Memasukkan Tanggal Pada Sel .......................................................171
Memasukkan Background Sel .........................................................172
BAB 7 MENGENAL RUMUS (FORMULAS) EXCEL 2016 .......175
Mengenal Formula .............................................................................175
Operator Formula ..............................................................................176
Operator Aritmatika ..........................................................................176
Operator Perbandingan ..................................................................177
Operator Teks ......................................................................................177
Operator Referensi ............................................................................177
Menggunakan Formula ...................................................................178
Formula Dengan Referensi Sel Reltif .........................................180
Formula Dengan Referensi Sel Semi Absolut .........................181
Formula Dengan Referensi Sel Absolut ....................................184
Mengedit Formula ....................................................................................186
Menghapus Formula ................................................................................187
Pesan Kesalahan Formula .......................................................................188
Formula Array ..............................................................................................189
Mengapa Menggunakan Rumus Array? .............................................189
Sintak Rumus Array ..........................................................................190
Memasukkan Rumus Array ...........................................................190
Membuat Rumus Array Sel Tunggal ............................................192
Membuat Rumus Array Multi Sel .................................................193
Konstanta Array ...................................................................................196
Membuat Konstanta Satu Dimensi ...............................................197
Membuat Konstanta Dua Dimensi ...............................................199
Menggunakan Konstanta Dalam Rumus .....................................201
Kelemahan Rumus Array ..................................................................203
BAB 8 MENGENAL FUNGSI (FUNCTIONS) EXCEL 2016 .....204
Fungsi Excel ...........................................................................................204
Argumen Dalam Fungsi ....................................................................205
Penggunaan Fungsi ............................................................................206
Macam-macam Fungsi ......................................................................210
Fungsi Yang Populer ...........................................................................210
Fungsi MIN ......................................................................................211
Fungsi MAX .....................................................................................213
Fungsi AVERAGE ...........................................................................215
Fungsi SUM .....................................................................................219
Fungsi SUMIF ..................................................................................232
Fungsi IF ...........................................................................................235
Fungsi LOOKUP .............................................................................239
BAB 9 GRAFIK DAN BENTUK .....................................................246
Chart ................................................................................................246
Chart Column & Bar .......................................................................246
Chart Line & Area ...........................................................................249
Chart Pie & Doughnut ...................................................................251
Chart Histogram & Whisker .........................................................153
Chart Scatter & Bubble ...................................................................256
Chart Waterfall ................................................................................258
Chart Radar ......................................................................................260
Chart PivotChart .............................................................................262
Menambah Elemen Chart ..............................................................265
Mengatur Warna & Style Chart .....................................................267
Menghapus Chart ..............................................................................269
Sparklines .............................................................................................271
Line ..........................................................................................................271
Column ..................................................................................................273
Win/Loss ..............................................................................................275
Shapes ....................................................................................................277
Menambah Shapes ...........................................................................277
Mengedit Shapes ..............................................................................279
Menghapus Shapes ..........................................................................280
Memasukkan Teks Ke Dalam Shapes ........................................281
SmartArt ..............................................................................................282
Membuat SmartArt .........................................................................282
Memasukkan Teks Ke Dalam SmartArt ..................................283
Memberi Warna & Style SmartArt ............................................285
Menghapus SmartArt .....................................................................288
WordArt .............................................................................................288
Menambah WordArt ......................................................................289
Mengedit WordArt .........................................................................290
Menghapus WordArt ......................................................................291
BAB 10 MENAMBAH GAMBAR ..................................................293
Memasukkan gambar ................................................................................293
Mengoreksi Warna Gambar ....................................................................295
Merubah Warna Gambar .........................................................................296
Menggunakan Efek Artistik ....................................................................297
Menggunakan Style Gambar ...................................................................299
Menggunakan Rancangan Gambar .......................................................300
Memotong Gambar ......................................................................................301
BAB 11 BERBAGI DAN MENCETAK FILE ...........................................304
Berbagi Workbook Dengan Orang Lain ..............................................304
Menyimpan Workbook Format Lain ....................................................305
Mencetak File ...............................................................................................308
Mencetak Area seleksi ...............................................................................308
Pengaturan Pencetakan ...........................................................................310

Daftar Pustaka ...............................................................................................314




PANDUAN LENGKAP MICROSOFT POWER POINT



DAFTAR ISI


Daftar Isi 

Kata Sambutan .........................................................................................
Kata Pengantar .........................................................................................
Daftar Isi ....................................................................................................
BAB 1 PENGENALAN MICROSOFT POWERPOINT ..........................1
Sejarah Microsoft PowerPoint ...............................................................2
Versi Microsoft PowerPoint ...................................................................3
Operasi Microsoft PowerPoint ..............................................................4
Kompatibilitas Microsoft PowerPoint ..................................................5
Yang Baru Di Microsoft PowerPoint 2016 ...........................................6
BAB 2 PENGENALAN TOOLS POWERPOINT 2016 ………...............10
Membuka Aplikasi PowerPoint 2016 ....................................................11
Mengenal Tools PowerPoint 2016 .........................................................13
Mengenal Tab Ribbon PowerPoint 2016 ..............................................17
File .....................................................................................................17
Home ................................................................................................20
Insert .................................................................................................26
Design ...............................................................................................32
Transitions .......................................................................................34
Animations ......................................................................................36
Slide Show ........................................................................................39
Review ...............................................................................................42
View ..................................................................................................46
Pintasan Keyboard PowerPoint .............................................................51
BAB 3 MEMULAI DENGAN POWERPOINT .......................................56
Membuat Presentasi baru ........................................................................56
Membuat Presentasi Dengan Template .............................................58
Menyimpan Presentasi ..............................................................................61
Menyimpan Presentasi Dengan Format Lain ...................................63
Membuka Presentasi Yang Telah Ditutup ...........................................66
Mengubah Tampilan Presentasi .............................................................68
Menutup Presentasi ....................................................................................69
BAB 4 BEKERJA DENGAN SLIDE ...............................................72
Section ...................................................................................................72
Menambah Section Baru ................................................................73
Mengubah Nama Section ..............................................................75
Menghapus Section .........................................................................77
Membuka & Menutup Section ....................................................78
Slide .......................................................................................................81
Menambah Slide Baru ....................................................................81
Menduplikasi Slide .........................................................................83
Menghapus Slide .............................................................................85
Menyembunyikan Slide .................................................................87
Mengubah Warna Background Slide ...........................................90
Menentukan Layout Slide ................................................................92
BAB 5 BEKERJA DENGAN TEKS ....................................................95
Memasukkan Teks Ke Dalam Slide ..............................................95
Menyalin Teks .......................................................................................97
Memindahkan Teks ..........................................................................100
Menggunakan Format Painter .....................................................103
Font ..........................................................................................................104
Mengubah Font Dan Ukuran Font ...............................................104
Membuat Teks Bold .......................................................................107
Membuat Teks Italic .......................................................................109
Membuat Teks Underline ..............................................................111
Membuat Teks Shadow ..................................................................113
Membuat Teks Strikethrough .......................................................115
Mengubah Warna Teks ..................................................................117
Mengubah Spasi Karakter .............................................................120
Menghapus Format Teks ...............................................................122
Paragraph .............................................................,...........................124
Menambah Bullets ..........................................................................124
Menambah Numbering .................................................................126
Membuat Teks Rata Kiri ................................................................129
Membuat Teks Rata Tengah .........................................................131
Membuat Teks Rata Kanan ...........................................................133
Membuat Teks Rata Kiri Kanan ...................................................135
Membuat Kolom Teks ...................................................................137
Mengubah Spasi Teks .....................................................................140
Mengubah Arah Teks .....................................................................142
Mencari Teks ...........................................................................................144
Mengganti Teks ......................................................................................146
Memasukkan Text Box ........................................................................148
Menampilkan Rule ................................................................................149
BAB 6 BEKERJA DENGAN ILUSTRASI ......................................152
Tabel ........................................................................................................152
Menambah Tabel ..............................................................................153
Menambah Tabel Dengan Draw Table .....................................156
Menambah Tabel Excel ..................................................................159
Menyisipkan Tabel .........................................................................160
Menggabungkan Sel .......................................................................162
Menghapus Tabel ............................................................................164
Menentukan Ukuran Tabel ...........................................................167
Menggunakan Style Tabel .............................................................169
Memberi Warna Tabel ...................................................................172
Memberi Efek Tabel .......................................................................177
Mengubah Border Tabel ................................................................180
Gambar ......................................................................................................183
Memasukkan Gambar ....................................................................183
Memasukkan Gambar Melalui Online ........................................185
Memasukkan Gambar Screenshoot .............................................187




Menambahkan Album Foto ..........................................................189
Mengoreksi Gambar .......................................................................192
Mengubah Warna Gambar ...........................................................194
Memberi Efek Artistik ...................................................................196
Mengubah Style Gambar ...............................................................198
Mengubah Efek Gambar ................................................................200
Memotong Gambar ........................................................................203
Menghapus Background Gambar ................................................205
Shape ....................................................................................................208
Menambah Shape ...........................................................................209
Mengedit Point Shape ....................................................................211
Mengubah Warna Shape ...............................................................214
Memberi Efek Pada Shape .............................................................220
Memasukkan Teks Ke Dalam Shape ............................................223
Menghapus Shape ...........................................................................224
SmartArt ............................................................................................226
Menambah SmartArt .....................................................................226
Memasukkan Teks Ke Dalam SmartArt ......................................228
Mengubah Warna SmartArt .........................................................230
Memberi Efek Pada SmartArt .......................................................232
Menghapus SmartArt .....................................................................234
Chart ..................................................................................................236
Menambah Chart ............................................................................237
Menambah Elemen Chart ..............................................................239
Mengubah Style & Warna Chart ..................................................242
Mengubah Tipe Chart ....................................................................244
Mengedit Data Chart ......................................................................246
Menghapus Chart ...........................................................................248
Link ....................................................................................................250
Menambah Link Pada Teks ...........................................................250
Mengedit Link .................................................................................253
Menghapus Link .............................................................................255
Comment ..........................................................................................258
Menambah Comment ....................................................................258
Mengedit Comment .......................................................................260
Menghapus Comment ....................................................................262
Menyembunyikan & Menampilkan Comment ..........................264
Footer .................................................................................................265
Menambah Footer ..........................................................................265
Mengedit Footer ..............................................................................268
Menghapus Footer ..........................................................................269
WordArt .............................................................................................271
Menambah WordArt .....................................................................271
Mengubah Teks WordArt .............................................................274
Mengubah Warna WordArt .........................................................275
Mengubah Efek WordArt ..............................................................277
Menghapus WordArt .....................................................................280
Date & Time .....................................................................................281
Memasukkan Date & Time ...........................................................281
Mengedit Date & Time ..................................................................283
Menghapus Date & Time ...............................................................285
Slide Number .....................................................................................286
Memasukkan Slide Number ..........................................................286
Mengedit Slide Number .................................................................288
Menghapus Slide Number .............................................................290
Rumus ................................................................................................291
Memasukkan Rumus Persamaan .................................................291
Mengedit Rumus Persamaan ........................................................293
Menghapus Rumus Persamaan ....................................................295
Symbol ...............................................................................................297
Memasukkan Simbol ......................................................................297
Menghapus Simbol .........................................................................299
BAB 7 BEKERJA DENGAN MEDIA ..............................................302
Video ...................................................................................................302
Memasukkan Video ........................................................................303
Mengoreksi Video ...........................................................................305
Mengubah Warna Video .................................................................307
Memotong Video ............................................................................308
Audio .........................................................................................................311
Memasukkan Audio ...........................................................................311
Memotong Audio .................................................................................313
Membuat Audio Bermain Di Dalam Background .....................315
BAB 8 BEKERJA DENGAN DESAIN ...........................................317
Thema ........................................................................................................317
Memasukkan Thema Baru ............................................................318
Varian ........................................................................................................320
Memilih Warna .....................................................................................320
Mengubah Ukuran Slide ................................................................323
BAB 9 BEKERJA DENGAN TRANSISI & ANIMASI ..................326
Transisi ......................................................................................................326
Memilih Transisi Slide ...................................................................327
Memilih Opsi Efek Transisi Slide .................................................328
Memilih Suara Transisi Slide ........................................................330
Mengatur Durasi Transisi Slide ....................................................331
Animasi ......................................................................................................333
Memilih Animasi ...............................................................................333
Memilih Opsi Efek Animasi ..........................................................335
Mengatur Durasi Animasi .............................................................337
BAB 10 BEKERJA DENGAN SLIDE SHOW ...............................340
Memulai Presentasi ..................................................................................340
Menampilkan Slide Yang Dipilih ..........................................................342
BAB 11 KEAMANAN PRESENTASI ......................................................345
Mengunci Presentasi ................................................................................345
Menghilangkan Penguncian Presentasi ............................................352
BAB 12 MEMBAGI DAN MENCETAK PRESENTASI ........................356
Berbagi Presentasi Dengan OneDrive ................................................356
Mencetak Presentasi ................................................................................363
Pengaturan Percetakan .............................................................................363
Daftar Pustaka ..............................................................................................368
Profil Penulis ..................................................................................................369




PANDUAN LENGKAP MICROSOFT ACCESS



DAFTAR ISI




Kata Sambutan .........................................................................................
Kata Pengantar .........................................................................................
Daftar Isi ....................................................................................................

BAB 1 PENGENALAN MICROSOFT ACCESS .................................1
Sejarah Microsoft Access ........................................................................2
Versi Microsoft Access ............................................................................3
Penggunaan Microsoft Access ................................................................4
Fitur Microsoft Access .............................................................................5
Pengembangan dengan Access ...............................................................7
Yang Baru Di Microsoft Access 2016 ....................................................7
BAB 2 PENGENALAN DATABASE ..................................................10
Database .................................................................................................10
Mengenal Database ................................................................................10
Tahapan Perancangan Database ..............................................................12
Bahasa Yang Digunakan Database .........................................................13
Perangkat Lunak Database .....................................................................13
Mengenal Database dalam Access .........................................................13
Struktur Database Access .......................................................................15
File Database Access .............................................................................15
Tabel & Hubungan Database Access .....................................................15
Query Database Access ..........................................................................16
Formulir Database Access ......................................................................17
Laporan Database Access .......................................................................17
Dasar-dasar Desain Database Access .....................................................18
BAB 3 PENGENALAN TOOLS ACCESS 2016 ..................................23
Membuka Aplikasi Access 2016 .............................................................23
Mengenal Tools Access 2016 ..................................................................27
Mengenal Tab Ribbon Access 2016 ........................................................31
File .......................................................................................................... 31
Home ...................................................................................................... 33
Create ...................................................................................................... 39
External Data .......................................................................................... 42
Database Tools ........................................................................................ 45
Fields ....................................................................................................... 49
Table ....................................................................................................... 53
BAB 4 MEMULAI DENGAN ACCESS ..............................................56
Membuat Database Baru ........................................................................56
Membuat Database Dengan Template ..................................................58
Mengenal Panel Navigasi ......................................................................61
Menyimpan Database .............................................................................62
Membuka File Database ........................................................................63
Menutup Aplikasi Access ......................................................................65
Pintasan Tombol Keyboard Yang Umum ............................................67
BAB 5 DESAIN TABEL .......................................................................69
Apa Itu Tabel? ........................................................................................69
Membuat Tabel Baru .............................................................................70
Menetapkan Primery Key ......................................................................78
Menyimpan Tabel ..................................................................................79
Menutup Tabel .......................................................................................80
Mengedit Nama Tabel ............................................................................81
Menyalin Tabel ......................................................................................83
Menghapus Tabel ...................................................................................86
Mencetak Tabel ......................................................................................87
BAB 6 BEKERJA DENGAN FIELD & RECORD ..............................90
Field........................................................................................................90
Menambah Field Baru ............................................................................90
Menyembunyikan Dan Menampilkan Field ..........................................93
Menyalin Data Field Ke Dalam Tabel Lain ...........................................95
Memindahkan Letak Field .....................................................................98
Menyisipkan Field .................................................................................99
Mengedit Nama Field ...........................................................................100
Menghapus Field ..................................................................................102
Mengubah Tampilan Field ..................................................................103
Mengubah Lebar Kolom ......................................................................103
Mengubah Tinggi Baris .......................................................................105
Mengubah Font & Ukuran Teks ..........................................................108
Memasukkan Data Berjenis Hyperlink ................................................111
Menggunakan Fasilitas Lookup Wizard ..............................................114
Mengubah Tipe Data ............................................................................118
Record...................................................................................................120
Memasukkan Data Record ...................................................................120
Mengedit Data Record ..........................................................................121
Menghapus Data Record .......................................................................122
Menghapus Baris Record ......................................................................124
Memindahkan Petunjuk Record ............................................................125
Menemukan & Me-Replace Data .........................................................127
Men-Sorter Data Dalam Tabel .............................................................129
BAB 7 RELASI (RELATIONSHIP) ANTAR TABEL .......................132
Apa Itu Relasi? .....................................................................................132
Jenis-jenis Relasi Antar Tabel .............................................................133
Menetapkan Relasi Antar Tabel ...........................................................135
Mengedit Relasi Antar Tabel ...............................................................138
Menghapus Relasi Antar Tabel ............................................................140
Mencetak Relasi Antar Tabel ...............................................................141
BAB 8 MENGGUNAKAN QUERY ...................................................144
Pengenalan Query ................................................................................144
Membuat Query ...................................................................................147
Membuat Query Dengan Wizard ..........................................................147
Membuat Query Dengan Design ...........................................................151
Mengelola Query ...................................................................................153
Membuka Query ....................................................................................153
Mengedit Query .....................................................................................154
Menyisipkan Kolom Query ..................................................................155
Menghapus Kolom Query ....................................................................157
Menyembunyikan Field Query ............................................................159
Memindahkan Posisi Field Query ........................................................161
Mengurutkan Data Di Dalam Query ....................................................163



Menampilkan Data Dalam Query .....................................................164
Menampilkan Query Dengan SQL View ..........................................165
Menampilkan Sebagian Data Query .................................................166
Menampilkan Data Dengan Kriteria ..................................................167
Menampilkan Data Dengan Kriteria Diawali Operator ……............169
Menampilkan Data Dengan Kriteria Wildcard ..................................171
Menampilkan Data Lebih Dari Satu Kriteria .....................................174
Menggunakan Query Action ...............................................................176
Membuat Tabel Dengan Make Table Query ......................................176
Menambah Data Dengan Append Query ............................................179
Mengubah Nama Query ......................................................................181
Mencetak Query ..................................................................................183
Menghapus Query ...............................................................................184
BAB 9 MEMBUAT FORM .................................................................186
Apa Itu Form? .....................................................................................186
Membuat Form ....................................................................................186
Membuat Form Dengan Tombol Form ...............................................187
Membuat Form Dengan Wizard ..........................................................188
Membuat Form Dengan Wizard Dari Beberapa Tabel ........................191
Membuat Form Dengan Design ...........................................................196
Membuat Form Dengan Multiple Item ................................................199
Membuat Form Dengan Datasheet ......................................................201
Membuat Form Dengan Split Form ....................................................202
Membuat Form Dengan Modal Dialog ...............................................204
Membuat Form Kosong (Blank) .........................................................206
Membuat Subform Ke Dalam Form ...................................................207
Mengedit Form ...................................................................................208
Mengatur Ukuran Objek Field & Label ..............................................208
Menghapus Objek Field & Label .......................................................210
Mengatur Format Objek Field & Label ...............................................211
Memasukkan Logo ..............................................................................213
Memasukkan Judul Form .....................................................................215
Membuat Line & Rectangle .................................................................216
Memasukkan Tanggal & Waktu ..........................................................219
Memasukkan Gambar Background .....................................................221
Menutup & Menyimpan Form .............................................................223
Mengubah Nama Form ........................................................................225
Menghapus Form .................................................................................227
Mencetak Form ....................................................................................229
BAB 10 MEMBUAT KONTROL FORM ..........................................231
Membuat Label & Text Box Unbound ................................................231
Membuat Option & Toggle Button ......................................................233
Membuat Option Group .......................................................................236
Membuat List .......................................................................................240
Membuat Combo Box ..........................................................................246
Membuat Hyperlink .............................................................................251
Membuat Kontrol Image ......................................................................253
Membuat Kontrol Web Browser ..........................................................255
Membuat Kontrol Tab ..........................................................................257
Membuat Tombol Perintah (Command) .............................................259
BAB 11 MEMBUAT REPORT ..........................................................266
Apa Itu Report? ....................................................................................266
Membuat Report ..................................................................................266
Membuat Report Dengan Tombol Report ....................................266
Membuat Report Dengan Wizard .................................................268
Membuat Report Dengan Wizard Dari Beberapa Tabel …...........272
Membuat Report Dengan Design .................................................275
Membuat Blank Report .................................................................276
Modifikasi Rancangan Report .......................................................277
Menambahkan Field Ke Dalam Report .........................................278
Mengatur Posisi & Ukuran Field Dalam Report ............................280
Membuat Label Di Dalam Report ..................................................284
Menyaring Data Pada Report .........................................................286
Mengurutkan Data Report ..............................................................288
Menempatkan Objek Di Dalam Report ..........................................290
Memasukkan Logo Atau Gambar ..................................................290
Mencetak Report ..................................................................................292
Menutup & Menyimpan Report ...........................................................293
BAB 12 MENGGUNAKAN MACRO ................................................296
Apa Itu Macro? ....................................................................................296
Membuat Macro Baru ..........................................................................296
Menjalankan Macro .............................................................................299
Mengedit Macro ...................................................................................300
Membuat Group Macro ........................................................................302
BAB 13 IMPORT DAN EKSPORT DATA ........................................305
Meng-Import Data Dari Luar ................................................................305
Meng-Import Data Dari Excel ...............................................................309
Meng-Eksport Data Ke Dalam Excel ....................................................316
Meng-Eksport Data Ke Dalam Format Lain ........................................318
BAB 14 PEMELIHARAAN DATABASE .........................................320
Membuat Password Database ..............................................................320
Compact & Repair Database ................................................................324
Mem-Backup Database ........................................................................325
Daftar Pustaka .......................................................................................329








BELAJAR TUNTAS RUMUS DAN FUNGSI MICROSOFT EXCEL


Daftar Isi


 DafTar  Isi

Kata Sambutan .........................................................................
Kata Pengantar .........................................................................
Daftar Isi ................................................................................
BAB 1 PENGENALAN EXCEL ............................................................... 1
1.1. Excel .......................................................................................................1
1.2. Apa Yang Baru Di Excel? ...............................................................2
1.3. Membuka Excel .................................................................................3
1.4. Workbook ............................................................................................6
1.5. Worksheet ..........................................................................................7
1.6. Sel ...........................................................................................................7
BAB 2 PENGENALAN RUMUS (FORMULAS) ....................... 9
2.1. Apa Itu Formula? ....................................................................9
2.2. Operator Formula ................................................................10
2.2.1. Operator Aritmatika ........................................................10
2.2.2. Operator Perbandingan ..................................................11
2.2.3. Operator Teks ....................................................................11
2.2.4. Operator Referensi .........................................................12
2.3. Penggunaan Formula ........................................................12
2.3.1. Referensi Sel Relatif ................................................................14
2.3.2. Referensi Sel Semi Absolut ....................................................16
2.3.3. Referensi Sel Absolut ..............................................................18
2.4. Mengedit Formula ........................................................................20
2.5. Menghapus Formula ...................................................................22
2.6. Pesan Kesalahan Formula ........................................................23
2.7. Formula Array ...................................................................................24
2.7.1. Mengapa Menggunakan Rumus Array? ..............................24
2.7.2. Sintak Rumus Array ....................................................................25
2.7.3. Memasukkan Rumus Array ...................................................25
2.7.4. Membuat Rumus Array Sel Tunggal ....................................26
2.7.5. Membuat Rumus Array Multi Sel .........................................28
2.8. Konstanta Array ..............................................................................31
2.8.1. Membuat Konstanta Satu Dimensi ......................................32
2.8.2. Membuat Konstanta Dua Dimensi .......................................34
2.8.3. Menggunakan Konstanta Dalam Rumus .............................36
2.9. Kelemahan Rumus Array ...............................................................38
BAB 3 PENGENALAN FUNGSI (FUNCTIONS) .............................. 39
3.1. Apa Itu Fungsi? ................................................................................39
3.2. Argumen Dalam Fungsi ....................................................................40
3.3. Penggunaan Fungsi ..........................................................................41
3.4. Fungsi AutoSum ..............................................................................45
3.5. Fungsi Financial ................................................................................45
3.6. Fungsi Logical ..................................................................................45
3.7. Fungsi Text .......................................................................................46
3.8. Fungsi Date & Time ...........................................................................46
3.9. Fungsi Lookup & Reference ..............................................................46
3.10. Fungsi Math & Trig ............................................................................46
3.11. Fungsi Statistical .................................................................................47
3.12. Fungsi Engineering ............................................................................47
3.13. Fungsi Information ............................................................................47
3.14. Fungsi Web .........................................................................................47
BAB 4 FUNGSI AUTOSUM ................................................................ 48
4.1. Fungsi Sum ..........................................................................................48
4.2. Fungsi Average ....................................................................................51
4.3. Fungsi Max ..........................................................................................54
4.4. Fungsi Min ..........................................................................................56
BAB 5 FUNGSI KEUANGAN (FINANCIAL) ..................................... 60
5.1. Fungsi Accrint .....................................................................................60
5.2. Fungsi Accrintm .................................................................................63
5.3. Fungsi Amordegrc ..............................................................................65
5.4. Fungsi Amorlinc .................................................................................66
5.5. Fungsi Coupdaybs ..............................................................................67
5.6. Fungsi Coupdays ................................................................................69
5.7. Fungsi Coupdaysnc ............................................................................71
5.8. Fungsi Coupncd ..................................................................................72
5.9. Fungsi Coupnum ................................................................................74
5.10. Fungsi Couppcd ..................................................................................76
5.11. Fungsi Cumipmt .................................................................................77
5.12. Fungsi Cumprinc ................................................................................79
5.13. Fungsi Db ............................................................................................81
5.14. Fungsi Ddb ..........................................................................................82
5.15. Fungsi Disc ..........................................................................................83
5.16. Fungsi Dollarde ..................................................................................85
5.17. Fungsi Dollarfr ....................................................................................86
5.18. Fungsi Duration ..................................................................................87
5.19. Fungsi Effect ........................................................................................89
5.20. Fungsi Fv .............................................................................................90
5.21. Fungsi Fvschedule ..............................................................................92
5.22. Fungsi Intrate ......................................................................................93
5.23. Fungsi Ipmt .........................................................................................95
5.24. Fungsi Irr .............................................................................................96
5.25. Fungsi Ispmt .......................................................................................98
5.26. Fungsi Mduration ...............................................................................99
5.27. Fungsi Mirr .........................................................................................101
5.28. Fungsi Nominal ..................................................................................103
5.29. Fungsi Nper .........................................................................................104
5.30. Fungsi Npv ..........................................................................................105
5.31. Fungsi Oddfprice ................................................................................107
5.32. Fungsi Oddfyield ................................................................................109
5.33. Fungsi Oddlprice ................................................................................111
5.34. Fungsi Oddlyield ................................................................................113
5.35. Fungsi Pduration ................................................................................115
5.36. Fungsi Pmt ..........................................................................................116
5.37. Fungsi Ppmt ........................................................................................118
5.38. Fungsi Price .........................................................................................119
5.39. Fungsi Pricedisc ..................................................................................121
5.40. Fungsi Pricemat ..................................................................................123
5.41. Fungsi Pv .............................................................................................125
5.42. Fungsi Rate ..........................................................................................127
5.43. Fungsi Received ..................................................................................128
5.44. Fungsi Rri ............................................................................................130
5.45. Fungsi Sln ............................................................................................131
5.46. Fungsi Syd ...........................................................................................132
5.47. Fungsi Tbilleq .....................................................................................133
5.48. Fungsi Tbillprice .................................................................................135
5.49. Fungsi Tbillyield .................................................................................136
5.50. Fungsi Vdb ..........................................................................................137
5.51. Fungsi Xirr ...........................................................................................139
5.52. Fungsi Xnpv ........................................................................................141
5.53. Fungsi Yield .........................................................................................143
5.54. Fungsi Yielddisc ..................................................................................145
5.55. Fungsi Yieldmat ..................................................................................147
BAB 6 FUNGSI LOGIKA (LOGICAL) ................................................ 149
6.1. Fungsi And ..........................................................................................149
6.2. Fungsi False .........................................................................................151
6.3. Fungsi If ...............................................................................................152
6.4. Fungsi Iferror ......................................................................................153
6.5. Fungsi Ifna ...........................................................................................154
6.6. Fungsi Not ...........................................................................................155
6.7. Fungsi Or .............................................................................................156
6.8. Fungsi True .........................................................................................157
6.9. Fungsi Xor ...........................................................................................158
BAB 7 FUNGSI TEKS (TEXT) ............................................................ 160
7.1. Fungsi Asc ...........................................................................................160
7.2. Fungsi Bahttext ...................................................................................161
7.3. Fungsi Char .........................................................................................162
7.4. Fungsi Clean ........................................................................................163
7.5. Fungsi Code .........................................................................................164
7.6. Fungsi Concatenate ............................................................................165
7.7. Fungsi Dollar .......................................................................................166
7.8. Fungsi Exact ........................................................................................167
7.9. Fungsi Find ..........................................................................................168
7.10. Fungsi Fixed ........................................................................................170
7.11. Fungsi Left ...........................................................................................171
7.12. Fungsi Len ...........................................................................................172
7.13. Fungsi Lower .......................................................................................173
7.14. Fungsi Mid ..........................................................................................174
7.15. Fungsi Numbervalue ..........................................................................175
7.16. Fungsi Proper ......................................................................................177
7.17. Fungsi Replace ....................................................................................178
7.18. Fungsi Rept ..........................................................................................179
7.19. Fungsi Right ........................................................................................180
7.20. Fungsi Search ......................................................................................181
7.21. Fungsi Substitute ................................................................................183
7.22. Fungsi T ...............................................................................................184
7.23. Fungsi Text ..........................................................................................185
7.24. Fungsi Trim .........................................................................................187
7.25. Fungsi Unichar ...................................................................................188
7.26. Fungsi Unicode ...................................................................................189
7.27. Fungsi Upper .......................................................................................190
7.28. Fungsi Value ........................................................................................191
BAB 8 FUNGSI TANGGAL & WAKTU (DATE & TIME) ................ 193
8.1. Fungsi Date ..........................................................................................193
8.2. Fungsi Datedif .....................................................................................195
8.2. Fungsi Datevalue ................................................................................197
8.3. Fungsi Day ...........................................................................................198
8.4. Fungsi Days .........................................................................................199
8.5. Fungsi Days360 ...................................................................................201
8.6. Fungsi Edate ........................................................................................202
8.7. Fungsi Eomonth .................................................................................203
8.8. Fungsi Hour ........................................................................................205
8.9. Fungsi Isoweeknum ...........................................................................206
8.10. Fungsi Minute .....................................................................................207
8.11. Fungsi Month ......................................................................................208
8.12. Fungsi Networkdays ..........................................................................209
8.13. Fungsi Networkdays.intl ...................................................................211
8.14. Fungsi Now .........................................................................................213
8.15. Fungsi Second .....................................................................................214
8.16. Fungsi Time ........................................................................................215
8.17. Fungsi Timevalue ...............................................................................217
8.18. Fungsi Today .......................................................................................218
8.19. Fungsi Weekday .................................................................................219
8.20. Fungsi Weeknum ...............................................................................221
8.21. Fungsi Workday .................................................................................223
8.22. Fungsi Workday.intl ..........................................................................224
8.23. Fungsi Year ..........................................................................................227
8.24. Fungsi Yearfrac ...................................................................................228
BAB 9 FUNGSI LOOKUP & REFERENSI (REFERENCES) ............... 231
9.1. Fungsi Address ....................................................................................231
9.2. Fungsi Areas ........................................................................................233
9.3. Fungsi Choose .....................................................................................234
9.4. Fungsi Column ...................................................................................235
9.5. Fungsi Columns ..................................................................................236
9.6. Fungsi Formulatext ............................................................................237
9.7. Fungsi Hlookup ..................................................................................239
9.8. Fungsi Hyperlink ................................................................................241
9.9. Fungsi Index ........................................................................................242
9.10. Fungsi Indirect ....................................................................................246
9.11. Fungsi Lookup ....................................................................................247
9.12. Fungsi Match ......................................................................................249
9.13. Fungsi Offset .......................................................................................251
9.14. Fungsi Row ..........................................................................................253
9.15. Fungsi Rows ........................................................................................254
9.16. Fungsi Transpose ................................................................................255
9.17. Fungsi Vlookup ..................................................................................256
BAB 10 FUNGSI MATEMATIKA & TRIGONOMETRI (MATH &
TRIG) ...................................................................................... 259
10.1. Fungsi Abs .........................................................................................259
10.2. Fungsi Acos .......................................................................................260
10.3. Fungsi Acosh .....................................................................................261
10.4. Fungsi Acot .......................................................................................262
10.5. Fungsi Acoth .....................................................................................263
10.6. Fungsi Aggregate ..............................................................................264
10.7. Fungsi Arabic ....................................................................................268
10.8. Fungsi Asin ........................................................................................270
10.9. Fungsi Asinh .....................................................................................271
10.10. Fungsi Atan .......................................................................................271
10.11. Fungsi Atan2 .....................................................................................272
10.12. Fungsi Atanh .....................................................................................274
10.13. Fungsi Base ........................................................................................275
10.14. Fungsi Ceiling ...................................................................................277
10.15. Fungsi Ceiling.math .........................................................................278
10.16. Fungsi Ceiling.precise ......................................................................280
10.17. Fungsi Combin .................................................................................281
10.18. Fungsi Combina ...............................................................................282
10.19. Fungsi Cos .........................................................................................284
10.20. Fungsi Cosh .......................................................................................285
10.21. Fungsi Cot .........................................................................................286
10.22. Fungsi Coth .......................................................................................287
10.23. Fungsi Csc .........................................................................................288
10.24. Fungsi Csch .......................................................................................289
10.25. Fungsi Decimal .................................................................................290
10.26. Fungsi Degrees ..................................................................................291
10.27. Fungsi Even .......................................................................................292
10.28. Fungsi Exp .........................................................................................293
10.29. Fungsi Fact ........................................................................................294
10.30. Fungsi Factdouble ............................................................................295
10.31. Fungsi Floor ......................................................................................296
10.32. Fungsi Floor.math ............................................................................298
10.33. Fungsi Floor.precise .........................................................................299





10.34. Fungsi Gcd ........................................................................................301
10.35. Fungsi Int ..........................................................................................302
10.36. Fungsi Iso.ceiling ..............................................................................303
10.37. Fungsi Lcm ........................................................................................304
10.38. Fungsi Ln ...........................................................................................305
10.39. Fungsi Log .........................................................................................306
10.40. Fungsi Log10 .....................................................................................307
10.41. Fungsi Mdeterm ...............................................................................308
10.42. Fungsi Minverse ...............................................................................309
10.43. Fungsi Mmult ...................................................................................311
10.44. Fungsi Mod .......................................................................................312
10.45. Fungsi Mround .................................................................................314
10.46. Fungsi Multinomial .........................................................................315
10.47. Fungsi Munit .....................................................................................316
10.48. Fungsi Odd ........................................................................................317
10.49. Fungsi Pi ............................................................................................318
10.50. Fungsi Power .....................................................................................319
10.51. Fungsi Product ..................................................................................320
10.52. Fungsi Quotient ................................................................................321
10.53. Fungsi Radians ..................................................................................322
10.54. Fungsi Rand ......................................................................................323
10.55. Fungsi Randbetween ........................................................................324
10.56. Fungsi Roman ...................................................................................325
10.57. Fungsi Round ....................................................................................326
10.58. Fungsi Rounddown ..........................................................................328
10.59. Fungsi Roundup ...............................................................................329
10.60. Fungsi Sec ..........................................................................................330
10.61. Fungsi Sech ........................................................................................331
10.62. Fungsi Seriessum ..............................................................................332
10.63. Fungsi Sign ........................................................................................334
10.64. Fungsi Sin ..........................................................................................334
10.65. Fungsi Sinh ........................................................................................335
10.66. Fungsi Sqrt ........................................................................................336
10.67. Fungsi Sqrtpi .....................................................................................337
10.68. Fungsi Subtotal .................................................................................338
10.69. Fungsi Sumif .....................................................................................340
10.70. Fungsi Sumifs ....................................................................................342
10.71. Fungsi Sumproduct ..........................................................................344
10.72. Fungsi Sumsq ....................................................................................345
10.73. Fungsi Sumx2my2 ............................................................................346
10.74. Fungsi Sumx2py2 .............................................................................348
10.75. Fungsi Sumxmy2 ..............................................................................349
10.76. Fungsi Tan .........................................................................................350
10.77. Fungsi Tanh ......................................................................................351
10.78. Fungsi Trunc .....................................................................................352
BAB 11 FUNGSI STATISTIK (STATISTICAL) .................................. 354
11.1. Fungsi Avedev ...................................................................................354
11.2. Fungsi Averagea ................................................................................355
11.3. Fungsi Averageif ...............................................................................357
11.4. Fungsi Averageifs .............................................................................359
11.5. Fungsi Beta.dist .................................................................................361
11.6. Fungsi Beta.inv ..................................................................................362
11.7. Fungsi Binom.dist ............................................................................364
11.8. Fungsi Binom.dist.range ..................................................................365
11.9. Fungsi Binom.inv .............................................................................367
11.10. Fungsi Chisq.dist ..............................................................................368
11.11. Fungsi Chisq.dist.rt ..........................................................................370
11.12. Fungsi Chisq.inv ...............................................................................371
11.13. Fungsi Chisq.inv.rt ...........................................................................372
11.14. Fungsi Chisq.test ..............................................................................373
11.15. Fungsi Cofidence.norm ...................................................................374
11.16. Fungsi Confidence.t .........................................................................376
11.17. Fungsi Correl ....................................................................................377
11.18. Fungsi Count .....................................................................................379
11.19. Fungsi Counta ...................................................................................380
11.20. Fungsi Countblank ...........................................................................381
11.21. Fungsi Countif ..................................................................................382
11.22. Fungsi Countifs ................................................................................383
11.23. Fungsi Covariance.p ........................................................................384
11.24. Fungsi Covariance.s .........................................................................386
11.25. Fungsi Devsq .....................................................................................387
11.26. Fungsi Expon.dist .............................................................................388
11.27. Fungsi F.dist ......................................................................................389
11.28. Fungsi F.dist.rt ..................................................................................391
11.29. Fungsi F.inv .......................................................................................392
11.30. Fungsi F.inv.rt ...................................................................................393
11.31. Fungsi F.test ......................................................................................395
11.32. Fungsi Fisher .....................................................................................396
11.33. Fungsi Fisherinv ...............................................................................397
11.34. Fungsi Forecast.ets ...........................................................................398
11.35. Fungsi Forecast.ets.confint .............................................................400
11.36. Fungsi Forecast.ets.seasonality .......................................................401
11.37. Fungsi Forecast.ets.stat ....................................................................402
11.38. Fungsi Forecast.linear ......................................................................404
11.39. Fungsi Frequency .............................................................................405
11.40. Fungsi Gamma ..................................................................................406
11.41. Fungsi Gamma.dist ..........................................................................407
11.42. Fungsi Gamma.inv ...........................................................................408
11.43. Fungsi Gammaln ..............................................................................410
11.44. Fungsi Gammaln.precise .................................................................411
11.45. Fungsi Gauss .....................................................................................412
11.46. Fungsi Geomean ...............................................................................413
11.47. Fungsi Growth ..................................................................................414
11.48. Fungsi Harmean ...............................................................................416
11.49. Fungsi Hypgeom.dist .......................................................................418
11.50. Fungsi Intercept ................................................................................419
11.51. Fungsi Kurt .......................................................................................421
11.52. Fungsi Large ......................................................................................422
11.53. Fungsi Linest .....................................................................................424
11.54. Fungsi Logest ....................................................................................422
11.55. Fungsi Lognorm.dist ........................................................................423
11.56. Fungsi Lognorm.inv .........................................................................424
11.57. Fungsi Maxa ......................................................................................425
11.58. Fungsi Median ..................................................................................427
11.59. Fungsi Mina ......................................................................................428
11.60. Fungsi Mode.mult ............................................................................430
11.61. Fungsi Mode.sngl .............................................................................431
11.62. Fungsi Negbinom.dist ......................................................................433
11.63. Fungsi Norm.dist ..............................................................................434
11.64. Fungsi Norm.inv ..............................................................................436
11.65. Fungsi Norm.s.dist ...........................................................................437
11.66. Fungsi Norm.s.inv ............................................................................438
11.67. Fungsi Pearson ..................................................................................439
11.68. Fungsi Percentile.exc .......................................................................441
11.69. Fungsi Percentile.inc ........................................................................442
11.70. Fungsi Percentrank.exc ...................................................................443
11.71. Fungsi Percentrank.inc ....................................................................445
11.72. Fungsi Permut ...................................................................................446
11.73. Fungsi Permutationa ........................................................................447
11.74. Fungsi Phi ..........................................................................................448
11.75. Fungsi Poisson.dist ...........................................................................449
11.76. Fungsi Prob .......................................................................................451
11.77. Fungsi Quartile.exc ..........................................................................452
11.78. Fungsi Quartile.inc ...........................................................................454
11.79. Fungsi Rank.avg ................................................................................455
11.80. Fungsi Rank.eq .................................................................................457
11.81. Fungsi Rsq .........................................................................................458
11.82. Fungsi Skew .......................................................................................460
11.83. Fungsi Skew.p ...................................................................................461
11.84. Fungsi Slope ......................................................................................463
11.85. Fungsi Small ......................................................................................464
11.86. Fungsi Standardize ...........................................................................465
11.87. Fungsi Stdev.p ...................................................................................466
11.88. Fungsi Stdev.s ...................................................................................468
11.89. Fungsi Stdeva ....................................................................................470
11.90. Fungsi Stdevpa ..................................................................................471
11.91. Fungsi Steyx ......................................................................................473
11.92. Fungsi T.dist ......................................................................................474
11.93. Fungsi T.dist.2t .................................................................................476
11.94. Fungsi T.dist.rt ..................................................................................477
11.95. Fungsi T.inv ......................................................................................478
11.96. Fungsi T.inv.2t ..................................................................................479
11.97. Fungsi T.test ......................................................................................481
11.98. Fungsi Trend .....................................................................................483
11.99. Fungsi Trimmean .............................................................................485
11.100. Fungsi Var.p ....................................................................................486
11.101. Fungsi Var.s ....................................................................................491
11.102. Fungsi Vara .....................................................................................492
11.103. Fungsi Varpa ...................................................................................494
11.104. Fungsi Weibull.dist ........................................................................495
11.105. Fungsi Z.test ....................................................................................497
BAB 12 FUNGSI TEKNIK (ENGINEERING) ...................................... 500
12.1. Fungsi Besseli ....................................................................................500
12.2. Fungsi Besselj ....................................................................................501
12.3. Fungsi Besselk ...................................................................................502
12.4. Fungsi Bessely ...................................................................................503
12.5. Fungsi Bin2dec ..................................................................................505
12.6. Fungsi Bin2hex .................................................................................506
12.7. Fungsi Bin2oct ..................................................................................507
12.8. Fungsi Bitand ....................................................................................509
12.9. Fungsi Bitlshift ..................................................................................510
12.10. Fungsi Bitor .......................................................................................512
12.11. Fungsi Bitrshift .................................................................................513
12.12. Fungsi Bitxor .....................................................................................514
12.13. Fungsi Complex ................................................................................516
12.14. Fungsi Convert .................................................................................517
12.15. Fungsi Dec2bin .................................................................................519
12.16. Fungsi Dec2hex ................................................................................520
12.17. Fungsi Dec2oct .................................................................................521
12.18. Fungsi Delta ......................................................................................523
12.19. Fungsi Erf ..........................................................................................524
12.20. Fungsi Erf.precise .............................................................................525
12.21. Fungsi Erfc ........................................................................................525
12.22. Fungsi Erfc.precise ...........................................................................526
12.23. Fungsi Gestep ....................................................................................527
12.24. Fungsi Hex2bin .................................................................................528
12.25. Fungsi Hex2dec ................................................................................530
12.26. Fungsi Hex2oct .................................................................................531
12.27. Fungsi Imabs .....................................................................................532
12.28. Fungsi Imaginary ..............................................................................533
12.29. Fungsi Imargument ..........................................................................534
12.30. Fungsi Imconjugate ..........................................................................535
12.31. Fungsi Imcos .....................................................................................536
12.32. Fungsi Imcosh ...................................................................................537
12.33. Fungsi Imcot .....................................................................................538
12.34. Fungsi Imcsc .....................................................................................539
12.35. Fungsi Imcsch ...................................................................................541
12.36. Fungsi Imdiv .....................................................................................542
12.37. Fungsi Imexp ....................................................................................543
12.38. Fungsi Imln .......................................................................................543
12.39. Fungsi Imlog10 .................................................................................544
12.40. Fungsi Imlog2 ...................................................................................545
12.41. Fungsi Impower ................................................................................546
12.42. Fungsi Improduct .............................................................................547
12.43. Fungsi Imreal ....................................................................................548
12.44. Fungsi Imsec .....................................................................................549
12.45. Fungsi Imsech ...................................................................................550
12.46. Fungsi Imsin .....................................................................................551
12.47. Fungsi Imsinh ...................................................................................552
12.48. Fungsi Imsqrt ....................................................................................553
12.49. Fungsi Imsub ....................................................................................554
12.50. Fungsi Imsum ...................................................................................555
12.51. Fungsi Imtan .....................................................................................556
12.52. Fungsi Oct2bin .................................................................................557
12.53. Fungsi Oct2dec .................................................................................559
12.54. Fungsi Oct2hex .................................................................................560
BAB 14 FUNGSI INFORMASI (INFORMATION) ............................. 562
14.1. Fungsi Cell .........................................................................................562
14.2. Fungsi Error.type ..............................................................................564
14.3. Fungsi Info ........................................................................................565
14.4. Fungsi Isblank ...................................................................................566
14.5. Fungsi Iserr ........................................................................................567
14.6. Fungsi Iserror ....................................................................................569
14.7. Fungsi Iseven .....................................................................................570
14.8. Fungsi Isformula ...............................................................................571
14.9. Fungsi Islogical .................................................................................572
14.10. Fungsi Isna ........................................................................................573
14.11. Fungsi Isnontext ...............................................................................574
14.12. Fungsi Isnumber ...............................................................................575
14.13. Fungsi Isodd ......................................................................................576
14.14. Fungsi Isref ........................................................................................577
14.15. Fungsi Istext ......................................................................................578
14.16. Fungsi N ............................................................................................580
14.17. Fungsi Na ...........................................................................................581
14.18. Fungsi Sheet ......................................................................................582
14.19. Fungsi Sheets .....................................................................................583
14.20. Fungsi Type .......................................................................................584
BAB 16 FUNGSI JARINGAN (WEB) .................................................. 587
16.1. Fungsi Encodeurl ..............................................................................587
16.2. Fungsi Filterxml ................................................................................588
16.3. Fungsi Webservice ...........................................................................589
Penutup .............................................................................................................592
Daftar Pustaka ..................................................................................................593
Profil Penulis ....................................................................................................594






No comments:

Post a Comment