Minggu, 22 Februari 2015

[belajar-excel] Digest Number 3312

5 Messages

Digest #3312

Messages

Sat Feb 21, 2015 3:38 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Mau pakai macro?Coba copas hasil (edit) rekaman macro ini pada module VBE Sheet,Sub Filt_ke_Shlain()    'macro hasil rekaman dari Sheets("Rekap")(diedit sheetnya)    Sheets("DATA").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _        CriteriaRange:=Sheets("REKAP").Range("I1:J2"), CopyToRange:=Sheets("REKAP").Range("B7:H7"), Unique:=TrueEnd Sub
Kalau No urutnya mau dibuat mulai dari No 1...sila dibuat rekaman macro tersendiri...kmdn digabung dengan macro di atas.
Salam,HK
NB:Kriterianya harus pas penulisannya
From: "omeza icat_omez@ymail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Saturday, 21 February 2015, 13:19
Subject: [belajar-excel] memangil data sesuai kriteria ke sheet baru

  Dear Para Master,,
bagaimana memangil data ke sheet baru dengan criteria..
saya lampirkan file di sini..
terima kasih
wasalam Book1.xlsx
<http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729222/Book1.xlsx>

--
View this message in context: http://milis-belajar-excel.1048464.n5.nabble.com/memangil-data-sesuai-kriteria-ke-sheet-baru-tp5729222.html
Sent from the Milis Belajar Excel mailing list archive at Nabble.com.
#yiv4389322926 #yiv4389322926 -- #yiv4389322926ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4389322926 #yiv4389322926ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4389322926 #yiv4389322926ygrp-mkp #yiv4389322926hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4389322926 #yiv4389322926ygrp-mkp #yiv4389322926ads {margin-bottom:10px;}#yiv4389322926 #yiv4389322926ygrp-mkp .yiv4389322926ad {padding:0 0;}#yiv4389322926 #yiv4389322926ygrp-mkp .yiv4389322926ad p {margin:0;}#yiv4389322926 #yiv4389322926ygrp-mkp .yiv4389322926ad a {color:#0000ff;text-decoration:none;}#yiv4389322926 #yiv4389322926ygrp-sponsor #yiv4389322926ygrp-lc {font-family:Arial;}#yiv4389322926 #yiv4389322926ygrp-sponsor #yiv4389322926ygrp-lc #yiv4389322926hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4389322926 #yiv4389322926ygrp-sponsor #yiv4389322926ygrp-lc .yiv4389322926ad {margin-bottom:10px;padding:0 0;}#yiv4389322926 #yiv4389322926actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4389322926 #yiv4389322926activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4389322926 #yiv4389322926activity span {font-weight:700;}#yiv4389322926 #yiv4389322926activity span:first-child {text-transform:uppercase;}#yiv4389322926 #yiv4389322926activity span a {color:#5085b6;text-decoration:none;}#yiv4389322926 #yiv4389322926activity span span {color:#ff7900;}#yiv4389322926 #yiv4389322926activity span .yiv4389322926underline {text-decoration:underline;}#yiv4389322926 .yiv4389322926attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4389322926 .yiv4389322926attach div a {text-decoration:none;}#yiv4389322926 .yiv4389322926attach img {border:none;padding-right:5px;}#yiv4389322926 .yiv4389322926attach label {display:block;margin-bottom:5px;}#yiv4389322926 .yiv4389322926attach label a {text-decoration:none;}#yiv4389322926 blockquote {margin:0 0 0 4px;}#yiv4389322926 .yiv4389322926bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4389322926 .yiv4389322926bold a {text-decoration:none;}#yiv4389322926 dd.yiv4389322926last p a {font-family:Verdana;font-weight:700;}#yiv4389322926 dd.yiv4389322926last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4389322926 dd.yiv4389322926last p span.yiv4389322926yshortcuts {margin-right:0;}#yiv4389322926 div.yiv4389322926attach-table div div a {text-decoration:none;}#yiv4389322926 div.yiv4389322926attach-table {width:400px;}#yiv4389322926 div.yiv4389322926file-title a, #yiv4389322926 div.yiv4389322926file-title a:active, #yiv4389322926 div.yiv4389322926file-title a:hover, #yiv4389322926 div.yiv4389322926file-title a:visited {text-decoration:none;}#yiv4389322926 div.yiv4389322926photo-title a, #yiv4389322926 div.yiv4389322926photo-title a:active, #yiv4389322926 div.yiv4389322926photo-title a:hover, #yiv4389322926 div.yiv4389322926photo-title a:visited {text-decoration:none;}#yiv4389322926 div#yiv4389322926ygrp-mlmsg #yiv4389322926ygrp-msg p a span.yiv4389322926yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4389322926 .yiv4389322926green {color:#628c2a;}#yiv4389322926 .yiv4389322926MsoNormal {margin:0 0 0 0;}#yiv4389322926 o {font-size:0;}#yiv4389322926 #yiv4389322926photos div {float:left;width:72px;}#yiv4389322926 #yiv4389322926photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4389322926 #yiv4389322926photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4389322926 #yiv4389322926reco-category {font-size:77%;}#yiv4389322926 #yiv4389322926reco-desc {font-size:77%;}#yiv4389322926 .yiv4389322926replbq {margin:4px;}#yiv4389322926 #yiv4389322926ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4389322926 #yiv4389322926ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4389322926 #yiv4389322926ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4389322926 #yiv4389322926ygrp-mlmsg select, #yiv4389322926 input, #yiv4389322926 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4389322926 #yiv4389322926ygrp-mlmsg pre, #yiv4389322926 code {font:115% monospace;}#yiv4389322926 #yiv4389322926ygrp-mlmsg * {line-height:1.22em;}#yiv4389322926 #yiv4389322926ygrp-mlmsg #yiv4389322926logo {padding-bottom:10px;}#yiv4389322926 #yiv4389322926ygrp-msg p a {font-family:Verdana;}#yiv4389322926 #yiv4389322926ygrp-msg p#yiv4389322926attach-count span {color:#1E66AE;font-weight:700;}#yiv4389322926 #yiv4389322926ygrp-reco #yiv4389322926reco-head {color:#ff7900;font-weight:700;}#yiv4389322926 #yiv4389322926ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4389322926 #yiv4389322926ygrp-sponsor #yiv4389322926ov li a {font-size:130%;text-decoration:none;}#yiv4389322926 #yiv4389322926ygrp-sponsor #yiv4389322926ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4389322926 #yiv4389322926ygrp-sponsor #yiv4389322926ov ul {margin:0;padding:0 0 0 8px;}#yiv4389322926 #yiv4389322926ygrp-text {font-family:Georgia;}#yiv4389322926 #yiv4389322926ygrp-text p {margin:0 0 1em 0;}#yiv4389322926 #yiv4389322926ygrp-text tt {font-size:120%;}#yiv4389322926 #yiv4389322926ygrp-vital ul li:last-child {border-right:none !important;}#yiv4389322926

