Dengan semakin berkembangnya era teknologi pada zaman sekarang ini, kita
harus benar-benar sadar bahwa kita harus skill yang memadai dalam menggunakan komputer pada masa
sekarang ini. Maka, kali ini berkesempatan untuk memposting ebook dalam bentuk PDF yang mencakup:
|
|
Daftar Isi
|
|
Pendahuluan
|
|
Modul 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 Modul ……………………………………………………………...
|
10
|
Modul 2. Bekerja Dengan Microsoft
Excel
|
|
Mengenal Workbook dan Worksheet
....................................................
|
11
|
Mengenal
& Membuat Range ……………………………………………
|
13
|
Memasukan 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 Modul 2
....................................................................................
|
21
|
Modul 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 Modul 3
......................................................................................
|
33
|
Modul 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 Modul 5
.........................................................................................
|
45
|
Modul 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 Modul 5
..........................................................................................
|
51
|
Modul 6. Menggunakan Fungsi Dasar
|
|
Alamat Relatif, Absolut dan Semiabsolut
......................................................
|
53
|
Memahami penggunaan fungsi dasar
............................................................
|
54
|
Tugas Modul 6
...........................................................................................
|
56
|
Modul 7. Menggunakan Fungsi Lanjutan
|
|
Menggunakan Operator Dan Ekspresi Logika
............................................
|
58
|
Menggunakan Fungsi Logika If.
....................................................................
|
59
|
Tugas Modul 7
............................................................................................
|
64
|
Modul 8. Menyisipkan Objek
|
|
Menyisipkan Gambar dari ClipArt
.................................................................
|
62
|
Menyisipkan Gambar dari File
......................................................................
|
63
|
Menyisipkan Gambar Autoshapes
.................................................................
|
64
|
Menyisipkan Gambar Wordart
.....................................................................
|
65
|
Tugas Modul 8 ............................................................................................
|
67
|
Modul 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 Modul 9
......................................................................................
|
81
|