user testing

A reupload of Joel Spolsky's talk teaching spreadsheet users the Excel features they are probably missing, such as keyboard navigation, named ranges, tables and lookups. The original disappeared and this copy comes from the Wayback Machine.

Matt Risinger demonstrates a blower door test on a house, using a fan to measure air leakage and find where air gets in and out. It shows how the test reveals the quality of the build.

The UK DVSA's one-minute guide to the hazard perception part of the driving theory test, covering when to click and how to score well.

George Brocklehurst of thoughtbot demonstrates Vim's built-in completion mechanisms, from word, line and block completion to ctags. The aim is to type less and make fewer typos.

Essential Craftsman announces the start of a spec house build on a scenic lot, kicking off a long series. The channel covers every step of building a house from the viewpoint of a general contractor.

Lock-picking YouTuber Bill Johnson (BosnianBill) explains how to choose a high-security lock and why, showing examples and comparing designs. It covers what makes some padlocks more pick-resistant than others.

In a long live-coding session, Andreas Kling works on making the Cookie Clicker game playable in the Ladybird browser from SerenityOS. He tracks down bugs in the browser engine and fixes them.

Jeri Ellsworth shows early steps of making microchips at home: cleaving wafers, removing native oxide, testing dopant type with a hot probe, and loading the furnace.