Sat Feb 21, 2015 9:41 am (PST) . Posted by:

"Icat Omez" icat_omez@ymail.com

dear master HKtolong di jelaskan langkah2nya dari awal harus seperti apa,,saya sudah berhaasil mengunakan macro itu,tpi saya pgin tahu prosesnya terima kasih,,,
terima kasih sebelumnya atas bantuanya
salamOmez


Pada Sabtu, 21 Februari 2015 18:38, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Mau pakai macro?Coba copas hasil (edit) rekaman macro ini pada module VBE Sheet,Sub Filt_ke_Shlain()    'macro hasil rekaman dari Sheets("Rekap")(diedit sheetnya)    Sheets("DATA").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _        CriteriaRange:=Sheets("REKAP").Range("I1:J2"), CopyToRange:=Sheets("REKAP").Range("B7:H7"), Unique:=TrueEnd Sub
Kalau No urutnya mau dibuat mulai dari No 1...sila dibuat rekaman macro tersendiri...kmdn digabung dengan macro di atas.
Salam,HK
NB:Kriterianya harus pas penulisannya
From: "omeza icat_omez@ymail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Saturday, 21 February 2015, 13:19
Subject: [belajar-excel] memangil data sesuai kriteria ke sheet baru

  Dear Para Master,,
bagaimana memangil data ke sheet baru dengan criteria..
saya lampirkan file di sini..
terima kasih
wasalam Book1.xlsx
<http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729222/Book1.xlsx>

