[valentin]

lynda.com | Excel for Mac 2011 Essential Training [2010] [EN] PCRec

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

Описание:
В курсе Excel for Mac 2011 Essential Training автор Curt Frye дает подробный обзор Excel, полнофункционального приложения от Microsoft. Курс охватывает ключевые умения, такие как манипуляции с рабочей книгой и ячейкой данных, использование функций, автоматические действия, печать рабочих листов и совместная работа с другими.
Файлы упражнений прилагаются к курсу.

Introduction

Welcome 1:16

Using the exercise files 0:42

1. Getting Started with Excel

Exploring the Excel 2011 window 4:16

Introducing the Ribbon for Mac 4:44

Customizing the Ribbon 4:20

Setting program preferences 3:20

Getting help in Excel 4:16

2. Managing Workbooks

Opening, creating, and saving workbooks 5:23

Setting workbook properties 4:14

Creating and modifying workbook templates 4:18

Managing workbooks across multiple versions of Excel 6:09

3. Managing Worksheets, Cells, and Cell Data

Selecting cells and groups of cells 4:58

Copying and pasting cell data 2:39

Entering data using AutoFill and other techniques 4:32

Inserting symbols and special characters 5:03

Creating an Excel table 4:43

Locating and changing data using Find and Replace 4:57

Restricting input using validation rules 4:28

Using lists to limit data entered into a cell 2:32

Sorting worksheet data 3:02

Creating a custom sort order 3:54

Filtering worksheet data 4:06

Inserting, moving, and deleting cells and cell ranges 3:50

Splitting and freezing rows and columns 3:51

Managing worksheets 5:28

Creating, editing, and deleting headers and footers 4:41

4. Summarizing Data Using Formulas and Functions

Introducing Excel formulas and functions 3:17

Adding a formula to a cell 4:00

Introducing arithmetic operators 4:13

Using absolute and relative cell references 6:29

Controlling how Excel copies and pastes formulas 6:05

Referring to Excel table data in formulas 2:03

Creating an AutoSum formula 3:22

Summarizing data on the status bar 2:22

Joining text in cells with concatenation 3:59

Summarizing data using an IF function 6:21

Summarizing data using SUMIF and other conditional functions 5:37

Creating formulas to count cells 2:37

Rounding cell values up and down 4:55

Finding data using VLOOKUP and HLOOKUP 6:33

Auditing formulas by identifying precedents and dependents 3:25

Managing Excel formula error indicators 4:42

Managing scenarios 4:59

Performing Goal Seek analysis 2:31

5. Formatting Worksheet Elements

Applying fonts, background colors, and borders 6:07

Applying number and date formats to cells 7:01

Managing text alignment 3:56

Copying cell formats 4:02

Managing cell styles 3:16

Managing Office themes 3:31

Creating rule-based conditional formats 3:54

Defining Top 10 conditional formats 4:19

Defining data bar, color scale, and icon set conditional formats 6:06

Editing, ordering, and deleting conditional formats 3:36

6. Working with Charts

Creating bar and column charts 5:26

Creating pie charts 2:32

Creating line charts 4:34

Creating XY (scatter) charts 1:49

Creating stock charts 4:11

Changing chart types and layouts 2:22

Changing the appearance of a chart 4:25

Managing chart axes and numbering 2:51

Adding trendlines to charts 4:14

Creating sparkline charts 4:36

7. Working with External Data

Importing data from comma separated value (CSV) or text files 4:20

Connecting to an external data source 2:22

Using hyperlinks 6:01

Including an Excel workbook in another Office document 3:05

Linking to an Excel chart from another Office program 2:51

8. Working with Objects

Creating and formatting shapes 3:10

Adding and adjusting images 5:38

Cropping, compressing, and removing image backgrounds 4:46

Creating SmartArt graphics 5:07

Creating WordArt 2:34

Aligning and layering objects 5:06

9. Exploring PivotTable Reports

Introducing PivotTable reports 3:47

Creating a PivotTable report 4:37

Pivoting a PivotTable report 3:18

Managing subtotals and grand totals 3:23

Summarizing more than one data field 1:34

Changing the data field summary operation 2:40

Changing the data field number format 2:27

Filtering a PivotTable report 2:46

Applying a PivotTable style 2:20

Creating and editing styles 2:59

10. Reviewing and Sharing Your Spreadsheets

Checking spelling 3:32

Setting AutoCorrect and automatic Replace options 3:59

Managing workbook comments 3:40

Tracking and reviewing changes 5:12

Printing a worksheet or workbook 3:44

Setting and removing print areas 2:31

Exporting to other formats 1:33

Protecting a workbook 2:36

11. Automating Workbooks Using Macros

Running an existing macro 4:56

Recording a macro 3:56

Recording a macro using relative references 6:15

Renaming, viewing, and deleting macros 2:58

Adding comments to a macro 2:43

Turning off screen updating in a macro 3:04

Conclusion

Additional resources 1:01

Скриншоты:


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