Modern Data Analysis with Excel
Modern Data Analysis with Excel is a practical, hands-on course delivered through live online classes, designed to help you analyze data confidently, make better decisions, and present insights professionally using Microsoft Excel.
This course goes beyond basic spreadsheet skills and focuses on how Excel is used today in business, analytics, and decision-making. Participants will work with real-world datasets and learn modern Excel techniques used by data analysts across industries.
📅 Class Schedule & Format
- Start Date: 21st January, 2026
- Duration: 6 weeks
- Days: Wednesdays & Thursdays
- Time: 8:00 PM – 9:30 PM (WAT)
- Mode: Live online classes
- Platform: Google Meet
All sessions are interactive, with live demonstrations, guided practice, and opportunities to ask questions in real time.
What You Will Learn
- Understanding data and thinking like a data analyst
- Data cleaning and preparation using modern Excel techniques
- Using formulas and functions for analysis (logical, lookup, text, date, and statistical functions)
- Working with large datasets efficiently
- PivotTables and PivotCharts for fast data summarization
- Data visualization best practices
- Creating interactive dashboards and reports
- Analyzing trends, patterns, and performance metrics
Tools & Features Covered
- Modern Excel interface and productivity shortcuts
- Excel Tables and structured references
- PivotTables & PivotCharts
- XLOOKUP and INDEX-MATCH
- Conditional formatting
- Data validation
- Charts and dashboards
Who This Course Is For
- Senior secondary school students
- University and polytechnic students
- Working professionals
- Entrepreneurs and business owners
- Anyone interested in data analysis using Excel
No prior data analysis experience is required.
What You’ll Be Able to Do After the Course
- Analyze real-world data confidently
- Build professional reports and dashboards
- Make data-driven decisions using Excel
- Apply Excel skills in academics, work, or business
- Prepare for more advanced analytics tools like Power BI, SQL, or Python
Certificate
Participants who complete the course will receive a Certificate of Completion.