Lynda Excel 2011 for the Mac Mastering Formulas and Functions | B9C393B2C960F8DAD94CD995A7F1DB165655C570

Lynda Excel 2011 for the Mac Mastering Formulas and Functions

Name	Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions	DOWNLOAD Copy Link
Total Size	901.3 MB
Total Files	90
Hash	B9C393B2C960F8DAD94CD995A7F1DB165655C570

/
063 Extending formula capabilities with arrays.mp4	23.6 MB
048 Understanding Excel date-time capabilities in formulas.mp4	21.0 MB
017 Creating 3D formulas to gather data from multiple sheets.mp4	19.6 MB
068 Using array formula techniques with the MATCH function for complex lookups.mp4	18.9 MB
044 Using the random-number functions RAND and RANDBETWEEN.mp4	18.8 MB
016 Enhancing readability with range names.mp4	18.5 MB
020 Using the AND and OR functions with IF to create compound logical tests.mp4	18.4 MB
029 Using MATCH and INDEX together.mp4	18.2 MB
056 Locating and extracting data with FIND, SEARCH, and MID.mp4	17.4 MB
046 Using the powerful AGGREGATE function to bypass errors and hidden data.mp4	17.0 MB
035 Tabulating based on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mp4	16.9 MB
061 Adjusting character content with REPLACE and SUBSTITUTE.mp4	16.8 MB
036 Tabulating based on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mp4	16.5 MB
040 Working with ROUND, ROUNDUP, and ROUNDDOWN.mp4	16.4 MB
074 Using error-checking functions ISERR, ISERROR, IFERROR, and ISNA.mp4	16.4 MB
007 Using the Reference button on the Formulas tab for locating functions.mp4	16.4 MB
004 Using and extending AutoSum button capabilities.mp4	16.0 MB
062 Using other utility text functions - LEN, REPT, VALUE, TEXT.mp4	16.0 MB
071 Using INDIRECT with data validation for two-tiered pick-list scenarios.mp4	15.7 MB
022 Finding approximate matches with VLOOKUP.mp4	15.4 MB
072 Extracting information with the CELL and INFO functions.mp4	15.4 MB
010 Tracking cell dependencies and locating formula sources.mp4	14.8 MB
058 Removing extra spaces with TRIM.mp4	14.2 MB
012 Copying column formulas instantly.mp4	14.2 MB
023 Finding exact matches with VLOOKUP.mp4	14.1 MB
064 Counting unique entries in a range with an array formula.mp4	13.9 MB
043 Finding the remainder with MOD, and using MOD with conditional formatting.mp4	13.5 MB
037 Calculating payments with PMT.mp4	13.2 MB
053 Tabulating date differences with DATEDIF.mp4	12.9 MB
009 Displaying and highlighting formulas.mp4	12.9 MB
054 Calculating end-of-month and future-past dates with EDATE and EOMONTH.mp4	12.6 MB
050 Identifying the day of the week with WEEKDAY.mp4	12.5 MB
005 Using absolute and relative references in formulas.mp4	12.4 MB
059 Using ampersands and CONCATENATE to combine data from different cells.mp4	12.2 MB
027 Locating data with MATCH.mp4	12.2 MB
073 Using ISBLANK, ISODD, ISEVEN, ISTEXT, and ISNUMBER.mp4	12.2 MB
019 Creating and expanding the use of nested IF statements.mp4	12.0 MB
011 Using entire row and entire column references.mp4	12.0 MB
041 Working with MROUND, CEILING, and FLOOR for specialized rounding.mp4	11.8 MB
031 Ranking data without sorting, using the RANK function.mp4	11.8 MB
069 Getting data from remote cells with OFFSET.mp4	11.5 MB
018 Exploring IF logical tests and using relational operators.mp4	11.1 MB
013 Converting formulas to values with a simple drag.mp4	11.1 MB
049 Using TODAY and NOW functions for dynamic date-time entry.mp4	11.1 MB
003 Understanding the hierarchy of operations in Excel formulas.mp4	10.7 MB
024 Using VLOOKUP with large tables.mp4	10.6 MB
066 Flipping row-column orientation with TRANSPOSE.mp4	10.5 MB
006 Using mixed references in formulas.mp4	10.2 MB
034 Using COUNT, COUNTA, and the status bar.mp4	10.2 MB
025 Nesting VLOOKUP functions.mp4	10.2 MB
014 Updating values without formulas.mp4	9.9 MB
026 Finding table-like information within a function with CHOOSE.mp4	9.6 MB
060 Adjusting the case within cells using the PROPER, UPPER, and LOWER functions.mp4	9.5 MB
021 Looking up information with VLOOKUP and HLOOKUP.mp4	9.2 MB
067 Building analysis via regression techniques with TREND and GROWTH.mp4	8.8 MB
008 Using the Formula Builder button for guidance with unfamiliar functions.mp4	8.5 MB
015 Simplifying debugging formulas.mp4	8.5 MB
042 Using the INT and TRUNC functions to extract integer data.mp4	8.3 MB
055 Converting text entries into dates and times with DATEVALUE and TIMEVALUE.mp4	8.2 MB
065 Determining frequency distributions with FREQUENCY.mp4	8.1 MB
033 Tabulating blank cells with COUNTBLANK.mp4	8.1 MB
051 Counting working days with NETWORKDAYS.mp4	7.8 MB
057 Extracting specific data with LEFT and RIGHT.mp4	7.7 MB
039 Determining total amount of future payments with PV.mp4	7.3 MB
038 Finding future values with FV.mp4	7.1 MB
028 Retrieving information by location with INDEX.mp4	6.8 MB
001 Welcome.mp4	6.7 MB
070 Returning references with INDIRECT.mp4	6.7 MB
030 Finding the middle value with MEDIAN.mp4	5.9 MB
052 Determining a completion date with WORKDAY.mp4	5.6 MB
047 Using the ROMAN function to display different number systems.mp4	5.3 MB
045 Converting a value between measurement systems with CONVERT.mp4	5.1 MB
032 Finding the largest and smallest values with MAX, MIN, LARGE, and SMALL.mp4	5.1 MB
075 Goodbye.mp4	1.2 MB
002 Using the exercise files.mp4	1.2 MB
/Exercise Files/Ch09/
09-Date.xlsx	658.9 KB
/Exercise Files/Ch03/
03-IF Function.xlsx	611.7 KB
Lookup Functions.xlsx	351.2 KB
/Exercise Files/Ch01/
01-Tools.xlsx	497.9 KB
/Exercise Files/Ch04/
04-Lookup Functions.xlsx	370.7 KB
/Exercise Files/Ch02/
02-TipsShortcuts.xlsx	306.4 KB
02-RegionalSales.xlsx	39.5 KB
/Exercise Files/Ch11/
11-Array.xlsx	168.8 KB
/Exercise Files/Ch06/
06-PowerFunctions.xlsx	156.4 KB
/Exercise Files/Ch05/
05-Stat.xlsx	128.0 KB
/Exercise Files/Ch08/
08-Math.xlsx	72.4 KB
/Exercise Files/Ch10/
10-Text.xlsx	22.1 KB
/Exercise Files/Ch12/
12-Reference.xlsx	22.1 KB
/Exercise Files/Ch07/
07-FinancialFunctions.xlsx	16.8 KB
/Exercise Files/Ch13/
13-Information.xlsx	15.3 KB
Total files 90