Data Science · Level 1

Excel & Google Sheets for Data Analysis

By SRTR Academy Faculty

3 modules · 13 lessons · 7 videos · 6 hrs

Formulas, pivot tables, VLOOKUP, dashboards, data validation, basic macros

What you will learn

Module 1: Spreadsheet Fundamentals
- 🎬 Navigating Excel and Google Sheets — free preview
- 📄 Cell references: relative, absolute, mixed
- 🎬 Essential formulas: SUM, AVERAGE, COUNT, IF
- 📄 Data formatting and conditional formatting
Module 2: Intermediate Functions
- 🎬 VLOOKUP, HLOOKUP, and INDEX-MATCH — free preview
- 📄 Text functions: CONCATENATE, LEFT, RIGHT, MID
- 🎬 Date and time calculations
- 📄 Logical functions: IF, AND, OR, nested IFs
Module 3: Data Analysis Features
- 🎬 Pivot tables for quick analysis — free preview
- 📄 Data validation and drop-downs
- 🎬 Sorting, filtering, and slicers
- 📄 Creating interactive dashboards
- 🎬 Introduction to macros and automation