--
View this message in context: http://milis-belajar-excel.1048464.n5.nabble.com/memangil-data-sesuai-kriteria-ke-sheet-baru-tp5729222.html
Sent from the Milis Belajar Excel mailing list archive at Nabble.com.


#yiv5466199004 #yiv5466199004 -- #yiv5466199004ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5466199004 #yiv5466199004ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5466199004 #yiv5466199004ygrp-mkp #yiv5466199004hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5466199004 #yiv5466199004ygrp-mkp #yiv5466199004ads {margin-bottom:10px;}#yiv5466199004 #yiv5466199004ygrp-mkp .yiv5466199004ad {padding:0 0;}#yiv5466199004 #yiv5466199004ygrp-mkp .yiv5466199004ad p {margin:0;}#yiv5466199004 #yiv5466199004ygrp-mkp .yiv5466199004ad a {color:#0000ff;text-decoration:none;}#yiv5466199004 #yiv5466199004ygrp-sponsor #yiv5466199004ygrp-lc {font-family:Arial;}#yiv5466199004 #yiv5466199004ygrp-sponsor #yiv5466199004ygrp-lc #yiv5466199004hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5466199004 #yiv5466199004ygrp-sponsor #yiv5466199004ygrp-lc .yiv5466199004ad {margin-bottom:10px;padding:0 0;}#yiv5466199004 #yiv5466199004actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5466199004 #yiv5466199004activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5466199004 #yiv5466199004activity span {font-weight:700;}#yiv5466199004 #yiv5466199004activity span:first-child {text-transform:uppercase;}#yiv5466199004 #yiv5466199004activity span a {color:#5085b6;text-decoration:none;}#yiv5466199004 #yiv5466199004activity span span {color:#ff7900;}#yiv5466199004 #yiv5466199004activity span .yiv5466199004underline {text-decoration:underline;}#yiv5466199004 .yiv5466199004attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5466199004 .yiv5466199004attach div a {text-decoration:none;}#yiv5466199004 .yiv5466199004attach img {border:none;padding-right:5px;}#yiv5466199004 .yiv5466199004attach label {display:block;margin-bottom:5px;}#yiv5466199004 .yiv5466199004attach label a {text-decoration:none;}#yiv5466199004 blockquote {margin:0 0 0 4px;}#yiv5466199004 .yiv5466199004bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5466199004 .yiv5466199004bold a {text-decoration:none;}#yiv5466199004 dd.yiv5466199004last p a {font-family:Verdana;font-weight:700;}#yiv5466199004 dd.yiv5466199004last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5466199004 dd.yiv5466199004last p span.yiv5466199004yshortcuts {margin-right:0;}#yiv5466199004 div.yiv5466199004attach-table div div a {text-decoration:none;}#yiv5466199004 div.yiv5466199004attach-table {width:400px;}#yiv5466199004 div.yiv5466199004file-title a, #yiv5466199004 div.yiv5466199004file-title a:active, #yiv5466199004 div.yiv5466199004file-title a:hover, #yiv5466199004 div.yiv5466199004file-title a:visited {text-decoration:none;}#yiv5466199004 div.yiv5466199004photo-title a, #yiv5466199004 div.yiv5466199004photo-title a:active, #yiv5466199004 div.yiv5466199004photo-title a:hover, #yiv5466199004 div.yiv5466199004photo-title a:visited {text-decoration:none;}#yiv5466199004 div#yiv5466199004ygrp-mlmsg #yiv5466199004ygrp-msg p a span.yiv5466199004yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5466199004 .yiv5466199004green {color:#628c2a;}#yiv5466199004 .yiv5466199004MsoNormal {margin:0 0 0 0;}#yiv5466199004 o {font-size:0;}#yiv5466199004 #yiv5466199004photos div {float:left;width:72px;}#yiv5466199004 #yiv5466199004photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5466199004 #yiv5466199004photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5466199004 #yiv5466199004reco-category {font-size:77%;}#yiv5466199004 #yiv5466199004reco-desc {font-size:77%;}#yiv5466199004 .yiv5466199004replbq {margin:4px;}#yiv5466199004 #yiv5466199004ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5466199004 #yiv5466199004ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5466199004 #yiv5466199004ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5466199004 #yiv5466199004ygrp-mlmsg select, #yiv5466199004 input, #yiv5466199004 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5466199004 #yiv5466199004ygrp-mlmsg pre, #yiv5466199004 code {font:115% monospace;}#yiv5466199004 #yiv5466199004ygrp-mlmsg * {line-height:1.22em;}#yiv5466199004 #yiv5466199004ygrp-mlmsg #yiv5466199004logo {padding-bottom:10px;}#yiv5466199004 #yiv5466199004ygrp-msg p a {font-family:Verdana;}#yiv5466199004 #yiv5466199004ygrp-msg p#yiv5466199004attach-count span {color:#1E66AE;font-weight:700;}#yiv5466199004 #yiv5466199004ygrp-reco #yiv5466199004reco-head {color:#ff7900;font-weight:700;}#yiv5466199004 #yiv5466199004ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5466199004 #yiv5466199004ygrp-sponsor #yiv5466199004ov li a {font-size:130%;text-decoration:none;}#yiv5466199004 #yiv5466199004ygrp-sponsor #yiv5466199004ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5466199004 #yiv5466199004ygrp-sponsor #yiv5466199004ov ul {margin:0;padding:0 0 0 8px;}#yiv5466199004 #yiv5466199004ygrp-text {font-family:Georgia;}#yiv5466199004 #yiv5466199004ygrp-text p {margin:0 0 1em 0;}#yiv5466199004 #yiv5466199004ygrp-text tt {font-size:120%;}#yiv5466199004 #yiv5466199004ygrp-vital ul li:last-child {border-right:none !important;}#yiv5466199004

