| | 0001 Welcome.mov | 11.44 MB |
| | 0002 Using the exercise files.mov | 837.85 KB |
| | 0106 Displaying and highlighting formulas.mov | 21.76 MB |
| | 0101 Using the entire row column references.mov | 14.73 MB |
| | 0108 Enhancing readability with range names.mov | 12.74 MB |
| | 0104 Creating 3D formulas to gather data from multiple sheets.mov | 10.05 MB |
| | 0102 Copying column formulas instantly.mov | 9.92 MB |
| | 0107 Simplifying debugging formulas.mov | 8.43 MB |
| | 0103 Converting formulas to values with a simple drag.mov | 5.98 MB |
| | 0105 Updating values without formulas.mov | 5.49 MB |
| | 0201 Reviewing function basics.mov | 29.06 MB |
| | 0204 Using mixed references.mov | 10.8 MB |
| | 0202 Using and extending AutoSum.mov | 10.33 MB |
| | 0203 Using absolute and relative references.mov | 8.99 MB |
| | 0303 Using the AND, OR, and NOT functions with IF to create compound logical tests.mov | 12.97 MB |
| | 0301 Exploring IF logical tests and using relational operators.mov | 7.97 MB |
| | 0302 Creating and expanding the use of nested IF statements.mov | 7.29 MB |
| | 0408 Using MATCH and INDEX together.mov | 13.84 MB |
| | 0402 Finding approximate matches with VLOOKUP.mov | 13.74 MB |
| | 0404 Nesting LOOKUP functions.mov | 12.92 MB |
| | 0406 Locating data with MATCH.mov | 10.45 MB |
| | 0401 Looking up information with VLOOKUP and HLOOKUP.mov | 10.21 MB |
| | 0407 Retrieving information by location with INDEX.mov | 9.63 MB |
| | 0403 Finding exact matches with VLOOKUP.mov | 7.83 MB |
| | 0405 Finding table-like information within a function with CHOOSE.mov | 6.29 MB |
| | 0502 Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov | 15 MB |
| | 0501 Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov | 8.84 MB |
| | 0602 Ranking data without sorting with RANK.mov | 10.72 MB |
| | 0604 Tabulating blank cells with COUNTBLANK.mov | 8.6 MB |
| | 0601 Finding the middle value with MEDIAN.mov | 3.36 MB |
| | 0603 Finding the magnitude data with LARGE and SMALL.mov | 3.24 MB |
| | 0701 Understanding Excel date time capabilities in formulas.mov | 13.05 MB |
| | 0702 Identifying the day of the week with WEEKDAY.mov | 12.02 MB |
| | 0705 Tabulating date time differences with DATEDIF.mov | 8.53 MB |
| | 0703 Counting working days with NETWORKDAYS.mov | 5.26 MB |
| | 0704 Determining a completion date with WORKDAY.mov | 4.27 MB |
| | 0801 Working with rounding functions.mov | 15.45 MB |
| | 0803 Building random number generators with RAND and RANDBETWEEN.mov | 11.36 MB |
| | 0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov | 10.8 MB |
| | 0802 Finding the remainder with MOD and using MOD with conditional formatting.mov | 10.39 MB |
| | 0804 Converting a value between measurement systems with CONVERT.mov | 7.87 MB |
| | 0901 Extending formula capabilities with arrays.mov | 17.68 MB |
| | 0902 Counting unique entries in a range with an array formula.mov | 11.49 MB |
| | 0906 Combining multiple functions in arrays.mov | 9.03 MB |
| | 0904 Flipping row column orientation with TRANSPOSE.mov | 8.95 MB |
| | 0905 Building analysis via regression techniques with TREND and GROWTH.mov | 8.54 MB |
| | 0903 Determining frequency distributions with FREQUENCY.mov | 6.05 MB |
| | 1006 Adjusting character content with REPLACE and SUBSTITUTE.mov | 11.31 MB |
| | 1001 Locating and extracting data with FIND and MID.mov | 10.99 MB |
| | 1003 Removing excess spaces with TRIM.mov | 10.36 MB |
| | 1007 Reviewing additional text functions.mov | 10.34 MB |
| | 1005 Adjusting case within cells with PROPER, UPPER, and LOWER.mov | 9.43 MB |
| | 1004 Using CONCATENATE with functions.mov | 7.29 MB |
| | 1002 Extracting specific data with LEFT and RIGHT.mov | 5.82 MB |
| | 1101 Calculating payments with PMT.mov | 7.86 MB |
| | 1103 Determining total amount of future payments with PV.mov | 7.65 MB |
| | 1102 Finding future values with FV.mov | 6.28 MB |
| | 1202 Using error-checking functions ISERR, ISERROR, IFERROR.mov | 12.78 MB |
| | 1201 Working with the IS information functions.mov | 8.16 MB |
| | 1302 Returning references with INDIRECT.mov | 20.26 MB |
| | 1301 Getting data from remote cells with OFFSET.mov | 7.66 MB |
| | 1401 Final thoughts.mov | 2.37 MB |
| | Ch 1 Tips.xlsx | 199.41 KB |
| | Ch 9 Array.xlsx | 165.26 KB |
| | Ch 6 Stat.xlsx | 107.26 KB |
| | Ch 4 LOOKUP.xlsx | 103.82 KB |
| | Ch 8 Math.xlsx | 70.88 KB |
| | Ch 2 Functions.xlsx | 64.78 KB |
| | Ch 5 Power.xlsx | 60.97 KB |
| | Ch 7 Date.xlsx | 44.79 KB |
| | Ch 3 IF.xlsx | 42.92 KB |
| | Ch 13 Reference.xlsx | 25.85 KB |