Lynda com Excel 2010 Advanced Formulas and Functions | E7832FED384F03358CE4EDC2E8DA69DD77DD1FA0

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	E7832FED384F03358CE4EDC2E8DA69DD77DD1FA0

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