[Ebook] Microsoft word dan excel Untuk Penulisan Karya Ilmiah (Skripsi)

[Ebook] Microsoft word dan excel Untuk Penulisan Karya Ilmiah (Skripsi)

Deskripsi

Buku Microsoft Word dan Excel untuk Penulisan Karya Ilmiah (Skripsi) merupakan buku yang dirancang untuk membantu mahasiswa menyelesaikan segala persoalan ketika mengerjakan tulisan karya ilmiah berupa skripsi maupun tugas-tugas makalah. Selama ini banyak persoalan yang kerap dialami mahasiswa dalam menyelesaikan skripsi maupun makalah. Di antaranya permasalahan tidak sesuai format, tidak mencantumkan sumber, permasalahan citation, permasalahan membuat daftar isi, membuat referensi (daftar pustaka), dan persoalan lain.  Adapun keunggulan buku ini, yakni: (1) Cara mudah membuat daftar isi; (2) Pengaturan nomor halaman berbeda untuk tulisan karya ilmiah (skripsi) dan tugas makalah menggunakan section break; (3) Menambah sumber referensi dan membuat daftar pustaka dengan sistem APA; dan (4) Memahami fungsi matematika dan fungsi statistik di Microsoft Excel.

Buku ini sangat tepat membantu mahasiswa dalam menemukan berbagai jawaban dari berbagai persoalan penulisan karya ilmiah seperti penulisan skripsi ataupun tugas-tugas mahasiswa. Buku ini juga membahas tentang sistem penghitungan matematika dan statistik yang dapat digunakan dalam menyelesaikan persoalan penilaian di Microsoft Excel.

Informasi Tambahan

Cetakan

1

Halaman

174

ISBN

978-623-218-259-2

Pengarang

Muhammad Arifin, M.Pd. Isna Ardilla, S.E., M.Si. Ismail Saleh Nasution, M.Pd.

Tahun Terbit

September 2019

Ukuran

15 x 22

 

