Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions
File Information:
Magnet LinkFile List:
- 063 Extending formula capabilities with arrays.mp4 22.50 MB
- 048 Understanding Excel date-time capabilities in formulas.mp4 20.05 MB
- 017 Creating 3D formulas to gather data from multiple sheets.mp4 18.69 MB
- 068 Using array formula techniques with the MATCH function for complex lookups.mp4 17.99 MB
- 044 Using the random-number functions RAND and RANDBETWEEN.mp4 17.89 MB
- 016 Enhancing readability with range names.mp4 17.60 MB
- 020 Using the AND and OR functions with IF to create compound logical tests.mp4 17.52 MB
- 029 Using MATCH and INDEX together.mp4 17.36 MB
- 056 Locating and extracting data with FIND, SEARCH, and MID.mp4 16.56 MB
- 046 Using the powerful AGGREGATE function to bypass errors and hidden data.mp4 16.25 MB
- 035 Tabulating based on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mp4 16.12 MB
- 061 Adjusting character content with REPLACE and SUBSTITUTE.mp4 16.05 MB
- 036 Tabulating based on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mp4 15.74 MB
- 040 Working with ROUND, ROUNDUP, and ROUNDDOWN.mp4 15.66 MB
- 074 Using error-checking functions ISERR, ISERROR, IFERROR, and ISNA.mp4 15.65 MB
- 007 Using the Reference button on the Formulas tab for locating functions.mp4 15.62 MB
- 004 Using and extending AutoSum button capabilities.mp4 15.24 MB
- 062 Using other utility text functions - LEN, REPT, VALUE, TEXT.mp4 15.23 MB
- 071 Using INDIRECT with data validation for two-tiered pick-list scenarios.mp4 14.97 MB
- 022 Finding approximate matches with VLOOKUP.mp4 14.70 MB
- 072 Extracting information with the CELL and INFO functions.mp4 14.67 MB
- 010 Tracking cell dependencies and locating formula sources.mp4 14.14 MB
- 058 Removing extra spaces with TRIM.mp4 13.52 MB
- 012 Copying column formulas instantly.mp4 13.50 MB
- 023 Finding exact matches with VLOOKUP.mp4 13.49 MB
- 064 Counting unique entries in a range with an array formula.mp4 13.23 MB
- 043 Finding the remainder with MOD, and using MOD with conditional formatting.mp4 12.90 MB
- 037 Calculating payments with PMT.mp4 12.58 MB
- 053 Tabulating date differences with DATEDIF.mp4 12.30 MB
- 009 Displaying and highlighting formulas.mp4 12.30 MB
- 054 Calculating end-of-month and future-past dates with EDATE and EOMONTH.mp4 12.04 MB
- 050 Identifying the day of the week with WEEKDAY.mp4 11.88 MB
- 005 Using absolute and relative references in formulas.mp4 11.84 MB
- 059 Using ampersands and CONCATENATE to combine data from different cells.mp4 11.66 MB
- 027 Locating data with MATCH.mp4 11.66 MB
- 073 Using ISBLANK, ISODD, ISEVEN, ISTEXT, and ISNUMBER.mp4 11.64 MB
- 019 Creating and expanding the use of nested IF statements.mp4 11.49 MB
- 011 Using entire row and entire column references.mp4 11.41 MB
- 041 Working with MROUND, CEILING, and FLOOR for specialized rounding.mp4 11.28 MB
- 031 Ranking data without sorting, using the RANK function.mp4 11.27 MB
- 069 Getting data from remote cells with OFFSET.mp4 10.96 MB
- 018 Exploring IF logical tests and using relational operators.mp4 10.62 MB
- 013 Converting formulas to values with a simple drag.mp4 10.60 MB
- 049 Using TODAY and NOW functions for dynamic date-time entry.mp4 10.54 MB
- 003 Understanding the hierarchy of operations in Excel formulas.mp4 10.19 MB
- 024 Using VLOOKUP with large tables.mp4 10.13 MB
- 066 Flipping row-column orientation with TRANSPOSE.mp4 10.04 MB
- 006 Using mixed references in formulas.mp4 9.76 MB
- 034 Using COUNT, COUNTA, and the status bar.mp4 9.76 MB
- 025 Nesting VLOOKUP functions.mp4 9.73 MB
Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions
Hot Tags: