Beginner to Pro FREE Excel Data Analysis Course
You asked for it. Here is my free course to help you kick start your data analytics journey.
In this comprehensive video, learn:
1) How to approach a data analysis project
2) A real-world example data with 10 problems
3) Step by step walk thru
4) How to calculate descriptive statistics (mean, median, quartiles, range, distinct items & count)
5) Exploratory data analysis in Excel
6) Analysis with formulas vs. pivots (necessary techniques)
7) Top / bottom performing items
8) Anomaly detection
9) Best in class analysis
10) Complete report preparation
11) Combining data in different tables (spreadsheets)
12) Answering open ended questions
13) Preparing and using Excel charts
14) Challenges & homework assignment
You will also learn below Excel features:
1) Using Tables
2) Formulas
3) Pivot Tables & Power Pivot measures
4) Conditional formatting
5) Charts
6) Data Validation
7) Keyboard Shortcuts & tricks
⏱ Video Timestamps:
==================
0:00 - Introduction
2:12 - Descriptive statistics in Excel
8:05 - Exploratory Data Analysis (EDA) with conditional formatting
13:20 - Sales by Country report with formulas
19:01 - Sales by Country report with Pivots
23:43 - Top 5 products with $ per unit
27:13 - Anomaly detection in your data
31:24 - Best in category analysis
33:36 - Profit analysis (combining two tables)
37:26 - Dynamic country level sales report
41:55 - Which products to discontinue (Open ended questions)
💥📁 Sample files:
================
Blank data file (perfect for following along) - https://chandoo.org/wp/wp-content/uploads/2021/08/beginner-DA-course-blank.xlsx
Completed workbook - https://chandoo.org/wp/wp-content/uploads/2021/08/beginner-DA-course.xlsx
What to watch next?
=================
I recommend setting aside sometime to practice what you just learned. But if you are in the mood to watch more, I suggest this video:
5 key skills you need to be a GREAT data analyst - https://youtu.be/gVr9f1GJdZc
My playlist on data analysis - https://www.youtube.com/watch?v=gVr9f1GJdZc&list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
Want to learn more? Join my Excel School 👉
=====================================
If you want more step by step education & resources to be AWESOME at your work, consider joining my Excel School program. This online class will teach you everything you need for data analysis + reporting roles.
Visit https://chandoo.org/wp/excel-school-program/ to sign up today.
My Recommended Excel Books 📚👌:
===============================
https://chandoo.org/wp/best-excel-power-bi-books/
Have a beautiful day 🌼🌞😀
Видео Beginner to Pro FREE Excel Data Analysis Course канала Chandoo
In this comprehensive video, learn:
1) How to approach a data analysis project
2) A real-world example data with 10 problems
3) Step by step walk thru
4) How to calculate descriptive statistics (mean, median, quartiles, range, distinct items & count)
5) Exploratory data analysis in Excel
6) Analysis with formulas vs. pivots (necessary techniques)
7) Top / bottom performing items
8) Anomaly detection
9) Best in class analysis
10) Complete report preparation
11) Combining data in different tables (spreadsheets)
12) Answering open ended questions
13) Preparing and using Excel charts
14) Challenges & homework assignment
You will also learn below Excel features:
1) Using Tables
2) Formulas
3) Pivot Tables & Power Pivot measures
4) Conditional formatting
5) Charts
6) Data Validation
7) Keyboard Shortcuts & tricks
⏱ Video Timestamps:
==================
0:00 - Introduction
2:12 - Descriptive statistics in Excel
8:05 - Exploratory Data Analysis (EDA) with conditional formatting
13:20 - Sales by Country report with formulas
19:01 - Sales by Country report with Pivots
23:43 - Top 5 products with $ per unit
27:13 - Anomaly detection in your data
31:24 - Best in category analysis
33:36 - Profit analysis (combining two tables)
37:26 - Dynamic country level sales report
41:55 - Which products to discontinue (Open ended questions)
💥📁 Sample files:
================
Blank data file (perfect for following along) - https://chandoo.org/wp/wp-content/uploads/2021/08/beginner-DA-course-blank.xlsx
Completed workbook - https://chandoo.org/wp/wp-content/uploads/2021/08/beginner-DA-course.xlsx
What to watch next?
=================
I recommend setting aside sometime to practice what you just learned. But if you are in the mood to watch more, I suggest this video:
5 key skills you need to be a GREAT data analyst - https://youtu.be/gVr9f1GJdZc
My playlist on data analysis - https://www.youtube.com/watch?v=gVr9f1GJdZc&list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
Want to learn more? Join my Excel School 👉
=====================================
If you want more step by step education & resources to be AWESOME at your work, consider joining my Excel School program. This online class will teach you everything you need for data analysis + reporting roles.
Visit https://chandoo.org/wp/excel-school-program/ to sign up today.
My Recommended Excel Books 📚👌:
===============================
https://chandoo.org/wp/best-excel-power-bi-books/
Have a beautiful day 🌼🌞😀
Видео Beginner to Pro FREE Excel Data Analysis Course канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Data cleaning in Excel - 10 tricks *PROs* use all the time5 key skills you need to become a GREAT Data Analyst ~ Lessons from 15 years of analytics experience8 AMAZING tactics to learn Excel quickly 🏆The *ONLY* 10 Excel keyboard shortcuts you need to masterExcel Beginners - Complete Crash Course in 30 minutes (with sample files)Top 30 *Advanced* Excel Tips to make you awesome ⚡💡The truth about Power BI (and how to learn it properly)How I make videos, How much money I earn, What equipment I use...Talking to my wife about her Power BI analyst job (how it started, the hardest part, salary ...)Excel Interview Questions For Data Analystتحليل البيانات باستخدام اكسيل | Data Analysis using MS ExcelLearn data analyst skills in 3 months, step by step | Complete data analyst roadmap in 2021New to Data Analysis? Use Pivot Tables to get quick results // Getting Started TutorialAdvanced Pivot Table Techniques (to achieve more in Excel)Learn these top 10 Excel Formulas to be GREAT at your workMicrosoft Excel Tutorial for Beginners - Full CourseWhat Is Data Analytics? - An Introduction (Full Guide)How to build Interactive Excel Dashboards that Update with ONE CLICK!Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)