Lynda Excel 2013 Tutorials Advanced Formulas and Functions | B9DC779BF99D7E58104A6C8AE0123A0B5CBD5D56

Lynda Excel 2013 Tutorials Advanced Formulas and Functions

Name	Lynda - Excel 2013 Tutorials Advanced Formulas and Functions	DOWNLOAD Copy Link
Total Size	762.3 MB
Total Files	86
Hash	B9DC779BF99D7E58104A6C8AE0123A0B5CBD5D56

/
Extending formula capabilities with arrays-135786.mp4	26.6 MB
Using INDIRECT with data validation for two-tiered pick list scenarios-135795.mp4	19.7 MB
Finding approximate matches with VLOOKUP-135750.mp4	18.2 MB
Using MATCH and INDEX together-135757.mp4	18.1 MB
Tabulating blank cells with COUNTBLANK-135765.mp4	17.5 MB
Understanding Excel date_time capabilities in formulas-135777.mp4	17.3 MB
Practical uses for the random number functions RAND and RANDBETWEEN-135772.mp4	15.8 MB
Counting unique entries in a range with an array formula-135787.mp4	15.7 MB
Auditing tools-135729.mp4	15.3 MB
Enhancing readability with range names-135735.mp4	14.8 MB
Displaying and highlighting formulas-135728.mp4	14.1 MB
Using the powerful AGGREGATE function to bypass errors and hidden data-135774.mp4	14.1 MB
Using the AND and OR functions with IF to create compound logical tests-135747.mp4	14.0 MB
Using other utility text functions - LEN, REPT, VALUE, TEXT-135803.mp4	13.3 MB
Using error-checking functions ISERR, ISERROR, IFERROR, ISNA, and IFNA-135807.mp4	13.2 MB
Ranking data without sorting with RANK-135763.mp4	13.1 MB
Using and extending AutoSum button capabilities-135741.mp4	12.9 MB
Looking up information with VLOOKUP and HLOOKUP-135749.mp4	12.8 MB
Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF-135759.mp4	12.8 MB
Tabulating date differences with DATEDIF-135782.mp4	12.1 MB
Getting data from remote cells with OFFSET-135793.mp4	12.0 MB
Working with ROUND, ROUNDUP, and ROUNDDOWN-135768.mp4	12.0 MB
Using ampersands and CONCATENATE to combine data from different cells-135800.mp4	11.7 MB
Adjusting character content with REPLACE and SUBSTITUTE-135802.mp4	11.7 MB
Using entire row_column references-135730.mp4	11.6 MB
Calculating end-of-month and future_past dates with EDATE and EOMONTH-135783.mp4	11.5 MB
Finding the remainder with MOD and using MOD with conditional formatting-135771.mp4	11.4 MB
Tabulating information using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS-135760.mp4	11.3 MB
Building analysis via regression techniques with TREND and GROWTH-135790.mp4	11.2 MB
Copying column formulas instantly-135731.mp4	11.1 MB
Using ISBLANK, ISODD, ISEVEN, ISTEXT, and ISNUMBER-135806.mp4	10.6 MB
Simplifying debugging formulas-135734.mp4	10.5 MB
Extracting information with the CELL and INFO functions-135805.mp4	10.5 MB
Locating and extracting data with FIND, SEARCH, and MID-135797.mp4	10.4 MB
Working with MROUND, CEILING, and FLOOR for specialized rounding-135769.mp4	10.2 MB
Nesting lookup functions-135752.mp4	10.1 MB
Identifying the day of the week with WEEKDAY-135779.mp4	10.0 MB
Removing extra spaces with TRIM and removing hidden characters with CLEAN-135799.mp4	9.9 MB
Finding exact matches with VLOOKUP-135751.mp4	9.6 MB
Converting text entries into dates and times with DATEVALUE and TIMEVALUE-135784.mp4	9.5 MB
Locating data with MATCH-135755.mp4	9.5 MB
Using array formula techniques with the MATCH function for complex lookups-135791.mp4	9.4 MB
Creating 3D formulas to gather data from multiple sheets-135736.mp4	9.3 MB
Determining frequency distributions with FREQUENCY-135788.mp4	9.1 MB
Using VLOOKUP with large tables-135753.mp4	9.0 MB
Returning references with INDIRECT-135794.mp4	8.9 MB
Converting formulas to values with a simple drag-135732.mp4	8.7 MB
Adjusting the case within cells with PROPER, UPPER, and LOWER-135801.mp4	8.5 MB
Counting working days with NETWORKDAYS-135780.mp4	8.4 MB
Using the Insert Function button for guidance with unfamiliar functions-135740.mp4	8.3 MB
Flipping row_column orientation with TRANSPOSE-135789.mp4	8.2 MB
Using mixed references in formulas-135743.mp4	8.1 MB
Creating and expanding the use of nested IF statements-135746.mp4	7.9 MB
Using COUNT, COUNTA, and the status bar-135766.mp4	7.5 MB
Finding the middle value with MEDIAN-135762.mp4	7.2 MB
Exploring IF logical tests and using relational operators-135745.mp4	7.2 MB
Using the Formulas tab on the Ribbon for locating functions-135739.mp4	7.2 MB
Using TODAY and NOW functions for dynamic date_time entry-135778.mp4	7.1 MB
Determining a completion date with WORKDAY-135781.mp4	6.9 MB
Converting a value between measurement systems with CONVERT-135773.mp4	6.9 MB
Using absolute and relative references in formulas-135742.mp4	6.8 MB
Using the INT and TRUNC functions to extract integer data-135770.mp4	6.5 MB
Finding table-like information within a function with CHOOSE-135754.mp4	6.3 MB
Retrieving information by location with INDEX-135756.mp4	6.2 MB
Extracting specific data with LEFT and RIGHT-135798.mp4	6.2 MB
Welcome-135725.mp4	6.2 MB
Using the ROMAN and ARABIC functions to display different numeral systems-135775.mp4	6.1 MB
Updating values without formulas-135733.mp4	5.9 MB
Understanding the hierarchy of operations in Excel formulas-135738.mp4	5.7 MB
Using the ISFORMULA function with conditional formatting-135808.mp4	5.4 MB
Finding the largest and smallest values with LARGE and SMALL-135764.mp4	4.7 MB
Using the exercise files-135726.mp4	1.8 MB
Goodbye-135810.mp4	799.1 KB
/Exercise Files/Ch03/
03-IF Function.xlsx	550.2 KB
/Exercise Files/Ch02/
02-Tools.xlsx	456.9 KB
/Exercise Files/Ch04/
04-LookupFunctions.xlsx	340.8 KB
/Exercise Files/Ch01/
01-TipsShortcuts.xlsx	286.3 KB
01-RegionalSales.xlsx	40.1 KB
/Exercise Files/Ch05/
05-COUNTIF-SUMIF.xlsx	275.3 KB
/Exercise Files/Ch09/
09-Array.xlsx	160.4 KB
/Exercise Files/Ch06/
06-Stat.xlsx	124.7 KB
/Exercise Files/Ch07/
07-Math.xlsx	65.9 KB
/Exercise Files/Ch08/
08-Date.xlsx	58.1 KB
/Exercise Files/Ch10/
10-Reference.xlsx	24.3 KB
/Exercise Files/Ch11/
11-Text.xlsx	23.0 KB
/Exercise Files/Ch12/
12-Information.xlsx	16.3 KB
Total files 86