[belajar-excel] Digest Number 3916

Milis Belajar Microsoft Excel Group

6 Messages

Digest #3916

1a

Re: Info Training MS Excel by "Teuku Machfud"

1b

Re: Info Training MS Excel by "Dwi Ardhi"

1c

Re: Info Training MS Excel by "muhammad iqbal" iq_bal76id

1d

Re: Info Training MS Excel by "Hilman" hilman_email

2

Step by step buat by "Kamirin Faqoth" kamirin_2

3a

Re: Membuat Rangking Sederhana [1 Attachment] by "omn|vora" omnivora

Messages

1a

Re: Info Training MS Excel

Thu Jul 21, 2016 8:11 am (PDT) . Posted by:

"Teuku Machfud"

Ini offline ya acaranya?

Thanks Teuku
Sent from my BlackBerry 10 smartphone on the Telkomsel network.
From: hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel]Sent: Thursday, 21 July, 2016 15:17To:
belajar-excel@yahoogroups.comReply To:
belajar-excel@yahoogroups.comSubject: Re: [belajar-excel] Info
Training MS Excel


Ini kesempatan yang langka....sesepuh mau turun gunung.
Salam,HK

From: "Belajar Excel training.msexcel@gmail.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 21 July 2016, 11:11
Subject: [belajar-excel] Info Training MS Excel

Dear rekan-rekan
Belajar-Excel

Untuk membantu rekan-rekan agar lebih cepat dalam proses
belajarnya, di bulan Agustus 2016 ini kita akan menggelar
TRAINING MS Excel.
Ada 2 materi, yaitu BASIC dan INTERMEDIATE, masing-masing materi
diberikan dalam sehari.
Silahkan lihat informasi dan syllabus di b-excel.blogspot.co.id
<http://b-excel.blogspot.co.id/>

Semoga manfaat ya!

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1b

Re: Info Training MS Excel

Thu Jul 21, 2016 12:30 pm (PDT) . Posted by:

"Dwi Ardhi"

Saya ikut, daftarnya gimana ni, di web kok ga ada infonya, di halaman mana
suhu, mohon izin ikut....

On Jul 21, 2016 3:17 PM, "hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:

>
>
> Ini kesempatan yang langka....sesepuh mau turun gunung.
>
> Salam,
> HK
>
> ------------------------------
> *From:* "Belajar Excel training.msexcel@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *To:* belajar-excel@yahoogroups.com
> *Sent:* Thursday, 21 July 2016, 11:11
> *Subject:* [belajar-excel] Info Training MS Excel
>
>
> Dear rekan-rekan Belajar-Excel
>
> Untuk membantu rekan-rekan agar lebih cepat dalam proses belajarnya, di
> bulan Agustus 2016 ini kita akan menggelar TRAINING MS Excel.
> Ada 2 materi, yaitu BASIC dan INTERMEDIATE, masing-masing materi diberikan
> dalam sehari.
> Silahkan lihat informasi dan syllabus di b-excel.blogspot.co.id
>
> Semoga manfaat ya!
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1c

Re: Info Training MS Excel

Thu Jul 21, 2016 8:16 pm (PDT) . Posted by:

"muhammad iqbal" iq_bal76id

berikut info yg ada di web

Pendaftaran
Bagi rekan-rekan yang berminat, silahkan kirim email ke: training@belajar-excel.com
cantumkan data:
Nama lengkap
Alamat
Pekerjaan
Nama perusahaan/kantor
Jabatan
Email
No. Kontak/HP

(Pendaftaran terbuka juga untuk umum/bukan anggota milis).

Proses pengadaan training akan diatur oleh "Admin Training", yaitu penentuan jadwal dan transfer biaya, yang akan diinformasikan melalui email atau no. kontak yang diberikan.

thanks
br
muhammad iqbal

Sent from my iPhone

> On Jul 21, 2016, at 22:53, Dwi Ardhi ardhidwirari@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
> Saya ikut, daftarnya gimana ni, di web kok ga ada infonya, di halaman mana suhu, mohon izin ikut....
>
>
>> On Jul 21, 2016 3:17 PM, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>>
>> Ini kesempatan yang langka....sesepuh mau turun gunung.
>>
>> Salam,
>> HK
>>
>> From: "Belajar Excel training.msexcel@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
>> To: belajar-excel@yahoogroups.com
>> Sent: Thursday, 21 July 2016, 11:11

>> Subject: [belajar-excel] Info Training MS Excel
>>
>>
>> Dear rekan-rekan Belajar-Excel
>>
>> Untuk membantu rekan-rekan agar lebih cepat dalam proses belajarnya, di bulan Agustus 2016 ini kita akan menggelar TRAINING MS Excel.
>> Ada 2 materi, yaitu BASIC dan INTERMEDIATE, masing-masing materi diberikan dalam sehari.
>> Silahkan lihat informasi dan syllabus di b-excel.blogspot.co.id
>>
>> Semoga manfaat ya!
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

