Excel 2013 Advanced Formulas and Functions | 8A6DAFC29458F4D97F1C832E63E586641E376238

Excel 2013 Advanced Formulas and Functions

Name	Excel 2013 Advanced Formulas and Functions	DOWNLOAD Copy Link
Total Size	805.0 MB
Total Files	160
Hash	8A6DAFC29458F4D97F1C832E63E586641E376238

/00 Introduction/
00_01-intro.mp4	7.4 MB
00_01-intro.srt	2.8 KB
00_02-exFiles.mp4	1.7 MB
00_02-exFiles.srt	1.3 KB
/01 Formula and Function Tips and Shortcuts/
01_01-displayFormulas.mp4	14.4 MB
01_01-displayFormulas.srt	16.4 KB
01_02-AuditingTools.mp4	17.0 MB
01_02-AuditingTools.srt	13.1 KB
01_03-rowColumnRefs.mp4	12.6 MB
01_03-rowColumnRefs.srt	11.6 KB
01_04-copyColumnFormulas.mp4	10.7 MB
01_04-copyColumnFormulas.srt	9.4 KB
01_05-convertFormulas.mp4	8.9 MB
01_05-convertFormulas.srt	10.8 KB
01_06-updateValues.mp4	6.5 MB
01_06-updateValues.srt	8.4 KB
01_07-debugFormulas.mp4	10.6 MB
01_07-debugFormulas.srt	11.9 KB
01_08-rangeNames.mp4	15.3 MB
01_08-rangeNames.srt	17.1 KB
01_09-3Dformulas.mp4	10.7 MB
01_09-3Dformulas.srt	15.2 KB
/02 Formula and Function Tools/
02_01-hierarchy.mp4	6.6 MB
02_01-hierarchy.srt	10.3 KB
02_02-formulasTab.mp4	7.9 MB
02_02-formulasTab.srt	10.8 KB
02_03-insertFunction.mp4	9.6 MB
02_03-insertFunction.srt	14.4 KB
02_04-AutoSum.mp4	13.4 MB
02_04-AutoSum.srt	15.6 KB
02_05-absoluteRelative.mp4	8.0 MB
02_05-absoluteRelative.srt	10.1 KB
02_06-mixedReference.mp4	9.4 MB
02_06-mixedReference.srt	12.9 KB
/03 IF and Related Functions/
03_01-IFrelational.mp4	7.9 MB
03_01-IFrelational.srt	11.1 KB
03_02-IFnested.mp4	9.0 MB
03_02-IFnested.srt	13.3 KB
03_03-IFcompound.mp4	16.0 MB
03_03-IFcompound.srt	24.4 KB
/04 Lookup and Reference Functions/
04_01-VLOOKUPandHLOOKUP.mp4	13.1 MB
04_01-VLOOKUPandHLOOKUP.srt	12.4 KB
04_02-approxMatch.mp4	19.5 MB
04_02-approxMatch.srt	23.3 KB
04_03-exactMatch.mp4	10.5 MB
04_03-exactMatch.srt	14.8 KB
04_04-nestedVlookup.mp4	10.7 MB
04_04-nestedVlookup.srt	12.7 KB
04_05-largeVlookup.mp4	9.4 MB
04_05-largeVlookup.srt	9.9 KB
04_06-CHOOSE.mp4	7.2 MB
04_06-CHOOSE.srt	10.7 KB
04_07-MATCH.mp4	10.4 MB
04_07-MATCH.srt	14.6 KB
04_08-INDEX.mp4	6.7 MB
04_08-INDEX.srt	8.3 KB
04_09-MATCHINDEX.mp4	19.1 MB
04_09-MATCHINDEX.srt	20.6 KB
/05 Power Functions/
05_01-SingleCriterion.mp4	13.4 MB
05_01-SingleCriterion.srt	15.7 KB
05_02-MultipleCriteria.mp4	12.1 MB
05_02-MultipleCriteria.srt	14.9 KB
/06 Statistical Functions/
06_01-MEDIAN.mp4	7.3 MB
06_01-MEDIAN.srt	8.9 KB
06_02-RANK.mp4	13.5 MB
06_02-RANK.srt	13.8 KB
06_03-LARGESMALL.mp4	5.2 MB
06_03-LARGESMALL.srt	7.2 KB
06_04-COUNTBLANK.mp4	17.4 MB
06_04-COUNTBLANK.srt	17.7 KB
06_05-COUNT.mp4	8.3 MB
06_05-COUNT.srt	11.5 KB
/07 Math Functions/
07_01-ROUND.mp4	1.5 MB
07_01-ROUND.srt	18.0 KB
07_02-MROUND.mp4	11.4 MB
07_02-MROUND.srt	16.5 KB
07_03-TRUNC.mp4	6.9 MB
07_03-TRUNC.srt	9.2 KB
07_04-MOD.mp4	12.5 MB
07_04-MOD.srt	17.2 KB
07_05-RAND.mp4	16.4 MB
07_05-RAND.srt	19.9 KB
07_06-CONVERT.mp4	7.9 MB
07_06-CONVERT.srt	10.5 KB
07_07-AGGREGATE.mp4	14.3 MB
07_07-AGGREGATE.srt	15.5 KB
07_08-RomanArabic.mp4	6.6 MB
07_08-RomanArabic.srt	8.6 KB
/08 Date and Time Functions/
08_01-Dates.mp4	19.5 MB
08_01-Dates.srt	26.5 KB
08_02-TODAYNOW.mp4	8.1 MB
08_02-TODAYNOW.srt	11.4 KB
08_03-WEEKDAY.mp4	10.9 MB
08_03-WEEKDAY.srt	12.5 KB
08_04-NETWORKDAYS.mp4	8.8 MB
08_04-NETWORKDAYS.srt	11.7 KB
08_05-WORKDAY.mp4	7.9 MB
08_05-WORKDAY.srt	11.8 KB
08_06-DATEDIF.mp4	13.3 MB
08_06-DATEDIF.srt	17.3 KB
08_07-EDATEEOMONTH.mp4	12.1 MB
08_07-EDATEEOMONTH.srt	14.9 KB
08_08-DATEVALUE.mp4	10.7 MB
08_08-DATEVALUE.srt	14.7 KB
/09 Array Formulas and Functions/
09_01-ARRAYS.mp4	26.7 MB
09_01-ARRAYS.srt	26.5 KB
09_02-Unique.mp4	15.6 MB
09_02-Unique.srt	18.3 KB
09_03-FREQUENCY.mp4	9.8 MB
09_03-FREQUENCY.srt	11.8 KB
09_04-TRANSPOSE.mp4	8.8 MB
09_04-TRANSPOSE.srt	10.6 KB
09_05-TRENDGROWTH.mp4	10.5 MB
09_05-TRENDGROWTH.srt	7.0 KB
09_06-ArrayMATCH.mp4	10.2 MB
09_06-ArrayMATCH.srt	13.5 KB
/10 Reference Functions/
10_01-OFFSET.mp4	13.4 MB
10_01-OFFSET.srt	19.3 KB
10_02-INDIRECT.mp4	8.5 MB
10_02-INDIRECT.srt	11.7 KB
10_03-PickList.mp4	20.6 MB
10_03-PickList.srt	20.8 KB
/11 Text Functions/
11_01-FINDMID.mp4	11.5 MB
11_01-FINDMID.srt	16.5 KB
11_02-LEFTRIGHT.mp4	6.3 MB
11_02-LEFTRIGHT.srt	8.1 KB
11_03-TRIM.mp4	10.9 MB
11_03-TRIM.srt	16.6 KB
11_04-Concatenate.mp4	12.7 MB
11_04-Concatenate.srt	17.5 KB
11_05-PROPER.mp4	8.8 MB
11_05-PROPER.srt	10.4 KB
11_06-REPLACE.mp4	12.8 MB
11_06-REPLACE.srt	17.8 KB
11_07-otherTextFunctions.mp4	15.7 MB
11_07-otherTextFunctions.srt	22.0 KB
/12 Information Functions/
12_01-CELL-INFO.mp4	12.4 MB
12_01-CELL-INFO.srt	17.6 KB
12_02-ISFunctions.mp4	12.0 MB
12_02-ISFunctions.srt	16.3 KB
12_03-errorChecking.mp4	11.5 MB
12_03-errorChecking.srt	19.0 KB
12_04-ISFORMULA.mp4	5.8 MB
12_04-ISFORMULA.srt	7.4 KB
/13 Conclusion/
13_01-goodbye.mp4	875.3 KB
13_01-goodbye.srt	1.4 KB
/Exercise Files/Ch01/
01-RegionalSales.xlsx	40.1 KB
01-TipsShortcuts.xlsx	286.3 KB
/Exercise Files/Ch02/
02-Tools.xlsx	456.9 KB
/Exercise Files/Ch03/
03-IF Function.xlsx	550.2 KB
/Exercise Files/Ch04/
04-LookupFunctions.xlsx	340.8 KB
/Exercise Files/Ch05/
05-COUNTIF-SUMIF.xlsx	275.3 KB
/Exercise Files/Ch06/
06-Stat.xlsx	124.7 KB
/Exercise Files/Ch07/
07-Math.xlsx	65.9 KB
/Exercise Files/Ch08/
08-Date.xlsx	58.1 KB
/Exercise Files/Ch09/
09-Array.xlsx	160.4 KB
/Exercise Files/Ch10/
10-Reference.xlsx	24.3 KB
/Exercise Files/Ch11/
11-Text.xlsx	23.0 KB
/Exercise Files/Ch12/
12-Information.xlsx	16.3 KB
/Exercise Files/
Fitness Sports Training.txt	0.1 KB
Total files 160