What a completion record looks like

Completion record

Name

Sample learner

Course

Google Sheets Foundations

Completed

8 November 2026

Project

View the dashboard →

Skills demonstrated

Turning an export somebody else produced into a spreadsheet of your own, and knowing how much of it there is before changing a cell · Finding what is wrong with a supplied file and removing it deliberately, able to account for every row that went · Cleaning text and numbers with formulas rather than by hand, including one failure Google documents in its own cleaning tools · Writing formulas that name what they mean rather than where it sits · Producing a figure for every row and a set of figures for a whole file, and making the two agree · Summarising by category, stating what a proportion is a proportion of, and proving the parts add back up to the whole · Presenting a summary as a chart and a sheet fit to hand over, with access set deliberately · Checking your own work at every stage without being told the answer

What was built

One spreadsheet in your own Google account. The export exactly as it arrived, a cleaned table you can summarise, three columns of your own that fix what the export got wrong, a Summary sheet holding the whole file's figures and a row for every branch and every category, a titled chart, a note saying where the numbers came from, and access set so the people you send it to can read it and nothing more.

The 6 sessions, and when each was completed on their own

Each session was completed twice: once with step-by-step guidance on one company’s data, then on a second company’s data from a brief, with guidance only when asked. Every check passed on both. Alongrail records the sessions, the checks and the dates; the dashboard itself is the learner’s own, hosted where they chose.