1d

Re: Info Training MS Excel

Thu Jul 21, 2016 8:18 pm (PDT) . Posted by:

"Hilman" hilman_email

Wow keren nih.... ini acaranya kapan ya tepat nya ? 
Udah lama gak main excel nih... hehehe...

From: "Teuku Machfud aku.maput@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, July 21, 2016 8:49 PM
Subject: Re: [belajar-excel] Info Training MS Excel

  Ini offline ya acaranya?

Thanks Teuku
Sent from my BlackBerry 10 smartphone on the Telkomsel network.
| From: hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]Sent: Thursday, 21 July, 2016 15:17To: belajar-excel@yahoogroups.comReply To: belajar-excel@yahoogroups.comSubject: Re: [belajar-excel] Info Training MS Excel |

  Ini kesempatan yang langka....sesepuh mau turun gunung.
Salam,HK

From: "Belajar Excel training.msexcel@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 21 July 2016, 11:11
Subject: [belajar-excel] Info Training MS Excel

  Dear rekan-rekan Belajar-Excel

Untuk membantu rekan-rekan agar lebih cepat dalam proses belajarnya, di bulan Agustus 2016 ini kita akan menggelar TRAINING MS Excel.
Ada 2 materi, yaitu BASIC dan INTERMEDIATE, masing-masing materi diberikan dalam sehari.
Silahkan lihat informasi dan syllabus di b-excel.blogspot.co.id

Semoga manfaat ya!

#yiv5983288991 #yiv5983288991 -- #yiv5983288991ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5983288991 #yiv5983288991ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5983288991 #yiv5983288991ygrp-mkp #yiv5983288991hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5983288991 #yiv5983288991ygrp-mkp #yiv5983288991ads {margin-bottom:10px;}#yiv5983288991 #yiv5983288991ygrp-mkp .yiv5983288991ad {padding:0 0;}#yiv5983288991 #yiv5983288991ygrp-mkp .yiv5983288991ad p {margin:0;}#yiv5983288991 #yiv5983288991ygrp-mkp .yiv5983288991ad a {color:#0000ff;text-decoration:none;}#yiv5983288991 #yiv5983288991ygrp-sponsor #yiv5983288991ygrp-lc {font-family:Arial;}#yiv5983288991 #yiv5983288991ygrp-sponsor #yiv5983288991ygrp-lc #yiv5983288991hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5983288991 #yiv5983288991ygrp-sponsor #yiv5983288991ygrp-lc .yiv5983288991ad {margin-bottom:10px;padding:0 0;}#yiv5983288991 #yiv5983288991actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5983288991 #yiv5983288991activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5983288991 #yiv5983288991activity span {font-weight:700;}#yiv5983288991 #yiv5983288991activity span:first-child {text-transform:uppercase;}#yiv5983288991 #yiv5983288991activity span a {color:#5085b6;text-decoration:none;}#yiv5983288991 #yiv5983288991activity span span {color:#ff7900;}#yiv5983288991 #yiv5983288991activity span .yiv5983288991underline {text-decoration:underline;}#yiv5983288991 .yiv5983288991attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5983288991 .yiv5983288991attach div a {text-decoration:none;}#yiv5983288991 .yiv5983288991attach img {border:none;padding-right:5px;}#yiv5983288991 .yiv5983288991attach label {display:block;margin-bottom:5px;}#yiv5983288991 .yiv5983288991attach label a {text-decoration:none;}#yiv5983288991 blockquote {margin:0 0 0 4px;}#yiv5983288991 .yiv5983288991bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5983288991 .yiv5983288991bold a {text-decoration:none;}#yiv5983288991 dd.yiv5983288991last p a {font-family:Verdana;font-weight:700;}#yiv5983288991 dd.yiv5983288991last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5983288991 dd.yiv5983288991last p span.yiv5983288991yshortcuts {margin-right:0;}#yiv5983288991 div.yiv5983288991attach-table div div a {text-decoration:none;}#yiv5983288991 div.yiv5983288991attach-table {width:400px;}#yiv5983288991 div.yiv5983288991file-title a, #yiv5983288991 div.yiv5983288991file-title a:active, #yiv5983288991 div.yiv5983288991file-title a:hover, #yiv5983288991 div.yiv5983288991file-title a:visited {text-decoration:none;}#yiv5983288991 div.yiv5983288991photo-title a, #yiv5983288991 div.yiv5983288991photo-title a:active, #yiv5983288991 div.yiv5983288991photo-title a:hover, #yiv5983288991 div.yiv5983288991photo-title a:visited {text-decoration:none;}#yiv5983288991 div#yiv5983288991ygrp-mlmsg #yiv5983288991ygrp-msg p a span.yiv5983288991yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5983288991 .yiv5983288991green {color:#628c2a;}#yiv5983288991 .yiv5983288991MsoNormal {margin:0 0 0 0;}#yiv5983288991 o {font-size:0;}#yiv5983288991 #yiv5983288991photos div {float:left;width:72px;}#yiv5983288991 #yiv5983288991photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5983288991 #yiv5983288991photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5983288991 #yiv5983288991reco-category {font-size:77%;}#yiv5983288991 #yiv5983288991reco-desc {font-size:77%;}#yiv5983288991 .yiv5983288991replbq {margin:4px;}#yiv5983288991 #yiv5983288991ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5983288991 #yiv5983288991ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5983288991 #yiv5983288991ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5983288991 #yiv5983288991ygrp-mlmsg select, #yiv5983288991 input, #yiv5983288991 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5983288991 #yiv5983288991ygrp-mlmsg pre, #yiv5983288991 code {font:115% monospace;}#yiv5983288991 #yiv5983288991ygrp-mlmsg * {line-height:1.22em;}#yiv5983288991 #yiv5983288991ygrp-mlmsg #yiv5983288991logo {padding-bottom:10px;}#yiv5983288991 #yiv5983288991ygrp-msg p a {font-family:Verdana;}#yiv5983288991 #yiv5983288991ygrp-msg p#yiv5983288991attach-count span {color:#1E66AE;font-weight:700;}#yiv5983288991 #yiv5983288991ygrp-reco #yiv5983288991reco-head {color:#ff7900;font-weight:700;}#yiv5983288991 #yiv5983288991ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5983288991 #yiv5983288991ygrp-sponsor #yiv5983288991ov li a {font-size:130%;text-decoration:none;}#yiv5983288991 #yiv5983288991ygrp-sponsor #yiv5983288991ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5983288991 #yiv5983288991ygrp-sponsor #yiv5983288991ov ul {margin:0;padding:0 0 0 8px;}#yiv5983288991 #yiv5983288991ygrp-text {font-family:Georgia;}#yiv5983288991 #yiv5983288991ygrp-text p {margin:0 0 1em 0;}#yiv5983288991 #yiv5983288991ygrp-text tt {font-size:120%;}#yiv5983288991 #yiv5983288991ygrp-vital ul li:last-child {border-right:none !important;}#yiv5983288991

