AI Micro-Internship · ~180 min · low-code

Build a spreadsheet tool someone actually uses

Half of every office runs on spreadsheets built by "the person who’s good with Excel". Become that person: build a working Google Sheets tool — attendance tracker, budget manager, marks calculator — with real formulas, validation, and a real user.

Steps

01Pick a real tracking problem someone near you has (class rep tracking fees, family budget, club attendance).
02Build it in Google Sheets: input area, automatic calculations (SUMIF/VLOOKUP/QUERY — AI can teach you), data validation dropdowns, and a summary section with conditional formatting.
03Give it to the real user with real (or realistic) data and watch them use it. Fix what confused them.
04Share it with a public view link.

Tools: Google Sheets (free), ChatGPT or Gemini for formula help

Your submission

Submit the public sheet link, the problem + user, your formula explanations, and what changed after the real user tried it.

The problem and the real person who has it *Public view link to your working sheet *Your 3 most important formulas, explained in your own words *What the real user did, what confused them, what you fixed *