Excel Pivot Tables Data Analysis Master Class [2015, ENG] torrent

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

Excel Pivot Tables Data Analysis Master Class

Год выпуска: 2015
Производитель: Udemy
Сайт производителя: udemy.com/easy-excel-pivot-tables-data-analysis-with-igor
Автор: Игорь Овчинников (Igor Ovchinnikov)
Продолжительность: 1:10
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: From creating your first pivot table in Excel, to becoming a pivot table expert there is a path of learning and experimenting. Microsoft Excel is one the most widely used data analysis tools in business today. Excel pivot tables is undeniably the most powerful part of Excel. If you have ever had a data set to analyze and spent time wondering what you can do with it, then Excel pivot tables is your friend and this Excel course is for you.

Форматирование сводных таблиц в Экселе.
[spoiler="Содержание"]
Section 1: First Things First
Welcome!
Navigating Udemy Course Interface
Learning Tips

Section 2: Without Any Further Ado
Let's Begin
Importance Of Good Data
Adding Data To The Data Source
Using Excel Table As A Data Source
Adding Data To An Excel Table

Section 3: Let's Play With Some Of The Tools
Design Contextual Tab Overview
Defer Layout Update
Pivot Table Builder Overview

Section 4: Grouping Fields
Grouping Dates
Grouping Numbers
Grouping By Selection

Section 5: Filtering
Slicing Your Report
Timeline

Section 6: Expanding Our Knowledge
Counting With Pivot Tables
Pivot Tables As Data Extraction Tool
Look Ma - No Data Source!
Show As....
Calculated Field
Calculated Item
Recommended Pivot Tables
Pivot Charts

Section 7: Data Analasys: List Of Woman-Owned Retail Businesses Of Seattle
Data Fix: Homework Assignment
Data Fix: Solution
Analysis - Homework
Count By Congressional District Report
Top Ten Zip Codes Report
Top Ten Industries Report
Small Businesses Count Report
Fax or No Fax Report
Count By Month And Year Report

Section 8: Data Analysis: Per Capita GDP By State
Data Fix: Homework
Data Fix: Solution
Average-Highest-Lowest Report - Homework
Average-Highest-Lowest Report - Solution
Percent Of DC Report - Homework
Percent Of DC Report - Solution
USA Overall vs. DC Report - Homework
USA Overall vs. DC Report - Solution
Percent Difference From 1997 Report - Homework
Percent Difference From 1997 Report - Solution
Additional Thoughts On The Data Set

Section 9: Data Analysis: USA Car Crash Data
Data Set Fix - Homework
Data Set Fix - Solution
Additional Thoughts On Car Crash Data
Accidents & Fatalities Monthly Report - Homework
Accidents & Fatalities Monthly Report - Solution
Accidents & Fatalities By Age - Homework
Accidents & Fatalities By Age - Solution
By Age And Gender - Homework
By Age And Gender - Solution
Drug-Related By Gender - Homework
Drug-Related By Gender - Solution

Section 10: Wrapping up!
Thank you
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 960x540, 16:9, 30fps, 478kbps
Аудио: AAC, 44.1kHz, 128kbps, stereo
[spoiler="Скриншоты"]

[/spoiler]