Reply to sender . Reply to group . Reply via Web Post . All Messages (6) . Top ^

2

Step by step buat

Thu Jul 21, 2016 8:16 pm (PDT) . Posted by:

"Kamirin Faqoth" kamirin_2

Dear Rekan-rekan B-Exceler
Mohon penjelasannya, step by step buat Form Message Box dan didalam Form tersebut terdapat fungsi vlookup
Misal:
Saya punya 4 Sheet:
1. Sheet Database Cust
2. Sheet Input
3. Sheet Laporan Penjualan
4. Sheet Rekap
saya ingin membuat aplikasi sederhana yang isi Formnya terdapat pada Sheet Input, apabila saya masukkan no ID menggunakan dropdownlist berdasarkan data di Sheet Cust, maka kolom Nama, Alamat dan telpon terisi otomatis, jadi saya hanya isi kolom Tgl, Permintaan, Pembelian dan harga barang, dan dari Form Tersebut seluruh data masuknya ke Sheet Laporan Penjualan.
File Terlampir
Terima kasih sebelumnya atas pencerahannya.

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

3a

Re: Membuat Rangking Sederhana [1 Attachment]

Thu Jul 21, 2016 8:16 pm (PDT) . Posted by:

"omn|vora" omnivora

kalau net vol seller ada kemungkinan bernilai positif. rumus copy paste dr internet

On Thursday, July 21, 2016 3:19 PM, "sh.ronald@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Selamat siang rekan belajar Excel,

Mohon bantuan atas kesulitan yang sedang saya kerjakan. File lampiran terlampir.
Atas bantuannya saya ucapkan terima kasih.

Ronald

