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.

MAU BELI SERIAL LENGKAPNYA DISINI

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

KALAU MAU BELI DISINI

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

KALAU MAU BELI SILAHKAN DISINI