Learn Excel in Just 10 Days – New Year Special Offer 🎉
Master Excel in Basic level with Practical Training — Only in 2 Weeks (1 Hour/Day)
Who is this course for?
- Students who want job-ready Excel skills
- Office staff struggling with Excel tasks
- Accountants & finance learners
- Data entry operators
- Anyone who wants to improve productivity using Excel
What you will achieve in 10 days
- Use Excel confidently in office work
- Apply formulas and functions efficiently
- Clean and organize messy data
- Create reports using Pivot Tables
- Build simple dashboards and charts
- Save time by using smart Excel techniques
Course Outline – Advanced Excel (10 Days)
Day 1: Excel Basics + Smart Work
- Interface & Navigation
- Data Entry Tricks
- Top 10 Shortcuts
- Basic Formatting
Day 2: Formulas Foundation
- SUM, AVERAGE, COUNT
- Relative vs Absolute Reference
- Basic Calculation Logic
Day 3: Logical Functions
- IF Function
- Simple Nested IF
- Practical Examples (Pass/Fail, Bonus)
Day 4: Lookup Functions ⭐
- VLOOKUP
- XLOOKUP (Introduction)
- Real Data Practice
Day 5: Text + Date Functions
- LEFT, RIGHT, MID
- CONCAT / TEXTJOIN
- TODAY, NOW, DATEDIF
Day 6: Data Cleaning Tools
- Remove Duplicates
- Text to Columns
- TRIM Function
- Flash Fill
Day 7: Data Control Tools
- Data Validation (Dropdown)
- Conditional Formatting
- IFERROR Function
Day 8: Pivot Table (Game Changer) ⭐
- Create Pivot Table
- Grouping Data
- Basic Data Analysis
Day 9: Dashboard Basics
- Charts Creation
- Simple KPIs
- Mini Interactive Dashboard
Day 10: Final Project + Revision
- Real Project (Sales / Attendance)
- Q&A Session
- Practical Test
