| Lynda - Excel 2016 - Advanced Formulas and Functions/01. Introduction/01_01-Welcome.mp4 |
6.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/01. Introduction/01_02-Using the exercise files.mp4 |
1.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_01-Displaying and highlighting formulas.mp4 |
16.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_02-Using Auditing tools.mp4 |
22.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_03-Using entire row and column references.mp4 |
11.7 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_04-Copying column formulas instantly.mp4 |
9.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_05-Converting formulas to values with a drag.mp4 |
15.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_06-Updating values without formulas.mp4 |
9.2 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_07-Debugging formulas with the F9 key.mp4 |
10.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_08-Enhancing readability with range names.mp4 |
14.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/02. Formula and Function Tips and Shortcuts/02_09-Tabulating data from multiple sheets.mp4 |
22.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/03. Formula and Function Tools/03_01-Hierarchy of operations in formulas.mp4 |
14.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/03. Formula and Function Tools/03_02-Formulas tab for locating functions.mp4 |
15.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/03. Formula and Function Tools/03_03-Insert Function for learning about unfamiliar functions.mp4 |
13.7 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/03. Formula and Function Tools/03_04-Extending the capabilities of AutoSum.mp4 |
14.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/03. Formula and Function Tools/03_05-Absolute and relative references.mp4 |
16 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/03. Formula and Function Tools/03_06-Using mixed references in formulas.mp4 |
14.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/03. Formula and Function Tools/03_07-Using autocalculate in the status bar.mp4 |
16.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/04. IF and Related Functions/04_01-IF logical tests.mp4 |
9.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/04. IF and Related Functions/04_02-Expanding nested IF statements.mp4 |
11.1 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/04. IF and Related Functions/04_03-AND, OR, and NOT functions with IF.mp4 |
20.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_01-Looking up information with VLOOKUP and HLOOKUP.mp4 |
11.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_02-Finding approximate matches with VLOOKUP and HLOOKUP.mp4 |
20.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_03-Finding exact matches with VLOOKUP.mp4 |
15.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_04-Nesting lookup functions.mp4 |
11.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_05-Using VLOOKUP with large tables.mp4 |
16.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_06-Finding tablelike information within a function using the CHOOSE function.mp4 |
6.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_07-Locating data with the MATCH function.mp4 |
9.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_08-Retrieving information by location.mp4 |
8.2 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/05. Lookup and Reference Functions/05_09-Using MATCH and INDEX functions together.mp4 |
12.7 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/06. Power Functions/06_01-Tabulating data using a single criterion.mp4 |
14.1 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/06. Power Functions/06_02-Tabulating data using multiple criteria.mp4 |
16.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/06. Power Functions/06_03-Preventing double counting.mp4 |
18.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/07. Statistical Functions/07_01-Finding the middle value with MEDIAN and most common value with MODE.mp4 |
7.1 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/07. Statistical Functions/07_02-Ranking data without sorting with RANK and RANK.EQ.mp4 |
12.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/07. Statistical Functions/07_03-Finding the largest and smallest values with the LARGE and SMALL functions.mp4 |
4.8 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/07. Statistical Functions/07_04-Tabulating blank cells with the COUNTBLANK function.mp4 |
14.8 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/07. Statistical Functions/07_05-Using COUNT, COUNTA, and the status bar.mp4 |
9.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/08. Math Functions/08_01-Working with the ROUND, ROUNDUP, and ROUNDDOWN functions.mp4 |
14.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/08. Math Functions/08_02-Working with MROUND, CEILING, and FLOOR for specialized rounding.mp4 |
7.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/08. Math Functions/08_03-Using the INT and TRUNC functions to extract integer data.mp4 |
11.1 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/08. Math Functions/08_04-Finding the remainder with MOD and using MOD with conditional formatting.mp4 |
14.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/08. Math Functions/08_05-Exploring practical uses for the RAND and RANDBETWEEN functions.mp4 |
15.2 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/08. Math Functions/08_06-Converting a value between measurement systems with CONVERT.mp4 |
8.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/08. Math Functions/08_07-Using the powerful AGGREGATE function to bypass errors and hidden data.mp4 |
21.1 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/08. Math Functions/08_08-Using the ROMAN and ARABIC functions to display different number systems.mp4 |
9.2 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/09. Date and Time Functions/09_01-Understanding Excel date and time capabilities in formulas.mp4 |
22.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/09. Date and Time Functions/09_02-Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions.mp4 |
11.7 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/09. Date and Time Functions/09_03-Using the TODAY and NOW functions for dynamic date and time entry.mp4 |
15.1 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/09. Date and Time Functions/09_04-Identifying the day of the week with the WEEKDAY function.mp4 |
12.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/09. Date and Time Functions/09_05-Counting working days with the NETWORKDAYS function.mp4 |
15.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/09. Date and Time Functions/09_06-Determining a completion date with the WORKDAY function.mp4 |
10.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/09. Date and Time Functions/09_07-Tabulating date differences with the DATEDIF function.mp4 |
14.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/09. Date and Time Functions/09_08-Calculating endofmonth and future and past dates with EDATE and EOMONTH.mp4 |
13 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/10. Array Formulas and Functions/10_01-Extending formula capabilities with array formulas.mp4 |
14.7 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/10. Array Formulas and Functions/10_02-Counting unique entries in a range with an array formula.mp4 |
17 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/10. Array Formulas and Functions/10_03-Determining frequency distributions with the FREQUENCY function.mp4 |
10.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/10. Array Formulas and Functions/10_04-Flipping row and column orientation with TRANSPOSE.mp4 |
14.2 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/10. Array Formulas and Functions/10_05-Building analysis via regression techniques with TREND and GROWTH.mp4 |
9.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/10. Array Formulas and Functions/10_06-Using array formulas and the MATCH function for complex lookups.mp4 |
16.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/11. Reference Functions/11_01-Getting data from remote cells with the OFFSET function.mp4 |
14.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/11. Reference Functions/11_02-Returning references with the INDIRECT function.mp4 |
8.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/11. Reference Functions/11_03-Using INDIRECT with Data Validation for twotiered pick list scenarios.mp4 |
20.5 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/12. Text Functions/12_01-Locating and extracting data with the FIND, SEARCH, and MID functions.mp4 |
17.8 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/12. Text Functions/12_02-Extracting specific data with the LEFT and RIGHT functions.mp4 |
9.6 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/12. Text Functions/12_03-Using the TRIM function to remove unwanted spaces in a cell.mp4 |
14.8 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/12. Text Functions/12_04-Using ampersands and CONCATENATE to combine data from different cells.mp4 |
14.7 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/12. Text Functions/12_05-Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions.mp4 |
11.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/12. Text Functions/12_06-Adjusting character content with the REPLACE and SUBSTITUTE functions.mp4 |
14.2 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/12. Text Functions/12_07-Using the utility text functions TEXT, REPT, and LEN.mp4 |
11.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/13. Information Functions/13_01-Extracting information with the CELL and INFO functions.mp4 |
10.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/13. Information Functions/13_02-Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER.mp4 |
11.8 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/13. Information Functions/13_03-Using the ISERR, ISERROR, IFERROR, and ISNA errorchecking functions.mp4 |
23.3 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/13. Information Functions/13_04-Tracking and highlighting formula cells with the ISFORMULA function.mp4 |
8.4 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/14. Conclusion/14_01-Next steps.mp4 |
1.9 MB |
| Lynda - Excel 2016 - Advanced Formulas and Functions/Exercice Files/Ex_Files_Excel2016_AdvancedFormulas.zip |
1.9 MB |
Magnet link
