Lynda.com Excel.2007 Advanced Formulas And Functions !h33t!
File List
- 08. Math Functions/08 01. Working with rounding functions.mov 12.8 MB
- 12. Information Functions/12 04. Returning references with INDIRECT.mov 12.7 MB
- 07. Date Functions/07 01. Understanding Excel date-time capabilities in formulas.mov 11.3 MB
- 00. Introduction/00 01. Welcome.mov 11.1 MB
- 02. Excel Functions/02 01. Understanding and using basic Excel functions.mov 11.0 MB
- 10. Text Functions/10 07. Reviewing additional text functions.mov 10.1 MB
- 09. Array Formulas and Functions/09 01. Extending formula capabilities with Arrays.mov 10.0 MB
- 04. Lookup and Reference Functions/04 02. Using VLOOKUP for approximate matches.mov 9.4 MB
- 12. Information Functions/12 02. Using error-checking functions ISERR, ISERROR, IFERROR.mov 9.3 MB
- 10. Text Functions/10 01. Locating and extracting data with FIND and MID.mov 8.4 MB
- 11. Financial Functions/11 01. Calculating payments with PMT.mov 8.4 MB
- 04. Lookup and Reference Functions/04 08. Using MATCH and INDEX together.mov 8.4 MB
- 08. Math Functions/08 03. Building random number generators with RAND and RANDBETWEEN.mov 7.9 MB
- 01. Formula and Function Tips-Shortcuts/01 09. Creating range names to enhance readability.mov 7.7 MB
- 01. Formula and Function Tips-Shortcuts/01 06. Showing all formulas with a single command.mov 7.6 MB
- 05. Power Functions/05 02. Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov 7.2 MB
- 02. Excel Functions/02 02. Using common functions SUM, AVERAGE, MAX, and MIN.mov 7.1 MB
- 03. IF and Related Functions/03 03. Using the AND, OR, and NOT functions with IF to create compound logical tests.mov 7.1 MB
- 04. Lookup and Reference Functions/04 01. Looking up information with VLOOKUP and HLOOKUP.mov 7.0 MB
- 05. Power Functions/05 01. Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov 6.8 MB
- 04. Lookup and Reference Functions/04 06. Locating data with MATCH.mov 6.6 MB
- 01. Formula and Function Tips-Shortcuts/01 04. Creating 3D formulas to gather data from multiple sheets.mov 6.5 MB
- 09. Array Formulas and Functions/09 02. Counting unique entries in a range with an Array formula.mov 6.5 MB
- 10. Text Functions/10 06. Adjusting character content with REPLACE and SUBSTITUTE.mov 6.4 MB
- 09. Array Formulas and Functions/09 06. Combining multiple functions in arrays.mov 6.4 MB
- 01. Formula and Function Tips-Shortcuts/01 08. Simplifying debugging formulas.mov 6.2 MB
- 06. Statistical Functions/06 02. Ranking data without sorting with RANK.mov 6.1 MB
- 12. Information Functions/12 03. Getting data from remote cells with OFFSET.mov 6.1 MB
- 02. Excel Functions/02 03. Using and extending AutoSum.mov 6.0 MB
- 03. IF and Related Functions/03 01. Exploring IF logical tests and using relational operators.mov 5.9 MB
- 12. Information Functions/12 01. Working with the IS information functions.mov 5.9 MB
- 11. Financial Functions/11 02. Finding future values with FV.mov 5.8 MB
- 01. Formula and Function Tips-Shortcuts/01 02. Copying column formulas instantly.mov 5.8 MB
- 03. IF and Related Functions/03 02. Creating and expanding the use of nested IFs.mov 5.7 MB
- 04. Lookup and Reference Functions/04 03. Using VLOOKUP for exact matches.mov 5.2 MB
- 01. Formula and Function Tips-Shortcuts/01 01. Using the entire row-column references.mov 5.2 MB
- 10. Text Functions/10 04. Using CONCATENATE with functions.mov 5.2 MB
- 07. Date Functions/07 05. Tabulating date-time differences with DATEDIF.mov 5.1 MB
- 01. Formula and Function Tips-Shortcuts/01 07. Highlighting formulas with two clicks.mov 5.1 MB
- 10. Text Functions/10 03. Removing excess spaces with TRIM.mov 5.0 MB
- 01. Formula and Function Tips-Shortcuts/01 03. Converting formulas to values with a simple drag.mov 5.0 MB
- 07. Date Functions/07 02. Identifying the day of the week with WEEKDAY.mov 4.8 MB
- 06. Statistical Functions/06 04. Tabulating blank cells with COUNTBLANK.mov 4.7 MB
- 10. Text Functions/10 05. Adjusting case within cells with PROPER, UPPER, and LOWER.mov 4.7 MB
- 08. Math Functions/08 02. Finding the remainder with MOD.mov 4.6 MB
- 09. Array Formulas and Functions/09 03. Determining frequency distributions with FREQUENCY.mov 4.5 MB
- 09. Array Formulas and Functions/09 04. Flipping row-column orientation with TRANSPOSE.mov 4.1 MB
- 04. Lookup and Reference Functions/04 04. Nesting Lookup functions.mov 4.1 MB
- 08. Math Functions/08 04. Converting a value between measurement systems with CONVERT.mov 4.0 MB
- 04. Lookup and Reference Functions/04 05. Finding table-like information within a function with CHOOSE.mov 4.0 MB
- 01. Formula and Function Tips-Shortcuts/01 05. Updating values without formulas.mov 3.8 MB
- 06. Statistical Functions/06 01. Finding the middle value with MEDIAN.mov 3.6 MB
- 10. Text Functions/10 02. Extracting specific data with LEFT and RIGHT.mov 3.5 MB
- 07. Date Functions/07 03. Counting working days with NETWORKDAYS.mov 3.4 MB
- 04. Lookup and Reference Functions/04 07. Retrieving information by location with INDEX.mov 3.0 MB
- 11. Financial Functions/11 03. Determining total amount of future payments with PV.mov 3.0 MB
- 09. Array Formulas and Functions/09 05. Building analysis via regression techniques with TREND and GROWTH.mov 2.8 MB
- 07. Date Functions/07 04. Determining a completion date with WORKDAY.mov 2.5 MB
- 06. Statistical Functions/06 03. Finding the magnitude data with LARGE and SMALL.mov 2.4 MB
- 00. Introduction/00 02. Using the exercise files.mov 1.3 MB
- Exercise Files/Ex_Files_Excel07_Ad_Form.zip 784.9 KB
- 13. Conclusion/13 01. Goodbye.mov 667.3 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.