Daftar Isi vii
Bab 1 PENDAHULUAN 1
Bab 2 ATURAN PENULISAN KARYA ILMIAH 3
2.1 Susunan Penulisan Karya Ilmiah ..........................................................................................3
2.2 Pengetikan .................................................................................................................................5
Bab 3 MEMULAI DAN MENGENAL WORD 2013 7
3.1 Memulai Microsoft Word 2013...............................................................................................7
3.2 Mengenal Tampilan Baru Microsoft Word 2013................................................................8
3.3 Tampilan Lembar Kerja Microsoft Word 2013...................................................................8
3.4 Membuat dan Membuka Dokumen Baru............................................................................10
3.5 Membuka File Dokumen.........................................................................................................10
3.6 Menyimpan Dokumen ............................................................................................................10
3.7 Menutup Microsoft Word 2013.............................................................................................11
3.8 Mengubah Fitur Melalui Options...........................................................................................11
3.9. Menyimpan File Selain di Folder My Documents .............................................................13
3.10 Mengganti Satuan Inches ke Centimeter...........................................................................15
3.11 Memunculkan Garis Margin...................................................................................................15
Bab 4 MENGEDIT TEKS 19
4.1 Mencari dan Mengganti Teks................................................................................................19
4.2 Menuju Bagian Tertentu.........................................................................................................21
4.3 Memperbanyak dan Memindahkan Teks........................................................................... 22
4.4 Mem-Paste Menggunakan Tombol Insert......................................................................... 23
Bab 5 MEMFORMAT DOKUMEN 25
5.1 Mengatur Tipe Huruf (Font) ..................................................................................................25
5.2 Mengubah Font Secara Default............................................................................................27
5.3 Memformat Paragraf............................................................................................................. 28
5.4 Mengatur Perataan Teks dalam Paragraf......................................................................... 29
5.5 Mengatur Indentasi................................................................................................................. 30
5.6 Mengatur Tabulasi (Tab Stop)...............................................................................................31
5.7 Cara Membuat Daftar Isi Menggunakan Tabulasi........................................................... 32
5.8 Menggunakan Drop Cap.........................................................................................................35
5.9 Membuat Border and Shading (Bingkai Halaman)...........................................................35
5.10 Membuat Cover di Halaman Pertama ................................................................................37
5.11 Membuat Bullets and Numbering.........................................................................................41
5.12 Membuat Halaman Cover...................................................................................................... 42
Bab 6 MEMBUAT FORMAT KOLOM 45
Bab 7 MENYISIP SIMBOL, EQUAT ION, CLIP ART, SHAPE, DAN WordArt 49
7.1 Simbol....................................................................................................................................... 49
7.2 Equation.....................................................................................................................................51
7.3 Clip Art/Gambar.......................................................................................................................52
7.4 Menyisip Shape.........................................................................................................................53
7.5 Menyisip WordArt....................................................................................................................55
Bab 8 MEMBUAT TA BEL 57
8.1 Menambah Kolom dan Baris ................................................................................................ 58
8.2 Menghapus Kolom, Baris, Sel dan Tabel............................................................................ 59
8.3 Mengatur Lebar Kolom dan Baris........................................................................................ 59
8.4 Memecah atau Membagi Sel ...............................................................................................60
8.5 Menggabung Kolom dan Baris.............................................................................................60
8.6 Memecah atau Membagi Tabel.............................................................................................61
8.7 Mengatur Perataan Teks pada Sel Tabel............................................................................61
8.8 Hal Baru Pengaturan Tabel di Microsoft Word 2013......................................................61
Bab 9 KONFIGURASI HALAMAN 65
9.1 Pengaturan Kertas.................................................................................................................. 65
9.2 Pengaturan Margin dan Orientasi Kertas...........................................................................67
9.3 Menempatkan Nomor Halaman........................................................................................... 69
9.4 Membuat Header dan Footer.................................................................................................70
9.5 Membuat Kop Surat ................................................................................................................70
9.6 Mengatur Halaman dengan Breaks.....................................................................................72
9.7 Mengatur Orientasi Berbeda dalam Satu Dokumen ....................................................... 77
9.8 Mengatur Nomor Halaman Berbeda (Atas, Bawah) ........................................................79
Bab 10 MENAMBAH SUMBER REFERENSI DAN MEMBUAT DAFTAR PUSTA KA 85
10.1 Sumber Referensi dari Buku .............................................................................................. 85
10.2 Sumber referensi dari Jurnal ................................................................................................87
10.3 Membuat Daftar Pustaka ..................................................................................................... 88
10.4 Membuat Footnote dan Endnote ......................................................................................... 89
Bab 11 MENJADIKAN DOKUMEN SEBAGA I FILE ARSIP/PDF 95
Bab 12 MENCETA K DOKUMEN 99
Bab 13 MENGENAL MICROSOFT EXCEL 2013 103
13.1 Memulai Microsoft Excel 2013.......................................................................................... 103
13.2 Worksheet..............................................................................................................................104
13.3 Mengganti Nama Sheet dan Memberi Warna Sheet..................................................... 105
13.4 Memindahkan, Menggandakan dan Menghapus Sheet ............................................... 105
13.5 kolom ..................................................................................................................................... 105
13.6 Mengatur Lebar Kolom........................................................................................................106
13.7 Menyisip atau Menambah Kolom.......................................................................................107
13.8 Menghapus Kolom..................................................................................................................107
13.9 Baris.........................................................................................................................................107
13.10 Mengatur Tinggi Baris..........................................................................................................107
13.11 Menyisip atau Menambah Baris........................................................................................108
13.12 Menghapus Baris...................................................................................................................108
13.13 Sel (Cell).................................................................................................................................109
13.14 Range.......................................................................................................................................110
13.15 Memperbaiki Salah Pengetikan..........................................................................................110
13.16 Mengedit Data.........................................................................................................................111
Bab 14 FORMAT DATA 113
14.1 Membuat Nomor Urut...........................................................................................................113
14.2 Format 0 (nol) di Depan Angka...........................................................................................114
13.3 Format Mata Uang.................................................................................................................115
13.4 Membuat Format Satuan......................................................................................................116
13.5 Format Perataan Teks ...........................................................................................................117
14.6 Format Huruf...........................................................................................................................117
14.7 Format Bingkai dan Fill.........................................................................................................118
Bab 15 MENGUNAKAN FORMULA 121
15.1 Formula....................................................................................................................................121
15.2 Sel Absolut............................................................................................................................. 122
Bab 16 MENGUNAKAN FUNGSI STAT ISTIK 125
16.1 Fungsi Statistik...................................................................................................................... 125
Bab 17 FUNGSI LOGICAL DAN FUNGSI LOOKUP 131
17.1 Fungsi Logika.........................................................................................................................131
17.2 Fungsi IF ................................................................................................................................ 132
17.3 Fungsi IF dengan Dua Tes Logika...................................................................................... 133
17.4 Fungsi LOOKUP..................................................................................................................... 134
17.5 Fungsi VLOOKUP................................................................................................................... 134
17.6 Fungsi HLOOKUP...................................................................................................................137
Bab 18 GRAFIK 143
Bab 19 MENCETAK DATA 147
19.1 Mengatur Area dan Urutan Cetak......................................................................................147
19.2 Melihat Tampilan Lembar Kerja Sebelum Dicetak ....................................................... 149
19.3 Mencetak Lembar Kerja ..................................................................................................... 150
Bab 20 PENUTUP 153
DAFTAR PUSTA KA 155
Lampiran-Lamipran 157
para PENULIS 163

© 2017 , Design by Kodeforest