nurdin Or Id

Cara mudah mengatasi jika muncul pesan " "Windows Explorer Has Stopped Working"

<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Mungkin Anda pernah mengalami Ini ketika membuka Windows Explorer dan membuka folder tertentu muncul pesan "Windows Explorer Has Stopped Working<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">. Tentunya hal ini sangat mengganggu aktivitas Anda ketika berinteraksi dengan komputer. Berikut akan saya tuliskan tips atau cara mengatasi jika muncul pesan " "Windows Explorer Has Stopped Working" (jawaban resmi dari Microsoft) dengan melakukan scanning pada windows untuk merepair corrupted files atau missing files. Simak langkah langkah nya :</div>
<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; margin: 0px; outline: 0px; padding: 0px; text-align: center; vertical-align: baseline;">
 
<div style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<img height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-EV6eDf-Fumrab2giUQ_PwsVU8VQpWAhhHucAHxs02i0KTauskBqKkrPBtJlxhQ9bH_JXJFc3Dio29hRU68-3Ol6mgyQCy0wNYYSWXLQ_sGaWHk1t6Xzl5BOhO2Y_FR81VV11ZbMEO5Kb/s400/Widows+Explorer+Has+Stopped+Working.gif" style="-webkit-box-shadow: rgba(0, 0, 0, 0.498039) 1px 1px 5px; border: 1px solid rgb(65, 105, 225); box-shadow: rgba(0, 0, 0, 0.498039) 1px 1px 5px; font-family: 'Trebuchet MS', sans-serif; height: auto; margin: 5px 0px 0px; max-width: 100%; outline: 0px; overflow: hidden; padding: 6px; vertical-align: middle;" width="400" /></div>
</div>
<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; line-height: 16.100000381469727px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </div>
<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; line-height: 16.100000381469727px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
 </div>
<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; line-height: 16.100000381469727px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">1. Scanning Pada Windows</div>
<ol style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; line-height: 16.100000381469727px; margin: 0px 0px 0px 2em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Buka Command Prompt, dengan cara :<ol style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px 0px 0px 2em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">klik tombol Start - kemudian pilih Run - pada kotak textbox ketikkan cmd - kemudian klik tombol OK</li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Atau dengan cara klik Tombol Start-kemudian pilih Program - Acessories - Command Prompt</li>
</ol>
</li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Pada command prompt, aktifkan cursor pada drive C. Pada umumnya ketika Anda buka Command Prompt, Anda akan aktif di C:\Documents and Settings\User\. Nah, untuk mengaktifkan ke Drive C, cukup ketik cd\ kemudian tekan enter</li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Setelah aktif pada drive C, maka lanjutkan dengan mengetik sfc/scannowkemudian tekan enter. Perintah ini fungsinya untuk me-repair file System yang Missing atau Corrupt, proses scanningnya akan memakan waktu beberapa saat. Jika informasi dari Installasion CD diperlukan, maka masukkan CD Windows Installer. </li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Jika cara di atas tersebut belum berhasil,Anda ingat kembali pada saat Anda membuka folder/aplikasi apa sehingga pesan "Windows Explorer Has Stopping Worked"itu muncul?. Dan install kembalilah aplikasi tersebut</li>
</ol>
<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; line-height: 16.100000381469727px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> 2. Hapus Kunci String Dalam Registry</div>
<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; line-height: 16.100000381469727px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<ol style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px 0px 0px 2em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 18px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Klik di start dan cari pada menu search ketik regedit (atau pada menu RUN command klik "super+R")</li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 18px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Cari key ini " HKLM\Software\Microsoft\MClient\Windows\DisableSessions "</li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> Sekarang menghapus semua kunci string kecuali default dalam "DisableSessions"</li>
</ol>
</div>
<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; line-height: 18px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">3. Disabling CEIP</div>
<div style="background-color: white; border: 0px; color: #2c3e50; font-family: calibri; line-height: 16.100000381469727px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<ol style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px 0px 0px 2em; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 18px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> Klik di start dan cari pada menu search ketik "gpedit.msc"(atau pada menu RUN command klik "super+R)</li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 18px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><div style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Cari lokasi dibawah ini</div>
<div style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Computer Configuration => Administrative Templates => System => Internet Communication Management, and then Klik Internet Communication Setting</div>
</li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> Pada Lokasi Turn of Windows Customer Experience Improvement Progam, double klik atau klik kanan pilih edit</li>
<li style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Pilih enable, kemudian apply dan tutup menu gpedit</li>
</ol>
</div>
<div class="separator" style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; clear: both; line-height: 18px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">4. Install Ulang Komputer Anda</div>
<div class="separator" style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; clear: both; line-height: 18px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </div>
<div class="separator" style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; clear: both; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Jika cara - cara di atas tidak berhasil , maka cara yang paling ampuh adalah dengan cara Install Ulang Komputer anda . Maka semua masalah yang ada dalam komputer anda akan terselesaikan . Dan jika cara tersebut masih gagal juga , maka belilah komputer yang lebih bagus secara spesifikasinya .</div>
<div class="separator" style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; clear: both; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </div>
<div class="separator" style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; clear: both; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; font-family: 'Trebuchet MS', sans-serif; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Nah , sekian yang dapat saya berikan tentang <span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; text-align: left; vertical-align: baseline;">Kumpulan Cara Mengatasi " Windows Explorer Has Stopped Working " . Semoga cara-cara tersebut bermanfaat .Jangan lupa tinggalkan komentar + like fans page kami ya . <span style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; text-align: left; vertical-align: baseline;">Terima Kasih - <b style="background-color: transparent; background-position: initial initial; background-repeat: initial initial; border: 0px; line-height: 15px; margin: 0px; outline: 0px; padding: 0px; text-align: left; vertical-align: baseline;">Kumpulan Cara Mengatasi " Windows Explorer Has Stopped Working " Terlengkap</div>
</div>

