) 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
Description:
Explore advanced Excel techniques for statistical analysis in this comprehensive 36-minute video tutorial. Master the use of Power Query to import and transform CSV file data, and learn how to create frequency distributions for categorical and quantitative data using PivotTables. Dive into topics such as PivotTable caching, user interface, and calculation methods. Discover efficient keyboard shortcuts, data type management in Power Query, and field merging techniques. Gain insights into creating and modifying frequency distributions for nominal, discrete quantitative, and continuous quantitative data. Learn how to handle source data changes, refresh PivotTables, and fix ambiguous grouping categories. Enhance your Excel skills with practical examples, downloadable resources, and valuable homework assignments to reinforce your learning.
Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions