[المصممم]

الشرح الكامل لدوال إكسيل Excel
الشرح عبارة عن ملفات وورد كل ملف يحتوي علي شرح دالة بالأمثلة

روابط تحميل الملفات

الجزء الأول
دوال العمليات التلقائية
Automation Functions

http://www.ziddu.com/download/122630...AT A.doc.html
http://www.ziddu.com/download/12263090/CALL.doc.ht ml
http://www.ziddu.com/download/122630...ERT .doc.html
http://www.ziddu.com/download/122630....ID .doc.html
http://www.ziddu.com/download/122630...EST .doc.html


الجزء الثاني
الدوال الإحصائية
http://www.ziddu.com/download/122835...IST.d oc.html
http://www.ziddu.com/download/122835...GEA.do c.html
http://www.ziddu.com/download/122835...IFS. doc.html
http://www.ziddu.com/download/122835...EIF.d oc.html
http://www.ziddu.com/download/122835...INV.doc. html
http://www.ziddu.com/download/122835...INV.doc .html
http://www.ziddu.com/download/122835...IST.do c.html
http://www.ziddu.com/download/122835...IST.doc .html
http://www.ziddu.com/download/122835...AGE.doc .html
http://www.ziddu.com/download/122835...DEV.doc. html
http://www.ziddu.com/download/122835...TIF.doc .html
http://www.ziddu.com/download/122835...ANK. doc.html
http://www.ziddu.com/download/122835...NOM.d oc.html
http://www.ziddu.com/download/12283596/COVAR.doc.h tml
http://www.ziddu.com/download/122835...IFS.do c.html
http://www.ziddu.com/download/122835...NTA.doc. html
http://www.ziddu.com/download/122835...NCE. doc.html
http://www.ziddu.com/download/12283600/COUNT.doc.h tml
http://www.ziddu.com/download/122836...REL.doc. html
http://www.ziddu.com/download/122836...EST.doc .html
http://www.ziddu.com/download/122836...AST.do c.html
http://www.ziddu.com/download/122836...INV.d oc.html
http://www.ziddu.com/download/122836...NCY.d oc.html
http://www.ziddu.com/download/12283608/DEVSQ.doc.h tml
http://www.ziddu.com/download/122836...IST.d oc.html
http://www.ziddu.com/download/12283610/FINV.doc.ht ml
http://www.ziddu.com/download/122836...HER.doc. html
http://www.ziddu.com/download/12283612/FTEST.doc.h tml
http://www.ziddu.com/download/12283613/FDIST.doc.h tml
http://www.ziddu.com/download/122836...IST.d oc.html
http://www.ziddu.com/download/122836...EPT.d oc.html
http://www.ziddu.com/download/122836...ALN.doc .html
http://www.ziddu.com/download/122836...EAN.doc .html
http://www.ziddu.com/download/12283627/LARGE.doc.h tml
http://www.ziddu.com/download/122836...INV.do c.html
http://www.ziddu.com/download/122836...EST.doc. html
http://www.ziddu.com/download/122836...EAN.doc .html
http://www.ziddu.com/download/12283631/KURT.doc.ht ml
http://www.ziddu.com/download/122836...WTH.doc. html
http://www.ziddu.com/download/122836...IST .doc.html
http://www.ziddu.com/download/122836...IS T.doc.html
http://www.ziddu.com/download/12283663/MINA.doc.ht ml
http://www.ziddu.com/download/12283664/MIN.doc.htm l
http://www.ziddu.com/download/122836...INV.doc. html
http://www.ziddu.com/download/122836...IST .doc.html
http://www.ziddu.com/download/12283667/MAXA.doc.ht ml
http://www.ziddu.com/download/12283668/MODE.doc.ht ml
http://www.ziddu.com/download/122836...IST.do c.html
http://www.ziddu.com/download/12283670/MAX.doc.htm l
http://www.ziddu.com/download/122836...IAN.doc. html
http://www.ziddu.com/download/122837...SON.doc .html
http://www.ziddu.com/download/122837...IST.d oc.html
http://www.ziddu.com/download/122837...INV.doc .html
http://www.ziddu.com/download/122837...MUT.doc. html
http://www.ziddu.com/download/122837...ANK .doc.html
http://www.ziddu.com/download/12283724/PROB.doc.ht ml
http://www.ziddu.com/download/122837...ILE. doc.html
http://www.ziddu.com/download/122837...SON.doc .html
http://www.ziddu.com/download/122837...ILE.do c.html
http://www.ziddu.com/download/122837...INV.do c.html
http://www.ziddu.com/download/122837...EVP.doc. html
http://www.ziddu.com/download/12283758/SKEW.doc.ht ml
http://www.ziddu.com/download/122837...IZE .doc.html
http://www.ziddu.com/download/122837...VPA.doc .html
http://www.ziddu.com/download/12283761/RANK.doc.ht ml
http://www.ziddu.com/download/122837...EVA.doc. html
http://www.ziddu.com/download/12283763/SLOPE.doc.h tml
http://www.ziddu.com/download/12283764/SMALL.doc.h tml
http://www.ziddu.com/download/12283765/STDEV.doc.h tml
http://www.ziddu.com/download/12283766/RSQ.doc.htm l
http://www.ziddu.com/download/12283773/TINV.doc.ht ml
http://www.ziddu.com/download/12283774/TREND.doc.h tml
http://www.ziddu.com/download/12283775/TTEST.doc.h tml
http://www.ziddu.com/download/12283776/VARPA.doc.h tml
http://www.ziddu.com/download/12283777/VARA.doc.ht ml
http://www.ziddu.com/download/122837...EAN.do c.html
http://www.ziddu.com/download/12283779/VAR.doc.htm l
http://www.ziddu.com/download/12283780/STEYX.doc.h tml
http://www.ziddu.com/download/12283781/VARP.doc.ht ml
http://www.ziddu.com/download/12283782/TDIST.doc.h tml
http://www.ziddu.com/download/122837...ULL.doc .html
http://www.ziddu.com/download/12283791/ZTEST.doc.h tml



