المصممم قام بنشر November 8, 2010 قام بنشر November 8, 2010 الشرح الكامل لدوال إكسيل Excel الشرح عبارة عن ملفات وورد كل ملف يحتوي علي شرح دالة بالأمثلة روابط تحميل الملفات الجزء الأول دوال العمليات التلقائية Automation Functions http://www.ziddu.com/download/12263089/GETPIVOTDATA.doc.html http://www.ziddu.com/download/12263090/CALL.doc.html http://www.ziddu.com/download/12263091/EUROCONVERT.doc.html http://www.ziddu.com/download/12263092/REGISTER.ID.doc.html http://www.ziddu.com/download/12263093/SQL.REQUEST.doc.html الجزء الثاني الدوال الإحصائية http://www.ziddu.com/download/12283565/BINOMDIST.doc.html http://www.ziddu.com/download/12283566/AVERAGEA.doc.html http://www.ziddu.com/download/12283567/AVERAGEIFS.doc.html http://www.ziddu.com/download/12283568/AVERAGEIF.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/12283571/BETADIST.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/12283594/COUNTBLANK.doc.html http://www.ziddu.com/download/12283595/CRITBINOM.doc.html http://www.ziddu.com/download/12283596/COVAR.doc.html http://www.ziddu.com/download/12283597/COUNTIFS.doc.html http://www.ziddu.com/download/12283598/COUNTA.doc.html http://www.ziddu.com/download/12283599/CONFIDENCE.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/12283605/FORECAST.doc.html http://www.ziddu.com/download/12283606/FISHERINV.doc.html http://www.ziddu.com/download/12283607/FREQUENCY.doc.html http://www.ziddu.com/download/12283608/DEVSQ.doc.html http://www.ziddu.com/download/12283609/EXPONDIST.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/12283614/GAMMADIST.doc.html http://www.ziddu.com/download/12283624/INTERCEPT.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/12283628/GAMMAINV.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/12283633/HYPGEOMDIST.doc.html http://www.ziddu.com/download/12283662/NEGBINOMDIST.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/12283666/LOGNORMDIST.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/12283669/NORMDIST.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/12283720/NORMSDIST.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/12283723/PERCENTRANK.doc.html http://www.ziddu.com/download/12283724/PROB.doc.html http://www.ziddu.com/download/12283725/PERCENTILE.doc.html http://www.ziddu.com/download/12283726/POISSON.doc.html http://www.ziddu.com/download/12283727/QUARTILE.doc.html http://www.ziddu.com/download/12283728/NORMSINV.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/12283759/STANDARDIZE.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/12283778/TRIMMEAN.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/12279888/FACTDOUBLE.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/12279935/MINVERSE.doc.html http://www.ziddu.com/download/12279936/MULTINOMIAL.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/12279962/QUOTIENT.doc.html http://www.ziddu.com/download/12279963/ROUNDDOWN.doc.html http://www.ziddu.com/download/12279964/PI.doc.html http://www.ziddu.com/download/12279965/RANDBETWEEN.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/12280018/SERIESSUM.doc.html http://www.ziddu.com/download/12280019/SQRT.doc.html http://www.ziddu.com/download/12280020/SUBTOTAL.doc.html http://www.ziddu.com/download/12280021/SUM.doc.html http://www.ziddu.com/download/12280046/SUMX2MY2.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/12280050/SUMPRODUCT.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/12280053/SUMX2PY2.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/12277552/ODDFYIELD.doc.html http://www.ziddu.com/download/12277553/AMORDEGRC.doc.html http://www.ziddu.com/download/12277554/PRICEDISC.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/12277557/ACCRINTM.doc.html http://www.ziddu.com/download/12277558/ISPMT.doc.html http://www.ziddu.com/download/12277559/DURATION.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/12277607/DOLLARFR.doc.html http://www.ziddu.com/download/12277608/EFFECT.doc.html http://www.ziddu.com/download/12277609/DOLLARDE.doc.html http://www.ziddu.com/download/12277610/FVSCHEDULE.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/12277639/COUPDAYSNC.doc.html http://www.ziddu.com/download/12277640/AMORLINC.doc.html http://www.ziddu.com/download/12277641/DDB.doc.html http://www.ziddu.com/download/12277642/CUMPRINC.doc.html http://www.ziddu.com/download/12277643/COUPDAYS.doc.html http://www.ziddu.com/download/12277644/COUPDAYBS.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/12277639/COUPDAYSNC.doc.html http://www.ziddu.com/download/12277640/AMORLINC.doc.html http://www.ziddu.com/download/12277641/DDB.doc.html http://www.ziddu.com/download/12277642/CUMPRINC.doc.html http://www.ziddu.com/download/12277643/COUPDAYS.doc.html http://www.ziddu.com/download/12277644/COUPDAYBS.doc.html http://www.ziddu.com/download/12277645/CUMIPMT.doc.html http://www.ziddu.com/download/12277715/TBILLYIELD.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/12277722/RECEIVED.doc.html http://www.ziddu.com/download/12277723/TBILLEQ.doc.html http://www.ziddu.com/download/12277724/TBILLPRICE.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/12277763/YIELDDISC.doc.html http://www.ziddu.com/download/12277764/YIELDMAT.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/12266753/DPRODUCT.doc.html http://www.ziddu.com/download/12266754/DAVERAGE.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/12267021/DATEVALUE.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/12267026/NETWORKDAYS.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/12267048/YEARFRAC.doc.html http://www.ziddu.com/download/12267049/TODAY.doc.html http://www.ziddu.com/download/12267050/TIMEVALUE.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/12267298/IMARGUMENT.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/12267303/IMCONJUGATE.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/12267320/IMPRODUCT.doc.html http://www.ziddu.com/download/12267321/IMAGINARY.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/12277949/ERROR.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/12279383/INDIRECT.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/12279386/HYPERLINK.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/12279417/TRANSPOSE.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/12283819/FINDFINDB.doc.html http://www.ziddu.com/download/12283820/BAHTTEXT.doc.html http://www.ziddu.com/download/12283821/CONCATENATE.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/12283854/REPLACEREPLACEB.doc.html http://www.ziddu.com/download/12283855/LOWER.doc.html http://www.ziddu.com/download/12283856/RIGHTRIGHTB.doc.html http://www.ziddu.com/download/12283857/PHONETIC.doc.html http://www.ziddu.com/download/12283858/MIDMIDB.doc.html http://www.ziddu.com/download/12283859/LEFTLEFTB.doc.html http://www.ziddu.com/download/12283860/LENLENB.doc.html http://www.ziddu.com/download/12284667/SUBSTITUTE.doc.html http://www.ziddu.com/download/12284668/TRIM.doc.html http://www.ziddu.com/download/12284669/SEARCHSEARCHB.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/12284673/TEXT.doc.html الجزء الثاني عشر دوال المكعب http://www.ziddu.com/download/12266611/CUBMEMBER.doc.html http://www.ziddu.com/download/12266612/CUBESET.doc.html http://www.ziddu.com/download/12266613/CUBEVALUE.doc.html http://www.ziddu.com/download/12266614/CUBEMEMBERPROPERTY.doc.html http://www.ziddu.com/download/12266615/CUBERANKEDMEMBER.doc.html http://www.ziddu.com/download/12266616/CUBESETCOUNT.doc.html http://www.ziddu.com/download/12266617/CUBEKPIMEMBER.doc.html
Recommended Posts
انشئ حساب جديد او قم بتسجيل دخولك لتتمكن من اضافه تعليق جديد
يجب ان تكون عضوا لدينا لتتمكن من التعليق
انشئ حساب جديد
سجل حسابك الجديد لدينا في الموقع بمنتهي السهوله .
سجل حساب جديد♥ تسجيل دخول ♥
هل تمتلك حساب بالفعل ؟ سجل دخولك من هنا.
♥ سجل دخولك الان ♥