Excel for data analysis: cleaning, stats & dashboards

Learn to analyze data in Excel from start to finish: clean messy data, run hypothesis tests like t-tests, ANOVA and regression, and build a dashboard.
Get the project files and follow along: https://allgoodtutorials.com/supporters/videos/analyze-data-in-excel-full-course?utm_source=youtube&utm_medium=description
What you will learn:
Clean missing values, inconsistent entries, outliers and duplicates
Summarize data with frequency tables, descriptive statistics and PivotTables
Compare groups with t-tests and one-way ANOVA
Measure relationships with correlation and multiple regression
Build a dashboard from a blank canvas
Chapters:
00:00 Course overview
01:36 What is data analysis
05:14 Data analysis workflow
08:08 Understanding statistical analysis
16:19 Hypothesis testing elements
21:25 Steps in hypothesis testing
26:31 Dealing with missing values
40:24 Dealing with inconsistent values
49:28 Dealing with outliers
58:11 Removing duplicate values
1:01:35 Frequency and percentage analysis
1:13:20 Descriptive statistics
1:25:37 Group by with PivotTables
1:41:24 Crosstabulation with PivotTables
1:47:32 Independent sample t-test
2:00:00 Paired sample t-test
2:08:29 One-way ANOVA
2:17:02 Pearson correlation
2:29:36 Multiple linear regression
2:46:52 Building the dashboard canvas
2:54:45 Finishing the dashboard
The project files are on the course page, included with All Access (7-day free trial) or with the course ($19).
All Good Tutorials publishes step-by-step video courses for the software you use at work: Microsoft Office, Google Workspace and more.
Start free or try All Access free for 7 days: https://allgoodtutorials.com/supporters/pricing?utm_source=youtube&utm_medium=description
#Excel #DataAnalysis #ExcelTutorial
