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