You Suck at Excel - Joel Spolsky (Reupload)
Channel:Cool Bug Facts · Length:54:00 · Published:2024-04-27 · Views:27025
Summary
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.
Why HN recommends it
HN commenters call it an internet classic that makes you a more proficient Excel user, and note it is still relevant despite predating newer functions like XLOOKUP.
will turn you into a more proficient user of Excel. — HN, 2024
Software (other) · Data science & statistics · Productivity & self-improvement
Subtitles (excerpt)
Um This uh This material is, I guess, kind of like basic to intermediate. But for you all, it's going to be stupid hard. So, just try to pay attention and don't slow me down. Try not to slow down the rest of us, either. This is Excel. Not a Google spreadsheet. The first thing that everybody always screws up in Excel is what's a row and which is a column. I always get confused. Is that the row or the column? Easy way to remember it is to think of columns in a building like a Roman architecture columns. The columns are the tall ones. I told you it was going to be easy. Now, Now Now, sit down. This is going to get a lot harder now, all of a sudden, real quick. Because you probably been using Excel in baby mode. This is baby mode with little letters across the top, ABC. It's very cute. This is not actually a representation of what's really going on under the scenes, which is R1C1 mode. You go into the little options here. You can see that you can turn that on. And when you turn that on, you get numbers across the top. Going to go back and forth a a few times. Cuz that will help you understand what Excel is really doing as I do some stuff. So, the first thing I'm going to do, actually, I'll do a little demo.
On Hacker News
> They force name and number everything which is exactly like using single letter variables, they are only allowed for simple things. This isn't true, named ranges have existed for longer than many (most?) HN readers have been alive. As far as I'm aware they were in the first version in 1985. Joel Spolsky's "you suck at Excel" is more than a decade old but still relevant: [VIDEO] — Arainach, 2026-08
I think you're thinking of "You Suck at Excel" by Joel Spolsky. [VIDEO] Lots of past HN discussion... [LINK] That video was before the introduction of xlookup, which I believe is now worth considering over index and match. — imurray, 2026-06
> Big tools like MSOffice have the ability to be put in hiring contracts: Everyone is assumed to know how to use it, so the company is allowed to deny the no training excuse without spending money. I would claim that if you haven't worked in the finance or insurance industry (or some related industry) for quite some time, you very likely don't know how to use Excel (I have a feeling that a simila… — aleph_minus_one, 2025-04
As a well seasoned web developer, when I'm doing front-end, there are always 2 big problems: Data tables and loading indicators (fun way of saying it's hard to tackle lazy loading without a request waterfall). The second problem has had good attempts in the recent years, but no single web application can beat excel in terms of data tables (while not 100% relevant anymore, I really like the super … — egeozcan, 2024-10
[VIDEO] will turn you into a more proficient user of Excel. However, make sure you know the limits of Excel... [LINK] — surfingdino, 2024-06
Related videos
- The Spectacular Failure of the Star Wars Hotel · Jenny Nicholson · 4:05:39
- BlueHat Seattle 2019 || Guarding Against Physical Attacks: The Xbox One Story · Microsoft Security Response Center (MSRC) · 45:32
- Why Figure 8 knot is NOT hard to untie! · Hard Is Easy · 17:37
- Raiden Warned About AI Censorship - MGS2 Codec Call (2023 Version) · CYBERGEM · 4:48
- How to Speak · MIT OpenCourseWare · 1:03:42
- A Better Default Colormap for Matplotlib | SciPy 2015 | Nathaniel Smith and Stéfan van der Walt · Enthought · 19:08
- Steve Jobs Stanford Commencement Speech 2005 · JoshuaG · 14:34
- The Problem with Time & Timezones - Computerphile · Computerphile · 10:12
- Randy Pausch's Last Lecture: Achieving Your Childhood Dreams · Carnegie Mellon University · 1:16:27
- Controlling Your Dopamine For Motivation, Focus & Satisfaction · Andrew Huberman · 2:16:31
- Music and Life - Alan Watts · seandulac · 2:23
- Hamming, "You and Your Research" (June 6, 1995) · securitylectures · 44:02
- Hammock Driven Development - Rich Hickey · ClojureTV · 39:49
- Marty Lobdell - Study Less Study Smart · Pierce College District WA · 59:55
- You Need a Theme, Not a Goal · CGP Grey · 6:23
- Mike Monteiro: F*ck You, Pay Me · CreativeMornings HQ · 37:53