Meetings
Requirements
- Absolute beginners, Basic users of Phone and computers
Description
Total Contact period: 54 hours
Weekly contact: 4.5 hours of Lecture time
Core Concepts:
Data Literacy: Understanding data types (qualitative/descriptive vs. quantitative/numerical).
Basic Statistics: Learning how to find the mean (average), median (middle value), mode (most frequent value), and range (the spread).
Asking the Right Questions: Learning why you are looking at data (e.g., "Why did our website traffic drop on Tuesday?").
The Primary Tool: Microsoft Excel or Google Sheets
How to input data, sort it, and filter it.
Basic formulas: SUM, AVERAGE, COUNT, and IF statements.
Creating basic charts (bar charts, line graphs, and pie charts) to see patterns.
Month 1: Spreadsheet Mastery (The Foundation)
- Week 1: Core Concepts, Mindset, and Tool Onboarding
- Week 2: Excel/Sheets Data Entry, Formatting, and Text Functions (LEFT, RIGHT, CONCATENATE, and TRIM to clean messy data).
- Week 3: Basic Logic and Aggregations (SUM, AVERAGE, COUNT, COUNTA, and logical IF statements).
- Week 4: Advanced sorting, filtering, and conditional formatting to spot trends instantly.
Month 2: Relational Databases & Data Extraction (SQL)
- Week 5: Introduction to Databases. Understanding tables, rows, columns, and primary keys.
- Week 6: Writing basic SQL queries. Focus on SELECT, FROM, and WHERE to filter data.
- Week 7: Aggregating data in SQL using GROUP BY, HAVING, and functions like COUNT(), SUM(), and AVG().
- Week 8: Combining tables. Master INNER JOIN and LEFT JOIN (how to pull related data from different places).
Month 3: Business Intelligence & Data Storytelling
- Week 9: Spreadsheet Power Tools. Master Pivot Tables and XLOOKUP / VLOOKUP.
- Week 10: Introduction to Data Visualization. Learn when to use a bar chart vs. line chart vs. scatter plot.
- Week 11: Building your first dashboard using a free business intelligence tool like Tableau Public or Google Looker Studio.
- Week 12: Capstone Project & Portfolio Building. Tie spreadsheets, SQL, and visuals together.
Frequently Asked Question
MasterOneSkill (masteroneskill.com) is a Nigerian digital skills e-learning platform that trains individuals across Africa to acquire in-demand skills so they can earn real income in the digital economy.
MasterOneSkill is built for anyone in Nigeria or Africa who wants to build a profitable digital skill, whether you're a fresh graduate, career switcher, stay-at-home parent, side hustler, or entrepreneur. No prior tech experience is required for most courses.
Most courses can be accessed on a smartphone. However, for practical courses that involve tools, software, or file creation, a laptop or desktop will give you the best learning experience.
MasterOneSkill offers both free introductory content and paid full courses. Paid courses are priced to be affordable for the Nigerian market, with no hidden fees.
About Instructor
