حمل مجاناً موسوعة شرح جميع دوال أكسيل باللغة العربية
حمل مجاناً موسوعة شرح جميع دوال أكسيل باللغة العربية
الشرح الكامل لدوال إكسيل Excel
الشرح عبارة عن ملفات وورد كل ملف يحتوي علي شرح دالة بالأمثلة
روابط تحميل الملفات
الجزء الأول
دوال العمليات التلقائية
Automation Functions
http://www.ziddu.com/download/122630...TDATA.doc.html
http://www.ziddu.com/download/12263090/CALL.doc.html
http://www.ziddu.com/download/122630...NVERT.doc.html
http://www.ziddu.com/download/122630...ER.ID.doc.html
http://www.ziddu.com/download/122630...QUEST.doc.html
الجزء الثاني
الدوال الإحصائية
http://www.ziddu.com/download/122835...MDIST.doc.html
http://www.ziddu.com/download/122835...RAGEA.doc.html
http://www.ziddu.com/download/122835...GEIFS.doc.html
http://www.ziddu.com/download/122835...AGEIF.doc.html
http://www.ziddu.com/download/12283569/CHIINV.doc.html
http://www.ziddu.com/download/12283570/BETAINV.doc.html
http://www.ziddu.com/download/122835...ADIST.doc.html
http://www.ziddu.com/download/12283572/CHIDIST.doc.html
http://www.ziddu.com/download/12283573/AVERAGE.doc.html
http://www.ziddu.com/download/12283574/AVEDEV.doc.html
http://www.ziddu.com/download/12283593/COUNTIF.doc.html
http://www.ziddu.com/download/122835...BLANK.doc.html
http://www.ziddu.com/download/122835...BINOM.doc.html
http://www.ziddu.com/download/12283596/COVAR.doc.html
http://www.ziddu.com/download/122835...NTIFS.doc.html
http://www.ziddu.com/download/12283598/COUNTA.doc.html
http://www.ziddu.com/download/122835...DENCE.doc.html
http://www.ziddu.com/download/12283600/COUNT.doc.html
http://www.ziddu.com/download/12283601/CORREL.doc.html
http://www.ziddu.com/download/12283602/CHITEST.doc.html
http://www.ziddu.com/download/122836...ECAST.doc.html
http://www.ziddu.com/download/122836...ERINV.doc.html
http://www.ziddu.com/download/122836...UENCY.doc.html
http://www.ziddu.com/download/12283608/DEVSQ.doc.html
http://www.ziddu.com/download/122836...NDIST.doc.html
http://www.ziddu.com/download/12283610/FINV.doc.html
http://www.ziddu.com/download/12283611/FISHER.doc.html
http://www.ziddu.com/download/12283612/FTEST.doc.html
http://www.ziddu.com/download/12283613/FDIST.doc.html
http://www.ziddu.com/download/122836...ADIST.doc.html
http://www.ziddu.com/download/122836...RCEPT.doc.html
http://www.ziddu.com/download/12283625/GAMMALN.doc.html
http://www.ziddu.com/download/12283626/GEOMEAN.doc.html
http://www.ziddu.com/download/12283627/LARGE.doc.html
http://www.ziddu.com/download/122836...MAINV.doc.html
http://www.ziddu.com/download/12283629/LINEST.doc.html
http://www.ziddu.com/download/12283630/HARMEAN.doc.html
http://www.ziddu.com/download/12283631/KURT.doc.html
http://www.ziddu.com/download/12283632/GROWTH.doc.html
http://www.ziddu.com/download/122836...MDIST.doc.html
http://www.ziddu.com/download/122836...MDIST.doc.html
http://www.ziddu.com/download/12283663/MINA.doc.html
http://www.ziddu.com/download/12283664/MIN.doc.html
http://www.ziddu.com/download/12283665/LOGINV.doc.html
http://www.ziddu.com/download/122836...MDIST.doc.html
http://www.ziddu.com/download/12283667/MAXA.doc.html
http://www.ziddu.com/download/12283668/MODE.doc.html
http://www.ziddu.com/download/122836...MDIST.doc.html
http://www.ziddu.com/download/12283670/MAX.doc.html
http://www.ziddu.com/download/12283671/MEDIAN.doc.html
http://www.ziddu.com/download/12283719/PEARSON.doc.html
http://www.ziddu.com/download/122837...SDIST.doc.html
http://www.ziddu.com/download/12283721/NORMINV.doc.html
http://www.ziddu.com/download/12283722/PERMUT.doc.html
http://www.ziddu.com/download/122837...TRANK.doc.html
http://www.ziddu.com/download/12283724/PROB.doc.html
http://www.ziddu.com/download/122837...NTILE.doc.html
http://www.ziddu.com/download/12283726/POISSON.doc.html
http://www.ziddu.com/download/122837...RTILE.doc.html
http://www.ziddu.com/download/122837...MSINV.doc.html
http://www.ziddu.com/download/12283757/STDEVP.doc.html
http://www.ziddu.com/download/12283758/SKEW.doc.html
http://www.ziddu.com/download/122837...RDIZE.doc.html
http://www.ziddu.com/download/12283760/STDEVPA.doc.html
http://www.ziddu.com/download/12283761/RANK.doc.html
http://www.ziddu.com/download/12283762/STDEVA.doc.html
http://www.ziddu.com/download/12283763/SLOPE.doc.html
http://www.ziddu.com/download/12283764/SMALL.doc.html
http://www.ziddu.com/download/12283765/STDEV.doc.html
http://www.ziddu.com/download/12283766/RSQ.doc.html
http://www.ziddu.com/download/12283773/TINV.doc.html
http://www.ziddu.com/download/12283774/TREND.doc.html
http://www.ziddu.com/download/12283775/TTEST.doc.html
http://www.ziddu.com/download/12283776/VARPA.doc.html
http://www.ziddu.com/download/12283777/VARA.doc.html
http://www.ziddu.com/download/122837...MMEAN.doc.html
http://www.ziddu.com/download/12283779/VAR.doc.html
http://www.ziddu.com/download/12283780/STEYX.doc.html
http://www.ziddu.com/download/12283781/VARP.doc.html
http://www.ziddu.com/download/12283782/TDIST.doc.html
http://www.ziddu.com/download/12283790/WEIBULL.doc.html
http://www.ziddu.com/download/12283791/ZTEST.doc.html
الجزء الثالث
الدوال الرياضية
http://www.ziddu.com/download/12279858/CEILING.doc.html
http://www.ziddu.com/download/12279859/COMBIN.doc.html
http://www.ziddu.com/download/12279860/ASINH.doc.html
http://www.ziddu.com/download/12279861/ABS.doc.html
http://www.ziddu.com/download/12279862/ATAN.doc.html
http://www.ziddu.com/download/12279863/ACOSH.doc.html
http://www.ziddu.com/download/12279864/ATAN2.doc.html
http://www.ziddu.com/download/12279865/ATANH.doc.html
http://www.ziddu.com/download/12279866/ASIN.doc.html
http://www.ziddu.com/download/12279867/ACOS.doc.html
http://www.ziddu.com/download/12279883/EXP.doc.html
http://www.ziddu.com/download/12279884/INT.doc.html
http://www.ziddu.com/download/12279885/COSH.doc.html
http://www.ziddu.com/download/12279886/LCM.doc.html
http://www.ziddu.com/download/12279887/GCD.doc.html
http://www.ziddu.com/download/122798...OUBLE.doc.html
http://www.ziddu.com/download/12279889/FLOOR.doc.html
http://www.ziddu.com/download/12279890/COS.doc.html
http://www.ziddu.com/download/12279891/FACT.doc.html
http://www.ziddu.com/download/12279892/EVEN.doc.html
http://www.ziddu.com/download/12279928/MROUND.doc.html
http://www.ziddu.com/download/12279929/LOG10.doc.html
http://www.ziddu.com/download/12279930/MMULT.doc.html
http://www.ziddu.com/download/12279931/MOD.doc.html
http://www.ziddu.com/download/12279932/LOG.doc.html
http://www.ziddu.com/download/12279933/LN.doc.html
http://www.ziddu.com/download/12279934/MDETERM.doc.html
http://www.ziddu.com/download/122799...VERSE.doc.html
http://www.ziddu.com/download/122799...OMIAL.doc.html
http://www.ziddu.com/download/12279937/ODD.doc.html
http://www.ziddu.com/download/12279956/POWER.doc.html
http://www.ziddu.com/download/12279957/ROMAN.doc.html
http://www.ziddu.com/download/12279958/PRODUCT.doc.html
http://www.ziddu.com/download/12279959/ROUND.doc.html
http://www.ziddu.com/download/12279960/RAND.doc.html
http://www.ziddu.com/download/12279961/RADIANS.doc.html
http://www.ziddu.com/download/122799...TIENT.doc.html
http://www.ziddu.com/download/122799...DDOWN.doc.html
http://www.ziddu.com/download/12279964/PI.doc.html
http://www.ziddu.com/download/122799...TWEEN.doc.html
http://www.ziddu.com/download/12280012/SQRTPI.doc.html
http://www.ziddu.com/download/12280013/ROUNDUP.doc.html
http://www.ziddu.com/download/12280014/SIN.doc.html
http://www.ziddu.com/download/12280015/SUMIF.doc.html
http://www.ziddu.com/download/12280016/SIGN.doc.html
http://www.ziddu.com/download/12280017/SINH.doc.html
http://www.ziddu.com/download/122800...ESSUM.doc.html
http://www.ziddu.com/download/12280019/SQRT.doc.html
http://www.ziddu.com/download/122800...TOTAL.doc.html
http://www.ziddu.com/download/12280021/SUM.doc.html
http://www.ziddu.com/download/122800...X2MY2.doc.html
http://www.ziddu.com/download/12280047/TANH.doc.html
http://www.ziddu.com/download/12280048/TRUNC.doc.html
http://www.ziddu.com/download/12280049/TAN.doc.html
http://www.ziddu.com/download/122800...ODUCT.doc.html
http://www.ziddu.com/download/12280051/SUMSQ.doc.html
http://www.ziddu.com/download/12280052/SUMXMY2.doc.html
http://www.ziddu.com/download/122800...X2PY2.doc.html
http://www.ziddu.com/download/12280054/SUMIFS.doc.html
الجزء الرابع
الدوال المالية
http://www.ziddu.com/download/12277550/PRICE.doc.html
http://www.ziddu.com/download/12277551/PMT.doc.html
http://www.ziddu.com/download/122775...YIELD.doc.html
http://www.ziddu.com/download/122775...DEGRC.doc.html
http://www.ziddu.com/download/122775...EDISC.doc.html
http://www.ziddu.com/download/12277555/ACCRINT.doc.html
http://www.ziddu.com/download/12277556/COUPPCD.doc.html
http://www.ziddu.com/download/122775...RINTM.doc.html
http://www.ziddu.com/download/12277558/ISPMT.doc.html
http://www.ziddu.com/download/122775...ATION.doc.html
http://www.ziddu.com/download/12277605/DISC.doc.html
http://www.ziddu.com/download/12277606/FV.doc.html
http://www.ziddu.com/download/122776...LARFR.doc.html
http://www.ziddu.com/download/12277608/EFFECT.doc.html
http://www.ziddu.com/download/122776...LARDE.doc.html
http://www.ziddu.com/download/122776...EDULE.doc.html
http://www.ziddu.com/download/12277611/IPMT.doc.html
http://www.ziddu.com/download/12277612/LOGEST.doc.html
http://www.ziddu.com/download/12277613/INTRATE.doc.html
http://www.ziddu.com/download/12277614/IRR.doc.html
http://www.ziddu.com/download/12277636/COUPNUM.doc.html
http://www.ziddu.com/download/12277637/DB.doc.html
http://www.ziddu.com/download/12277638/COUPNCD.doc.html
http://www.ziddu.com/download/122776...AYSNC.doc.html
http://www.ziddu.com/download/122776...RLINC.doc.html
http://www.ziddu.com/download/12277641/DDB.doc.html
http://www.ziddu.com/download/122776...PRINC.doc.html
http://www.ziddu.com/download/122776...PDAYS.doc.html
http://www.ziddu.com/download/122776...DAYBS.doc.html
http://www.ziddu.com/download/12277645/CUMIPMT.doc.html
http://www.ziddu.com/download/12277636/COUPNUM.doc.html
http://www.ziddu.com/download/12277637/DB.doc.html
http://www.ziddu.com/download/12277638/COUPNCD.doc.html
http://www.ziddu.com/download/122776...AYSNC.doc.html
http://www.ziddu.com/download/122776...RLINC.doc.html
http://www.ziddu.com/download/12277641/DDB.doc.html
http://www.ziddu.com/download/122776...PRINC.doc.html
http://www.ziddu.com/download/122776...PDAYS.doc.html
http://www.ziddu.com/download/122776...DAYBS.doc.html
http://www.ziddu.com/download/12277645/CUMIPMT.doc.html
http://www.ziddu.com/download/122777...YIELD.doc.html
http://www.ziddu.com/download/12277716/RATE.doc.html
http://www.ziddu.com/download/12277717/SYD.doc.html
http://www.ziddu.com/download/12277718/XIRR.doc.html
http://www.ziddu.com/download/12277719/SLN.doc.html
http://www.ziddu.com/download/12277720/PV.doc.html
http://www.ziddu.com/download/12277721/VDB.doc.html
http://www.ziddu.com/download/122777...EIVED.doc.html
http://www.ziddu.com/download/12277723/TBILLEQ.doc.html
http://www.ziddu.com/download/122777...PRICE.doc.html
http://www.ziddu.com/download/12277761/YIELD.doc.html
http://www.ziddu.com/download/12277762/XNPV.doc.html
http://www.ziddu.com/download/122777...DDISC.doc.html
http://www.ziddu.com/download/122777...LDMAT.doc.html
الجزء الخامس
دوال قواعد البيانات
http://www.ziddu.com/download/12266745/DSUM.doc.html
http://www.ziddu.com/download/12266746/DCOUNT.doc.html
http://www.ziddu.com/download/12266747/DMAX.doc.html
http://www.ziddu.com/download/12266748/DSTDEVP.doc.html
http://www.ziddu.com/download/12266749/DMIN.doc.html
http://www.ziddu.com/download/12266750/DSTDEV.doc.html
http://www.ziddu.com/download/12266751/COUNTA.doc.html
http://www.ziddu.com/download/12266752/DGET.doc.html
http://www.ziddu.com/download/122667...ODUCT.doc.html
http://www.ziddu.com/download/122667...ERAGE.doc.html
http://www.ziddu.com/download/12266876/DVARP.doc.html
http://www.ziddu.com/download/12266877/DVAR.doc.html
الجزء السادس
دوال الوقت و التاريخ
http://www.ziddu.com/download/12267017/MONTH.doc.html
http://www.ziddu.com/download/12267018/EOMONTH.doc.html
http://www.ziddu.com/download/12267019/MINUTE.doc.html
http://www.ziddu.com/download/12267020/DAYS360.doc.html
http://www.ziddu.com/download/122670...VALUE.doc.html
http://www.ziddu.com/download/12267022/DAY.doc.html
http://www.ziddu.com/download/12267023/HOUR.doc.html
http://www.ziddu.com/download/12267024/DATE.doc.html
http://www.ziddu.com/download/12267025/EDATE.doc.html
http://www.ziddu.com/download/122670...KDAYS.doc.html
http://www.ziddu.com/download/12267043/WEEKNUM.doc.html
http://www.ziddu.com/download/12267044/SECOND.doc.html
http://www.ziddu.com/download/12267045/YEAR.doc.html
http://www.ziddu.com/download/12267046/TIME.doc.html
http://www.ziddu.com/download/12267047/NOW.doc.html
http://www.ziddu.com/download/122670...RFRAC.doc.html
http://www.ziddu.com/download/12267049/TODAY.doc.html
http://www.ziddu.com/download/122670...VALUE.doc.html
http://www.ziddu.com/download/12267051/WEEKDAY.doc.html
http://www.ziddu.com/download/12267052/WORKDAY.doc.html
الجزء السابع
الدوال الهندسية
http://www.ziddu.com/download/12267255/DEC2OCT.doc.html
http://www.ziddu.com/download/12267256/DEC2BIN.doc.html
http://www.ziddu.com/download/12267257/DELTA.doc.html
http://www.ziddu.com/download/12267258/BIN2DEC.doc.html
http://www.ziddu.com/download/12267259/BIN2OCT.doc.html
http://www.ziddu.com/download/12267260/COMPLEX.doc.html
http://www.ziddu.com/download/12267261/CONVERT.doc.html
http://www.ziddu.com/download/12267262/ERF.doc.html
http://www.ziddu.com/download/12267263/DEC2HEX.doc.html
http://www.ziddu.com/download/12267264/BIN2HEX.doc.html
http://www.ziddu.com/download/12267294/IMCOS.doc.html
http://www.ziddu.com/download/12267295/IMDIV.doc.html
http://www.ziddu.com/download/12267296/GETSTEP.doc.html
http://www.ziddu.com/download/12267297/HEX2OCT.doc.html
http://www.ziddu.com/download/122672...UMENT.doc.html
http://www.ziddu.com/download/12267299/IMABS.doc.html
http://www.ziddu.com/download/12267300/HEX2BIN.doc.html
http://www.ziddu.com/download/12267301/ERFC.doc.html
http://www.ziddu.com/download/12267302/HEX2DEC.doc.html
http://www.ziddu.com/download/122673...UGATE.doc.html
http://www.ziddu.com/download/12267314/IMREAL.doc.html
http://www.ziddu.com/download/12267315/IMPOWER.doc.html
http://www.ziddu.com/download/12267316/IMEXP.doc.html
http://www.ziddu.com/download/12267317/IMLOG10.doc.html
http://www.ziddu.com/download/12267318/IMLOG2.doc.html
http://www.ziddu.com/download/12267319/IMSQRT.doc.html
http://www.ziddu.com/download/122673...ODUCT.doc.html
http://www.ziddu.com/download/122673...INARY.doc.html
http://www.ziddu.com/download/12267322/IMLN.doc.html
http://www.ziddu.com/download/12267323/IMSIN.doc.html
http://www.ziddu.com/download/12267332/OCT2BIN.doc.html
http://www.ziddu.com/download/12267333/IMSUB.doc.html
http://www.ziddu.com/download/12267334/OCT2HEX.doc.html
http://www.ziddu.com/download/12267335/IMSUM.doc.html
http://www.ziddu.com/download/12267336/OCT2DEC.doc.html
الجزء الثامن
دوال المعلومات
http://www.ziddu.com/download/12277943/IS.doc.html
http://www.ziddu.com/download/12277944/ISEVEN.doc.html
http://www.ziddu.com/download/12277945/TYPE.doc.html
http://www.ziddu.com/download/12277946/CELL.doc.html
http://www.ziddu.com/download/12277947/N.doc.html
http://www.ziddu.com/download/12277948/NA.doc.html
http://www.ziddu.com/download/122779....TYPE.doc.html
http://www.ziddu.com/download/12277950/INFO.doc.html
http://www.ziddu.com/download/12277951/ISODD.doc.html
الرئيسية 