Mungkin Anda pernah mengalami Ini ketika membuka Windows Explorer dan membuka folder tertentu muncul pesan " Windows Explorer Has Stop...

Cara Membuat Border ( Garis ) di microsoft office excel

Helo sobat nurdin Or Id , 
kali ini saya akan share cara membuat Garis Atau Border pada Microsoft office excel 
 
SS ( Screen Shot ) yang sudah jadi Border ( Garis ) 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhryxY48X8-WZChvTZw9Uk9MqgKyWZxARL8VpSagLaUvBllz1jOHjns_EXjoFBw5jmCHK8HdTEDYiZsT3XKATiBUNLOjLuWb5FRT6h76pnNpsx1urLqrhZP0fK_9HGjmqXh_50c2Ps2D6E/s1600/Screenshot_89.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhryxY48X8-WZChvTZw9Uk9MqgKyWZxARL8VpSagLaUvBllz1jOHjns_EXjoFBw5jmCHK8HdTEDYiZsT3XKATiBUNLOjLuWb5FRT6h76pnNpsx1urLqrhZP0fK_9HGjmqXh_50c2Ps2D6E/s1600/Screenshot_89.png" width="320" /></a></div>
pertama-tama sobat buka MS Excel 
1. Klik kanan pada sesuatu yang mau di bikin Border ( Garis ) 
2. Klik kanan 
  Nanti akan muncul seperti gambar di bawah ini 
 
    
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPiGfkmPLbp55Izl8CSfDoDHDoaBoTZTES1Gj-7TWeQ0VUzZNAPkiTGIJtiFKqUPFeUjFO84aIIg41yLn5yIa3wwSZS-Mdhpiq7nZXOG-WA302QkEkaw84rGX25HvbnE-HgmAbWuQma-w/s1600/Screenshot_87.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="262" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPiGfkmPLbp55Izl8CSfDoDHDoaBoTZTES1Gj-7TWeQ0VUzZNAPkiTGIJtiFKqUPFeUjFO84aIIg41yLn5yIa3wwSZS-Mdhpiq7nZXOG-WA302QkEkaw84rGX25HvbnE-HgmAbWuQma-w/s1600/Screenshot_87.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
   lalu sobat klik "Format Cell"</div>