الجزء الثالث
الدوال الرياضية
http://www.ziddu.com/download/122798...ING.doc .html
http://www.ziddu.com/download/122798...BIN.doc. html
http://www.ziddu.com/download/12279860/ASINH.doc.h tml
http://www.ziddu.com/download/12279861/ABS.doc.htm l
http://www.ziddu.com/download/12279862/ATAN.doc.ht ml
http://www.ziddu.com/download/12279863/ACOSH.doc.h tml
http://www.ziddu.com/download/12279864/ATAN2.doc.h tml
http://www.ziddu.com/download/12279865/ATANH.doc.h tml
http://www.ziddu.com/download/12279866/ASIN.doc.ht ml
http://www.ziddu.com/download/12279867/ACOS.doc.ht ml
http://www.ziddu.com/download/12279883/EXP.doc.htm l
http://www.ziddu.com/download/12279884/INT.doc.htm l
http://www.ziddu.com/download/12279885/COSH.doc.ht ml
http://www.ziddu.com/download/12279886/LCM.doc.htm l
http://www.ziddu.com/download/12279887/GCD.doc.htm l
http://www.ziddu.com/download/122798...BLE. doc.html
http://www.ziddu.com/download/12279889/FLOOR.doc.h tml
http://www.ziddu.com/download/12279890/COS.doc.htm l
http://www.ziddu.com/download/12279891/FACT.doc.ht ml
http://www.ziddu.com/download/12279892/EVEN.doc.ht ml
http://www.ziddu.com/download/122799...UND.doc. html
http://www.ziddu.com/download/12279929/LOG10.doc.h tml
http://www.ziddu.com/download/12279930/MMULT.doc.h tml
http://www.ziddu.com/download/12279931/MOD.doc.htm l
http://www.ziddu.com/download/12279932/LOG.doc.htm l
http://www.ziddu.com/download/12279933/LN.doc.html
http://www.ziddu.com/download/122799...ERM.doc .html
http://www.ziddu.com/download/122799...RSE.do c.html
http://www.ziddu.com/download/122799...IAL .doc.html
http://www.ziddu.com/download/12279937/ODD.doc.htm l
http://www.ziddu.com/download/12279956/POWER.doc.h tml
http://www.ziddu.com/download/12279957/ROMAN.doc.h tml
http://www.ziddu.com/download/122799...UCT.doc .html
http://www.ziddu.com/download/12279959/ROUND.doc.h tml
http://www.ziddu.com/download/12279960/RAND.doc.ht ml
http://www.ziddu.com/download/122799...ANS.doc .html
http://www.ziddu.com/download/122799...ENT.do c.html
http://www.ziddu.com/download/122799...OWN.d oc.html
http://www.ziddu.com/download/12279964/PI.doc.html
http://www.ziddu.com/download/122799...EEN .doc.html
http://www.ziddu.com/download/122800...TPI.doc. html
http://www.ziddu.com/download/122800...DUP.doc .html
http://www.ziddu.com/download/12280014/SIN.doc.htm l
http://www.ziddu.com/download/12280015/SUMIF.doc.h tml
http://www.ziddu.com/download/12280016/SIGN.doc.ht ml
http://www.ziddu.com/download/12280017/SINH.doc.ht ml
http://www.ziddu.com/download/122800...SUM.d oc.html
http://www.ziddu.com/download/12280019/SQRT.doc.ht ml
http://www.ziddu.com/download/122800...TAL.do c.html
http://www.ziddu.com/download/12280021/SUM.doc.htm l
http://www.ziddu.com/download/122800...MY2.do c.html
http://www.ziddu.com/download/12280047/TANH.doc.ht ml
http://www.ziddu.com/download/12280048/TRUNC.doc.h tml
http://www.ziddu.com/download/12280049/TAN.doc.htm l
http://www.ziddu.com/download/122800...UCT. doc.html
http://www.ziddu.com/download/12280051/SUMSQ.doc.h tml
http://www.ziddu.com/download/122800...MY2.doc .html
http://www.ziddu.com/download/122800...PY2.do c.html
http://www.ziddu.com/download/122800...IFS.doc. html





الجزء الرابع
الدوال المالية
http://www.ziddu.com/download/12277550/PRICE.doc.h tml
http://www.ziddu.com/download/12277551/PMT.doc.htm l
http://www.ziddu.com/download/122775...ELD.d oc.html
http://www.ziddu.com/download/122775...GRC.d oc.html
http://www.ziddu.com/download/122775...ISC.d oc.html
http://www.ziddu.com/download/122775...INT.doc .html
http://www.ziddu.com/download/122775...PCD.doc .html
http://www.ziddu.com/download/122775...NTM.do c.html
http://www.ziddu.com/download/12277558/ISPMT.doc.h tml
http://www.ziddu.com/download/122775...ION.do c.html
http://www.ziddu.com/download/12277605/DISC.doc.ht ml
http://www.ziddu.com/download/12277606/FV.doc.html
http://www.ziddu.com/download/122776...RFR.do c.html
http://www.ziddu.com/download/122776...ECT.doc. html
http://www.ziddu.com/download/122776...RDE.do c.html
http://www.ziddu.com/download/122776...ULE. doc.html
http://www.ziddu.com/download/12277611/IPMT.doc.ht ml
http://www.ziddu.com/download/122776...EST.doc. html
http://www.ziddu.com/download/122776...ATE.doc .html
http://www.ziddu.com/download/12277614/IRR.doc.htm l
http://www.ziddu.com/download/122776...NUM.doc .html
http://www.ziddu.com/download/12277637/DB.doc.html
http://www.ziddu.com/download/122776...NCD.doc .html
http://www.ziddu.com/download/122776...SNC. doc.html
http://www.ziddu.com/download/122776...INC.do c.html
http://www.ziddu.com/download/12277641/DDB.doc.htm l
http://www.ziddu.com/download/122776...INC.do c.html
http://www.ziddu.com/download/122776...AYS.do c.html
http://www.ziddu.com/download/122776...YBS.d oc.html
http://www.ziddu.com/download/122776...PMT.doc .html
http://www.ziddu.com/download/122776...NUM.doc .html
http://www.ziddu.com/download/12277637/DB.doc.html
http://www.ziddu.com/download/122776...NCD.doc .html
http://www.ziddu.com/download/122776...SNC. doc.html
http://www.ziddu.com/download/122776...INC.do c.html
http://www.ziddu.com/download/12277641/DDB.doc.htm l
http://www.ziddu.com/download/122776...INC.do c.html
http://www.ziddu.com/download/122776...AYS.do c.html
http://www.ziddu.com/download/122776...YBS.d oc.html
http://www.ziddu.com/download/122776...PMT.doc .html
http://www.ziddu.com/download/122777...ELD. doc.html
http://www.ziddu.com/download/12277716/RATE.doc.ht ml
http://www.ziddu.com/download/12277717/SYD.doc.htm l
http://www.ziddu.com/download/12277718/XIRR.doc.ht ml
http://www.ziddu.com/download/12277719/SLN.doc.htm l
http://www.ziddu.com/download/12277720/PV.doc.html
http://www.ziddu.com/download/12277721/VDB.doc.htm l
http://www.ziddu.com/download/122777...VED.do c.html
http://www.ziddu.com/download/122777...LEQ.doc .html
http://www.ziddu.com/download/122777...ICE. doc.html
http://www.ziddu.com/download/12277761/YIELD.doc.h tml
http://www.ziddu.com/download/12277762/XNPV.doc.ht ml
http://www.ziddu.com/download/122777...ISC.d oc.html
http://www.ziddu.com/download/122777...MAT.do c.html



الجزء الخامس
دوال قواعد البيانات
http://www.ziddu.com/download/12266745/DSUM.doc.ht ml
http://www.ziddu.com/download/122667...UNT.doc. html
http://www.ziddu.com/download/12266747/DMAX.doc.ht ml
http://www.ziddu.com/download/122667...EVP.doc .html
http://www.ziddu.com/download/12266749/DMIN.doc.ht ml
http://www.ziddu.com/download/122667...DEV.doc. html
http://www.ziddu.com/download/122667...NTA.doc. html
http://www.ziddu.com/download/12266752/DGET.doc.ht ml
http://www.ziddu.com/download/122667...UCT.do c.html
http://www.ziddu.com/download/122667...AGE.do c.html
http://www.ziddu.com/download/12266876/DVARP.doc.h tml
http://www.ziddu.com/download/12266877/DVAR.doc.ht ml






الجزء السادس
دوال الوقت و التاريخ
http://www.ziddu.com/download/12267017/MONTH.doc.h tml
http://www.ziddu.com/download/122670...NTH.doc .html
http://www.ziddu.com/download/122670...UTE.doc. html
http://www.ziddu.com/download/122670...360.doc .html
http://www.ziddu.com/download/122670...LUE.d oc.html
http://www.ziddu.com/download/12267022/DAY.doc.htm l
http://www.ziddu.com/download/12267023/HOUR.doc.ht ml
http://www.ziddu.com/download/12267024/DATE.doc.ht ml
http://www.ziddu.com/download/12267025/EDATE.doc.h tml
http://www.ziddu.com/download/122670...AYS .doc.html
http://www.ziddu.com/download/122670...NUM.doc .html
http://www.ziddu.com/download/122670...OND.doc. html
http://www.ziddu.com/download/12267045/YEAR.doc.ht ml
http://www.ziddu.com/download/12267046/TIME.doc.ht ml
http://www.ziddu.com/download/12267047/NOW.doc.htm l
http://www.ziddu.com/download/122670...RAC.do c.html
http://www.ziddu.com/download/12267049/TODAY.doc.h tml
http://www.ziddu.com/download/122670...LUE.d oc.html
http://www.ziddu.com/download/122670...DAY.doc .html
http://www.ziddu.com/download/122670...DAY.doc .html





الجزء السابع
الدوال الهندسية
http://www.ziddu.com/download/122672...OCT.doc .html
http://www.ziddu.com/download/122672...BIN.doc .html
http://www.ziddu.com/download/12267257/DELTA.doc.h tml
http://www.ziddu.com/download/122672...DEC.doc .html
http://www.ziddu.com/download/122672...OCT.doc .html
http://www.ziddu.com/download/122672...LEX.doc .html
http://www.ziddu.com/download/122672...ERT.doc .html
http://www.ziddu.com/download/12267262/ERF.doc.htm l
http://www.ziddu.com/download/122672...HEX.doc .html
http://www.ziddu.com/download/122672...HEX.doc .html
http://www.ziddu.com/download/12267294/IMCOS.doc.h tml
http://www.ziddu.com/download/12267295/IMDIV.doc.h tml
http://www.ziddu.com/download/122672...TEP.doc .html
http://www.ziddu.com/download/122672...OCT.doc .html
http://www.ziddu.com/download/122672...ENT. doc.html
http://www.ziddu.com/download/12267299/IMABS.doc.h tml
http://www.ziddu.com/download/122673...BIN.doc .html
http://www.ziddu.com/download/12267301/ERFC.doc.ht ml
http://www.ziddu.com/download/122673...DEC.doc .html
http://www.ziddu.com/download/122673...ATE .doc.html
http://www.ziddu.com/download/122673...EAL.doc. html
http://www.ziddu.com/download/122673...WER.doc .html
http://www.ziddu.com/download/12267316/IMEXP.doc.h tml
http://www.ziddu.com/download/122673...G10.doc .html
http://www.ziddu.com/download/122673...OG2.doc. html
http://www.ziddu.com/download/122673...QRT.doc. html
http://www.ziddu.com/download/122673...UCT.d oc.html
http://www.ziddu.com/download/122673...ARY.d oc.html
http://www.ziddu.com/download/12267322/IMLN.doc.ht ml
http://www.ziddu.com/download/12267323/IMSIN.doc.h tml
http://www.ziddu.com/download/122673...BIN.doc .html
http://www.ziddu.com/download/12267333/IMSUB.doc.h tml
http://www.ziddu.com/download/122673...HEX.doc .html
http://www.ziddu.com/download/12267335/IMSUM.doc.h tml
http://www.ziddu.com/download/122673...DEC.doc .html


الجزء الثامن
دوال المعلومات
http://www.ziddu.com/download/12277943/IS.doc.html
http://www.ziddu.com/download/122779...VEN.doc. html
http://www.ziddu.com/download/12277945/TYPE.doc.ht ml
http://www.ziddu.com/download/12277946/CELL.doc.ht ml
http://www.ziddu.com/download/12277947/N.doc.html
http://www.ziddu.com/download/12277948/NA.doc.html
http://www.ziddu.com/download/122779...YPE. doc.html
http://www.ziddu.com/download/12277950/INFO.doc.ht ml
http://www.ziddu.com/download/12277951/ISODD.doc.h tml


