Back to Program Overview

Module 1: Spreadsheet Analytics

Module/Week 1: Spreadsheet Analytics

Module 1: Spreadsheet Analytics

Programme

Data Analytics Internship

Module Number

1

Module Title

Spreadsheet Analytics

Duration

3-4 Days

Level

Beginner to Intermediate

Tools Required

Excel, Google Sheets, CSV datasets

Overview

Clean, transform, and analyze business data with spreadsheet formulas and pivot workflows. This module is designed to feel like a real workplace sprint: you will understand the requirement, learn the technical concepts, inspect examples, build a practical artifact, and prepare your work for review.

Objectives

  • Clean messy datasets
  • Use lookup and aggregation formulas
  • Create pivot summaries

Course Content

13 Topics

Hands-on Tasks

  • Cleaned workbook
  • Pivot reports
  • Insights summary

Learning Outcomes

  • Clean messy datasets
  • Use lookup and aggregation formulas
  • Create pivot summaries