Kamis, 13 November 2014

116 STRATEGI KUASAI EXCEL 2007, 2010, 2013 + CD TUTORIAL

Insya Allah terbit Tanggal 17 November 2014
Tunggu terbitnya di GRAMEDIA seluruh Indonesia

Daftar Isi


Kata Pengantar............................................................................................................ i
Daftar Isi..................................................................................................................... iii
BAB 1.  8 Strategi Membuat Links....................................................................... 1
Strategi 1. Membuat Links Antar Folder............................................................... 1
Strategi 2. Membuat Links Antar Dokument/File................................................ 5
Strategi 3. Membuat Links Antar Cells.................................................................. 7
Strategi 4. Membuat Links Antar Sheet dan Cells............................................. 10
Strategi 5. Membuat Links dengan objeck Shapes........................................... 14
Strategi 6. Membuat Links Antar Sheet.............................................................. 18
Strategi 7. Dengan Linked Picture di Excel 2010 & 2013................................ 21
Strategi 8. Membuat Links Cells ke Gambar...................................................... 23
BAB 2. 6 Strategi Menyimpan  & Memprotect  Dokumen di Excel.......... 25
Strategi 9. Menyimpan Dokumen dengan Format PDF di Excel 2010 & 2013 25
Strategi 10. Menyimpan Dokumen agar terbaca semua versi Excel............. 27
Strategi 11. Mengunci Dokumen dengan Mark As Final................................. 29
Strategi 12. Mengunci dengan Encrypt With Password.................................... 34
Strategi 13Mengunci dengan Protect Current Sheet........................................ 38
Strategi 14. Mengunci dengan Protect Workbook Structure............................ 42
BAB 3. 93 Strategi Memahami Dasar Excel................................................... 44
Strategi 15. Copy dan Paste................................................................................... 44
Strategi 16. Cut dan Paste...................................................................................... 46
Strategi 17. Format Painter.................................................................................... 47
Strategi 18. Font ...................................................................................................... 49
Strategi 19. Font Size............................................................................................... 50
Strategi 20. Increase Font Size.............................................................................. 51
Strategi 21. Decrease Font Size............................................................................. 52
Strategi 22. Bold....................................................................................................... 53
Strategi 23. Italic...................................................................................................... 54
Strategi 24. Underline.............................................................................................. 55
Strategi 25. Bottom Borders.................................................................................. 56
Strategi 26. Menampilkan Border dan Menghapus Border pada Cells......... 58
Strategi 27. Fill Color............................................................................................... 59
Strategi 28. Font Color............................................................................................ 60
Strategi 29. Top Align.............................................................................................. 61
Strategi 30. Middle Align........................................................................................ 62
Strategi 31. Bottom Align....................................................................................... 63
Strategi 32. Orientation........................................................................................... 64
Strategi 33. Wrap Text............................................................................................ 65
Strategi 34. Align Left............................................................................................. 65
Strategi 35. Center................................................................................................... 66
Strategi 36. Align Right........................................................................................... 67
Strategi 37. Increase Indent................................................................................... 67
Strategi 38. Decrease Indent.................................................................................. 68
Strategi 39. Merge & Center................................................................................... 69
Strategi 40. Number Format ................................................................................. 71
Strategi 41. Menyamakan jumlah digit angka.................................................. 72
Strategi 42. Accounting Number Format............................................................. 75
Strategi 43. Comma Style...................................................................................... 77
Strategi 44. Increase Decimal................................................................................ 78
Strategi 45. Decrease Decimal............................................................................... 79
Strategi 46. Highlight Cells Rules.......................................................................... 80
Strategi 47. Top/Bottom Rules.............................................................................. 84
Strategi 48. Data Bars............................................................................................. 86
Strategi 49. Colors Scale......................................................................................... 87
Strategi 50. Icon Sets............................................................................................... 88
Strategi 51. Clear Rules........................................................................................... 89
Strategi 52. Insert..................................................................................................... 90
Strategi 53. Insert Sheet Rows............................................................................... 91
Strategi 54. Insert Sheet Columns......................................................................... 92
Strategi 55. Insert Sheet.......................................................................................... 93
Strategi 56. Delete Sheet Rows ............................................................................. 94
Strategi 57. Delete Sheet Columns........................................................................ 95
Strategi 58. Delete Sheet......................................................................................... 96
Strategi 59. Format.................................................................................................. 97
Strategi 60. Mengatur lebar baris (ROW)............................................................ 98
Strategi 61. Auto SUM.......................................................................................... 100
Strategi 62. Fill........................................................................................................ 101
Strategi 63. Clears.................................................................................................. 102
Strategi 64. Sort  and Filter................................................................................... 103
Strategi 65. Find and Select................................................................................. 104
Strategi 66. Pivot Table........................................................................................ 106
Strategi 67. Picture................................................................................................. 108
Strategi 68. Online Picture di Excel 2010 & 2013............................................ 109
Strategi 69. Shapes................................................................................................ 114
Strategi 70. SmartArt............................................................................................ 116
Strategi 71. Screenshot di Excel 2010 & 2013................................................. 118
Strategi 72. Insert Column Chart........................................................................ 120
Strategi 73. Insert Bar Chart................................................................................ 121
Strategi 74. Insert stock, Surface or Radar Chart............................................ 122
Strategi 75. PivotChart......................................................................................... 123
Strategi 76. Margins.............................................................................................. 125
Strategi 77. Orientation......................................................................................... 127
Strategi 78. Size...................................................................................................... 128
Strategi 79. Breaks................................................................................................ 129
Strategi 80. Background....................................................................................... 131
Strategi 81. Print Area........................................................................................... 132
Strategi 82. Print Titles.......................................................................................... 136
Strategi 83. Scale................................................................................................... 138
Strategi 84. Gridlines............................................................................................. 139
Strategi 85. Headings............................................................................................ 140
Strategi 86. Bring Forward................................................................................... 141
Strategi 87.  Send Backward............................................................................... 143
Strategi 88.  Selection Pane.................................................................................. 145
Strategi 89.  Align................................................................................................... 146
Strategi 90.  Group................................................................................................. 148
Strategi 91.  Rotate................................................................................................ 149
Strategi 92.  From Access..................................................................................... 150
Strategi 93.  Existing Connections...................................................................... 153
Strategi 94.  Sort..................................................................................................... 156
Strategi 95.  Text to Columns.............................................................................. 158
Strategi 96.  Remove Duplicates......................................................................... 161
Strategi 97.  Sel Validation................................................................................... 164
Strategi 98.  Group................................................................................................. 166
Strategi 99.  Paste Comments............................................................................. 167
Strategi 100. New Comment dan Delete Comment........................................ 169
Strategi 101. Memasukan gambar pada Comment....................................... 171
Strategi 102. Normal dan Page Layout............................................................. 176
Strategi 103. Page Break Preview....................................................................... 177
Strategi 104. Formula Bar.................................................................................... 178
Strategi 105. Headings.......................................................................................... 179
Strategi 106. Gridlines........................................................................................... 180
Strategi 107. Menggunakan Freeze Panes........................................................ 181
BAB 4. 9 Strategi Penggunaan Logika IF, VLOOKUP & HLOOKUP.. 182
Strategi 108. IF dengan 1 Kriteria....................................................................... 182
Strategi 109. IF dengan 2 Kriteria....................................................................... 183
Strategi 110. IF dengan 3 Kriteria....................................................................... 184
Strategi 111. IF dengan 4 Kriteria....................................................................... 185
Strategi 112. IF dengan 5 Kriteria....................................................................... 186
Strategi 113. IF dengan 6 Kriteria....................................................................... 187
Strategi 114. IF dengan 7 Kriteria....................................................................... 189
Strategi 115. IF dengan VLOOKUP................................................................... 190
Strategi 116. IF dengan HLOOKUP................................................................... 195

Tentang Penulis...................................................................................................... 205