Library

Excel for Data Analysis

Bootcamp · Data Track

Excel for Data Analysis

From formulas to Power Pivot — 7 meetings, one workbook, real skills. Designed for complete beginners who want to actually analyse data in Excel.

📅Jun–Jul 2026
🗓Every Tue & Thu
60–90 min/session
📊Beginner → Intermediate

Tracks

Free TrackRp0

Access to meetings 1–4. Covers Excel basics, data cleaning, conditional analysis, and PivotTables.

  • Meeting 1 — Excel Basics
  • Meeting 2 — Data Cleaning
  • Meeting 3 — Conditional + Lookups
  • Meeting 4 — PivotTables + Dashboard
Paid Track
Rp50.000

All 7 meetings + capstone guidance session. Includes Power Query, Power Pivot, DAX basics, and full portfolio showcase.

  • Everything in Free Track
  • Meeting 5 — Power Query
  • Meeting 6 — Advanced Formulas + Pivot
  • Meeting 7 — Power Pivot + Capstone Showcase
  • Capstone Guidance Session (Fri 26 Jun)

Schedule

What You'll Build

#1

First GitHub repo + basic formula workbook

#2

Cleaned dataset + documented error log

#3

Conditional + lookup exercise workbook

#4

PivotTable report + simple Excel dashboard

#6

Repeatable Power Query workflow

#7

Interactive analysis workbook

#8

Power Pivot model + capstone showcase

All sessions use one workbook file — excel-data-analysis-bootcamp-workbook.xlsx — built sheet by sheet across all 7 meetings.

Formula Coverage

Basic Calculation

SUM, AVERAGE, COUNT, COUNTA, MIN, MAX, ROUND

Logic

IF, IFERROR, Nested IF, IFS

Text Cleaning

TRIM, PROPER, UPPER, LOWER, LEFT, RIGHT, MID, LEN, SUBSTITUTE, TEXT, CONCAT, TEXTJOIN

Conditional Analysis

SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS

Lookup

VLOOKUP, XLOOKUP, INDEX + MATCH

Date Analysis

TODAY, YEAR, MONTH, date grouping, date formatting

Advanced Analysis

SUMPRODUCT, FILTER, SORT, UNIQUE

Power Pivot / DAX

SUM, COUNTROWS, CALCULATE

Before You Join

Laptop or desktop (phone/tablet only is not recommended)

Microsoft Excel 2019, 2021, or Microsoft 365

Internet connection — needed for GitHub, LinkedIn, and classroom access

Email account, GitHub account, and LinkedIn account

Ability to create folders, rename files, save and download files

Basic Excel terms: workbook, worksheet, row, column, cell, range, table

After Registration

After payment, you will receive WhatsApp confirmation within 1×24 hours. This includes registration confirmation, WhatsApp group access, classroom access instructions for bayaan-by-nur.com, and information about recordings, datasets, workbook files, assignments, and supporting materials.

Ready to join?

Starts Tuesday, 16 June 2026 · First 4 meetings are free

Paid track

Rp50.000

Daftar via WhatsApp