Tecnologia, programação e muito Visual FoxPro.

quinta-feira, 19 de agosto de 2010

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.


__._,_.___
Recent Activity:
+-:: 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              |
+-------------------------------------------------------------------+
.

__,_._,___

Nenhum comentário:

Arquivo do blog