tag:blogger.com,1999:blog-87284466224016481002024-02-07T19:29:31.358-08:00Data CeriaShare tutorial, panduan dan tips n trik manajemen dataAnonymoushttp://www.blogger.com/profile/05587361588861284376noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8728446622401648100.post-56623944349212605942012-04-21T06:42:00.000-07:002012-04-21T10:11:15.855-07:00PERBEDAAN DASAR MS. EXCEL 2003, 2007 DAN 2010<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXGYl8sbOQDvqIVOpLTCwmtmFdF13H88IYuE4Ywb8xjik3_wKBD8Y1r75ZRUtqat1LvQm882qbQ_yF5rxo7eHD0Ollo2-fAlWdVdJ3wed8gojFk1Tg9P40iXIH4afYZzVS759vMTcdXvON/s1600/perbedaan+excel+01.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXGYl8sbOQDvqIVOpLTCwmtmFdF13H88IYuE4Ywb8xjik3_wKBD8Y1r75ZRUtqat1LvQm882qbQ_yF5rxo7eHD0Ollo2-fAlWdVdJ3wed8gojFk1Tg9P40iXIH4afYZzVS759vMTcdXvON/s400/perbedaan+excel+01.png" width="400" /></a></div>
<div style="text-align: justify;">
Sepertinya baru kemaren kita mencoba Ms. Excel 2007 sebagai generasi penerus versi 2003, belum benar-benar memahami toolbar yang berubah 120°, eh.. tiba-tiba dah keluar lagi versi yang 2010. Capek deehh..</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Yah memang seperti itulah teknologi, selalu berkembang. Lagian pihak produsen (Microsoft Corporations) pasti terus mikir gimana cara menggaji karyawan-karyawannya, so kalau tidak membuat produk baru, gimana bisa menggaji karyawan, iya khan??</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Ok, kembali ke topik, kali ini kita akan mengkaji perubahan-perubahan apa aja yang ada pada Ms. Excel 2007 dan 2010. Namun kali ini, kita bahas yang ringan-ringan saja, supaya gak pusing..</div>
<div style="text-align: justify;">
<br />
Inilah beberapa perbedaan mendasar pada Excel 2003, 2007 dan 2010:</div>
<div style="text-align: justify;">
<br />
<ol>
<li><b><span style="font-size: small;">Tampilan Sub Menu dan Toolbars </span></b></li>
Pada Excel 2003 kita telah akrab dengan menu-menu File, Edit, View juga sub-sub menu-nya. Namun pada Excel 2007 dan 2010, menu-menu tersebut telah berubah. Bahkan nama "menu" pun sudah tidak dipakai lagi. "Menu" pada ms. excel 2007 dan 2010 biasa dinamai <b>Tab Ribbon</b>, karena interface-nya hampir sama dengan tab window pada aplikasi-aplikasi. Demikian juga sub-sub menu pada Excel 2003 tidak lagi dropdown pada versi 2007 dan 2010, namun berbentuk icon-icon seperti pada toolbars.
<br />
Icon-icon inilah yang disebut <b>Ribbon</b>. Dan kabar buruknya, kita tidak bisa menambah atau mengurangi icon-icon pada ribbon ini, kita hanya bisa menyembunyikan-nya.
<br />
Lantas bagaimana jika kita ingin menambah icon tertentu yang kebetulan tidak ditampilkan pada ribbon? seperti tombol Print Preview misalnya?
<br />
Jawab; kita memang tidak bisa mengutak-atik ribbon, namun kita tetap bisa menambahkan tombol tertentu pada interface Excel 2007 dan 2010 yakni pada Quick Access Toolbar, lihat pembahasannya <a href="http://dataceria.blogspot.com/2012/04/mengenal-quick-access-toolbar.html" target="_blank">di sini</a>.<br /><br />
<li><b><span style="font-size: small;">Jumlah Baris (Row)</span></b></li>
Pada Excel 2003 jumlah baris = 65.536 <br />
Pada Excel 2007 jumlah baris = 1.048.576 <br />
Pada Excel 2010 jumlah baris = 1.048.576 <br />
Kita dapat mengetahui jumlah baris tersebut dengan cara menekan CTRL+[panah bawah] <br /> <br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmQgW3kCRd5GdHDcxGkv1rGJVOmnfcsCQ35s_M4GHaR8zVJoaohknaS9LOtEPJroUox8TItX81wKbyckccZrq44hWd-ObylI82ExjQo_k5oL51oEHOa2RAGAr1DPBWqTywCLAJ8Uai7gJh/s1600/jumlah+baris.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmQgW3kCRd5GdHDcxGkv1rGJVOmnfcsCQ35s_M4GHaR8zVJoaohknaS9LOtEPJroUox8TItX81wKbyckccZrq44hWd-ObylI82ExjQo_k5oL51oEHOa2RAGAr1DPBWqTywCLAJ8Uai7gJh/s400/jumlah+baris.png" width="400" /></a></div>
<br /><br />
<li><b><span style="font-size: small;">Jumlah Kolom</span></b></li>
Pada Excel 2003 jumlah kolom = 256 <br />
Pada Excel 2007 jumlah kolom = 16.384 <br />
Pada Excel 2010 jumlah kolom = 16.384 <br />
Kita dapat mengetahui jumlah baris tersebut dengan cara: Sorot all dengan mouse salah satu baris dari kiri Ketik angka 1 pada keyboard Tekan CTRL+ENTER Lihat Jumlahnya pada status bar <br /><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTg9G-z9l0LwZaaNhcInVX1FBx1LlngEoxERZgBfnTp5RQ4xd11HzCcMMRxKYtpmyXqM5kyW62gKOfoPEW40K4hHEznPVLXQfW2l8rQc_1mkjHXQs7TxjiOiRLz7K6M1eh6vneQVMT-2Xw/s1600/jumlah+kolom.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTg9G-z9l0LwZaaNhcInVX1FBx1LlngEoxERZgBfnTp5RQ4xd11HzCcMMRxKYtpmyXqM5kyW62gKOfoPEW40K4hHEznPVLXQfW2l8rQc_1mkjHXQs7TxjiOiRLz7K6M1eh6vneQVMT-2Xw/s400/jumlah+kolom.png" width="400" /></a></div>
<br />
</ol>
</div>
Perbedaan lainnya silahkan lihat tabel berikut:<br />
(<i>maaf tidak menyertakan screen shot</i>)<br />
<br />
<br />
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: 4.65pt; width: 496px;">
<tbody>
<tr style="height: 15.0pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td nowrap="nowrap" style="border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" width="36"><div align="center" style="text-align: center;">
<b><span style="color: black; font-size: 11pt;">NO</span></b></div>
</td>
<td nowrap="nowrap" style="border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext 1.0pt; mso-border-left-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><div align="center" style="text-align: center;">
<b><span style="color: black; font-size: 11pt;">ITEM</span></b></div>
</td>
<td nowrap="nowrap" style="-moz-border-bottom-colors: none; -moz-border-image: none; -moz-border-left-colors: none; -moz-border-right-colors: none; -moz-border-top-colors: none; background: #B6D7A8; border-color: -moz-use-text-color; border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="center" style="text-align: center;">
<b><span style="color: black; font-size: 11pt;">Ms. Excel 2003</span></b></div>
</td>
<td nowrap="nowrap" style="-moz-border-bottom-colors: none; -moz-border-image: none; -moz-border-left-colors: none; -moz-border-right-colors: none; -moz-border-top-colors: none; background: #6FA8DC; border-color: -moz-use-text-color; border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" valign="bottom" width="127"><div align="center" style="text-align: center;">
<b><span style="color: black; font-size: 11pt;"> Ms. Excel 2007 / 2010 </span></b></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 1;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">1</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Kolom dalam 1 worksheet</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;"> 256 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">16.384 </span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 2;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">2</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Baris dalam 1 worksheet</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">65.536 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">1.048.576 </span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 3;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">3</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Batas maksimal panjang karakter <br />
dalam rumus</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">1.024 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">8.192 </span></div>
</td>
</tr>
<tr style="height: 28.5pt; mso-yfti-irow: 4;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 28.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">4</span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 28.5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah fields yg ditampilkan di <br />
PivotTable Field pada task pane</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 28.5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">255 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 28.5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">16.384 </span></div>
</td>
</tr>
<tr style="height: 15.75pt; mso-yfti-irow: 5;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.75pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">5</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah huruf yg di tampilkan di <br />
dalam 1 celll</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">1.024 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">32.768 </span></div>
</td>
</tr>
<tr style="height: 15.75pt; mso-yfti-irow: 6;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.75pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">6</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah item ditampilkan dalam <br />
list AutoFilter</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">1.024 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">32.768 </span></div>
</td>
</tr>
<tr style="height: 15.75pt; mso-yfti-irow: 7;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.75pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">7</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah kolom pada PivotTable</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">255 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">16.384 </span></div>
</td>
</tr>
<tr style="height: 25.5pt; mso-yfti-irow: 8;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 25.5pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">8</span></div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 25.5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah kondisi Conditional <br />
Formating dalam 1 cell</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 25.5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;"> 3 <br />
(kondisi standar) </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 25.5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;"> tergantung <br />
memory PC </span></div>
</td>
</tr>
<tr style="height: 15.75pt; mso-yfti-irow: 9;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.75pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">9</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah maksimal arguments <br />
dalam formula</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">30 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">255 </span></div>
</td>
</tr>
<tr style="height: 15.75pt; mso-yfti-irow: 10;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.75pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">10</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah pengulangan/looping <br />
pada rumus [=if(if(if…))..]</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">7 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">64 </span></div>
</td>
</tr>
<tr style="height: 15.75pt; mso-yfti-irow: 11;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.75pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">11</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah sorting levels pad range <br />
atau table</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">3 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">64 </span></div>
</td>
</tr>
<tr style="height: 15.75pt; mso-yfti-irow: 12;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.75pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">12</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Jumlah warna </span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">56 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;"> 4,3 milyar (billion) </span></div>
</td>
</tr>
<tr style="height: 15.75pt; mso-yfti-irow: 13; mso-yfti-lastrow: yes;">
<td nowrap="nowrap" style="border-top: none; border: solid windowtext 1.0pt; height: 15.75pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext 1.0pt; mso-border-top-alt: solid windowtext 1.0pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 27.3pt;" valign="top" width="36"><div align="center" style="text-align: center;">
<span style="color: black; font-size: 11pt;">13</span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 149.25pt;" width="199"><span style="color: #222222; font-size: 10pt;">Total number of unique cell styles <br />
in a workbook</span></td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 100.25pt;" width="134"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">4.000 </span></div>
</td>
<td nowrap="nowrap" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.75pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 95.05pt;" width="127"><div align="right" style="text-align: right;">
<span style="color: black; font-size: 11pt;">65.536 </span></div>
</td>
</tr>
</tbody></table>
</div>
<br />
<hr color="color:#000000:" size="5" />
<br />
Klik <b><a href="http://www.ziddu.com/download/19202247/PERBEDAANDASARMS.EXCEL20032007DAN2010.pdf.html" rel="nofollow" target="_blank">DOWNLOAD</a></b> untuk mengunduh tutorial ini dalam format PDF.<br />
Atau klik <a href="http://dataceria.blogspot.com/search/label/Download" target="_blank"><b>SINI</b></a> untuk mengunduh aplikasi/tutorial olah data lainnya.<br />
<br />
<hr color="color:#000000:" size="5" />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaIFf2O-RKqK68iXXPFI5cHja93jPNUxPRMDVcQQ2_1TQaL1B8Q4kWtQqWNPahWAi8YkhWiP9zpiLyIUhvwE8wAVDwUbF4zZjnJGWfetrm0Vz248yghS666nsOzG3-ztvOzpbCrCGqKXzD/s1600/oroginal+post.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaIFf2O-RKqK68iXXPFI5cHja93jPNUxPRMDVcQQ2_1TQaL1B8Q4kWtQqWNPahWAi8YkhWiP9zpiLyIUhvwE8wAVDwUbF4zZjnJGWfetrm0Vz248yghS666nsOzG3-ztvOzpbCrCGqKXzD/s1600/oroginal+post.png" /></a></div>
<blink><b>Original Posting</b></blink> by <a href="http://dataceria.blogspot.com/" target="_blank"><b>Data Ceria</b></a><br />
Dipersilahkan copas tutorial dengan menyertakan url dari kami <a href="http://dataceria.blogspot.com/">http://dataceria.blogspot.com</a>Anonymoushttp://www.blogger.com/profile/05587361588861284376noreply@blogger.com12Madiun, Indonesia-7.629714 111.513702-7.629714 111.513702 -7.629714 111.513702tag:blogger.com,1999:blog-8728446622401648100.post-88982360656008370892012-04-14T10:49:00.000-07:002012-04-14T10:49:25.033-07:00Download<iframe frameborder="0" height="300" src="https://docs.google.com/spreadsheet/pub?key=0AhQ9DgRtNePsdE15UzdtMEpmcEtQRWk4dXNEN1gxNXc&output=html&widget=true" width="500"></iframe>Anonymoushttp://www.blogger.com/profile/05587361588861284376noreply@blogger.com0tag:blogger.com,1999:blog-8728446622401648100.post-43711426466734326932012-04-14T10:27:00.010-07:002012-04-21T07:00:32.065-07:00Membuat Buku Dengan Ms. Word 2003, 2007 dan 2010<div style="text-align: justify;">
<b>Micrososft Word</b> adalah salah satu aplikasi pengolah kata yang paling populer dipakai oleh pengguna komputer. Hampir tidak ada pengguna komputer yang tidak mengenal aplikasi ini. Mengolah kata, termasuk di dalamnya adalah menulis naskah dan mencetaknya. Naskah yang kita cetak biasanya berwujud buku. Bisakah kita membuat buku dengan aplikasi ini? Mari kita simak ulasan di bawah..</div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: right; margin-left: 1em; text-align: right;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7CkkO5_S0Ax4pnedlNwgjeT9sEyXWxp8b23usLdWd2KqAiI_e6Y7MKcULWoV_PjM1tLjZyu8cN7xv9vghNE7CbgodJpOWCvqiIjbe_2HkHXHdrYuVnGc63UquLrT-KhTIwLNc4SxRjE_n/s1600/2003+page+setup.png" imageanchor="1" style="clear: right; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7CkkO5_S0Ax4pnedlNwgjeT9sEyXWxp8b23usLdWd2KqAiI_e6Y7MKcULWoV_PjM1tLjZyu8cN7xv9vghNE7CbgodJpOWCvqiIjbe_2HkHXHdrYuVnGc63UquLrT-KhTIwLNc4SxRjE_n/s200/2003+page+setup.png" width="200" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Menu File >> Page Setup</td></tr>
</tbody></table>
<ol>
<li>Buka Ms. Word Anda (boleh Ms. Word versi 2003, 2007 atau 2010)</li>
<li>Pada Ms. Word 2003, klik menu <span style="color: #741b47;">File </span>>> <span style="color: #741b47;">Page Setup</span></li>
<li>Pada Ms. Word 2007 dan 2010, klik <span style="color: #741b47;">Tab Ribbon Page Layout</span> >> <span style="color: #741b47;">Margin </span>>> <span style="color: #741b47;">Custom Margin</span></li>
<li>Setelah terbuka window Page Setup, klik tab <span style="color: #741b47;">Paper</span>, pada <span style="color: #741b47;">Paper Size</span>, tentukan ukuran kertas yang Anda kehendaki, bisa A4, Letter dan Folio. Untuk folio tidak ada pilihan di situ, pilih saja custom size, tuliskan manual Lebar: 33,02 cm, Tinggi: 21,59 cm</li>
<li>Klik tab <span style="color: #741b47;">Margins</span>, tentukan batas atas, bawah, kiri, kanan, dan gutter (batas penjilidan)</li>
<li>Pada <span style="color: #741b47;">Pages</span>, pilih <span style="color: #741b47;">Book Fold</span>, maka secara otomatis <span style="color: #741b47;">Orientation</span> akan berubah menjadi Landscape</li>
<li>Klik <span style="color: #741b47;">OK</span>, </li>
</ol>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_hyE8GQ11Hn2ZGpV0e95TXiYe4D3yzkrjcCyQz6wT-LfHXDKHJ2GfbA8jTmoz7PyPk4CWT-c1PoPf7BbV8INDZlGtV6258nbrlKmJaqgSLINgTMdGQg7AGClR9GTG6Rx1ASDXjKvuZhWl/s1600/2007+custom+margin.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh_hyE8GQ11Hn2ZGpV0e95TXiYe4D3yzkrjcCyQz6wT-LfHXDKHJ2GfbA8jTmoz7PyPk4CWT-c1PoPf7BbV8INDZlGtV6258nbrlKmJaqgSLINgTMdGQg7AGClR9GTG6Rx1ASDXjKvuZhWl/s320/2007+custom+margin.png" width="270" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Tab Ribbon Page Layout >> Customs Margin</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjW8kUSGOCti65yC8jImHWiefwLVg-xzK2n_PevAMXf-3Z93C7ME2gKE6sR9a7X3W5BQwKsylDHaQm4o23OvaKsqOLwfRbdkX80ABqATsKtJuBduxgbkHRAyOHf_EwfJ_po-NQ3u5i2pLZi/s1600/2007+book+fold.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjW8kUSGOCti65yC8jImHWiefwLVg-xzK2n_PevAMXf-3Z93C7ME2gKE6sR9a7X3W5BQwKsylDHaQm4o23OvaKsqOLwfRbdkX80ABqATsKtJuBduxgbkHRAyOHf_EwfJ_po-NQ3u5i2pLZi/s320/2007+book+fold.png" width="234" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Page Setup >> Book Fold</td></tr>
</tbody></table>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Sekarang saatnya anda mengetik dokumen Anda sampai selesai. jika sudah selesai, lakukan print/pencetakan dengan langkah sebagai berikut: </div>
<ul>
<li>Pada Ms. Word 2003, klik Menu <span style="color: #741b47;">File </span>>> <span style="color: #741b47;">Print</span>, atau tekan <span style="color: #741b47;">CTRL+P</span></li>
<li>Pada Ms. Word 2007, klik<span style="color: #741b47;"> Logo Office</span> (bulat pojok kiri atas), pilih <span style="color: #741b47;">Print</span>, atau tekan <span style="color: #741b47;">CTRL+</span>P</li>
<li>Pada Ms. Word 2010, klik <span style="color: #741b47;">Tab Ribbon File</span>, pilih <span style="color: #741b47;">Print</span>, atau tekan <span style="color: #741b47;">CTRL+P</span></li>
</ul>
<div style="text-align: justify;">
Jika window print sudah tampil, pada Ms. Word 2003 dan 2007 centang <span style="color: #741b47;">Manual Duplex</span>. Kemudian klik <span style="color: #741b47;">OK</span>, tunggu sampai anda disuruh membalik kertas, silahkan balik kertas yang telah tercetak sisi lainnya dan taruh dalam mesin printer lagi, klik <span style="color: #741b47;">OK</span>.</div>
<div style="text-align: justify;">
<br /></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-4o09IEAfPdhzEKf8OzfURn7W5JKGllJldlzxtFZwfKCwuHeBptuRkziYkjiJpYCXJ98kGsHzrt7yyBc3HyZ4_5U6wbFsgAeEx3Qu3gaMjlBmhMAnR_BCUFd0PKlK0ENGs3UgoRVgHio1/s1600/manual+duplex.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="100" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-4o09IEAfPdhzEKf8OzfURn7W5JKGllJldlzxtFZwfKCwuHeBptuRkziYkjiJpYCXJ98kGsHzrt7yyBc3HyZ4_5U6wbFsgAeEx3Qu3gaMjlBmhMAnR_BCUFd0PKlK0ENGs3UgoRVgHio1/s320/manual+duplex.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Centang Manual Duplex</td></tr>
</tbody></table>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Pada Ms. Word 2010, option <b>Manual Duplex</b> tidak ada, namun Anda dapat menyetingnya dengan memilih <b style="color: #741b47;">Print on Both Sides</b> pada Setting.</div>
<div style="text-align: justify;">
<br /></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO9EFSYNA7IVw25nZIvcyfEZwH3bJb7qSEMY9zKBWORT-dtyS3VeoP5kAPZIiRr0UIrk9f9mLMovF6mBVRaZkH1URTlAoSJ1SijNzvY-oOodFIX9YZmxYnKrDv7nJGgW7ylGIT8JfrnSol/s1600/print+on+both+side.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="309" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO9EFSYNA7IVw25nZIvcyfEZwH3bJb7qSEMY9zKBWORT-dtyS3VeoP5kAPZIiRr0UIrk9f9mLMovF6mBVRaZkH1URTlAoSJ1SijNzvY-oOodFIX9YZmxYnKrDv7nJGgW7ylGIT8JfrnSol/s320/print+on+both+side.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Print >> Setting >> Print on Both Sides</td></tr>
</tbody></table>
<div style="text-align: justify;">
Kemudian klik tombol <span style="color: #741b47;">Print </span>(bergambar printer). Tunggu hingga selesai mencetak sisi lain, kemudian balikkan kertas, dan klik <span style="color: #741b47;">OK </span>lagi.</div>
<div style="text-align: justify;">
<br />
<br />
<hr color="color:#000000:" size="5" />
<br />
Klik <b><a href="http://www.ziddu.com/download/19201180/Membuat_Buku_Dengan_MsWord_2003_2007_dan_2010.pdf.html" rel="nofollow" target="_blank">DOWNLOAD</a></b> untuk mengunduh tutorial ini dalam format PDF.<br />
Atau klik <a href="http://dataceria.blogspot.com/search/label/Download" target="_blank"><b>SINI</b></a> untuk mengunduh aplikasi/tutorial olah data lainnya.<br />
<br />
<hr color="color:#000000:" size="5" />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaIFf2O-RKqK68iXXPFI5cHja93jPNUxPRMDVcQQ2_1TQaL1B8Q4kWtQqWNPahWAi8YkhWiP9zpiLyIUhvwE8wAVDwUbF4zZjnJGWfetrm0Vz248yghS666nsOzG3-ztvOzpbCrCGqKXzD/s1600/oroginal+post.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaIFf2O-RKqK68iXXPFI5cHja93jPNUxPRMDVcQQ2_1TQaL1B8Q4kWtQqWNPahWAi8YkhWiP9zpiLyIUhvwE8wAVDwUbF4zZjnJGWfetrm0Vz248yghS666nsOzG3-ztvOzpbCrCGqKXzD/s1600/oroginal+post.png" /></a></div>
<blink><b>Original Posting</b></blink> by <a href="http://dataceria.blogspot.com/" target="_blank"><b>Data Ceria</b></a><br />
Dipersilahkan copas tutorial dengan menyertakan url dari kami <a href="http://dataceria.blogspot.com/">http://dataceria.blogspot.com</a></div>Anonymoushttp://www.blogger.com/profile/05587361588861284376noreply@blogger.com2Madiun, Indonesia-7.6297140000000008 111.51370199999997-7.6634790000000006 111.48309449999996 -7.595949000000001 111.54430949999997tag:blogger.com,1999:blog-8728446622401648100.post-54105892271673617972012-04-14T02:28:00.017-07:002012-04-21T06:59:49.137-07:00MENGENAL QUICK ACCESS TOOLBAR<div style="text-align: justify;">
Quick Access Toolbar (menu akses cepat) adalah group toolbar yang secara default terletak di atas Tab Ribbon. Toolbars ini tersedian pada Ms. Office versi 2007 dan 2010. Pada Quick Access tedapat 3 tombol utama, yakni save (simpan), Undo (batal), Redo (membatalkan Undo). Namun demikian, kita dapat memodifikasi Quick Access Toolbar, yakni dengan menambah atau mengurangi tombol dan memindah letaknya.</div>
<div style="text-align: justify;">
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn6xAjCXp8_-Izyfg9cbL4KN_mFI7fi2iV0hm7QfilhghIhkF3z8mTlkOPT0GXE0A9Bbvx19YcIdv1v00sBMcxqdVLKrUvh0QE4ttCMytz1h9mkBlBS1LITKb7udVhXTCjXlRELKTbg59o/s1600/quick+access.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn6xAjCXp8_-Izyfg9cbL4KN_mFI7fi2iV0hm7QfilhghIhkF3z8mTlkOPT0GXE0A9Bbvx19YcIdv1v00sBMcxqdVLKrUvh0QE4ttCMytz1h9mkBlBS1LITKb7udVhXTCjXlRELKTbg59o/s1600/quick+access.png" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Quick Access Toolbar pada Ms. Office 2007</td></tr>
</tbody></table>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgicLHkb3QBGQ3DbUozsWIrwYiH6Q0gWoW97I4DkVnM-5C4PKeDaV_U03FwZ3JAhJMsstLMp_07aJ4EX5mCk0Hy54ZjyA7iO-S_9YPpoKBJ2wDZy3dlkrpQENOclcmKR6WXkwbkoirPfQpJ/s1600/quick+2010.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgicLHkb3QBGQ3DbUozsWIrwYiH6Q0gWoW97I4DkVnM-5C4PKeDaV_U03FwZ3JAhJMsstLMp_07aJ4EX5mCk0Hy54ZjyA7iO-S_9YPpoKBJ2wDZy3dlkrpQENOclcmKR6WXkwbkoirPfQpJ/s1600/quick+2010.png" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container"><tbody>
<tr><td style="text-align: center;"><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container"><tbody>
<tr><td style="text-align: center;"></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Quick Access Toolbar pada Ms. Office 201<b>0</b></td></tr>
</tbody></table>
</td></tr>
</tbody></table>
</td></tr>
</tbody></table>
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: justify;">
<b>Menambah dan mengurangi tombol pada Quick Access Toolbar</b><br />
Cara 01<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2cJiXfYaw5VQLtA6otZz8Hjq5sFV30lW9X4TwTe8id929iU20GhzTmtSIgN4OUwd31Eoxaai_LxUvlLofngjLsQuBLloJLMFyqpfma9K-4SvsmQSEL6XAqlTi-7IJmN_r1Aws6gHAh-wK/s1600/quick+atas+klik+kanan.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="116" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2cJiXfYaw5VQLtA6otZz8Hjq5sFV30lW9X4TwTe8id929iU20GhzTmtSIgN4OUwd31Eoxaai_LxUvlLofngjLsQuBLloJLMFyqpfma9K-4SvsmQSEL6XAqlTi-7IJmN_r1Aws6gHAh-wK/s320/quick+atas+klik+kanan.png" width="320" /></a></div>
<ol>
<li>Klik kanan area <span style="color: #b45f06;">Quick Access</span></li>
<li>Pilih <span style="color: #b45f06;">Customize Quick Access Toolbar</span></li>
<li>Untuk menambah tombol, perhatikan kolom sebelah kiri (<span style="color: #b45f06;">choose command</span>), pilih tombol yang ingin anda tambahkan, kemudian klik <span style="color: #b45f06;">Add </span>diantara 2 kolom tersebut</li>
<li>Untuk mengurangi tombol, pilih tombol pada kolom sebelah kanan (<span style="color: #b45f06;">Customize Quick Access Toolbar</span>), kemudian klik <span style="color: #b45f06;">Remove </span>diantara 2 kolom tersebut</li>
<li>Demikian seterusnya</li>
</ol>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxfdpaW5_Maczyu0iGXJCzPv7smUoNjMuyq9WmuyOMvy-WONRJg8NdE77WTRO-nu5lCSiC421cYMeeCSEmrJPRbb2aTd8fUBW5xmayCunys2r_91FJNk5GE1J_T6OpLogrvNyJXeLSDeM9/s1600/cutomize.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxfdpaW5_Maczyu0iGXJCzPv7smUoNjMuyq9WmuyOMvy-WONRJg8NdE77WTRO-nu5lCSiC421cYMeeCSEmrJPRbb2aTd8fUBW5xmayCunys2r_91FJNk5GE1J_T6OpLogrvNyJXeLSDeM9/s320/cutomize.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVTg81ijP4O6V3nA4EfqUKDnD-F69qcK35MHQdYLLgV0gvb8ttjvKYojtOM2S9P3UqeGo2YWvw2y1v94GgIDubk8SUbJq5qHAB41iJI3uCQoE26m39UpbiA_hgo9xvy-BzLI48iONFl3c6/s1600/quick+atas+klik+kanan.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVTg81ijP4O6V3nA4EfqUKDnD-F69qcK35MHQdYLLgV0gvb8ttjvKYojtOM2S9P3UqeGo2YWvw2y1v94GgIDubk8SUbJq5qHAB41iJI3uCQoE26m39UpbiA_hgo9xvy-BzLI48iONFl3c6/s1600/quick+atas+klik+kanan.png" /></a><br />
Cara 02<br />
<ol>
<li>Klik kiri pada panah disebelah kanan Quick Access Toolbar</li>
<li>Maka akan terlihat deretan nama-nama tombol, anda tinggal centang tombol mana yang ingin anda tambahkan, atau menghilangkan centang jika ingin menghapus</li>
<li>Jika tombol tersebut kurang, anda dapat meng-klik <span style="color: #b45f06;">More Command</span>, maka akan tampil window seperti penjelasan Cara 01 di atas.</li>
</ol>
<br />
<br />
<br />
<br />
<b>Memindah Posisi Quick Access Toolbar</b><br />
Secara default, letak Quick Access Toolbar adalah di atas Ribbon, namun kita dapat memindahkannya di bawah Ribbon, caranya:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRwQy5KAEmUdPk-EoSIy43_9gpWcmUH44Ykw37aO74UPlKiYBcY0ppGVLXnVQVEyJ4dINGi8liaLvluI7x15SX-hkRNYGLBZdxt1tfOYFuTDFnEtb0xGdTXIJbaWywyBYh5Ie8D-XWeail/s1600/quick+bawah.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRwQy5KAEmUdPk-EoSIy43_9gpWcmUH44Ykw37aO74UPlKiYBcY0ppGVLXnVQVEyJ4dINGi8liaLvluI7x15SX-hkRNYGLBZdxt1tfOYFuTDFnEtb0xGdTXIJbaWywyBYh5Ie8D-XWeail/s1600/quick+bawah.png" /></a></div>
<br />
<br />
Cara 01<br />
<ol>
<li>Klik kanan area <span style="color: #b45f06;">Quick Access Toolbar</span></li>
<li>Pilih<span style="color: #b45f06;"> Show Quick Access Toolbar Below the Ribbon</span></li>
<li>Jika ingin memindah ke atas lagi, pilih S<span style="color: #b45f06;">how Quick Access Toolbar Above the Ribbon</span></li>
</ol>
<br />
Cara 02<br />
<ol>
<li>Klik panah disebelah kanan Quick Access Toolbar</li>
<li>Pilih <span style="color: #b45f06;">Show Below the Ribbon</span></li>
<li>Jika ingin memindah ke atas lagi, pilih <span style="color: #b45f06;">Show Above the Ribbon</span> </li>
</ol>
</div>
<br />
<br />
<hr color="color:#000000:" size="5" />
<br />
Klik <b><a href="http://www.ziddu.com/download/19201370/MENGENAL_QUICK_ACCESS_TOOLBAR.pdf.html" rel="nofollow" target="_blank">DOWNLOAD</a></b> untuk mengunduh tutorial ini dalam format PDF.<br />
Atau klik <a href="http://dataceria.blogspot.com/search/label/Download" target="_blank"><b>SINI</b></a> untuk mengunduh aplikasi/tutorial olah data lainnya.<br />
<br />
<hr color="color:#000000:" size="5" />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaIFf2O-RKqK68iXXPFI5cHja93jPNUxPRMDVcQQ2_1TQaL1B8Q4kWtQqWNPahWAi8YkhWiP9zpiLyIUhvwE8wAVDwUbF4zZjnJGWfetrm0Vz248yghS666nsOzG3-ztvOzpbCrCGqKXzD/s1600/oroginal+post.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaIFf2O-RKqK68iXXPFI5cHja93jPNUxPRMDVcQQ2_1TQaL1B8Q4kWtQqWNPahWAi8YkhWiP9zpiLyIUhvwE8wAVDwUbF4zZjnJGWfetrm0Vz248yghS666nsOzG3-ztvOzpbCrCGqKXzD/s1600/oroginal+post.png" /></a></div>
<blink><b>Original Posting</b></blink> by <a href="http://dataceria.blogspot.com/" target="_blank"><b>Data Ceria</b></a><br />
Dipersilahkan copas tutorial dengan menyertakan url dari kami <a href="http://dataceria.blogspot.com/">http://dataceria.blogspot.com</a>Anonymoushttp://www.blogger.com/profile/05587361588861284376noreply@blogger.com2Madiun, Indonesia-7.6297140000000008 111.51370199999997-7.6634790000000006 111.48309449999996 -7.595949000000001 111.54430949999997