Sale!

# Chandoo – Excel School + 50 Ways Course

\$447 \$120

As the name suggests, 50 ways to analyze data contains 50 video lessons, each exploring one analysis technique or situation.
You can consume these lessons in any order. The only requirement is that you should be good with Excel. If you are a beginner, I suggest enrolling for the option – Advanced Excel + 50 Ways course package.

• Course’s name: Chandoo – Excel School + 50 Ways Course
• Size: 12.7  GB
• Last Update: 2023

Category:

## Chandoo – Excel School + 50 Ways Course

Lesson plan
As the name suggests, 50 ways to analyze data contains 50 video lessons, each exploring one analysis technique or situation.
You can consume these lessons in any order. The only requirement is that you should be good with Excel. If you are a beginner, I suggest enrolling for the option – Advanced Excel + 50 Ways course package.Let’s see the lesson plan.General Analysis techniques (25 lessons):

• Moving averages
• Weighted averages
• Top 5 / bottom 5 analysis (2 lessons)
• Trend analysis (4 lessons)
• Descriptive statistics
• Visual analysis of distribution (2 lessons)
• Budget vs. Actual analysis (3 lessons)
• How many items are due?
• Overlapping dates & times
• Monthly totals from daily data
• Quarterly totals & reporting from data (2 lessons)
• Unique & duplicate data analysis
• Panel charts
• XY Relationship analysis & charts
• Indexed charts
• Word frequency & sentiment analysis

Marketing & Operations analysis techniques (11 lessons):

• Pareto analysis & charting
• Us vs. competition analysis & charts
• Solver & optimization techniques (2 lessons)
• Planning a project
• FIFO inventory analysis
• BCG matrix analysis
• Random allocation & scheduling (2 lessons)
• Analytical charts
• Segmentation & Cluster analysis using K-means technique
• Finding outliers using K Nearest Neighbors technique

Financial analysis techniques (8 lessons):

• Break-even analysis
• Time value of money
• Cost benefit analysis
• 2 way data tables & what if analysis
• Internal rate of return
• Circular calculations & scenarios
• Simulation using Data tables

Case studies (6 lessons):

• Case studies on detailed analysis reports, dashboards & articles featured on chandoo.org hall of fame.

Bonus material:

• Introduction to Excel
• Techniques on working with raw data (clean up techniques, connecting to external databases)
• Example workbooks for each lesson
• Bonus: Cust. complaints case (\$99 value)
• Uber vs. Your Car – Bonus Model & Video
• Forecasting time series data – interactive chart – XLS & Video

Lessons for Advanced Excel (Excel School) module:

This is an optional module you can sign-up for. It includes 32 hours of training on beginner to advanced Excel concepts and dashboard reporting. This module has below lessons:

• Excel basics – 3 lessons
• Excel formulas – 11 lessons
• Advanced formulas – 7 lessons
• Formatting & presentation of data – 3 lessons
• Conditional formatting – 3 lessons
• Excel charting basics – 4 lessons
• Advanced charting in Excel – 2 lessons
• Interactive & dynamic charts in Excel -2 lessons
• Using data validation, sorting & filtering features –
• Excel Pivot tables – 2 lessons
• Working with external data – 5 lessons
• Excel Dashboards – 12 lessons 