Rabu, 10 Oktober 2018

[belajar-excel] Digest Number 4621

5 Messages

Digest #4621

Messages

Wed Oct 10, 2018 2:00 am (PDT) . Posted by:

"Topenk Baday" topenk_baday

mohon bantuan cari row yang tertera pada contoh

Wed Oct 10, 2018 8:28 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Tulis di cells B1 :
=HYPERLINK("#'Sheet1'!"&ADDRESS($C$1+3,1),"CARI >>")

Regards,
Kid

On Wed, Oct 10, 2018 at 4:11 PM Topenk Baday topenk_baday@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> mohon bantuan cari row yang tertera pada contoh
>
>

Wed Oct 10, 2018 7:33 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Info buat temen2 yang mencari pelatihan Excel bersertifikat.
Salam,HK

Sent from Yahoo Mail on Android

On Thu, Oct 11, 2018 at 0:59, Pelatihan LA LEARNING co<training@lalearning.co> wrote:
Jadwal Pelatihan
|
Jadwal Pelatihan LA LEARNING Bulan OKTOBER 2018

LA LEARNING: 0895 3313 69655; 0815-6802589; 021–5577 6954

hendry@lalearning.biz; training@lalearning.co; seminar@lalearning.co
|
| |
|
1
|
18 - 19 Okt 18
|
Mastering Excel 2010 for Data Processing System
|
|
2
|
18 - 19 Okt 18
|
Powerful Database Analysis Dashboard Reporting With Excel 2010
|
|
3
|
18 - 19 Okt 18
|
Strategic Sourcing & Vendor Management
|
|
4
|
18 - 19 Okt 18
|
Managing Office & Filling  System
|
|
5
|
22 - 23 Okt 18
|
Leadership & Managerial Skill
|
|
6
|
22 Okt 18
|
Digital Marketing
|
|
7
|
24 Okt 18
|
Customer Service Excellence
|
|
8
|
22 – 23 Okt 18
|
Effective Skills for PERSONAL ASSISTANT
|
|
9
|
23 -24 Okt 18
|
Metode Penyusunan Spesifikasi & Harga Perkiraan Sendiri ( HPS )
|
|
10
|
25 - 26 Okt 18
|
Effective Communication & Interpersonal Skill
|
|
11
|
25 - 26 Okt 18
|
Manajement Resiko (Risk Management)
|
|
12
|
26 Okt 18
|
POWERPOINT  Do More
|
|
13
|
29 - 30 Okt 18
|
Practical COACHING & COUNSELING
|
|
14
|
29 - 30 Okt 18
|
Problem Solving with LEGO SERIOUS PLAY
|
|
15
|
30 - 31 Okt 18
|
Supply Chain Management
|
|
16
|
30 - 31 Okt 18
|
KPI with Balanced Scored Card
|

MasteringExcel 2010 for

DataProcessing System

 Kamis - Jum'at, 18– 19 Oktober 2018, Hotel Ibis /MaxOne Menteng Jakarta

TujuanPelatihan

- Peserta memahami cara mengatur wilayah untuk memudahkan proses kerja
- Peserta mampu menggunakan operasional numerik dasar pada Microsoft Excel
- Peserta mampu mengolah kata dengan fungsi yang ada di Microsoft Excel
- Peserta mampu bekerja dengan area kerja dan penamaannya
- Peserta mampu melalukan pengurutan data secara cepat.
- Peserta mampu melakukan pengolahan data dengan metode pencarian.
- Peserta dapat mengenali dan menyusun rumus logika pada pengolahan data
- Peserta dapat membedakan dan memisahkan data penting dengan cepat berdasarkan isi data.
- Peserta dapat menyaring dan menampilkan spesifik data dengan cepat.
- Peserta dapat membuat media input yang aman dan mudah bagi pengguna.
- Peserta dapat menyajikan printout data yang cepat, tepat dan nyaman disajikan dengan berbagai metode jenis data.

MateriPelatihan

