Completed
) Alt Keyboard Efficiency Tricks to create PivotTable and other features
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction to topics in video
- 2 ) Tabular Reporting goals for this video: 4 Different Frequency Distributions
- 3 ) PivotTable to create Frequency Distribution from Nominal Data that is located in the worksheet
- 4 ) What is the PivotTable Cache?
- 5 ) Introduction to PivotTable User Interface
- 6 ) Change calculation in PivotTable with: Summarize Values By and Shows Values As
- 7 ) Alt Keyboard Efficiency Tricks to create PivotTable and other features
- 8 ) Power Query to Import & Transform CSV file with table of data
- 9 ) What is a CSV File? What is a Delimiter?
- 10 ) Where is the Power Query tool in Excel?
- 11 ) What are Data Types in Power Query? And why are they Important!
- 12 ) Merge two fields to create one element field
- 13 ) Load Power Query Table to Excel Worksheet
- 14 ) Edit Query after it has been loaded
- 15 ) Terms to describe the table, fields and data.
- 16 ) Frequency Distributions for different types of data
- 17 ) Frequency Distributions defined
- 18 ) Frequency Distribution for Nominal Data, using a PivotTable.
- 19 ) Frequency Distribution for Discrete Quantitative Data, using a PivotTable and the Grouping Feature
- 20 ) How to Group in a PivotTable and create Upper and Lower Limits for Counting Categories.
- 21 ) Use Field Settings to show categories without data.
- 22 ) Change Grouping Categories
- 23 ) Grouping Categories Created for Discrete Quantitative Data
- 24 ) Frequency Distribution for Continuous Quantitative Data, using a PivotTable and the Grouping Feature
- 25 ) Grouping Categories Created for Continuous Quantitative Data
- 26 ) What happens to PivotTable when Source Data Changes?
- 27 ) Refreshing a PivotTable to allow new data into Report
- 28 ) Fixing Ambiguous Grouping Categories in a PivotTable with Decimal Number Data. Three Methods.
- 29 ) How Grouping works with PivotTable Cache.
- 30 ) How to create Multiple Grouping Categories from a Single Data Source using PivotTable Wizard QAT Button or Keyboard: Alt, D, P.
- 31 ) Summary of video
- 32 ) How to Printout Notes from Excel Workbook File
- 33 ) Homework files to download from in Canvas
- 34 ) Closing and Video Links
