| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/00 Introduction/0001 Welcome.mov |
11.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/00 Introduction/0002 Using the exercise files.mov |
838 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/01 Formula and Function Tips and Shortcuts/0101 Using the entire row column references.mov |
14.7 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/01 Formula and Function Tips and Shortcuts/0102 Copying column formulas instantly.mov |
9.9 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/01 Formula and Function Tips and Shortcuts/0103 Converting formulas to values with a simple drag.mov |
6 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/01 Formula and Function Tips and Shortcuts/0104 Creating 3D formulas to gather data from multiple sheets.mov |
10.1 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/01 Formula and Function Tips and Shortcuts/0105 Updating values without formulas.mov |
5.5 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/01 Formula and Function Tips and Shortcuts/0106 Displaying and highlighting formulas.mov |
21.8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/01 Formula and Function Tips and Shortcuts/0107 Simplifying debugging formulas.mov |
8.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/01 Formula and Function Tips and Shortcuts/0108 Enhancing readability with range names.mov |
12.7 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/02 Formula and Function Tools/0201 Reviewing function basics.mov |
29.1 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/02 Formula and Function Tools/0202 Using and extending AutoSum.mov |
10.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/02 Formula and Function Tools/0203 Using absolute and relative references.mov |
9 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/02 Formula and Function Tools/0204 Using mixed references.mov |
10.8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/03 IF and Related Functions/0301 Exploring IF logical tests and using relational operators.mov |
8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/03 IF and Related Functions/0302 Creating and expanding the use of nested IF statements.mov |
7.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/03 IF and Related Functions/0303 Using the AND, OR, and NOT functions with IF to create compound logical tests.mov |
13 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/04 Lookup and Reference Function/0401 Looking up information with VLOOKUP and HLOOKUP.mov |
10.2 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/04 Lookup and Reference Function/0402 Finding approximate matches with VLOOKUP.mov |
13.7 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/04 Lookup and Reference Function/0403 Finding exact matches with VLOOKUP.mov |
7.8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/04 Lookup and Reference Function/0404 Nesting LOOKUP functions.mov |
12.9 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/04 Lookup and Reference Function/0405 Finding table-like information within a function with CHOOSE.mov |
6.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/04 Lookup and Reference Function/0406 Locating data with MATCH.mov |
10.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/04 Lookup and Reference Function/0407 Retrieving information by location with INDEX.mov |
9.6 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/04 Lookup and Reference Function/0408 Using MATCH and INDEX together.mov |
13.8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/05 Power Functions/0501 Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov |
8.8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/05 Power Functions/0502 Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov |
15 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/06 Statistical Functions/0601 Finding the middle value with MEDIAN.mov |
3.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/06 Statistical Functions/0602 Ranking data without sorting with RANK.mov |
10.7 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/06 Statistical Functions/0603 Finding the magnitude data with LARGE and SMALL.mov |
3.2 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/06 Statistical Functions/0604 Tabulating blank cells with COUNTBLANK.mov |
8.6 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/07 Data Functions/0701 Understanding Excel date time capabilities in formulas.mov |
13.1 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/07 Data Functions/0702 Identifying the day of the week with WEEKDAY.mov |
12 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/07 Data Functions/0703 Counting working days with NETWORKDAYS.mov |
5.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/07 Data Functions/0704 Determining a completion date with WORKDAY.mov |
4.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/07 Data Functions/0705 Tabulating date time differences with DATEDIF.mov |
8.5 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/08 Math Functions/0801 Working with rounding functions.mov |
15.5 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/08 Math Functions/0802 Finding the remainder with MOD and using MOD with conditional formatting.mov |
10.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/08 Math Functions/0803 Building random number generators with RAND and RANDBETWEEN.mov |
11.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/08 Math Functions/0804 Converting a value between measurement systems with CONVERT.mov |
7.9 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/08 Math Functions/0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov |
10.8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/09 Array Formulas and Functions/0901 Extending formula capabilities with arrays.mov |
17.7 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/09 Array Formulas and Functions/0902 Counting unique entries in a range with an array formula.mov |
11.5 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/09 Array Formulas and Functions/0903 Determining frequency distributions with FREQUENCY.mov |
6 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/09 Array Formulas and Functions/0904 Flipping row column orientation with TRANSPOSE.mov |
8.9 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/09 Array Formulas and Functions/0905 Building analysis via regression techniques with TREND and GROWTH.mov |
8.5 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/09 Array Formulas and Functions/0906 Combining multiple functions in arrays.mov |
9 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/10 Text Functions/1001 Locating and extracting data with FIND and MID.mov |
11 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/10 Text Functions/1002 Extracting specific data with LEFT and RIGHT.mov |
5.8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/10 Text Functions/1003 Removing excess spaces with TRIM.mov |
10.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/10 Text Functions/1004 Using CONCATENATE with functions.mov |
7.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/10 Text Functions/1005 Adjusting case within cells with PROPER, UPPER, and LOWER.mov |
9.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/10 Text Functions/1006 Adjusting character content with REPLACE and SUBSTITUTE.mov |
11.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/10 Text Functions/1007 Reviewing additional text functions.mov |
10.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/11 Financial Functions/1101 Calculating payments with PMT.mov |
7.9 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/11 Financial Functions/1102 Finding future values with FV.mov |
6.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/11 Financial Functions/1103 Determining total amount of future payments with PV.mov |
7.7 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/12 Information Functions/1201 Working with the IS information functions.mov |
8.2 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/12 Information Functions/1202 Using error-checking functions ISERR, ISERROR, IFERROR.mov |
12.8 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/13 Reference Functions/1301 Getting data from remote cells with OFFSET.mov |
7.7 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/13 Reference Functions/1302 Returning references with INDIRECT.mov |
20.3 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/14 Conclusion/1401 Final thoughts.mov |
2.4 MB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 1 Tips.xlsx |
199 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 10 Text.xlsx |
21 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 11 Financial.xlsx |
13 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 12 Information.xlsx |
15 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 13 Reference.xlsx |
26 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 2 Functions.xlsx |
65 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 3 IF.xlsx |
43 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 4 LOOKUP.xlsx |
104 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 5 Power.xlsx |
61 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 6 Stat.xlsx |
107 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 7 Date.xlsx |
45 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 8 Math.xlsx |
71 KB |
| Lynda.com.Excel.2010.Advanced.Formulas.and.Functions/Exercise Files/Ch 9 Array.xlsx |
165 KB |
Magnet link