- Workarea simplify
- Printing Technique
- Cells and Range Addressing
- Arithmatic Operational
- String Function
- Date Function
- Data Sort
- Total and SubTotal
- Data Search (VlookUp, HLookup)
- Remove Duplicates
- IF Formula (Beginning)
- Conditional Formatting
- AutoFilter
- Advance Filter
- Data Validation
- Sparklines
- PivotTable & PivotChart

Trainer:Eka Kurniawan

Investasiper Pelatihan

Rp4.000,000per peserta

Atau:mendaftar4 peserta boleh ikut 5 peserta (satu perusahaan yang sama)

Termasuk:Sertifikat, modul, lunch, coffee break,  buku karangan A..M. Lilik Agung.

Tidaktermasuk pajak.

LALEARNING

Jl. Taman Paris 1 no 230 LippoKarawaciTangerang. Telp/Fax.:(021) 55776954

Message sent with an unregistered version of MailList King!
MailList King: Powerful mailing list management from your desktop.
Xequte Software - www.xequte.com

| | Virus-free. www.avast.com |

Wed Oct 10, 2018 8:39 pm (PDT) . Posted by:

"Hilman" hilman_email

Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman#yiv8265176273 #yiv8265176273 -- #yiv8265176273ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8265176273 #yiv8265176273ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8265176273 #yiv8265176273ygrp-mkp #yiv8265176273hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8265176273 #yiv8265176273ygrp-mkp #yiv8265176273ads {margin-bottom:10px;}#yiv8265176273 #yiv8265176273ygrp-mkp .yiv8265176273ad {padding:0 0;}#yiv8265176273 #yiv8265176273ygrp-mkp .yiv8265176273ad p {margin:0;}#yiv8265176273 #yiv8265176273ygrp-mkp .yiv8265176273ad a {color:#0000ff;text-decoration:none;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ygrp-lc {font-family:Arial;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ygrp-lc #yiv8265176273hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ygrp-lc .yiv8265176273ad {margin-bottom:10px;padding:0 0;}#yiv8265176273 #yiv8265176273actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8265176273 #yiv8265176273activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8265176273 #yiv8265176273activity span {font-weight:700;}#yiv8265176273 #yiv8265176273activity span:first-child {text-transform:uppercase;}#yiv8265176273 #yiv8265176273activity span a {color:#5085b6;text-decoration:none;}#yiv8265176273 #yiv8265176273activity span span {color:#ff7900;}#yiv8265176273 #yiv8265176273activity span .yiv8265176273underline {text-decoration:underline;}#yiv8265176273 .yiv8265176273attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8265176273 .yiv8265176273attach div a {text-decoration:none;}#yiv8265176273 .yiv8265176273attach img {border:none;padding-right:5px;}#yiv8265176273 .yiv8265176273attach label {display:block;margin-bottom:5px;}#yiv8265176273 .yiv8265176273attach label a {text-decoration:none;}#yiv8265176273 blockquote {margin:0 0 0 4px;}#yiv8265176273 .yiv8265176273bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8265176273 .yiv8265176273bold a {text-decoration:none;}#yiv8265176273 dd.yiv8265176273last p a {font-family:Verdana;font-weight:700;}#yiv8265176273 dd.yiv8265176273last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8265176273 dd.yiv8265176273last p span.yiv8265176273yshortcuts {margin-right:0;}#yiv8265176273 div.yiv8265176273attach-table div div a {text-decoration:none;}#yiv8265176273 div.yiv8265176273attach-table {width:400px;}#yiv8265176273 div.yiv8265176273file-title a, #yiv8265176273 div.yiv8265176273file-title a:active, #yiv8265176273 div.yiv8265176273file-title a:hover, #yiv8265176273 div.yiv8265176273file-title a:visited {text-decoration:none;}#yiv8265176273 div.yiv8265176273photo-title a, #yiv8265176273 div.yiv8265176273photo-title a:active, #yiv8265176273 div.yiv8265176273photo-title a:hover, #yiv8265176273 div.yiv8265176273photo-title a:visited {text-decoration:none;}#yiv8265176273 div#yiv8265176273ygrp-mlmsg #yiv8265176273ygrp-msg p a span.yiv8265176273yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8265176273 .yiv8265176273green {color:#628c2a;}#yiv8265176273 .yiv8265176273MsoNormal {margin:0 0 0 0;}#yiv8265176273 o {font-size:0;}#yiv8265176273 #yiv8265176273photos div {float:left;width:72px;}#yiv8265176273 #yiv8265176273photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8265176273 #yiv8265176273photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8265176273 #yiv8265176273reco-category {font-size:77%;}#yiv8265176273 #yiv8265176273reco-desc {font-size:77%;}#yiv8265176273 .yiv8265176273replbq {margin:4px;}#yiv8265176273 #yiv8265176273ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8265176273 #yiv8265176273ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8265176273 #yiv8265176273ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8265176273 #yiv8265176273ygrp-mlmsg select, #yiv8265176273 input, #yiv8265176273 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8265176273 #yiv8265176273ygrp-mlmsg pre, #yiv8265176273 code {font:115% monospace;}#yiv8265176273 #yiv8265176273ygrp-mlmsg * {line-height:1.22em;}#yiv8265176273 #yiv8265176273ygrp-mlmsg #yiv8265176273logo {padding-bottom:10px;}#yiv8265176273 #yiv8265176273ygrp-msg p a {font-family:Verdana;}#yiv8265176273 #yiv8265176273ygrp-msg p#yiv8265176273attach-count span {color:#1E66AE;font-weight:700;}#yiv8265176273 #yiv8265176273ygrp-reco #yiv8265176273reco-head {color:#ff7900;font-weight:700;}#yiv8265176273 #yiv8265176273ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ov li a {font-size:130%;text-decoration:none;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8265176273 #yiv8265176273ygrp-sponsor #yiv8265176273ov ul {margin:0;padding:0 0 0 8px;}#yiv8265176273 #yiv8265176273ygrp-text {font-family:Georgia;}#yiv8265176273 #yiv8265176273ygrp-text p {margin:0 0 1em 0;}#yiv8265176273 #yiv8265176273ygrp-text tt {font-size:120%;}#yiv8265176273 #yiv8265176273ygrp-vital ul li:last-child {border-right:none !important;}#yiv8265176273

