Module 1 Intro: Foundations of Data & Spreadsheets

What You’ll Achieve in This Module

This module is structured to give you both the conceptual knowledge (the “why”) and the practical skills (the “how”). You’ll move from understanding the data profession to creating your first fully functional analytics product.

The core theme is the transformation of raw data into actionable insight using accessible tools. We’ll show you how to clean the messy data you receive, apply powerful functions to extract meaning, and finally, present your findings in a clear, compelling analysis.

Learning Objectives

By the time you complete this module, you will be able to:

• Identify and differentiate between key roles in the data field (e.g., Data Analyst, Data Scientist, Data Engineer).

• Understand the Data Analytics Lifecycle, from defining a problem to communicating insights.

• Master fundamental spreadsheet operations, including data cleaning, filtering, and validation.

• Utilize core functions such as VLOOKUP, IF, and SUMIFS to manipulate and analyze data.

• Create insightful pivot tables, charts, and interactive dashboards to tell a data story.

We will focus entirely on Microsoft Excel. This tool is the backbone of many business operations. Mastering its functions is non-negotiable for any aspiring analyst. You will learn to wield its power for serious data manipulation, not just simple calculations.

Your Module Deliverables

This module is highly project-based. You will be building a tangible portfolio piece from day one.

Get ready to transition from a student of data to a practitioner.

Let’s get started!