Lynda Com Excel 2007 Advanced Formulas and Functions
File List
| File | Size |
|---|---|
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/00. Introduction/00 01. Welcome.mov | 11.06 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/00. Introduction/00 02. Using the exercise files.mov | 1.26 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 01. Using the entire row-column references.mov | 5.2 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 02. Copying column formulas instantly.mov | 5.75 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 03. Converting formulas to values with a simple drag.mov | 4.96 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 04. Creating 3D formulas to gather data from multiple sheets.mov | 6.51 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 05. Updating values without formulas.mov | 3.83 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 06. Showing all formulas with a single command.mov | 7.63 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 07. Highlighting formulas with two clicks.mov | 5.09 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 08. Simplifying debugging formulas.mov | 6.16 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/01. Formula and Function Tips-Shortcuts/01 09. Creating range names to enhance readability.mov | 7.66 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/02. Excel Functions/02 01. Understanding and using basic Excel functions.mov | 11.05 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/02. Excel Functions/02 02. Using common functions SUM, AVERAGE, MAX, and MIN.mov | 7.12 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/02. Excel Functions/02 03. Using and extending AutoSum.mov | 6.05 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/03. IF and Related Functions/03 01. Exploring IF logical tests and using relational operators.mov | 5.93 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/03. IF and Related Functions/03 02. Creating and expanding the use of nested IFs.mov | 5.65 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/03. IF and Related Functions/03 03. Using the AND, OR, and NOT functions with IF to create compound logical tests.mov | 7.08 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/04. Lookup and Reference Functions/04 01. Looking up information with VLOOKUP and HLOOKUP.mov | 7.02 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/04. Lookup and Reference Functions/04 02. Using VLOOKUP for approximate matches.mov | 9.38 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/04. Lookup and Reference Functions/04 03. Using VLOOKUP for exact matches.mov | 5.2 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/04. Lookup and Reference Functions/04 04. Nesting Lookup functions.mov | 4.08 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/04. Lookup and Reference Functions/04 05. Finding table-like information within a function with CHOOSE.mov | 4.03 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/04. Lookup and Reference Functions/04 06. Locating data with MATCH.mov | 6.62 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/04. Lookup and Reference Functions/04 07. Retrieving information by location with INDEX.mov | 2.97 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/04. Lookup and Reference Functions/04 08. Using MATCH and INDEX together.mov | 8.36 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/05. Power Functions/05 01. Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov | 6.84 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/05. Power Functions/05 02. Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov | 7.22 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/06. Statistical Functions/06 01. Finding the middle value with MEDIAN.mov | 3.62 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/06. Statistical Functions/06 02. Ranking data without sorting with RANK.mov | 6.12 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/06. Statistical Functions/06 03. Finding the magnitude data with LARGE and SMALL.mov | 2.43 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/06. Statistical Functions/06 04. Tabulating blank cells with COUNTBLANK.mov | 4.75 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/07. Date Functions/07 01. Understanding Excel date-time capabilities in formulas.mov | 11.34 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/07. Date Functions/07 02. Identifying the day of the week with WEEKDAY.mov | 4.75 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/07. Date Functions/07 03. Counting working days with NETWORKDAYS.mov | 3.4 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/07. Date Functions/07 04. Determining a completion date with WORKDAY.mov | 2.52 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/07. Date Functions/07 05. Tabulating date-time differences with DATEDIF.mov | 5.15 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/08. Math Functions/08 01. Working with rounding functions.mov | 12.83 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/08. Math Functions/08 02. Finding the remainder with MOD.mov | 4.63 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/08. Math Functions/08 03. Building random number generators with RAND and RANDBETWEEN.mov | 7.89 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/08. Math Functions/08 04. Converting a value between measurement systems with CONVERT.mov | 4.04 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/09. Array Formulas and Functions/09 01. Extending formula capabilities with Arrays.mov | 10.02 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/09. Array Formulas and Functions/09 02. Counting unique entries in a range with an Array formula.mov | 6.5 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/09. Array Formulas and Functions/09 03. Determining frequency distributions with FREQUENCY.mov | 4.48 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/09. Array Formulas and Functions/09 04. Flipping row-column orientation with TRANSPOSE.mov | 4.1 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/09. Array Formulas and Functions/09 05. Building analysis via regression techniques with TREND and GROWTH.mov | 2.84 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/09. Array Formulas and Functions/09 06. Combining multiple functions in arrays.mov | 6.37 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/10. Text Functions/10 01. Locating and extracting data with FIND and MID.mov | 8.41 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/10. Text Functions/10 02. Extracting specific data with LEFT and RIGHT.mov | 3.48 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/10. Text Functions/10 03. Removing excess spaces with TRIM.mov | 5.04 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/10. Text Functions/10 04. Using CONCATENATE with functions.mov | 5.16 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/10. Text Functions/10 05. Adjusting case within cells with PROPER, UPPER, and LOWER.mov | 4.67 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/10. Text Functions/10 06. Adjusting character content with REPLACE and SUBSTITUTE.mov | 6.37 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/10. Text Functions/10 07. Reviewing additional text functions.mov | 10.05 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/11. Financial Functions/11 01. Calculating payments with PMT.mov | 8.4 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/11. Financial Functions/11 02. Finding future values with FV.mov | 5.81 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/11. Financial Functions/11 03. Determining total amount of future payments with PV.mov | 2.97 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/12. Information Functions/12 01. Working with the IS information functions.mov | 5.9 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/12. Information Functions/12 02. Using error-checking functions ISERR, ISERROR, IFERROR.mov | 9.28 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/12. Information Functions/12 03. Getting data from remote cells with OFFSET.mov | 6.08 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/12. Information Functions/12 04. Returning references with INDIRECT.mov | 12.7 MB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/13. Conclusion/13 01. Goodbye.mov | 667.34 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 1 Tips.xlsx | 189.71 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 10 Text.xlsx | 18.33 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 11 Financial.xlsx | 12.94 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 12 Information.xlsx | 29.26 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 2 Functions.xlsx | 56.84 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 3 IF.xlsx | 42.36 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 4 LOOKUP.xlsx | 106.31 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 5 Power.xlsx | 56.6 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 6 Stat.xlsx | 114.1 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 7 Date.xlsx | 41.08 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 8 Math.xlsx | 69.74 KB |
| Lynda.com.Excel.2007.Advanced.Formulas.and.Functions/Exercise Files/Ch 9 Array.xlsx | 162.54 KB |
Trackers
No trackers found.