Wed Oct 10, 2018 8:41 pm (PDT) . Posted by:

"Hilman" hilman_email

Maksudnya...
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 2,4 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….

From: "Hilman hilman_email@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Thursday, October 11, 2018 10:40 AM
Subject: [belajar-excel] Conditional Formating Untuk Baris Ganjil dan Baris Genap [1 Attachment]

  Dear All
Gimana caranya conditional formating untuk row yang nilainya 1,3,5 warnanya akan kuning, sedangkan row 4,5 warnanya hijau..Jadi walaupun diinsert row pada area ganjil ataupun area genap, warnanya akan tetap kuning atau tetap hijau….
Makasih yaaa....
Setelah 5 tahunan vakum dari dunia excel, agak kagok juga nih.. dan ternyata jadi gak tajam lagi...hehehehe....
SalamHilman #yiv3050217343 #yiv3050217343 -- #yiv3050217343ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3050217343 #yiv3050217343ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3050217343 #yiv3050217343ygrp-mkp #yiv3050217343hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3050217343 #yiv3050217343ygrp-mkp #yiv3050217343ads {margin-bottom:10px;}#yiv3050217343 #yiv3050217343ygrp-mkp .yiv3050217343ad {padding:0 0;}#yiv3050217343 #yiv3050217343ygrp-mkp .yiv3050217343ad p {margin:0;}#yiv3050217343 #yiv3050217343ygrp-mkp .yiv3050217343ad a {color:#0000ff;text-decoration:none;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ygrp-lc {font-family:Arial;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ygrp-lc #yiv3050217343hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ygrp-lc ..yiv3050217343ad {margin-bottom:10px;padding:0 0;}#yiv3050217343 #yiv3050217343actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3050217343 #yiv3050217343activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3050217343 #yiv3050217343activity span {font-weight:700;}#yiv3050217343 #yiv3050217343activity span:first-child {text-transform:uppercase;}#yiv3050217343 #yiv3050217343activity span a {color:#5085b6;text-decoration:none;}#yiv3050217343 #yiv3050217343activity span span {color:#ff7900;}#yiv3050217343 #yiv3050217343activity span .yiv3050217343underline {text-decoration:underline;}#yiv3050217343 .yiv3050217343attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3050217343 .yiv3050217343attach div a {text-decoration:none;}#yiv3050217343 ..yiv3050217343attach img {border:none;padding-right:5px;}#yiv3050217343 .yiv3050217343attach label {display:block;margin-bottom:5px;}#yiv3050217343 .yiv3050217343attach label a {text-decoration:none;}#yiv3050217343 blockquote {margin:0 0 0 4px;}#yiv3050217343 .yiv3050217343bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3050217343 .yiv3050217343bold a {text-decoration:none;}#yiv3050217343 dd.yiv3050217343last p a {font-family:Verdana;font-weight:700;}#yiv3050217343 dd.yiv3050217343last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3050217343 dd.yiv3050217343last p span.yiv3050217343yshortcuts {margin-right:0;}#yiv3050217343 div.yiv3050217343attach-table div div a {text-decoration:none;}#yiv3050217343 div.yiv3050217343attach-table {width:400px;}#yiv3050217343 div.yiv3050217343file-title a, #yiv3050217343 div.yiv3050217343file-title a:active, #yiv3050217343 div.yiv3050217343file-title a:hover, #yiv3050217343 div.yiv3050217343file-title a:visited {text-decoration:none;}#yiv3050217343 div.yiv3050217343photo-title a, #yiv3050217343 div.yiv3050217343photo-title a:active, #yiv3050217343 div.yiv3050217343photo-title a:hover, #yiv3050217343 div.yiv3050217343photo-title a:visited {text-decoration:none;}#yiv3050217343 div#yiv3050217343ygrp-mlmsg #yiv3050217343ygrp-msg p a span.yiv3050217343yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3050217343 .yiv3050217343green {color:#628c2a;}#yiv3050217343 .yiv3050217343MsoNormal {margin:0 0 0 0;}#yiv3050217343 o {font-size:0;}#yiv3050217343 #yiv3050217343photos div {float:left;width:72px;}#yiv3050217343 #yiv3050217343photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3050217343 #yiv3050217343photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3050217343 #yiv3050217343reco-category {font-size:77%;}#yiv3050217343 #yiv3050217343reco-desc {font-size:77%;}#yiv3050217343 .yiv3050217343replbq {margin:4px;}#yiv3050217343 #yiv3050217343ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3050217343 #yiv3050217343ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3050217343 #yiv3050217343ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3050217343 #yiv3050217343ygrp-mlmsg select, #yiv3050217343 input, #yiv3050217343 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3050217343 #yiv3050217343ygrp-mlmsg pre, #yiv3050217343 code {font:115% monospace;}#yiv3050217343 #yiv3050217343ygrp-mlmsg * {line-height:1.22em;}#yiv3050217343 #yiv3050217343ygrp-mlmsg #yiv3050217343logo {padding-bottom:10px;}#yiv3050217343 #yiv3050217343ygrp-msg p a {font-family:Verdana;}#yiv3050217343 #yiv3050217343ygrp-msg p#yiv3050217343attach-count span {color:#1E66AE;font-weight:700;}#yiv3050217343 #yiv3050217343ygrp-reco #yiv3050217343reco-head {color:#ff7900;font-weight:700;}#yiv3050217343 #yiv3050217343ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ov li a {font-size:130%;text-decoration:none;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3050217343 #yiv3050217343ygrp-sponsor #yiv3050217343ov ul {margin:0;padding:0 0 0 8px;}#yiv3050217343 #yiv3050217343ygrp-text {font-family:Georgia;}#yiv3050217343 #yiv3050217343ygrp-text p {margin:0 0 1em 0;}#yiv3050217343 #yiv3050217343ygrp-text tt {font-size:120%;}#yiv3050217343 #yiv3050217343ygrp-vital ul li:last-child {border-right:none !important;}#yiv3050217343

============================================================
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
---------------------------------------------------------------------
Diposting oleh EXCEL FEED LEARNING di 22.21

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)