Lynda.com - Excel 2010 Essential Training [2010, ENG]

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Офисные программы Microsoft

Lynda.com - Excel 2010 Essential Training

Производитель: Lynda.com
Год выпуска: 2010
Страна: США
Язык: английский
Автор: Bob Flisser
Продолжительность: 6:21 ч
Формат: клипы QuickTime (.mov)
Видео: VP6 960x540 15 fps ~70Kbps
Аудио: MP3 48kHz 2ch 96Kbps
Файлы примеров: присутствуют
Описание: In Excel 2010 Essential Training, Bob Flisser demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Topics include:

* Copying and pasting techniques
* Working with formulas and functions
* Dealing with formula errors
* Creating lookup tables
* Naming cell ranges
* Formatting data and worksheets
* Finding and replacing data
* Creating SmartArt diagrams
* Creating charts and PivotTables
* Recording macros
* Sharing workbooks
[spoiler="Содержание"]
Introduction Welcome 00:57
Using the exercise files 00:38

19:31
1. Getting Started Exploring three common uses for Excel 03:17
Touring the interface 03:38
Finding the commands you need 03:51
Using Backstage view or the File tab 03:25
Maintaining file compatibility 05:20

21:23
2. Worksheet Basics Creating a worksheet 05:23
Techniques for copying and pasting 03:57
Entering data automatically with Auto Fill 04:37
Targeting large data groups 04:26
Changing a worksheet's structure 03:00

47:50
3. Excel Formula Basics Understanding formulas and functions 04:41
Entering data in a worksheet 03:22
Adding numbers manually 05:01
Adding numbers using Sum and AutoSum 06:11
Adding a whole worksheet 01:48
Working with numbers in columns 04:53
Preventing errors using absolute references 05:57
Working with times and dates 03:08
Using IF 04:49
Using SUMIF and AVERAGEIF 04:15
Naming and using cell ranges 03:45

33:57
4. Essential Formatting Formatting numbers and dates 07:06
Applying fonts, background colors, and borders 04:35
Adjusting columns, rows, and text 05:02
Using conditional formatting 04:06
Using custom conditional formatting 05:49
Adding pictures and shapes 07:19

25:27
5. Advanced Formatting Inserting SmartArt 06:54
Coordinating a look using themes 03:22
Applying built-in styles 03:16
Creating and sharing styles 05:33
Using templates 04:09
Creating and using original templates 02:13

13:23
6. Printing Preparation Making the pieces fit 04:57
Inserting headers and footers 03:51
Printing and PDFs 04:35

34:03
7. Large Excel Projects Finding and replacing data 03:12
Freezing panes 03:00
Repeating row and column titles 03:34
Creating multiple custom worksheet views 05:18
Hiding or grouping rows and columns 05:31
Managing worksheets 07:23
Calculating formulas across worksheets 06:05

36:34
8. Collaborating with Others Importing and exporting data in Excel 08:02
Setting workbook permissions 06:44
Inserting and editing comments 06:49
Sharing a workbook 01:25
Tracking changes 03:05
Saving files in shared locations 10:29

27:30
9. Exploring Excel's Database Features Splitting cell data into multiple cells 02:22
Joining data from multiple cells 04:18
Basic and multi-field sorting 06:30
Using tables to sort and filter data 04:31
Inserting automatic subtotals 03:46
Creating lookup tables 06:03

32:56
10. Analyzing Data Using auditing to diagram 06:03
Using evaluation in Excel 02:02
Working with Goal Seek 05:29
Using data tables in formulas 06:02
Using scenarios in formulas 05:28
Exploring the Analysis Toolpak 07:52

18:01
11. Advanced Analysis with PivotTables Discovering PivotTables 02:22
Creating a basic PivotTable 02:46
Modifying a PivotTable 06:57
Creating and modifying a PivotChart 05:56

26:58
12. Creating and Using Charts Choosing chart types 01:55
Inserting Sparklines 03:54
Creating a column chart 03:23
Modifying a column chart 05:47
Creating and modifying a pie chart 06:45
Placing Excel charts into other Office applications 05:14

21:53
13. Creating and Using Macros Understanding macros 03:05
Recording and using a simple macro 11:58
Editing a macro 06:50

20:33
14. Customizing Excel Customizing the Quick Access toolbar 03:30
Customizing the Ribbon bar 08:44
Setting Excel options 08:19

00:16
Conclusion Goodbye 00:16
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]
Оставайтесь на раздаче!!!
Если на моих раздачах нет сидов, то пишите в личку. Без вашей помощи раздача начнет болеть, хиреть и может даже помереть.