Excel for Data Analysis
Bootcamp · Data Track
From formulas to Power Pivot — 7 meetings, one workbook, real skills. Designed for complete beginners who want to actually analyse data in Excel.
Tracks
Access to meetings 1–4. Covers Excel basics, data cleaning, conditional analysis, and PivotTables.
All 7 meetings + capstone guidance session. Includes Power Query, Power Pivot, DAX basics, and full portfolio showcase.
Schedule
What You'll Build
First GitHub repo + basic formula workbook
Cleaned dataset + documented error log
Conditional + lookup exercise workbook
PivotTable report + simple Excel dashboard
Repeatable Power Query workflow
Interactive analysis workbook
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