Lynda com Excel 2010 Advanced Formulas and Functions | 1491AF25D2F9DAD50202A6CE50CE4FA7233F8C46

Lynda com Excel 2010 Advanced Formulas and Functions

Name	Lynda.com - Excel 2010 Advanced Formulas and Functions	DOWNLOAD Copy Link
Total Size	654.0 MB
Total Files	75
Hash	1491AF25D2F9DAD50202A6CE50CE4FA7233F8C46

/00 Introduction/
0001 Welcome.mov	12.0 MB
0002 Using the exercise files.mov	858.0 KB
/01 Formula and Function Tips and Shortcuts/
0106 Displaying and highlighting formulas.mov	22.8 MB
0101 Using the entire row column references.mov	15.4 MB
0108 Enhancing readability with range names.mov	13.4 MB
0104 Creating 3D formulas to gather data from multiple sheets.mov	10.5 MB
0102 Copying column formulas instantly.mov	10.4 MB
0107 Simplifying debugging formulas.mov	8.8 MB
0103 Converting formulas to values with a simple drag.mov	6.3 MB
0105 Updating values without formulas.mov	5.8 MB
/02 Formula and Function Tools/
0201 Reviewing function basics.mov	30.5 MB
0204 Using mixed references.mov	11.3 MB
0202 Using and extending AutoSum.mov	10.8 MB
0203 Using absolute and relative references.mov	9.4 MB
/03 IF and Related Functions/
0303 Using the AND, OR, and NOT functions with IF to create compound logical tests.mov	13.6 MB
0301 Exploring IF logical tests and using relational operators.mov	8.4 MB
0302 Creating and expanding the use of nested IF statements.mov	7.6 MB
/04 Lookup and Reference Function/
0408 Using MATCH and INDEX together.mov	14.5 MB
0402 Finding approximate matches with VLOOKUP.mov	14.4 MB
0404 Nesting LOOKUP functions.mov	13.5 MB
0406 Locating data with MATCH.mov	11.0 MB
0401 Looking up information with VLOOKUP and HLOOKUP.mov	10.7 MB
0407 Retrieving information by location with INDEX.mov	10.1 MB
0403 Finding exact matches with VLOOKUP.mov	8.2 MB
0405 Finding table-like information within a function with CHOOSE.mov	6.6 MB
/05 Power Functions/
0502 Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov	15.7 MB
0501 Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov	9.3 MB
/06 Statistical Functions/
0602 Ranking data without sorting with RANK.mov	11.2 MB
0604 Tabulating blank cells with COUNTBLANK.mov	9.0 MB
0601 Finding the middle value with MEDIAN.mov	3.5 MB
0603 Finding the magnitude data with LARGE and SMALL.mov	3.4 MB
/07 Data Functions/
0701 Understanding Excel date time capabilities in formulas.mov	13.7 MB
0702 Identifying the day of the week with WEEKDAY.mov	12.6 MB
0705 Tabulating date time differences with DATEDIF.mov	8.9 MB
0703 Counting working days with NETWORKDAYS.mov	5.5 MB
0704 Determining a completion date with WORKDAY.mov	4.5 MB
/08 Math Functions/
0801 Working with rounding functions.mov	16.2 MB
0803 Building random number generators with RAND and RANDBETWEEN.mov	11.9 MB
0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov	11.3 MB
0802 Finding the remainder with MOD and using MOD with conditional formatting.mov	10.9 MB
0804 Converting a value between measurement systems with CONVERT.mov	8.3 MB
/09 Array Formulas and Functions/
0901 Extending formula capabilities with arrays.mov	18.5 MB
0902 Counting unique entries in a range with an array formula.mov	12.0 MB
0906 Combining multiple functions in arrays.mov	9.5 MB
0904 Flipping row column orientation with TRANSPOSE.mov	9.4 MB
0905 Building analysis via regression techniques with TREND and GROWTH.mov	9.0 MB
0903 Determining frequency distributions with FREQUENCY.mov	6.3 MB
/10 Text Functions/
1006 Adjusting character content with REPLACE and SUBSTITUTE.mov	11.9 MB
1001 Locating and extracting data with FIND and MID.mov	11.5 MB
1003 Removing excess spaces with TRIM.mov	10.9 MB
1007 Reviewing additional text functions.mov	10.8 MB
1005 Adjusting case within cells with PROPER, UPPER, and LOWER.mov	9.9 MB
1004 Using CONCATENATE with functions.mov	7.6 MB
1002 Extracting specific data with LEFT and RIGHT.mov	6.1 MB
/11 Financial Functions/
1101 Calculating payments with PMT.mov	8.2 MB
1103 Determining total amount of future payments with PV.mov	8.0 MB
1102 Finding future values with FV.mov	6.6 MB
/12 Information Functions/
1202 Using error-checking functions ISERR, ISERROR, IFERROR.mov	13.4 MB
1201 Working with the IS information functions.mov	8.6 MB
/13 Reference Functions/
1302 Returning references with INDIRECT.mov	21.2 MB
1301 Getting data from remote cells with OFFSET.mov	8.0 MB
/14 Conclusion/
1401 Final thoughts.mov	2.5 MB
/Exercise Files/
Ch 1 Tips.xlsx	204.2 KB
Ch 9 Array.xlsx	169.2 KB
Ch 6 Stat.xlsx	109.8 KB
Ch 4 LOOKUP.xlsx	106.3 KB
Ch 8 Math.xlsx	72.6 KB
Ch 2 Functions.xlsx	66.3 KB
Ch 5 Power.xlsx	62.4 KB
Ch 7 Date.xlsx	45.9 KB
Ch 3 IF.xlsx	43.9 KB
Ch 13 Reference.xlsx	26.5 KB
Ch 10 Text.xlsx	21.9 KB
Ch 12 Information.xlsx	15.1 KB
Ch 11 Financial.xlsx	13.0 KB
Total files 75