Re: ]] XL-mania [[ insert fungsi antar PC

 

excel 2003
menu > Tools > Add Ins...  Aktifkan Add-In "Analysis ToolPak"

Analysis tool tidak hanya menambah fungsi WORKDAY saja, ini daftarnya

nama fungsi	kategori
EDATE	Date & Time
EOMONTH	Date & Time
NETWORKDAYS	Date & Time
WEEKNUM	Date & Time
WORKDAY	Date & Time
YEARFRAC	Date & Time
BESSELI	Engineering
BESSELJ	Engineering
BESSELK	Engineering
BESSELY	Engineering
BIN2DEC	Engineering
BIN2HEX	Engineering
BIN2OCT	Engineering
COMPLEX	Engineering
CONVERT	Engineering
DEC2BIN	Engineering
DEC2HEX	Engineering
DEC2OCT	Engineering
DELTA	Engineering
ERF	Engineering
ERFC	Engineering
GESTEP	Engineering
HEX2BIN	Engineering
HEX2DEC	Engineering
HEX2OCT	Engineering
IMABS	Engineering
IMAGINARY	Engineering
IMARGUMENT	Engineering
IMCONJUGATE	Engineering
IMCOS	Engineering
IMDIV	Engineering
IMEXP	Engineering
IMLN	Engineering
IMLOG10	Engineering
IMLOG2	Engineering
IMPOWER	Engineering
IMPRODUCT	Engineering
IMREAL	Engineering
IMSIN	Engineering
IMSQRT	Engineering
IMSUB	Engineering
IMSUM	Engineering
OCT2BIN	Engineering
OCT2DEC	Engineering
OCT2HEX	Engineering
ACCRINT	Financial
ACCRINTM	Financial
AMORDEGRC	Financial
AMORLINC	Financial
COUPDAYBS	Financial
COUPDAYS	Financial
COUPDAYSNC	Financial
COUPNCD	Financial
COUPNUM	Financial
COUPPCD	Financial
CUMIPMT	Financial
CUMPRINC	Financial
DISC	Financial
DOLLARDE	Financial
DOLLARFR	Financial
DURATION	Financial
EFFECT	Financial
FVSCHEDULE	Financial
INTRATE	Financial
MDURATION	Financial
NOMINAL	Financial
ODDFPRICE	Financial
ODDFYIELD	Financial
ODDLPRICE	Financial
ODDLYIELD	Financial
PRICE	Financial
PRICEDISC	Financial
PRICEMAT	Financial
RECEIVED	Financial
TBILLEQ	Financial
TBILLPRICE	Financial
TBILLYIELD	Financial
XIRR	Financial
XNPV	Financial
YIELD	Financial
YIELDDISC	Financial
YIELDMAT	Financial
ISEVEN	Information
ISODD	Information
FACTDOUBLE	Math & Trigonometry
GCD	Math & Trigonometry
LCM	Math & Trigonometry
MROUND	Math & Trigonometry
MULTINOMIAL	Math & Trigonometry
QUOTIENT	Math & Trigonometry
RANDBETWEEN	Math & Trigonometry
SERIESSUM	Math & Trigonometry
SQRTPI	Math & Trigonometry

2010/8/18 ppic.pkm <ppic.pkm@toto.co.id>

Para Excel Mania,

Bagaimana setting agar fungsi workday seperti yang tampil di PC user B juga bisa tampil di PC user A?

Terima kasih.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 104

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| selamat menunaikan ibadah puasa... walau perut lapar, tanya excel |
| jalan terus... malu bertanya telat pulang kantor :D :D :D         |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___