lynda.com - Excel 2010: Advanced Formulas and Functions [ENG, 2010]
movies, software, shows...
Files
| 00 Introduction | |||
| 0001 Welcome.mov | 11.44 MB | ||
| 0002 Using the exercise files.mov | 837.85 KB | ||
| 01 Formula and Function Tips and Shortcuts | |||
| 0101 Using the entire row column references.mov | 14.73 MB | ||
| 0102 Copying column formulas instantly.mov | 9.92 MB | ||
| 0103 Converting formulas to values with a simple drag.mov | 5.98 MB | ||
| 0104 Creating 3D formulas to gather data from multiple sheets.mov | 10.05 MB | ||
| 0105 Updating values without formulas.mov | 5.49 MB | ||
| 0106 Displaying and highlighting formulas.mov | 21.76 MB | ||
| 0107 Simplifying debugging formulas.mov | 8.43 MB | ||
| 0108 Enhancing readability with range names.mov | 12.74 MB | ||
| 02 Formula and Function Tools | |||
| 0201 Reviewing function basics.mov | 29.06 MB | ||
| 0202 Using and extending AutoSum.mov | 10.33 MB | ||
| 0203 Using absolute and relative references.mov | 8.99 MB | ||
| 0204 Using mixed references.mov | 10.8 MB | ||
| 03 IF and Related Functions | |||
| 0301 Exploring IF logical tests and using relational operators.mov | 7.97 MB | ||
| 0302 Creating and expanding the use of nested IF statements.mov | 7.29 MB | ||
| 0303 Using the AND, OR, and NOT functions with IF to create compound logical tests.mov | 12.97 MB | ||
| 04 Lookup and Reference Function | |||
| 0401 Looking up information with VLOOKUP and HLOOKUP.mov | 10.21 MB | ||
| 0402 Finding approximate matches with VLOOKUP.mov | 13.74 MB | ||
| 0403 Finding exact matches with VLOOKUP.mov | 7.83 MB | ||
| 0404 Nesting LOOKUP functions.mov | 12.92 MB | ||
| 0405 Finding table-like information within a function with CHOOSE.mov | 6.29 MB | ||
| 0406 Locating data with MATCH.mov | 10.45 MB | ||
| 0407 Retrieving information by location with INDEX.mov | 9.63 MB | ||
| 0408 Using MATCH and INDEX together.mov | 13.84 MB | ||
| 05 Power Functions | |||
| 0501 Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov | 8.84 MB | ||
| 0502 Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov | 15 MB | ||
| 06 Statistical Functions | |||
| 0601 Finding the middle value with MEDIAN.mov | 3.36 MB | ||
| 0602 Ranking data without sorting with RANK.mov | 10.72 MB | ||
| 0603 Finding the magnitude data with LARGE and SMALL.mov | 3.24 MB | ||
| 0604 Tabulating blank cells with COUNTBLANK.mov | 8.6 MB | ||
| 07 Data Functions | |||
| 0701 Understanding Excel date time capabilities in formulas.mov | 13.05 MB | ||
| 0702 Identifying the day of the week with WEEKDAY.mov | 12.02 MB | ||
| 0703 Counting working days with NETWORKDAYS.mov | 5.26 MB | ||
| 0704 Determining a completion date with WORKDAY.mov | 4.27 MB | ||
| 0705 Tabulating date time differences with DATEDIF.mov | 8.53 MB | ||
| 08 Math Functions | |||
| 0801 Working with rounding functions.mov | 15.45 MB | ||
| 0802 Finding the remainder with MOD and using MOD with conditional formatting.mov | 10.39 MB | ||
| 0803 Building random number generators with RAND and RANDBETWEEN.mov | 11.36 MB | ||
| 0804 Converting a value between measurement systems with CONVERT.mov | 7.87 MB | ||
| 0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov | 10.8 MB | ||
| 09 Array Formulas and Functions | |||
| 0901 Extending formula capabilities with arrays.mov | 17.68 MB | ||
| 0902 Counting unique entries in a range with an array formula.mov | 11.49 MB | ||
| 0903 Determining frequency distributions with FREQUENCY.mov | 6.05 MB | ||
| 0904 Flipping row column orientation with TRANSPOSE.mov | 8.95 MB | ||
| 0905 Building analysis via regression techniques with TREND and GROWTH.mov | 8.54 MB | ||
| 0906 Combining multiple functions in arrays.mov | 9.03 MB | ||
| 10 Text Functions | |||
| 1001 Locating and extracting data with FIND and MID.mov | 10.99 MB | ||
| 1002 Extracting specific data with LEFT and RIGHT.mov | 5.82 MB | ||
| 1003 Removing excess spaces with TRIM.mov | 10.36 MB | ||
| 1004 Using CONCATENATE with functions.mov | 7.29 MB | ||
| 1005 Adjusting case within cells with PROPER, UPPER, and LOWER.mov | 9.43 MB | ||
| 1006 Adjusting character content with REPLACE and SUBSTITUTE.mov | 11.31 MB | ||
| 1007 Reviewing additional text functions.mov | 10.34 MB | ||
| 11 Financial Functions | |||
| 1101 Calculating payments with PMT.mov | 7.86 MB | ||
| 1102 Finding future values with FV.mov | 6.28 MB | ||
| 1103 Determining total amount of future payments with PV.mov | 7.65 MB | ||
| 12 Information Functions | |||
| 1201 Working with the IS information functions.mov | 8.16 MB | ||
| 1202 Using error-checking functions ISERR, ISERROR, IFERROR.mov | 12.78 MB | ||
| 13 Reference Functions | |||
| 1301 Getting data from remote cells with OFFSET.mov | 7.66 MB | ||
| 1302 Returning references with INDIRECT.mov | 20.26 MB | ||
| 14 Conclusion | |||
| 1401 Final thoughts.mov | 2.37 MB | ||
| Exercise Files | |||
| Ch 1 Tips.xlsx | 199.41 KB | ||
| Ch 10 Text.xlsx | 21.36 KB | ||
| Ch 11 Financial.xlsx | 12.66 KB | ||
| Ch 12 Information.xlsx | 14.75 KB | ||
| Ch 13 Reference.xlsx | 25.85 KB | ||
| Ch 2 Functions.xlsx | 64.78 KB | ||
| Ch 3 IF.xlsx | 42.92 KB | ||
| Ch 4 LOOKUP.xlsx | 103.82 KB | ||
| Ch 5 Power.xlsx | 60.97 KB | ||
| Ch 6 Stat.xlsx | 107.26 KB | ||
| Ch 7 Date.xlsx | 44.79 KB | ||
| Ch 8 Math.xlsx | 70.88 KB | ||
| Ch 9 Array.xlsx | 165.26 KB | ||
| ▲ 75 total files | |||
Description
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Офисные программы Microsoft
lynda.com - Excel 2010: Advanced Formulas and Functions [ENG]
Год выпуска: 2010
Производитель: lynda.com
Сайт производителя: http://lynda.com
Автор: Dennis Taylor
Продолжительность: 05:05:00
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best use. The course reviews the building-block functions, along with a few critical keyboard shortcuts that will speed up working with Excel data. It also covers how to perform advanced searching and data retrieval with LOOKUP functions, tabulate data with counting, statistical, and math functions, reformat data with text functions, and work with financial data using advanced formulas. Exercise files accompany the course.
Topics include:
- Referencing, copying, updating, and converting formulas
- Using the logical functions and creating compound logic tests
- Searching for and matching data based on specific criteria
- Reconfiguring cell data using text functions
- Calculating dates, times, and days of the week
- Analyzing mathematical and financial data
- Using the power functions, COUNTIFS, SUMIFS, and AVERAGEIFS
- Working with rounding functions
- Returning cell references
[spoiler="Содержание"]
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MOV
Видео: Видеокодек: AVC Битрейт видео: ~62.3 - 964 кбит/с Размер кадра: 960 x 540
Аудио: Аудиокодек: AAC Битрейт аудио: 96,0 - 159 Кбит/сек 2 канала 48,0 КГц
[spoiler="Скриншоты"]
[/spoiler]
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 496.73 MB | Midiablooo | 3 years | 0 | 0 | |
| 1 GB | TutorialPace | 6 years | 0 | 1 | |
| 1.07 GB | Hrund | 6 years | 0 | 0 | |
|
[Lynda.com] - Foundations of Programming : Web Security (2014) [WebDL MP4 720p EN ] Posted by
Imadiano in Other
|
299.07 MB | Imadiano | 6 years | 6 | 0 |
| 916.21 MB | Hrund | 6 years | 0 | 0 |
All Comments