| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Extending formula capabilities with arrays-135786.mp4 |
25.4 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using INDIRECT with data validation for two-tiered pick list scenarios-135795.mp4 |
18.7 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Finding approximate matches with VLOOKUP-135750.mp4 |
17.3 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using MATCH and INDEX together-135757.mp4 |
17.3 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Tabulating blank cells with COUNTBLANK-135765.mp4 |
16.7 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Understanding Excel date_time capabilities in formulas-135777.mp4 |
16.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Practical uses for the random number functions RAND and RANDBETWEEN-135772.mp4 |
15 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Counting unique entries in a range with an array formula-135787.mp4 |
15 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Auditing tools-135729.mp4 |
14.6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Enhancing readability with range names-135735.mp4 |
14.1 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Displaying and highlighting formulas-135728.mp4 |
13.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using the powerful AGGREGATE function to bypass errors and hidden data-135774.mp4 |
13.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using the AND and OR functions with IF to create compound logical tests-135747.mp4 |
13.4 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using other utility text functions - LEN, REPT, VALUE, TEXT-135803.mp4 |
12.7 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using error-checking functions ISERR, ISERROR, IFERROR, ISNA, and IFNA-135807.mp4 |
12.6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ranking data without sorting with RANK-135763.mp4 |
12.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using and extending AutoSum button capabilities-135741.mp4 |
12.3 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Looking up information with VLOOKUP and HLOOKUP-135749.mp4 |
12.2 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF-135759.mp4 |
12.2 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Tabulating date differences with DATEDIF-135782.mp4 |
11.6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Getting data from remote cells with OFFSET-135793.mp4 |
11.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Working with ROUND, ROUNDUP, and ROUNDDOWN-135768.mp4 |
11.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using ampersands and CONCATENATE to combine data from different cells-135800.mp4 |
11.2 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Adjusting character content with REPLACE and SUBSTITUTE-135802.mp4 |
11.1 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using entire row_column references-135730.mp4 |
11 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Calculating end-of-month and future_past dates with EDATE and EOMONTH-135783.mp4 |
10.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Finding the remainder with MOD and using MOD with conditional formatting-135771.mp4 |
10.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Tabulating information using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS-135760.mp4 |
10.8 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Building analysis via regression techniques with TREND and GROWTH-135790.mp4 |
10.7 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Copying column formulas instantly-135731.mp4 |
10.6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using ISBLANK, ISODD, ISEVEN, ISTEXT, and ISNUMBER-135806.mp4 |
10.1 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Simplifying debugging formulas-135734.mp4 |
10 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Extracting information with the CELL and INFO functions-135805.mp4 |
10 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Locating and extracting data with FIND, SEARCH, and MID-135797.mp4 |
10 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Working with MROUND, CEILING, and FLOOR for specialized rounding-135769.mp4 |
9.8 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Nesting lookup functions-135752.mp4 |
9.7 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Identifying the day of the week with WEEKDAY-135779.mp4 |
9.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Removing extra spaces with TRIM and removing hidden characters with CLEAN-135799.mp4 |
9.4 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Finding exact matches with VLOOKUP-135751.mp4 |
9.2 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Converting text entries into dates and times with DATEVALUE and TIMEVALUE-135784.mp4 |
9.1 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Locating data with MATCH-135755.mp4 |
9.1 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using array formula techniques with the MATCH function for complex lookups-135791.mp4 |
9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Creating 3D formulas to gather data from multiple sheets-135736.mp4 |
8.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Determining frequency distributions with FREQUENCY-135788.mp4 |
8.7 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using VLOOKUP with large tables-135753.mp4 |
8.6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Returning references with INDIRECT-135794.mp4 |
8.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Converting formulas to values with a simple drag-135732.mp4 |
8.3 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Adjusting the case within cells with PROPER, UPPER, and LOWER-135801.mp4 |
8.1 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Counting working days with NETWORKDAYS-135780.mp4 |
8 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using the Insert Function button for guidance with unfamiliar functions-135740.mp4 |
7.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Flipping row_column orientation with TRANSPOSE-135789.mp4 |
7.8 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using mixed references in formulas-135743.mp4 |
7.7 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Creating and expanding the use of nested IF statements-135746.mp4 |
7.6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using COUNT, COUNTA, and the status bar-135766.mp4 |
7.2 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Finding the middle value with MEDIAN-135762.mp4 |
6.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Exploring IF logical tests and using relational operators-135745.mp4 |
6.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using the Formulas tab on the Ribbon for locating functions-135739.mp4 |
6.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using TODAY and NOW functions for dynamic date_time entry-135778.mp4 |
6.8 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Determining a completion date with WORKDAY-135781.mp4 |
6.6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Converting a value between measurement systems with CONVERT-135773.mp4 |
6.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using absolute and relative references in formulas-135742.mp4 |
6.5 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using the INT and TRUNC functions to extract integer data-135770.mp4 |
6.2 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Finding table-like information within a function with CHOOSE-135754.mp4 |
6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Retrieving information by location with INDEX-135756.mp4 |
5.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Extracting specific data with LEFT and RIGHT-135798.mp4 |
5.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Welcome-135725.mp4 |
5.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using the ROMAN and ARABIC functions to display different numeral systems-135775.mp4 |
5.9 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Updating values without formulas-135733.mp4 |
5.6 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Understanding the hierarchy of operations in Excel formulas-135738.mp4 |
5.4 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using the ISFORMULA function with conditional formatting-135808.mp4 |
5.1 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Finding the largest and smallest values with LARGE and SMALL-135764.mp4 |
4.4 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Using the exercise files-135726.mp4 |
1.7 MB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Goodbye-135810.mp4 |
780 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch03/03-IF Function.xlsx |
537 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch02/02-Tools.xlsx |
446 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch04/04-LookupFunctions.xlsx |
333 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch01/01-TipsShortcuts.xlsx |
280 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch05/05-COUNTIF-SUMIF.xlsx |
269 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch09/09-Array.xlsx |
157 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch06/06-Stat.xlsx |
122 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch07/07-Math.xlsx |
64 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch08/08-Date.xlsx |
57 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch01/01-RegionalSales.xlsx |
39 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch10/10-Reference.xlsx |
24 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch11/11-Text.xlsx |
22 KB |
| Lynda - Excel 2013 Tutorials Advanced Formulas and Functions/Ex_Files_EX2013_AdvForm/Exercise Files/Ch12/12-Information.xlsx |
16 KB |
Magnet link