الجزء التاسع
الدوال المنطقية
http://www.ziddu.com/download/12278132/IF.doc.html
http://www.ziddu.com/download/122781...ROR.doc .html
http://www.ziddu.com/download/12278134/AND.doc.htm l
http://www.ziddu.com/download/12278135/OR.doc.html
http://www.ziddu.com/download/12278136/NOT.doc.htm l
http://www.ziddu.com/download/12278137/FALSE.doc.h tml
http://www.ziddu.com/download/12278138/TRUE.doc.ht ml




الجزء العاشر
دوال البحث
http://www.ziddu.com/download/122793...UMN.doc. html
http://www.ziddu.com/download/122793...KUP.doc .html
http://www.ziddu.com/download/122793...MNS.doc .html
http://www.ziddu.com/download/12279382/AREAS.doc.h tml
http://www.ziddu.com/download/122793...ECT.do c.html
http://www.ziddu.com/download/12279384/INDEX.doc.h tml
http://www.ziddu.com/download/122793...KUP.doc. html
http://www.ziddu.com/download/122793...INK.d oc.html
http://www.ziddu.com/download/122793...ESS.doc .html
http://www.ziddu.com/download/122793...OSE.doc. html
http://www.ziddu.com/download/122794...SET.doc. html
http://www.ziddu.com/download/12279416/RTD.doc.htm l
http://www.ziddu.com/download/122794...OSE.d oc.html
http://www.ziddu.com/download/122794...KUP.doc .html
http://www.ziddu.com/download/12279419/MATCH.doc.h tml
http://www.ziddu.com/download/12279420/ROWS.doc.ht ml
http://www.ziddu.com/download/12279421/ROW.doc.htm l



الجزء الحادي عشر
دوال النصوص
http://www.ziddu.com/download/12283816/CODE.doc.ht ml
http://www.ziddu.com/download/12283817/CHAR.doc.ht ml
http://www.ziddu.com/download/122838...LAR.doc. html
http://www.ziddu.com/download/122838...NDB.d oc.html
http://www.ziddu.com/download/122838...EXT.do c.html
http://www.ziddu.com/download/122838...ATE .doc.html
http://www.ziddu.com/download/12283822/ASC.doc.htm l
http://www.ziddu.com/download/12283823/FIXED.doc.h tml
http://www.ziddu.com/download/12283824/EXACT.doc.h tml
http://www.ziddu.com/download/12283825/CLEAN.doc.h tml
http://www.ziddu.com/download/12283851/REPT.doc.ht ml
http://www.ziddu.com/download/12283852/JIS.doc.htm l
http://www.ziddu.com/download/122838...PER.doc. html
http://www.ziddu.com/download/122838... ACEB.doc.html
http://www.ziddu.com/download/12283855/LOWER.doc.h tml
http://www.ziddu.com/download/122838...HTB .doc.html
http://www.ziddu.com/download/122838...TIC.do c.html
http://www.ziddu.com/download/122838...IDB.doc .html
http://www.ziddu.com/download/122838...FTB.d oc.html
http://www.ziddu.com/download/122838...ENB.doc .html
http://www.ziddu.com/download/122846...UTE. doc.html
http://www.ziddu.com/download/12284668/TRIM.doc.ht ml
http://www.ziddu.com/download/122846...C HB.doc.html
http://www.ziddu.com/download/12284670/T.doc.html
http://www.ziddu.com/download/12284671/UPPER.doc.h tml
http://www.ziddu.com/download/12284672/value.doc.h tml
http://www.ziddu.com/download/12284673/TEXT.doc.ht ml




الجزء الثاني عشر
دوال المكعب
http://www.ziddu.com/download/122666...BER.d oc.html
http://www.ziddu.com/download/122666...SET.doc .html
http://www.ziddu.com/download/122666...LUE.d oc.html
http://www.ziddu.com/download/122666...PERTY.doc.html
http://www.ziddu.com/download/122666...EMBER.doc.html
http://www.ziddu.com/download/122666...UN T.doc.html
http://www.ziddu.com/download/122666...B ER.doc.html

[soft4tech]

بارك الله فيك اخي