8 WEEKS
VIRTUAL &
PHYSICAL
PROJECTS/
ASSIGNMENTS
CERTIFICATION
What You’ll Learn
By the end of this course, you will:
✅ Develop essential digital literacy skills for work and study.
✅ Master Microsoft Excel for data cleaning, analysis, and visualization.
✅ Learn Python for handling and interpreting datasets.
✅ Build data visualizations to present insights clearly.
✅ Work on a capstone project to showcase your skills.
Why Enroll?
Data is at the heart of decision-making in today’s digital world. At Ibadan Digital Academy, our Data Analysis Pathfinder Training Program equips learners with essential digital literacy and data analysis skills. This hands-on course covers computer basics, Excel, Python, and data visualization, ensuring participants are prepared for further studies or professional growth.
Practical Learning:
Hands-on projects and real-world case studies.
Career-Ready Skills:
Learn tools used in the workplace and business.
Beginner-Friendly:
No prior experience required—ideal for anyone looking to develop data skills.
Expert Guidance:
Learn from professionals with real industry experience.
Capstone Project:
Showcase your skills with a final project to impress employers.
Data Analysis Course Outline
Weeks 1–2: Digital Literacy
🔹 Week 1: Introduction to Computer Basics
- Learn about computer hardware and software.
- Navigate operating systems (Windows) and file management.
- Practice safe browsing and email communication.
🔹 Week 2: Essential Software Skills
- Get hands-on with Microsoft Office and Google Workspace.
- Learn to create and edit documents and spreadsheets.
- Collaborate online using Google Docs.
Weeks 3–8: Data Analysis Training
🔹 Week 3: Fundamentals of Excel for Data Analysis
- Learn data cleaning, formatting, and basic formulas.
- Use pivot tables and simple visualizations.
🔹 Week 4: Advanced Excel for Data Analysis
- Master VLOOKUP/XLOOKUP, conditional formatting, and advanced pivot tables.
- Create charts and graphs to summarize data.
🔹 Week 5: Introduction to Python for Data Analysis
- Understand Python basics, including loops and conditionals.
- Work with Pandas for data manipulation.
🔹 Week 6: Data Visualization with Excel and Python
- Create advanced Excel charts and Python visualizations using Matplotlib.
🔹 Week 7: Integrating Excel and Python Skills
- Combine Excel and Python workflows for efficient data analysis.
- Work on real-world case studies.
🔹 Week 8: Capstone Project
- Apply all your skills to solve a real-world data problem.
- Present your analysis and insights using Excel and Python.
Tools Covered
