Buku Latihan PENGOLAH ANGKA: Microsoft EXCEL 2007

Ebook ini merupakan terbitan dari WEBMEDIA Training Center, yang mana penggunanaannya dapat diunduh (download), lalu diterjemahkan, digunakan, dimodifikasi dan disebarkan secara bebas untuk tujuan bukan komersial (nonprofit), dengan syarat tidak menghapus atau merubah pernyataan copyright yang disertakan dalam setiap dokumen. Selain itu, menurut aturan dari Penerbit Ebook ini, tidak diperbolehkan melakukan penulisan ulang, kecuali mendapatkan ijin terlebih dahulu dari Webmedia Training Center.

Buku inilah yang juga saya gunakan sebagai referensi mengajar di kelas KKPI. Untuk itu, kepada seluruh siswa yang saya ajar, silahkan download materi-materi dalam ebook ini.

Download disini

Sebelum download, silahkan lihat daftar isi dari Ebook dibawah ini

Daftar Isi

Pendahuluan

Bab 1. Mengenal Microsoft Excel 2007

Menjalankan Microsoft Excel 2007 ........................................................................ 2

Pengenalan Interface/Tampilan Excel 2007 ............................................................ 2

Mengaktifkan Menu–Menu Pada Microsoft Excel 2007 ......................................... 4

Membuat Dokumen Baru Dalam Microsoft Excel 2007 .......................................... 6

Menyimpan Dokumen Kerja ..................................................................................... 8

Menutup Dokumen Kerja .......................................................................................... 9

Tugas Bab 1 .............................................................................................................. 10



Bab 2. Bekerja Dengan Microsoft Excel

Mengenal Workbook dan Worksheet ......................................................................... 11

Mengenal & Membuat Range ......................................................................................13

Memasukkan Data ke Dalam Sel ................................................................................. 14

Fasilitas AutoFill .......................................................................................................... 14

Pengenalan Kursor Excel ............................................................................................... 17

Memindahkan Isi Sel .................................................................................................. 18

Kursor Untuk Menggandakan ..................................................................................... 18

Mengatur Lebar Kolom..............................................................................................19

Mengatur tinggi baris ................................................................................................ 20

Tugas Bab 2 ............................................................................................................ 21



Bab 3. Mengatur Workbook & Worksheet

Memindahkan Isi Worksheet ..................................................................................... 22

Menggandakan Isi Worksheet ....................................................................................... 22

Menyisipkan Sel Baru ................................................................................................... 23

Menyisipkan Kolom Baru............................................................................................ 24

Menyisipkan Baris Baru .................................................................................................. 25

Mengubah Isi Sel .................................................................................................... 25

Menghapus Isi workbook .............................................................................................. 26

Mengubah Isi Sel .......................................................................................................... 26

Menampilkan Kembali Kolom Yang Tersembunyi ........................................................ 27

Menyembunyikan Baris ............................................................................................ 27

Menampilkan Kembali Baris Yang Tersembunyi ......................................................... 28

Menyembunyikan Worksheet .................................................................................. 28

Menampilkan Kembali Baris Yang Tersembunyi ........................................................ 29

Menyisipkan kolom baru .............................................................................................. 30

Menyisipkan baris baru ............................................................................................. 31

Menambah data .......................................................................................................... 32

Tugas Bab 3 ............................................................................................................. 33



Bab 4. Mengatur Tampilan Lembar Kerja

Memilih Jenis dan Ukuran Huruf ............................................................................ 34

Mengatur format font ................................................................................................ 35

Mengatur Alignment ................................................................................................ 36

Menambah Garis Tebal .................................................................................................. 38

Mengatur Shading ....................................................................................................... 40

Mengatur Tampilan Tanggal dan Waktu ................................................................ 41

Mengatur format angka .............................................................................................. 43

Tugas Bab 5 .......................................................................................................... 45



Bab 5. Rumus dan Fungsi

Operasi Penjumlahan ................................................................................................. 46

Operasi Pengurangan ............................................................................................ 47

Operasi Perkalian....................................................................................................... 47

Operasi pembagian ................................................................................................. 48

Penggabungan Operasi Aritmatika ............................................................................. 49

Operasi Aritmatika Lanjut ....................................................................................... 50

Tugas Bab 5 ....................................................................................................... 51



Bab 6. Menggunakan Fungsi Dasar

Alamat Relatif, Absolut dan Semiabsolut ................................................................ 53

Memahami penggunaan fungsi dasar ....................................................................... 54

Tugas Bab 6 .......................................................................................................56



Bab 7. Menggunakan Fungsi Lanjutan

Menggunakan Operator Dan Ekspresi Logika ............................................................. 58

Menggunakan Fungsi Logika If. .................................................................................... 59

Tugas Bab 7 ......................................................................................................... 64



Bab 8. Menyisipkan Objek

Menyisipkan Gambar dari ClipArt ........................................................................... 62

Menyisipkan Gambar dari File .................................................................................. 63

Menyisipkan Gambar Autoshapes .......................................................................... 64

Menyisipkan Gambar Wordart .................................................................................. 65

Tugas Bab 8 .......................................................................................................... 67



Bab 9. Bekerja dengan Diagram dan Grafik

Membuat Diagram dan Grafik ................................................................................... 69

Memilih Jenis Grafik .................................................................................................. 70

Memberi Judul Grafik ............................................................................................... 71

Mengatur Tampilan Grafik .................................................................................. 72

Mengatur Tampilan Garis Grid ................................................................................... 73

Mengatur Posisi Legend .............................................................................................. 77

Data Label ................................................................................................................ 79

Menyertakan Data Table di Grafik Pada Table Grafik .............................................. 79

Tugas Bab 9 ........................................................................................................ 81



Bab 10. Mengurutkan Data

Mengurutkan data ................................................................................................ 82

Tugas Bab 10 ........................................................................................................... 84

Bab 11. Pengaturan Halaman

Pengaturan Halaman .................................................................................................. 85

Bab 12. Pencetakan Dokumen Kerja

Pencetakan Berkas Pada Excel 2007 .......................................................................... 90