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 realworld 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/wpcontent/upl...
Completed workbook https://chandoo.org/wp/wpcontent/upl...

⛔⚠ Got an ERROR Can't Change Array?
==================================

Here is the fix https://chandoo.org/wp/errorswithda...


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    • 5 key skills you need to become a GRE...  
5 Excel Skills you need to focus on    • Top 5 Excel skills you should focus o...  
15 Excel functions you should know    • These are the ONLY 15 functions you n...  

My playlist on data analysis    • 5 key skills you need to become a GRE...  

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/excelschoolp... to sign up today.


My Recommended Excel Books :
===============================
https://chandoo.org/wp/bestexcelpow...

SAY HELLO
===============

Apart from YouTube, I frequently post on,
my blog https://chandoo.org/wp/
twitter   / r1c1  
Instagram   / chandoo.xlsx  

Have a beautiful day

#DataAnalysis #Excel