<div class="separator" style="clear: both; text-align: left;">
     terus akan muncul seperti gambar di bawah ini</div>
<div class="separator" style="clear: both; text-align: left;">
  awalnya pasti ke Number sobat pilih "Border"</div>
<div class="separator" style="clear: both; text-align: left;">
  </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnZJgJ_LU6GwxYwAqf9c_SUeEiTcppTKLw0emhgAg8KzGNM2a5Dqcbbif3nxA2i6fR2KXuDAPV3RAQGLbepSZcu849hyphenhyphent3H5VB0PKfIaovONfZyqIEfWAJpHGAIHyYAa8nw9jzaG6wX68/s1600/Screenshot_88.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="289" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnZJgJ_LU6GwxYwAqf9c_SUeEiTcppTKLw0emhgAg8KzGNM2a5Dqcbbif3nxA2i6fR2KXuDAPV3RAQGLbepSZcu849hyphenhyphent3H5VB0PKfIaovONfZyqIEfWAJpHGAIHyYAa8nw9jzaG6wX68/s1600/Screenshot_88.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
terus sobat bikin Garisnya bisa langsung dengan klik "Outline" atau bikin sendiri , sobat bisa pilih Style Garisnya</div>
<div class="separator" style="clear: both; text-align: left;">
kemudian klik"OK"</div>
<div class="separator" style="clear: both; text-align: left;">
 </div>
<div class="separator" style="clear: both; text-align: left;">
Sekian dari saya</div>
<div class="separator" style="clear: both; text-align: left;">
see you again</div>

Helo sobat nurdin Or Id , kali ini saya akan share cara membuat Garis Atau Border pada Microsoft office excel SS ( Screen Shot ) yang sud...

