Excel Pivot Tables Data Analysis Master Class Год выпуска: 2015 Производитель: Udemy Сайт производителя: udemy.com Автор: Игорь Овчинников (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. Форматирование сводных таблиц в Экселе.
Содержание
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
![[Quote]](./templates/default/images/lang/en/icon_quote.gif "Reply with quote"){kind=icon}
![[Profile]](./templates/default/images/lang/en/icon_profile.gif "View user's profile"){kind=icon}
![[PM]](./templates/default/images/lang/en/icon_pm.gif "Send private message"){kind=icon}
