[valentin]

lynda.com | Excel 2010: Advanced Formulas and Functions [2010] [EN] PCRec

Автор (режиссер): lynda.com
Название: Excel 2010: Advanced Formulas and Functions
Год выпуска: 2010
Жанр: Excel
Язык: EN
Качество видео: PCRec
Продолжительность: 05:05:00
Видеокодек: Advanced Video Codec (AVC)
Битрейт видео: ~62.3 - 964 кбит/с
Размер кадра: 960 x 540
Аудиокодек: Advanced Audio Codec (AAC)
Битрейт аудио: 96,0 - 159 Кбит/сек 2 канала 48,0 КГц

Описание:
В курсе Excel 2010: Advanced Formulas and Functions автор Dennis Taylor снимает завесу таинственности с формул и некоторых из почти 400 функций в Excel и показывает, как ими лучше всего пользоваться. Курс рассматривает блоки функций вместе с некоторыми критичными быстрыми клавишами, которые ускорят работу с данными Excel. Он также охватывает представление продвинутого поиска и извлечения данных с помощью функции LOOKUP, сведение в таблицы с подсчетом, статистические и математические функции, форматирование данных текстовыми функциями и работу с финансовыми данными с использованием продвинутых формул.
Файлы упражнений прилагаются к курсу.

Introduction

Welcome 1:25

Using the exercise files 0:24

1. Formula and Function Tips and Shortcuts

Using the entire row/column references 5:43

Copying column formulas instantly 4:35

Converting formulas to values with a simple drag 5:10

Creating 3D formulas to gather data from multiple sheets 5:17

Updating values without formulas 4:25

Displaying and highlighting formulas 7:15

Simplifying debugging formulas 6:29

Enhancing readability with range names 8:18

2. Formula and Function Tools

Reviewing function basics 7:12

Using and extending AutoSum 4:55

Using absolute and relative references 4:52

Using mixed references 5:33

3. IF and Related Functions

Exploring IF logical tests and using relational operators 4:43

Creating and expanding the use of nested IF statements 4:47

Using the AND, OR, and NOT functions with IF to create compound logical tests 7:09

4. Lookup and Reference Functions

Looking up information with VLOOKUP and HLOOKUP 4:27

Finding approximate matches with VLOOKUP 6:22

Finding exact matches with VLOOKUP 4:21

Nesting LOOKUP functions 5:51

Finding table-like information within a function with CHOOSE 3:51

Locating data with MATCH 5:03

Retrieving information by location with INDEX 4:51

Using MATCH and INDEX together 6:15

5. Power Functions

Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF 4:49

Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS 7:38

6. Statistical Functions

Finding the middle value with MEDIAN 1:35

Ranking data without sorting with RANK 4:50

Finding the magnitude data with LARGE and SMALL 1:46

Tabulating blank cells with COUNTBLANK 3:24

7. Data Functions

Understanding Excel date/time capabilities in formulas 7:18

Identifying the day of the week with WEEKDAY 6:02

Counting working days with NETWORKDAYS 3:05

Determining a completion date with WORKDAY 2:24

Tabulating date/time differences with DATEDIF 4:38

8. Math Functions

Working with rounding functions 8:03

Finding the remainder with MOD and using MOD with conditional formatting 4:42

Building random number generators with RAND and RANDBETWEEN 4:42

Converting a value between measurement systems with CONVERT 3:07

Using the powerful new AGGREGATE function to bypass errors and hidden data 5:02

9. Array Formulas and Functions

Extending formula capabilities with arrays 7:12

Counting unique entries in a range with an array formula 4:46

Determining frequency distributions with FREQUENCY 3:06

Flipping row/column orientation with TRANSPOSE 4:38

Building analysis via regression techniques with TREND and GROWTH 3:07

Combining multiple functions in arrays 4:27

10. Text Functions

Locating and extracting data with FIND and MID 6:18

Extracting specific data with LEFT and RIGHT 3:02

Removing excess spaces with TRIM 5:42

Using CONCATENATE with functions 4:24

Adjusting case within cells with PROPER, UPPER, and LOWER 4:17

Adjusting character content with REPLACE and SUBSTITUTE 5:56

Reviewing additional text functions 6:32

11. Financial Functions

Calculating payments with PMT 4:34

Finding future values with FV 4:03

Determining total amount of future payments with PV 4:53

12. Information Functions

Working with the IS information functions 4:42

Using error-checking functions: ISERR, ISERROR, IFERROR 6:31

13. Reference Functions

Getting data from remote cells with OFFSET 4:46

Returning references with INDIRECT 9:43

Conclusion

Final thoughts 0:41

Скриншоты:


Время раздачи: с 23:00 до 8:00 (днём по возможности) до первых пяти скачавших
Заранее извиняюсь за низкую скорость раздачи... быстро скачать не получится...
Отдельная благодарность Группе "Uploaders" и лично slava03 за поддержку релизов