chandoo

I saw my boss do these 10 things in Excel!

Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)

How to create a fully *INTERACTIVE* and AWESOME Dashboard in Excel (tutorial + sample files)

Excel's INDEX + MATCH - How to use it // 7 real-world examples & tips

Roadmap to become a Data Analyst in 2024 🚀

The amazing ONE formula Excel dashboard with LET function

Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download

10 Advanced XLOOKUP Tips & Tricks

Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included)

FREE 3 Month Road Map to Learn Advanced Excel and Becoming a Data Analyst

Data Cleaning in Excel - 10 Tricks (Beginner to PRO)

Learn Power Query & Automate Boring Data Tasks in 15 Minutes!

How to use Pivot Tables in Excel - A Step-by-step guide

How to Remove Duplicate Values in Excel - Data Cleaning Tips🧹

Your first 10 minutes of Power BI - A no-nonsense getting started tutorial for beginners

How to calculate Compound Interest in Excel - Formula with Examples 💻

VLOOKUP All Matches with this Crazy Simple Trick

Excel Bar / Column Graph Tutorial + 5 Advanced Tips 📊

I don’t use filters in Excel anymore. I use this other function instead 😎

SQL Joins - Beginner to PRO Masterclass with 10 Examples

5 key skills you need to become a GREAT Data Analyst ~ Lessons from 15 years of analytics experience

Powerful trick to get data from any folder in Excel (works even after renaming!)

How to use SQL with Power BI 💡 ~ End-to-end Demo with Sample Files

How to 'BUILD' Excel Formulas - 5 Advanced Examples