Course Overview
MS Excel is the world's most popular tool for data analysis. This course starts from absolute zero—teaching you how to enter data—and takes you all the way to creating interactive dashboards and pivot tables.
Formulas
Master VLOOKUP, IF, SUMIF, and other essential logic.
Visualization
Create stunning charts and graphs for presentations.
Data Mgmt
Sorting, Filtering, and Validating large datasets.
Efficiency
Keyboard shortcuts and tips to work 2x faster.
Syllabus
4 Weeks- Understanding Ribbons, Cells, Rows & Columns
- Data Entry & AutoFill
- Formatting Cells (Date, Currency, Text)
- Task: Create a Personal Budget Sheet
- Basic Math (Sum, Average, Count)
- Logical Functions (IF, AND, OR)
- Lookup Functions (VLOOKUP, XLOOKUP)
- Task: Student Result Sheet Automation
[Image of different types of Excel charts]
- Creating Bar, Pie & Line Charts
- Conditional Formatting
- Data Sorting & Filtering
- Task: Sales Report Visualization
[Image of Excel Pivot Table dashboard]
- Introduction to Pivot Tables
- Data Validation (Drop-down lists)
- Protecting Sheets & Printing
- Final: Corporate Inventory System
Junayed Bin Karim
Data Analyst & Excel Expert
5+ years experience teaching Excel to corporate professionals and students. Expert in financial modeling and dashboards.
Data Viz
VBA Macros
Choose Your Path
Most Popular
Certified
৳ 2,000
৳ 3,000- Verified Certificate
- Project Reviews
- 2 Mentorship Sessions
Full Package
৳ 5,000
৳ 8,000- Weekly 1:1 Mentorship
- Career Guidance
- Custom Projects
FREE
or Upgrade
Join 4,000+ Learners
Start Learning Free
Course Includes:
- 8 Live Classes
- 20+ Practice Sheets
- Mobile Access
- Lifetime Access