Sat Feb 21, 2015 8:48 pm (PST) . Posted by:

"Hendrik Karnadi" hendrikkarnadi

Hai Omez,
Langkah2nya adalah sbb:
1. Select sheet Rekap, blok Judul pada sheet tsb
2. Klik View, Macro Recording (Excel 2007 ke atas)
3. Klik Data, Advance Filter
4. Pilih Copy to another sheet, isi kolom sumber, kriteria dan hasil dengan cara memblok rangenya
5. Klik unique value, ok
6. Klik stop recording.

Update macronya pada VBE sheet, Module1 yang ditulis secara otomatis oleh komputer sesuai langkah2 3 s/d 5 di atas.
Yang diupdate adalah range sumbernya, menjadi Range ("A1").CurrentRegion dan tambahkan Sheets ("Rekap") pada CrìteriaRange dan CopytoRange,  sehingga hasilnya seperti tertulis pada bag bawah.

Selamat mencoba.

Salam,
HK

Sent from Samsung Mobile

<div>-------- Original message --------</div><div>From: "Icat Omez icat_omez@ymail.com [belajar-excel]" <belajar-excel@yahoogroups.com> </div><div>Date:21/02/2015 23:29 (GMT+07:00) </div><div>To: belajar-excel@yahoogroups.com </div><div>Subject: Bls: [belajar-excel] memangil data sesuai kriteria ke sheet baru </div><div>
</div>dear master HK
tolong di jelaskan langkah2nya dari awal harus seperti apa,,
saya sudah berhaasil mengunakan macro itu,
tpi saya pgin tahu prosesnya terima kasih,,,

terima kasih sebelumnya atas bantuanya

salam
Omez

Pada Sabtu, 21 Februari 2015 18:38, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:

Mau pakai macro?
Coba copas hasil (edit) rekaman macro ini pada module VBE Sheet,
Sub Filt_ke_Shlain()
'macro hasil rekaman dari Sheets("Rekap")(diedit sheetnya)
Sheets("DATA").Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("REKAP").Range("I1:J2"), CopyToRange:=Sheets("REKAP").Range("B7:H7"), Unique:=True
End Sub

Kalau No urutnya mau dibuat mulai dari No 1...sila dibuat rekaman macro tersendiri...kmdn digabung dengan macro di atas.

Salam,
HK

NB:
Kriterianya harus pas penulisannya