#yiv3792447127 #yiv3792447127 -- #yiv3792447127ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3792447127 #yiv3792447127ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3792447127 #yiv3792447127ygrp-mkp #yiv3792447127hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3792447127 #yiv3792447127ygrp-mkp #yiv3792447127ads {margin-bottom:10px;}#yiv3792447127 #yiv3792447127ygrp-mkp .yiv3792447127ad {padding:0 0;}#yiv3792447127 #yiv3792447127ygrp-mkp .yiv3792447127ad p {margin:0;}#yiv3792447127 #yiv3792447127ygrp-mkp .yiv3792447127ad a {color:#0000ff;text-decoration:none;}#yiv3792447127 #yiv3792447127ygrp-sponsor #yiv3792447127ygrp-lc {font-family:Arial;}#yiv3792447127 #yiv3792447127ygrp-sponsor #yiv3792447127ygrp-lc #yiv3792447127hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3792447127 #yiv3792447127ygrp-sponsor #yiv3792447127ygrp-lc .yiv3792447127ad {margin-bottom:10px;padding:0 0;}#yiv3792447127 #yiv3792447127actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3792447127 #yiv3792447127activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3792447127 #yiv3792447127activity span {font-weight:700;}#yiv3792447127 #yiv3792447127activity span:first-child {text-transform:uppercase;}#yiv3792447127 #yiv3792447127activity span a {color:#5085b6;text-decoration:none;}#yiv3792447127 #yiv3792447127activity span span {color:#ff7900;}#yiv3792447127 #yiv3792447127activity span .yiv3792447127underline {text-decoration:underline;}#yiv3792447127 .yiv3792447127attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3792447127 .yiv3792447127attach div a {text-decoration:none;}#yiv3792447127 .yiv3792447127attach img {border:none;padding-right:5px;}#yiv3792447127 .yiv3792447127attach label {display:block;margin-bottom:5px;}#yiv3792447127 .yiv3792447127attach label a {text-decoration:none;}#yiv3792447127 blockquote {margin:0 0 0 4px;}#yiv3792447127 .yiv3792447127bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3792447127 .yiv3792447127bold a {text-decoration:none;}#yiv3792447127 dd.yiv3792447127last p a {font-family:Verdana;font-weight:700;}#yiv3792447127 dd.yiv3792447127last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3792447127 dd.yiv3792447127last p span.yiv3792447127yshortcuts {margin-right:0;}#yiv3792447127 div.yiv3792447127attach-table div div a {text-decoration:none;}#yiv3792447127 div.yiv3792447127attach-table {width:400px;}#yiv3792447127 div.yiv3792447127file-title a, #yiv3792447127 div.yiv3792447127file-title a:active, #yiv3792447127 div.yiv3792447127file-title a:hover, #yiv3792447127 div.yiv3792447127file-title a:visited {text-decoration:none;}#yiv3792447127 div.yiv3792447127photo-title a, #yiv3792447127 div.yiv3792447127photo-title a:active, #yiv3792447127 div.yiv3792447127photo-title a:hover, #yiv3792447127 div.yiv3792447127photo-title a:visited {text-decoration:none;}#yiv3792447127 div#yiv3792447127ygrp-mlmsg #yiv3792447127ygrp-msg p a span.yiv3792447127yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3792447127 .yiv3792447127green {color:#628c2a;}#yiv3792447127 .yiv3792447127MsoNormal {margin:0 0 0 0;}#yiv3792447127 o {font-size:0;}#yiv3792447127 #yiv3792447127photos div {float:left;width:72px;}#yiv3792447127 #yiv3792447127photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3792447127 #yiv3792447127photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3792447127 #yiv3792447127reco-category {font-size:77%;}#yiv3792447127 #yiv3792447127reco-desc {font-size:77%;}#yiv3792447127 .yiv3792447127replbq {margin:4px;}#yiv3792447127 #yiv3792447127ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3792447127 #yiv3792447127ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3792447127 #yiv3792447127ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3792447127 #yiv3792447127ygrp-mlmsg select, #yiv3792447127 input, #yiv3792447127 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3792447127 #yiv3792447127ygrp-mlmsg pre, #yiv3792447127 code {font:115% monospace;}#yiv3792447127 #yiv3792447127ygrp-mlmsg * {line-height:1.22em;}#yiv3792447127 #yiv3792447127ygrp-mlmsg #yiv3792447127logo {padding-bottom:10px;}#yiv3792447127 #yiv3792447127ygrp-msg p a {font-family:Verdana;}#yiv3792447127 #yiv3792447127ygrp-msg p#yiv3792447127attach-count span {color:#1E66AE;font-weight:700;}#yiv3792447127 #yiv3792447127ygrp-reco #yiv3792447127reco-head {color:#ff7900;font-weight:700;}#yiv3792447127 #yiv3792447127ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3792447127 #yiv3792447127ygrp-sponsor #yiv3792447127ov li a {font-size:130%;text-decoration:none;}#yiv3792447127 #yiv3792447127ygrp-sponsor #yiv3792447127ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3792447127 #yiv3792447127ygrp-sponsor #yiv3792447127ov ul {margin:0;padding:0 0 0 8px;}#yiv3792447127 #yiv3792447127ygrp-text {font-family:Georgia;}#yiv3792447127 #yiv3792447127ygrp-text p {margin:0 0 1em 0;}#yiv3792447127 #yiv3792447127ygrp-text tt {font-size:120%;}#yiv3792447127 #yiv3792447127ygrp-vital ul li:last-child {border-right:none !important;}#yiv3792447127

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use