Welcome to the official resource hub for my YouTube video series on Data Analytics using Microsoft Excel!
In this beginner-to-advanced course, I walk you through the most essential Excel concepts, including:
- ✅ Essential Excel Functions
- ✅ Conditional Formatting & Data Validation
- ✅ Goal Seek, TRIM, Macros
- ✅ Pivot Tables & Charts
- ✅ Dashboard Creation (Step-by-Step)
These downloadable Excel files will help you practice everything I teach in the video.
🎥 Watch the Full Video:
📺 Video Title: Excel for Data Analytics –
📂 What’s Inside the ZIP File?
| 📂 File Name | 📄 Purpose |
|---|---|
| Dashboard Main.xlsx | Final completed dashboard |
| Errors.pdf | Notes on common Excel errors & fixes |
| ExcelFunctions.xlsx | File containing all essential Excel functions used in data analysis |
| Raw Dashboard.xlsx | Starting point to build the dashboard |
| Raw Pivot Data.xlsx | Clean dataset used for pivot operations |
| Raw Staff Table.xlsx | Employee dataset used in dashboard/pivot |
| Recap Summary.pdf | Quick summary/cheatsheet of all functions & concepts |
📥 Download Section:
Click the button below to download all raw Excel data files used in the video:
📁 File Size: Approx. 8 MB
📌 Format: .zip (Contains .xlsx & .pdf files)
🔒 Safety Note:
✅ These files are 100% safe and contain no personal data or harmful macros.
🔐 For best practice, always scan files before opening (just like any online download).
📢 Want More?
💡 Don’t forget to subscribe to my YouTube channel for upcoming tutorials on:
- SQL for Data Analysis
- Power BI Dashboards
- Interview-focused Excel case studies
- Real-world projects using Excel + Python
