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
⛔⚠ Got an ERROR – Can’t Change Array?
==================================
Here is the fix – https://chandoo.org/wp/errors-with-data-analysis-course/
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 these videos:
5 key skills you need to be a GREAT data analyst – https://youtu.be/gVr9f1GJdZc
5 Excel Skills you need to focus on – https://youtu.be/cEuq_9CsHIY
15 Excel functions you should know – https://youtu.be/B5hayFelHDU
My playlist on data analysis – https://www.youtube.com/watch?v=gVr9f1GJdZc&list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R 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 📚👌: 😎 SAY HELLO 👋 Apart from YouTube, I frequently post on, Have a beautiful day 🌼🌞😀
#DataAnalysis #Excel
Want to learn more? Join my Excel School 👉
=====================================
===============================
https://chandoo.org/wp/best-excel-power-bi-books/
===============
my blog – https://chandoo.org/wp/
twitter – https://twitter.com/r1c1/
Instagram – https://www.instagram.com/chandoo.xlsx