From: "omeza icat_omez@ymail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Saturday, 21 February 2015, 13:19
Subject: [belajar-excel] memangil data sesuai kriteria ke sheet baru

Dear Para Master,,
bagaimana memangil data ke sheet baru dengan criteria..
saya lampirkan file di sini..
terima kasih
wasalam Book1.xlsx
<http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729222/Book1.xlsx>

--
View this message in context: http://milis-belajar-excel.1048464.n5.nabble.com/memangil-data-sesuai-kriteria-ke-sheet-baru-tp5729222.html
Sent from the Milis Belajar Excel mailing list archive at Nabble.com.

Sat Feb 21, 2015 4:44 am (PST) . Posted by:

"Rudi Anto" rudi.excel

Wah, dah clear permasalahannya..

Salam,
Rudi Anto
--------------------------------------------
On Fri, 2/20/15, Rudi Anto rudi.excel@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

Subject: [belajar-excel] Formula SMALL IF error ( muncul #N/A ) [1 Attachment]
To: belajar-excel@yahoogroups.com
Date: Friday, February 20, 2015, 7:09 PM


 




Salam untuk anggota milis Belajar-excel,



Berikut saya lampirkan file excel dengan formula SMALL(IF
yang error,

Singkat cerita error terjadi ketika saya pilih tanggal akhir
dari transaksi,

ambil contoh ketika tanggal terakhir sampai tanggal 7 (
seperti di sheet utility U3 )

maka array formula yang dihasilkan di sheet helper akan
berubah menjadi #N/A,



Semoga file terlampir bisa membantu menyampaikan kasus yang
saya alami.

Terima kasih sebelumnya atas bantuannya.



Salam,

Rudi Anto









#yiv5003917243 #yiv5003917243 --
#yiv5003917243ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv5003917243 #yiv5003917243ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5003917243 #yiv5003917243ygrp-mkp #yiv5003917243hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5003917243 #yiv5003917243ygrp-mkp #yiv5003917243ads {
margin-bottom:10px;}

#yiv5003917243 #yiv5003917243ygrp-mkp .yiv5003917243ad {
padding:0 0;}

#yiv5003917243 #yiv5003917243ygrp-mkp .yiv5003917243ad p {
margin:0;}

#yiv5003917243 #yiv5003917243ygrp-mkp .yiv5003917243ad a {
color:#0000ff;text-decoration:none;}
#yiv5003917243 #yiv5003917243ygrp-sponsor
#yiv5003917243ygrp-lc {
font-family:Arial;}

#yiv5003917243 #yiv5003917243ygrp-sponsor
#yiv5003917243ygrp-lc #yiv5003917243hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5003917243 #yiv5003917243ygrp-sponsor
#yiv5003917243ygrp-lc .yiv5003917243ad {
margin-bottom:10px;padding:0 0;}

#yiv5003917243 #yiv5003917243actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv5003917243 #yiv5003917243activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv5003917243 #yiv5003917243activity span {
font-weight:700;}

#yiv5003917243 #yiv5003917243activity span:first-child {
text-transform:uppercase;}

#yiv5003917243 #yiv5003917243activity span a {
color:#5085b6;text-decoration:none;}

#yiv5003917243 #yiv5003917243activity span span {
color:#ff7900;}

#yiv5003917243 #yiv5003917243activity span
.yiv5003917243underline {
text-decoration:underline;}

#yiv5003917243 .yiv5003917243attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv5003917243 .yiv5003917243attach div a {
text-decoration:none;}

#yiv5003917243 .yiv5003917243attach img {
border:none;padding-right:5px;}

#yiv5003917243 .yiv5003917243attach label {
display:block;margin-bottom:5px;}

#yiv5003917243 .yiv5003917243attach label a {
text-decoration:none;}

#yiv5003917243 blockquote {
margin:0 0 0 4px;}

#yiv5003917243 .yiv5003917243bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5003917243 .yiv5003917243bold a {
text-decoration:none;}


#yiv5003917243 dd.yiv5003917243last p a {
font-family:Verdana;font-weight:700;}

#yiv5003917243 dd.yiv5003917243last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv5003917243 dd.yiv5003917243last p
span.yiv5003917243yshortcuts {
margin-right:0;}

#yiv5003917243 div.yiv5003917243attach-table div div a {
text-decoration:none;}

#yiv5003917243 div.yiv5003917243attach-table {
width:400px;}

#yiv5003917243 div.yiv5003917243file-title a, #yiv5003917243
div.yiv5003917243file-title a:active, #yiv5003917243
div.yiv5003917243file-title a:hover, #yiv5003917243
div.yiv5003917243file-title a:visited {
text-decoration:none;}

#yiv5003917243 div.yiv5003917243photo-title a,
#yiv5003917243 div.yiv5003917243photo-title a:active,
#yiv5003917243 div.yiv5003917243photo-title a:hover,
#yiv5003917243 div.yiv5003917243photo-title a:visited {
text-decoration:none;}

#yiv5003917243 div#yiv5003917243ygrp-mlmsg
#yiv5003917243ygrp-msg p a span.yiv5003917243yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5003917243 .yiv5003917243green {
color:#628c2a;}

#yiv5003917243 .yiv5003917243MsoNormal {
margin:0 0 0 0;}

#yiv5003917243 o {
font-size:0;}

#yiv5003917243 #yiv5003917243photos div {
float:left;width:72px;}

#yiv5003917243 #yiv5003917243photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv5003917243 #yiv5003917243photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv5003917243 #yiv5003917243reco-category {
font-size:77%;}

#yiv5003917243 #yiv5003917243reco-desc {
font-size:77%;}

#yiv5003917243 .yiv5003917243replbq {
margin:4px;}

#yiv5003917243 #yiv5003917243ygrp-actbar div a:first-child {

margin-right:2px;padding-right:5px;}

#yiv5003917243 #yiv5003917243ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv5003917243 #yiv5003917243ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv5003917243 #yiv5003917243ygrp-mlmsg select,
#yiv5003917243 input, #yiv5003917243 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv5003917243 #yiv5003917243ygrp-mlmsg pre, #yiv5003917243
code {
font:115% monospace;}

#yiv5003917243 #yiv5003917243ygrp-mlmsg * {
line-height:1.22em;}

#yiv5003917243 #yiv5003917243ygrp-mlmsg #yiv5003917243logo {
padding-bottom:10px;}


#yiv5003917243 #yiv5003917243ygrp-msg p a {
font-family:Verdana;}

#yiv5003917243 #yiv5003917243ygrp-msg
p#yiv5003917243attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5003917243 #yiv5003917243ygrp-reco
#yiv5003917243reco-head {
color:#ff7900;font-weight:700;}

#yiv5003917243 #yiv5003917243ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5003917243 #yiv5003917243ygrp-sponsor #yiv5003917243ov
li a {
font-size:130%;text-decoration:none;}

#yiv5003917243 #yiv5003917243ygrp-sponsor #yiv5003917243ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5003917243 #yiv5003917243ygrp-sponsor #yiv5003917243ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5003917243 #yiv5003917243ygrp-text {
font-family:Georgia;}

#yiv5003917243 #yiv5003917243ygrp-text p {
margin:0 0 1em 0;}

#yiv5003917243 #yiv5003917243ygrp-text tt {
font-size:120%;}

#yiv5003917243 #yiv5003917243ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv5003917243

Sat Feb 21, 2015 9:42 pm (PST) . Posted by:

kieki_e


Dear Pak HK
Senang sekali Pak HK sudah mulai lirik2 Power Pivot. Jadi ke depannya pasti banyak pembahasan menarik tentang Power Pivot ini.
Power Pivot menurut saya salah satu fungsi nya adalah suatu tools untuk mengambil summary dari beberapa tabel yang dijadikan data model. Dengan Power Pivot, kita dapat membuat relasi data sehingga rumus lookup tergantikan dengan lebih powerfull.
Aplikasi Power Pivot dan Power Query dapat menjadi alat database yang canggih menurut saya. Ada satu thread yg sangat mencerahkan dari Mr Kid tentang dua tools ini.
Saya juga msh belajar tentang Power Pivot ini. Jadi mari rekan2 yang lain saling sharing..
--
Sent from myMail app for Android
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar