منتدى يهتم بشؤون التعليم ويربط بين المدرسة والبيت
أهلا بك زائرنا الكريم يشرفنا انضمامك للمنتدى
شرفنا كبير بالتواصل معنا قصد الإفادة والاستفادة
من فضلك قم بالتسجيل

منتدى يهتم بشؤون التعليم ويربط بين المدرسة والبيت

منتدى تربوي تعليمي
 
البوابةالبوابة  الرئيسيةالرئيسية  اليوميةاليومية  س .و .جس .و .ج  بحـثبحـث  المجموعاتالمجموعات  التسجيلالتسجيل  دخولدخول  زيارتك تسرنا وتسجيلكمعنا ينفعنازيارتك تسرنا وتسجيلكمعنا ينفعنا  

شاطر | 
 

 حمل موسوعة شرح جميع دوال أكسيل باللغة العربية

استعرض الموضوع السابق استعرض الموضوع التالي اذهب الى الأسفل 
كاتب الموضوعرسالة
الأستاذ:نورالدين قروي
المدير العام
المدير العام
avatar

عدد المساهمات : 724
تاريخ التسجيل : 19/11/2011

مُساهمةموضوع: حمل موسوعة شرح جميع دوال أكسيل باللغة العربية    الجمعة 27 أبريل 2012, 12:33

حمل موسوعة شرح جميع دوال أكسيل باللغة العربية















حمل موسوعة شرح جميع دوال أكسيل باللغة العربية

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


الجزء التاسع
الدوال المنطقية
http://www.ziddu.com/download/12278132/IF.doc.html
http://www.ziddu.com/download/12278133/IFERROR.doc.html
http://www.ziddu.com/download/12278134/AND.doc.html
http://www.ziddu.com/download/12278135/OR.doc.html
http://www.ziddu.com/download/12278136/NOT.doc.html
http://www.ziddu.com/download/12278137/FALSE.doc.html
http://www.ziddu.com/download/12278138/TRUE.doc.html




الجزء العاشر
دوال البحث
http://www.ziddu.com/download/12279379/COLUMN.doc.html
http://www.ziddu.com/download/12279380/HLOOKUP.doc.html
http://www.ziddu.com/download/12279381/COLUMNS.doc.html
http://www.ziddu.com/download/12279382/AREAS.doc.html
http://www.ziddu.com/download/122793...IRECT.doc.html
http://www.ziddu.com/download/12279384/INDEX.doc.html
http://www.ziddu.com/download/12279385/LOOKUP.doc.html
http://www.ziddu.com/download/122793...RLINK.doc.html
http://www.ziddu.com/download/12279387/ADDRESS.doc.html
http://www.ziddu.com/download/12279388/CHOOSE.doc.html
http://www.ziddu.com/download/12279415/OFFSET.doc.html
http://www.ziddu.com/download/12279416/RTD.doc.html
http://www.ziddu.com/download/122794...SPOSE.doc.html
http://www.ziddu.com/download/12279418/VLOOKUP.doc.html
http://www.ziddu.com/download/12279419/MATCH.doc.html
http://www.ziddu.com/download/12279420/ROWS.doc.html
http://www.ziddu.com/download/12279421/ROW.doc.html



الجزء الحادي عشر
دوال النصوص
http://www.ziddu.com/download/12283816/CODE.doc.html
http://www.ziddu.com/download/12283817/CHAR.doc.html
http://www.ziddu.com/download/12283818/DOLLAR.doc.html
http://www.ziddu.com/download/122838...FINDB.doc.html
http://www.ziddu.com/download/122838...*****.doc.html
http://www.ziddu.com/download/122838...ENATE.doc.html
http://www.ziddu.com/download/12283822/ASC.doc.html
http://www.ziddu.com/download/12283823/FIXED.doc.html
http://www.ziddu.com/download/12283824/EXACT.doc.html
http://www.ziddu.com/download/12283825/CLEAN.doc.html
http://www.ziddu.com/download/12283851/REPT.doc.html
http://www.ziddu.com/download/12283852/JIS.doc.html
http://www.ziddu.com/download/12283853/PROPER.doc.html
http://www.ziddu.com/download/122838...LACEB.doc.html
http://www.ziddu.com/download/12283855/LOWER.doc.html
http://www.ziddu.com/download/122838...IGHTB.doc.html
http://www.ziddu.com/download/122838...NETIC.doc.html
http://www.ziddu.com/download/12283858/MIDMIDB.doc.html
http://www.ziddu.com/download/122838...LEFTB.doc.html
http://www.ziddu.com/download/12283860/LENLENB.doc.html
http://www.ziddu.com/download/122846...ITUTE.doc.html
http://www.ziddu.com/download/12284668/TRIM.doc.html
http://www.ziddu.com/download/122846...ARCHB.doc.html
http://www.ziddu.com/download/12284670/T.doc.html
http://www.ziddu.com/download/12284671/UPPER.doc.html
http://www.ziddu.com/download/12284672/value.doc.html
http://www.ziddu.com/download/122846...*****.doc.html




الجزء الثاني عشر
دوال المكعب
http://www.ziddu.com/download/122666...EMBER.doc.html
http://www.ziddu.com/download/12266612/CUBESET.doc.html
http://www.ziddu.com/download/122666...VALUE.doc.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...COUNT.doc.html
http://www.ziddu.com/download/122666...EMBER.doc.html

ــــــــــــــــــــــ











" />
الرجوع الى أعلى الصفحة اذهب الى الأسفل
معاينة صفحة البيانات الشخصي للعضو http://nore.alamountada.com
 
حمل موسوعة شرح جميع دوال أكسيل باللغة العربية
استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1

صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
منتدى يهتم بشؤون التعليم ويربط بين المدرسة والبيت :: برامج الحاسب الآلي :: برامج الأوفيس-
انتقل الى: