Beginner · 3 hr · Free
Excel & Data from Zero · The Practical Beginner's Guide
Navigate Excel and enter & format data with confidence · Write core formulas: SUM, AVERAGE, IF, and XLOOKUP · Understand relative vs. absolute references and the $ sign
What you'll learn
- Navigate Excel and enter & format data with confidence
- Write core formulas: SUM, AVERAGE, IF, and XLOOKUP
- Understand relative vs. absolute references and the $ sign
- Sort, filter, and clean data from duplicates, blanks, and extra spaces
- Auto-highlight key values with conditional formatting
- Choose the right chart and format it professionally
- Summarize thousands of rows in seconds with PivotTables and slicers
- Build a complete one-page sales report dashboard from scratch
What this course includes
- Practical, step-by-step lessons
- Automatic progress tracking
- A comprehensive final exam
- Verifiable completion certificate with the Numoo seal
- Lifetime access with ongoing updates
Course content 22 lessons · 6 modules
1Unit 1 · Getting Started & Navigation5 lessons
- 🔒Start Here · Set Up Excel in 5 Minutes5 min
- 🔒A Tour of the Excel Interface: Its Six Key Parts9 min
- 🔒Entering & Formatting Data: Text or Number?10 min
- 🔒References: Relative, Absolute, and the Secret of $10 min
- 🔒✅ Checkpoint · Unit 14 min
2Unit 2 · Core Formulas5 lessons
- 🔒Core Functions: SUM, AVERAGE, and Friends10 min
- 🔒🧪 Game: Formula Lab — Write & Run It Yourself7 min
- 🔒The IF Function: Conditional Logic10 min
- 🔒XLOOKUP: Pulling Data from Another Table10 min
- 🔒✅ Checkpoint · Unit 24 min
3Unit 3 · Organizing & Cleaning Data4 lessons
- 🔒Sorting, Filtering & Smart Tables9 min
- 🔒Conditional Formatting: Make Data Speak with Color9 min
- 🔒Cleaning Data: From Messy to Analysis-Ready10 min
- 🔒🧹 Game: Clean the Table — Spot & Fix6 min
4Unit 4 · Visualizing with Charts3 lessons
- 🔒Choosing & Building the Right Chart9 min
- 🔒Formatting Charts: From Cluttered Default to Pro Report9 min
- 🔒✅ Checkpoint · Unit 44 min
5Unit 5 · Analyzing with PivotTables3 lessons
- 🔒Intro to PivotTables: Summarize Hundreds in Seconds11 min
- 🔒Slicers & PivotCharts: An Interactive One-Click Dashboard9 min
- 🔒🧩 Game: Build the PivotTable6 min
6Unit 6 · The Capstone Project2 lessons
- 🔒Capstone Project: Build a Complete Sales Report Dashboard15 min
- 🔒🎓 Conclusion: From Zero to Data Analyst5 min
★Final Exam10 questions · pass 70%
Student reviews
No reviews yet — be the first after you complete the course.