Excell 2013 Advanced Formulas and Functions

/9.Array Formulas and Functions/

126129_09_01_SC11_ARRAYS.mp4.flv

126129_09_02_SC11_Unique.mp4.flv

126129_09_06_SC11_ArrayMATCH.mp4.flv

126129_09_03_SC11_FREQUENCY.mp4.flv

126129_09_05_SC11_TRENDGROWTH.mp4.flv

126129_09_04_SC11_TRANSPOSE.mp4.flv

/8.Date and Time Functions/

126129_08_01_SC11_Dates.mp4.flv

126129_08_06_SC11_DATEDIF.mp4.flv

126129_08_07_SC11_EDATEEOMONTH.mp4.flv

126129_08_03_SC11_WEEKDAY.mp4.flv

126129_08_08_SC11_DATEVALUE.mp4.flv

126129_08_04_SC11_NETWORKDAYS.mp4.flv

126129_08_02_SC11_TODAYNOW.mp4.flv

126129_08_05_SC11_WORKDAY.mp4.flv

/4.Lookup and Reference Functions/

126129_04_09_SC11_MATCHINDEX.mp4.flv

126129_04_02_SC11_approxMatch.mp4.flv

126129_04_01_SC11_VLOOKUPandHLOOKUP.mp4.flv

126129_04_03_SC11_exactMatch.mp4.flv

126129_04_04_SC11_nestedVlookup.mp4.flv

126129_04_05_SC11_largeVlookup.mp4.flv

126129_04_07_SC11_MATCH.mp4.flv

126129_04_08_SC11_INDEX.mp4.flv

126129_04_06_SC11_CHOOSE.mp4.flv

/10.Reference Functions/

126129_10_03_SC11_PickList.mp4.flv

126129_10_01_SC11_OFFSET.mp4.flv

126129_10_02_SC11_INDIRECT.mp4.flv

/6.Statistical Functions/

126129_06_04_SC11_COUNTBLANK.mp4.flv

126129_06_02_SC11_RANK.mp4.flv

126129_06_01_SC11_MEDIAN.mp4.flv

126129_06_05_SC11_COUNT.mp4.flv

126129_06_03_SC11_LARGESMALL.mp4.flv

/1.Formula and Function Tips and Shortcuts/

126129_01_08_SC11_rangeNames.mp4.flv

126129_01_02_SC11_AuditingTools.mp4.flv

126129_01_01_SC11_displayFormulas.mp4.flv

126129_01_03_SC11_rowColumnRefs.mp4.flv

126129_01_05_SC11_convertFormulas.mp4.flv

126129_01_04_SC11_copyColumnFormulas.mp4.flv

126129_01_07_SC11_debugFormulas.mp4.flv

126129_01_09_SC11_3Dformulas.mp4.flv

126129_01_06_SC11_updateValues.mp4.flv

/7.Math Functions/

126129_07_05_SC11_RAND.mp4.flv

126129_07_07_SC11_AGGREGATE.mp4.flv

126129_07_01_SC11_ROUND.mp4.flv

126129_07_04_SC11_MOD.mp4.flv

126129_07_02_SC11_MROUND.mp4.flv

126129_07_03_SC11_TRUNC.mp4.flv

126129_07_06_SC11_CONVERT.mp4.flv

126129_07_08_SC11_RomanArabic.mp4.flv

/3.IF and Related Functions/

126129_03_03_SC11_IFcompound.mp4.flv

126129_03_02_SC11_IFnested.mp4.flv

126129_03_01_SC11_IFrelational.mp4.flv

/11.Text Functions/

126129_11_07_SC11_otherTextFunctions.mp4.flv

126129_11_06_SC11_REPLACE.mp4.flv

126129_11_01_SC11_FINDMID.mp4.flv

126129_11_04_SC11_Concatenate.mp4.flv

126129_11_03_SC11_TRIM.mp4.flv

126129_11_05_SC11_PROPER.mp4.flv

126129_11_02_SC11_LEFTRIGHT.mp4.flv

/5.Power Functions/

126129_05_01_SC11_SingleCriterion.mp4.flv

126129_05_02_SC11_MultipleCriteria.mp4.flv

/12.Information Functions/

126129_12_03_SC11_errorChecking.mp4.flv

126129_12_01_SC11_CELL-INFO.mp4.flv

126129_12_02_SC11_ISFunctions.mp4.flv

126129_12_04_SC11_ISFORMULA.mp4.flv

/2.Formula and Function Tools/

126129_02_04_SC11_AutoSum.mp4.flv

126129_02_03_SC11_insertFunction.mp4.flv

126129_02_06_SC11_mixedReference.mp4.flv

126129_02_05_SC11_absoluteRelative.mp4.flv

126129_02_02_SC11_formulasTab.mp4.flv

126129_02_01_SC11_hierarchy.mp4.flv

/0.Introduction/

126129_00_01_SC13_intro.mp4.flv

126129_00_02_SC11_exFiles.mp4.flv

/13.Conclusion/

126129_13_01_SC11_goodbye.mp4.flv

/Exercise Files/Ch03/

03-IF Function.xlsx

/Exercise Files/Ch02/

02-Tools.xlsx

/Exercise Files/Ch04/

04-LookupFunctions.xlsx

/Exercise Files/Ch01/

01-TipsShortcuts.xlsx

01-RegionalSales.xlsx

/Exercise Files/Ch05/

05-COUNTIF-SUMIF.xlsx

/Exercise Files/Ch09/

09-Array.xlsx

/Exercise Files/Ch06/

06-Stat.xlsx

/Exercise Files/Ch07/

07-Math.xlsx

/Exercise Files/Ch08/

08-Date.xlsx

/Exercise Files/Ch10/

10-Reference.xlsx

/Exercise Files/Ch11/

11-Text.xlsx

/Exercise Files/Ch12/

12-Information.xlsx

Total files 86