Kick‑off Session for Ideal Data School: From Excitement to Hands‑On Excel Training

Welcome and Energy Check

• The host repeatedly asked the audience to confirm they could hear her "loud and clear" and to post confirmations in the comment section.
• Participants from Nigeria, South Africa, Ghana, the US and other countries responded, creating a lively, interactive atmosphere.

Why This Training Matters

• Data analysis is presented as a critical skill for making informed decisions, avoiding assumptions, and gaining a competitive edge.
• The instructor linked data analysis to everyday AI tools (ChatGPT, Gemini, etc.) to illustrate its relevance in modern technology.

Core Concepts Covered

• Definition: Data analysis = examining, cleaning, transforming, and interpreting data to extract useful information.
• Data Types:
• Qualitative – non‑numeric information such as names, gender, location.
• Quantitative – numeric information that can be measured (age, salary, counts).
• Data Sources:
• Primary – data collected directly by the researcher (interviews, observations).
• Secondary – data obtained from third parties or existing reports.
• Data Collection Methods: surveys, interviews, observations, and secondary research.
• Key Terminology:
• Data set – a collection of related data.
• Data point – a single item within a data set.
• Database – organized electronic storage of data.
• Data cleaning – identifying and fixing errors, inconsistencies, and missing values.

Practical Setup: Excel Online

1. Account Creation – Participants were guided to sign in at office.com, create a Microsoft account if needed, and verify via email.
2. Launching Excel – Open the online Excel app, create a Blank Workbook, and rename it (e.g., "Lesson 1 – Working with Excel").
3. Interface Tour – Title bar, menu bar (Home, Insert, Share, etc.), formula bar, and worksheet cells (columns A‑Z, rows 1‑n).
4. Importing Data – Use File → Open → This device to load the provided CSV data file (a secondary data set about student performance).
5. Formatting as Table – Apply a table style, choose a color, and ensure the data is structured for analysis.
6. Selecting Cells – Demonstrated how to identify a cell (e.g., F5) and use shortcuts like Ctrl+A to select all data.
7. Pop‑up Blocker – Instructions for disabling pop‑up blockers in Chrome/Firefox to allow file uploads.

Engagement & Expectations

• Learners were asked to share their excitement level, expectations, and career goals (e.g., becoming a professional data analyst, earning extra income).
• The instructor emphasized the need for a fully charged laptop, a quiet environment, and a beverage (water or juice) to stay focused.
• Attendance of at least 70 % was highlighted as mandatory; recordings would be available for missed sessions.

Next Steps

• A short test will be released at the end of the session; completion is required for certification.
• The next live class is scheduled for Thursday, with a reminder to review the recorded material and practice the Excel workbook.
• Participants were encouraged to keep the interactive spirit alive by posting comments, likes, and subscriptions throughout the course.

Closing Motivation

• The host reiterated that learning data analysis is a foundation for personal and professional growth, urging everyone to take pride in the challenge and celebrate small wins.

This inaugural Ideal Data School session turned enthusiasm into concrete skills by defining data analysis, explaining its real‑world value, and walking participants through a hands‑on Excel workflow—setting the stage for deeper analytics training and certification.