Cara Membuat Nilai Total Di Microsoft Office Excel

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeOyQ7KpZUfHDKBGFkI2P6zFT4Z-fpjRNLS_PojFd9HYhRgdwtTIwhlnwEV0pPZVhPCSOJdf-n-r2r97oC4zD0ldJwsLkObjaNNw8a0_sHnt4viTcsNLVYriVmAlGWf_7ClQdlOibXtsw/s1600/Screenshot_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="232" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeOyQ7KpZUfHDKBGFkI2P6zFT4Z-fpjRNLS_PojFd9HYhRgdwtTIwhlnwEV0pPZVhPCSOJdf-n-r2r97oC4zD0ldJwsLkObjaNNw8a0_sHnt4viTcsNLVYriVmAlGWf_7ClQdlOibXtsw/s1600/Screenshot_1.png" width="320" /></a></div>
Helo sobat nurdin Or Id 
Kali ini saya akan membahas cara membuat nilai total lewat microsoft office excel 
kalo ini sih yang banyak di lakukan oleh guru untuk melihat semua nilai muridnya dengan cepat dan benar !! Jika sobat yang pengen tau di lihat ya :D 
 
 
 
 
 
 
Awal 
1. Sobat buka MS Excel 
2. Sobat bikin terserah apa aja yang penting ada nilainya :v 
   kalo udah sobat cari tempat yang mau di bikin nilai total 
   kalo udah sobat bikin =SUM( 
   terus sobat scrool yang mau di bikin nilai total, atau sobat bikin dengan Contoh ( D5;D7) Nah itu hanya sebagai contoh kalo nilainya beribu-ribu ribu dengan ketikan aja lah biar kagak capek scroolnya :v 
nah kalo udah =SUM(Blablabla) sobat klik enter 
 
mungkin sekian dari saya :D 
see you again 
<div class="separator" style="clear: both; text-align: center;">
</div>

Helo sobat nurdin Or Id Kali ini saya akan membahas cara membuat nilai total lewat microsoft office excel kalo ini sih yang banyak di la...

Cara Membuat Nilai Rata-Rata Menggunakan Microsoft Office Excel

Helo sobat nurdin Or Id 
kali ini saya akan membahas "Cara Membuat Nilai Rata-Rata Menggunakan Microsoft Office Excel" 
bagi kalian yang pengen tau nilai rata-rata kalian gunakanlah ini dari pada capek mikir :v 
Nah sebagai SS ( Screen Shot ) bisa lihat di bawah 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi49o8eX6DUyi-4_r1sHR5IFmDx5gXJVAQqvpbSxsNZqAJRsI7wCBKDekA-Ig45VDKLpIOvlD8Stz-oi40DYA2Gqe7nLI-5V5gLCdnicXenak_V5hNPnia5fVWnGOtlYTkPkDedFExSfmg/s1600/Screenshot_78.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi49o8eX6DUyi-4_r1sHR5IFmDx5gXJVAQqvpbSxsNZqAJRsI7wCBKDekA-Ig45VDKLpIOvlD8Stz-oi40DYA2Gqe7nLI-5V5gLCdnicXenak_V5hNPnia5fVWnGOtlYTkPkDedFExSfmg/s1600/Screenshot_78.png" width="320" /></a></div>
Lah terus bikinnya gimana ? 
bikinnya mudah 
sobat buka 
1. MS Office Excel 
2. Terserah lah gimana aja yang penting ada Number ( Angka ) ( Nomer ) :v 
3. Nah di kotak bawah sobat Ketik =AVERAGE( 
   Sebagai SSnya di bawah 
      
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO-ARwqw2tORn6bBt_m1VQ9ghrAXLg8gWbHVVGBiBoxT8Fp89YW-m24FDzOPejpKC9sPo-aQrLWFlwIdOPQ0VXDtGflfIJGmxAe1PmvB9DwY4Mvh7hf1ak8Qw6PJHRQyigBnXJlZL2NDM/s1600/Screenshot_79.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="136" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhO-ARwqw2tORn6bBt_m1VQ9ghrAXLg8gWbHVVGBiBoxT8Fp89YW-m24FDzOPejpKC9sPo-aQrLWFlwIdOPQ0VXDtGflfIJGmxAe1PmvB9DwY4Mvh7hf1ak8Qw6PJHRQyigBnXJlZL2NDM/s1600/Screenshot_79.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
kalo sudah di ketik =AVERAGE(   sobat klik kiri pada nilai yang pengen di bikin rata rata , untuk lebih dari satu jangan di lepas klik kirinya kemudian sobat bikin ) lalu klik ENTER</div>
<div class="separator" style="clear: both; text-align: left;">
atau bisa tulis tangan =AVERAGE(A2;B2) Lalu klik ENTER</div>
<div class="separator" style="clear: both; text-align: left;">
Sekian dari saya jika ada yang di tanyakan tinggalkan KOMENTAR</div>

Helo sobat nurdin Or Id kali ini saya akan membahas "Cara Membuat Nilai Rata-Rata Menggunakan Microsoft Office Excel" bagi kalia...

Cara Membuat Add In Terbilang Untuk Microsoft Excel 2007

<div dir="ltr" style="text-align: left;" trbidi="on">
 
 
<div style="background-color: white; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; margin: 0px 0px 0.75em; text-align: justify;">
Bagaimana
 membuat membuat Add In terbilang (menterjemahkan angka menjadi 
kata-kata ) pada Microsoft Excel 2007. Bagi anda yang sering membuat 
tanda terima pembayaran tentunya sering kali anda harus menterjemahkan 
angka-angka menjadi kata-kata, misal Rp. 1000,- diterjemahkan menjadi 
"Seribu Rupiah", tentu akan sangat melelahkan jika hal ini harus 
dikerjakan secara manual, dimana anda harus mengeja setiap angka pada 
transaksi anda untuk kemudian anda ketik. Tujuan Add In ini saya 
berharap akan bisa membantu mempermudah pekerjaan dalam membuat tanda 
terima dan mempersingkat proses. 
 
Langkah-langkahnya sebagai berikut : 
1. Copy paste kode dibawah ini pada notepad ("Terbilang dengan akhiran rupiah" atau "Terbilangan tanpa akhiran rupiah") 
2. Lalu Save As dengan akhiran "terbilang.xlam" dan taruh terserah anda, contoh c:/My Documents 
3. Kemuadian buka excel 2007 
4. Excel Option</div>
<div style="background-color: white; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; margin: 0px 0px 0.75em; text-align: center;">
<img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv8v6GUF8e-68K-7Smcf7BBYgpBRR3bL9F2wRUQShk91-PxDPIv_nW1lMhlNy5Q-1LXeuDzhHcM9Cf0rawdvdPPhlXbcnW510oAti6sujU1u-taZXkSqdihKepYjTnY6N0_5pC6Txaxmcy/s320/1.png" style="border: 1px solid rgb(0, 34, 0); padding: 4px;" width="305" /></div>
5.Pilih tabs "Add-Ins", lalu "Go…". 
<div align="center" style="background-color: white; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; margin: 0px 0px 0.75em;">
<img border="0" height="261" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwozYnaluDclOb3YLM1G7nM5tcOfQOLSLIquN78WyaYQWoahV5PZQR04qOutkiOKqofNIFlWKV3_ZDvSoiO2PYjQ-ojwgawBZCMWARb9UEf5ltv9m4vPL3QrDDkFRsrfXiH4aduculU3Sy/s320/2.png" style="border: 1px solid rgb(0, 34, 0); padding: 4px;" width="320" /></div>
6. Muncul kotak berikut tekan pada tombol "Browse" 
<div align="center" style="background-color: white; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; margin: 0px 0px 0.75em;">
<img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgb_CHm7Ju5WQIuZ1AfZOoGObOpZT5Y1H9vi3ZdvUikVUZZpdVAFifpQlvuhpYU5aMuTXLv-6-73wbSYlKUIQGqhIlCSFviRGCLtYiuCI8_CALEVesA9m1DpR1uySzq8SDDlgwiK8oBZ_t-/s320/3.jpg" style="border: 1px solid rgb(0, 34, 0); padding: 4px;" width="301" /></div>
7. Cari file yang anda simpan tadi (misal di c:/My Documents) 
<div align="center" style="background-color: white; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; margin: 0px 0px 0.75em;">
<img border="0" height="203" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxTFq5kBEjsRnJQFfFxLU_aVzF98SbyU4oI3TTkmNhpwWGT5Y73WSxfnVUoAFQHA2ny8c0XIt_nmzhRbVUivqdyGMAAhwwykMNLhaxoiIW2bSwjKyNSbhWPfl-f4Bh8RxHEGs2HPnVTFhu/s320/4.png" style="border: 1px solid rgb(0, 34, 0); padding: 4px;" width="320" /></div>
8. Klik tombol "Ok" lalu akan muncul kotak berikut : 
<div align="center" style="background-color: white; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; margin: 0px 0px 0.75em;">
<img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUcceMnm6sMU1knKd8JPqWUB6wRtPd3piqWtX5jq2PcJsiLO43QaW-gdUJdYz1xxz6fDpyWqAQnEV-5hwerBxRtW5HQv9ZaKOgoUkZpub0ydVegWNp7ZTaUW3bovRPJ3KC7yhQiYLGdBZF/s320/5.png" style="border: 1px solid rgb(0, 34, 0); padding: 4px;" width="248" /></div>
9. Klik Ok lagi untuk menyeselaikan proses pemasangan Add-Ins 
Sekarang
 kita check apakah fungsi tersebut berfungsi. Untuk memakainya anda 
perlu mengetahui formulanya. Misal angka yang hendak anda buatkan 
terbilangnya ada di cell "A1", maka formulanya adalah sebagai berikut : 
=terbilang(A1,4,"Rupiah.") 
<div align="center" style="background-color: white; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; margin: 0px 0px 0.75em;">
<img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBxBTydIAwhrp_QtUN7qokWKAqxlKgXn_GUuR_7fAuOjqx3tvmw_FL6x-ZR8Qn3Xfpkvm5l-9m-49dZijZlt5UHzFPJMntIEaLDVDpcmZ6AK5pz5ewEhiapHJm5yVTjQuy-037U6xl_brK/s320/6.jpg" style="border: 1px solid rgb(0, 34, 0); padding: 4px;" width="320" /></div>
<div align="center" style="background-color: white; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; margin: 0px 0px 0.75em;">
<img border="0" height="54" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIiwxX8NoRqsjjbhCHG6fH_B0q0eWk2a-iwwSMiQBfsfw4vBNkOnyRZ5eexYJnWggGoMDF0K3F1TA4rjOlh_cD0w9iX0lTsE-7tuOfaaXSOXnRoGLHKsU3qylbAoTxsI87WjgmypSfBdBW/s320/7.jpg" style="border: 1px solid rgb(0, 34, 0); padding: 4px;" width="320" /></div>
Kode Terbilang dengan akhiran rupiah : 
 
<div class="codeview" style="background-color: #f9f9f9; background-image: url(http://www.geocities.com/dhuwuh/codeview.gif); background-position: 100% 100%; background-repeat: no-repeat no-repeat; border-color: rgb(238, 238, 238) rgb(204, 204, 204) rgb(204, 204, 204) rgb(238, 238, 238); border-style: solid; border-width: 1px 2px 2px 1px; clear: both; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; list-style-type: none; margin: 0px 0px 0.75em; padding: 10px; text-align: justify;">
Attribute VB_Name = "Module1" 
Option Explicit 
 
Function Terbilang(ByVal MyNumber) 
Dim Rupiah, Sen, Temp 
Dim Des, Desimal, Count, Tmp 
Dim IsNeg 
 
ReDim Place(9) As String 
Place(2) = "RIBU " 
Place(3) = "JUTA " 
Place(4) = "MILYAR " 
Place(5) = "TRILYUN " 
 
'Ubah angka menjadi string 
MyNumber = Round(MyNumber, 2) 
MyNumber = Trim(Str(MyNumber)) 
 
'Cek bilangan negatif 
If Mid(MyNumber, 1, 1) = "-" Then 
MyNumber = Right(MyNumber, Len(MyNumber) - 1) 
IsNeg = True 
End If 
 
'Posisi desimal, 0 jika bil. bulat 
Desimal = InStr(MyNumber, ".") 
'Pembulatan sen, dua angka di belakang koma 
Des = Mid(MyNumber, Desimal + 2) 
If Desimal > 0 Then 
Tmp = Left(Mid(MyNumber, Desimal + 1) & "00", 2) 
If Left(Tmp, 1) = "0" Then 
Tmp = Mid(Tmp, 2) 
Sen = Satuan(Tmp) 
Else 
Sen = Puluhan(Tmp) 
End If 
MyNumber = Trim(Left(MyNumber, Desimal - 1)) 
End If 
 
Count = 1 
Do While MyNumber <> "" 
Temp = Ratusan(Right(MyNumber, 3), Count) 
If Temp <> "" Then Rupiah = Temp & Place(Count) & Rupiah 
If Len(MyNumber) > 3 Then 
MyNumber = Left(MyNumber, Len(MyNumber) - 3) 
Else 
MyNumber = "" 
End If 
Count = Count + 1 
Loop 
 
Select Case Rupiah 
Case "" 
Rupiah = "NOL RUPIAH" 
Case Else 
Rupiah = Rupiah & "RUPIAH" 
End Select 
 
Select Case Sen 
Case "" 
Sen = "" 
Case Else 
Sen = " DAN " & Sen & "SEN" 
End Select 
 
If IsNeg = True Then 
Terbilang = "MINUS " & Rupiah & Sen 
Else 
Terbilang = Rupiah & Sen 
End If 
 
End Function 
 
 
' Mengubah angka 100-999 menjadi teks * 
Function Ratusan(ByVal MyNumber, Count) 
Dim Result As String 
Dim Tmp 
 
If Val(MyNumber) = 0 Then Exit Function 
MyNumber = Right("000" & MyNumber, 3) 
 
'Mengubah seribu 
If MyNumber = "001" And Count = 2 Then 
Ratusan = "SE" 
Exit Function 
End If 
 
'Mengubah ratusan 
If Mid(MyNumber, 1, 1) <> "0" Then 
If Mid(MyNumber, 1, 1) = "1" Then 
Result = "SERATUS " 
Else 
Result = Satuan(Mid(MyNumber, 1, 1)) & "RATUS " 
End If 
End If 
 
'Mengubah puluhan dan satuan 
If Mid(MyNumber, 2, 1) <> "0" Then 
Result = Result & Puluhan(Mid(MyNumber, 2)) 
Else 
Result = Result & Satuan(Mid(MyNumber, 3)) 
End If 
 
Ratusan = Result 
 
End Function 
 
 
'******************* 
' Mengubah puluhan * 
Function Puluhan(TeksPuluhan) 
Dim Result As String 
 
Result = "" 
' nilai antara 10-19 
If Val(Left(TeksPuluhan, 1)) = 1 Then 
Select Case Val(TeksPuluhan) 
Case 10: Result = "SEPULUH " 
Case 11: Result = "SEBELAS " 
Case Else 
Result = Satuan(Mid(TeksPuluhan, 2)) & "BELAS " 
End Select 
' nilai antara 20-99 
Else 
Result = Satuan(Mid(TeksPuluhan, 1, 1)) _ 
& "PULUH " 
Result = Result & Satuan(Right(TeksPuluhan, 1)) 
'satuan 
End If 
Puluhan = Result 
End Function 
 
 
'******************************** 
' Mengubah satuan menjadi teks. * 
Function Satuan(Digit) 
Select Case Val(Digit) 
Case 1: Satuan = "SATU " 
Case 2: Satuan = "DUA " 
Case 3: Satuan = "TIGA " 
Case 4: Satuan = "EMPAT " 
Case 5: Satuan = "LIMA " 
Case 6: Satuan = "ENAM " 
Case 7: Satuan = "TUJUH " 
Case 8: Satuan = "DELAPAN " 
Case 9: Satuan = "SEMBILAN " 
Case Else: Satuan = "" 
End Select 
End Function</div>
 
Kode terbilang tanpa akhiran rupiah :  
<div class="codeview" style="background-color: #f9f9f9; background-image: url(http://www.geocities.com/dhuwuh/codeview.gif); background-position: 100% 100%; background-repeat: no-repeat no-repeat; border-color: rgb(238, 238, 238) rgb(204, 204, 204) rgb(204, 204, 204) rgb(238, 238, 238); border-style: solid; border-width: 1px 2px 2px 1px; clear: both; font-family: Georgia, Times, serif; font-size: 11px; line-height: 14.699999809265137px; list-style-type: none; margin: 0px 0px 0.75em; padding: 10px; text-align: justify;">
Function Terbilang(ByVal MyNumber) 
Dim Rupiah, Sen, Temp 
Dim Des, Desimal, Count, Tmp 
Dim IsNeg 
 
ReDim Place(9) As String 
Place(2) = "ribu " 
Place(3) = "juta " 
Place(4) = "milyar " 
Place(5) = "trilyun " 
 
'Ubah angka menjadi string 
MyNumber = Round(MyNumber, 2) 
MyNumber = Trim(Str(MyNumber)) 
 
'Cek bilangan negatif 
If Mid(MyNumber, 1, 1) = "-" Then 
MyNumber = Right(MyNumber, Len(MyNumber) - 1) 
IsNeg = True 
End If 
 
'Posisi desimal, 0 jika bil. bulat 
Desimal = InStr(MyNumber, ".") 
'Pembulatan sen, dua angka di belakang koma 
Des = Mid(MyNumber, Desimal + 2) 
If Desimal > 0 Then 
Tmp = Left(Mid(MyNumber, Desimal + 1) & "00", 2) 
If Left(Tmp, 1) = "0" Then 
Tmp = Mid(Tmp, 2) 
Sen = Satuan(Tmp) 
Else 
Sen = Puluhan(Tmp) 
End If 
MyNumber = Trim(Left(MyNumber, Desimal - 1)) 
End If 
 
Count = 1 
Do While MyNumber <> "" 
Temp = Ratusan(Right(MyNumber, 3), Count) 
If Temp <> "" Then Rupiah = Temp & Place(Count) & Rupiah 
If Len(MyNumber) > 3 Then 
MyNumber = Left(MyNumber, Len(MyNumber) - 3) 
Else 
MyNumber = "" 
End If 
Count = Count + 1 
Loop 
 
Select Case Rupiah 
Case "" 
Rupiah = "nol rupiah" 
Case Else 
Rupiah = Rupiah & "rupiah" 
End Select 
 
Select Case Sen 
Case "" 
Sen = "" 
Case Else 
Sen = " dan " & Sen & "sen" 
End Select 
 
If IsNeg = True Then 
Terbilang = "minus " & Rupiah & Sen 
Else 
Terbilang = Rupiah & Sen 
End If 
 
End Function 
 
 
'************************************** 
' Mengubah angka 100-999 menjadi teks * 
'************************************** 
Function Ratusan(ByVal MyNumber, Count) 
Dim Result As String 
Dim Tmp 
 
If Val(MyNumber) = 0 Then Exit Function 
MyNumber = Right("000" & MyNumber, 3) 
 
'Mengubah seribu 
If MyNumber = "001" And Count = 2 Then 
Ratusan = "se" 
Exit Function 
End If 
 
'Mengubah ratusan 
If Mid(MyNumber, 1, 1) <> "0" Then 
If Mid(MyNumber, 1, 1) = "1" Then 
Result = "seratus " 
Else 
Result = Satuan(Mid(MyNumber, 1, 1)) & "ratus " 
End If 
End If 
 
'Mengubah puluhan dan satuan 
If Mid(MyNumber, 2, 1) <> "0" Then 
Result = Result & Puluhan(Mid(MyNumber, 2)) 
Else 
Result = Result & Satuan(Mid(MyNumber, 3)) 
End If 
 
Ratusan = Result 
 
End Function 
 
 
'******************* 
' Mengubah puluhan * 
'******************* 
Function Puluhan(TeksPuluhan) 
Dim Result As String 
 
Result = "" 
' nilai antara 10-19 
If Val(Left(TeksPuluhan, 1)) = 1 Then 
Select Case Val(TeksPuluhan) 
Case 10: Result = "sepuluh " 
Case 11: Result = "sebelas " 
Case Else 
Result = Satuan(Mid(TeksPuluhan, 2)) & "belas " 
End Select 
' nilai antara 20-99 
Else 
Result = Satuan(Mid(TeksPuluhan, 1, 1)) _ 
& "puluh " 
Result = Result & Satuan(Right(TeksPuluhan, 1)) 
'satuan 
End If 
Puluhan = Result 
End Function 
 
 
'******************************** 
' Mengubah satuan menjadi teks. * 
'******************************** 
Function Satuan(Digit) 
Select Case Val(Digit) 
Case 1: Satuan = "satu " 
Case 2: Satuan = "dua " 
Case 3: Satuan = "tiga " 
Case 4: Satuan = "empat " 
Case 5: Satuan = "lima " 
Case 6: Satuan = "enam " 
Case 7: Satuan = "tujuh " 
Case 8: Satuan = "delapan " 
Case 9: Satuan = "sembilan " 
Case Else: Satuan = "" 
End Select 
End Function</div>
 
<div style="text-align: left;">
 </div>
 
 
<div style="text-align: left;">
tag:</div>
<h3 class="r" style="text-align: left;">
CARA MUDAH MEMBUAT FUNGSI TERBILANG PADA EXCEL 2007, cara membuat terbilang otomatis di MS-Excel, Rumus terbilang di excel</h3>
<div>
 </div>
</div>

B agaimana membuat membuat Add In terbilang (menterjemahkan angka menjadi kata-kata ) pada Microsoft Excel 2007. Bagi anda yang sering...

nurdin Or Id

Laman

Cara mudah mengatasi jika muncul pesan " "Windows Explorer Has Stopped Working"

Cara Membuat Border ( Garis ) di microsoft office excel

Cara Membuat Nilai Total Di Microsoft Office Excel

Cara Membuat Nilai Rata-Rata Menggunakan Microsoft Office Excel

Cara Membuat Add In Terbilang Untuk Microsoft Excel 2007

Category

Site Info