الويب العربي - حمل شرح جميع دوال أكسيل Excel

الشرح الكامل لدوال إكسيل 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