Lynda Excel 2016 Advanced Formulas and Functions | 860128A3310EC46C8DAD7E283093F1AC4A1BE440

Lynda Excel 2016 Advanced Formulas and Functions

Name	Lynda - Excel 2016 - Advanced Formulas and Functions	DOWNLOAD Copy Link
Total Size	1.0 GB
Total Files	76
Hash	860128A3310EC46C8DAD7E283093F1AC4A1BE440

/01. Introduction/
01_01-Welcome.mp4	6.8 MB
01_02-Using the exercise files.mp4	1.5 MB
/02. Formula and Function Tips and Shortcuts/
02_01-Displaying and highlighting formulas.mp4	17.2 MB
02_02-Using Auditing tools.mp4	23.5 MB
02_03-Using entire row and column references.mp4	12.3 MB
02_04-Copying column formulas instantly.mp4	9.7 MB
02_05-Converting formulas to values with a drag.mp4	16.7 MB
02_06-Updating values without formulas.mp4	9.6 MB
02_07-Debugging formulas with the F9 key.mp4	10.8 MB
02_08-Enhancing readability with range names.mp4	15.1 MB
02_09-Tabulating data from multiple sheets.mp4	23.7 MB
/03. Formula and Function Tools/
03_01-Hierarchy of operations in formulas.mp4	15.6 MB
03_02-Formulas tab for locating functions.mp4	16.3 MB
03_03-Insert Function for learning about unfamiliar functions.mp4	14.3 MB
03_04-Extending the capabilities of AutoSum.mp4	15.3 MB
03_05-Absolute and relative references.mp4	16.8 MB
03_06-Using mixed references in formulas.mp4	15.6 MB
03_07-Using autocalculate in the status bar.mp4	17.1 MB
/04. IF and Related Functions/
04_01-IF logical tests.mp4	10.0 MB
04_02-Expanding nested IF statements.mp4	11.6 MB
04_03-AND, OR, and NOT functions with IF.mp4	21.4 MB
/05. Lookup and Reference Functions/
05_01-Looking up information with VLOOKUP and HLOOKUP.mp4	12.0 MB
05_02-Finding approximate matches with VLOOKUP and HLOOKUP.mp4	21.9 MB
05_03-Finding exact matches with VLOOKUP.mp4	16.1 MB
05_04-Nesting lookup functions.mp4	12.1 MB
05_05-Using VLOOKUP with large tables.mp4	17.1 MB
05_06-Finding tablelike information within a function using the CHOOSE function.mp4	6.9 MB
05_07-Locating data with the MATCH function.mp4	10.0 MB
05_08-Retrieving information by location.mp4	8.6 MB
05_09-Using MATCH and INDEX functions together.mp4	13.3 MB
/06. Power Functions/
06_01-Tabulating data using a single criterion.mp4	14.8 MB
06_02-Tabulating data using multiple criteria.mp4	17.8 MB
06_03-Preventing double counting.mp4	19.2 MB
/07. Statistical Functions/
07_01-Finding the middle value with MEDIAN and most common value with MODE.mp4	7.5 MB
07_02-Ranking data without sorting with RANK and RANK.EQ.mp4	13.2 MB
07_03-Finding the largest and smallest values with the LARGE and SMALL functions.mp4	5.1 MB
07_04-Tabulating blank cells with the COUNTBLANK function.mp4	15.5 MB
07_05-Using COUNT, COUNTA, and the status bar.mp4	10.0 MB
/08. Math Functions/
08_01-Working with the ROUND, ROUNDUP, and ROUNDDOWN functions.mp4	15.1 MB
08_02-Working with MROUND, CEILING, and FLOOR for specialized rounding.mp4	7.9 MB
08_03-Using the INT and TRUNC functions to extract integer data.mp4	11.6 MB
08_04-Finding the remainder with MOD and using MOD with conditional formatting.mp4	15.7 MB
08_05-Exploring practical uses for the RAND and RANDBETWEEN functions.mp4	16.0 MB
08_06-Converting a value between measurement systems with CONVERT.mp4	8.8 MB
08_07-Using the powerful AGGREGATE function to bypass errors and hidden data.mp4	22.1 MB
08_08-Using the ROMAN and ARABIC functions to display different number systems.mp4	9.7 MB
/09. Date and Time Functions/
09_01-Understanding Excel date and time capabilities in formulas.mp4	23.5 MB
09_02-Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions.mp4	12.2 MB
09_03-Using the TODAY and NOW functions for dynamic date and time entry.mp4	15.9 MB
09_04-Identifying the day of the week with the WEEKDAY function.mp4	13.2 MB
09_05-Counting working days with the NETWORKDAYS function.mp4	16.3 MB
09_06-Determining a completion date with the WORKDAY function.mp4	11.5 MB
09_07-Tabulating date differences with the DATEDIF function.mp4	15.7 MB
09_08-Calculating endofmonth and future and past dates with EDATE and EOMONTH.mp4	13.6 MB
/10. Array Formulas and Functions/
10_01-Extending formula capabilities with array formulas.mp4	15.4 MB
10_02-Counting unique entries in a range with an array formula.mp4	17.8 MB
10_03-Determining frequency distributions with the FREQUENCY function.mp4	11.0 MB
10_04-Flipping row and column orientation with TRANSPOSE.mp4	14.9 MB
10_05-Building analysis via regression techniques with TREND and GROWTH.mp4	10.1 MB
10_06-Using array formulas and the MATCH function for complex lookups.mp4	17.4 MB
/11. Reference Functions/
11_01-Getting data from remote cells with the OFFSET function.mp4	15.0 MB
11_02-Returning references with the INDIRECT function.mp4	8.9 MB
11_03-Using INDIRECT with Data Validation for twotiered pick list scenarios.mp4	21.5 MB
/12. Text Functions/
12_01-Locating and extracting data with the FIND, SEARCH, and MID functions.mp4	18.7 MB
12_02-Extracting specific data with the LEFT and RIGHT functions.mp4	10.1 MB
12_03-Using the TRIM function to remove unwanted spaces in a cell.mp4	15.6 MB
12_04-Using ampersands and CONCATENATE to combine data from different cells.mp4	15.4 MB
12_05-Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions.mp4	11.8 MB
12_06-Adjusting character content with the REPLACE and SUBSTITUTE functions.mp4	14.8 MB
12_07-Using the utility text functions TEXT, REPT, and LEN.mp4	11.9 MB
/13. Information Functions/
13_01-Extracting information with the CELL and INFO functions.mp4	10.9 MB
13_02-Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER.mp4	12.4 MB
13_03-Using the ISERR, ISERROR, IFERROR, and ISNA errorchecking functions.mp4	24.5 MB
13_04-Tracking and highlighting formula cells with the ISFORMULA function.mp4	8.8 MB
/14. Conclusion/
14_01-Next steps.mp4	2.0 MB
/Exercice Files/
Ex_Files_Excel2016_AdvancedFormulas.zip	2.0 MB
Total files 76