工具与资源youtube.com
Joel Spolsky：你的 Excel 很烂
You Suck at Excel with Joel Spolsky (2015) [video]
2016 — 2019，它一次次回到首页
黑点是上首页（≥ 50 分）的那次投稿，空心点是没冲上去的投稿，点越大分数越高。
导读
这是 Joel Spolsky 在 2015 年的一场演示型演讲录像，面向自认为“会用 Excel”的程序员，讲解 Excel 里真正好用的功能：把区域转成 Table、按列名引用、R1C1 相对引用、数据透视表等。核心观点是大多数人只把 Excel 当电子表格用，其实它可以当作一个数据处理和轻量编程环境。
为什么经久不衰：它把 Excel 从“画表格的工具”重新讲成一套可组合的数据处理范式，十年来一直是让人重新认识 Excel 的经典入门材料。
HN 评论精选
用 Excel 做工程规划必须靠“输入/参数/输出分离 + 锁定引用 + 交叉校验”的纪律，否则必然出错。
我在工作中经常看到技术供应商和顾问用 Excel（更糟的是 Word 表格）来规划基础设施变更，结果惨不忍睹：先手工清点配置、随手敲进表格，然后叠加一堆手工修改、批注、高亮和多色字体，像地层沉积一样；公式只用来临时求和计数。最终方案总有错误和遗漏，部署时非常痛苦。正确做法需要纪律：不可变的输入表（来自机器生成的配置导出）、参数表、输出表（统一用 $ 锁定行列的公式），以及带条件高亮的交叉校验。可惜没有编程直觉的人很难做到——不过这也算是职业保障。做得到的话，比手工自由发挥既快又安全。
tominous查看英文原文
In my line of work I often see tech vendors and consultants trying to plan infrastructure changes using Excel (or worse, tables in Word, but we won't go into that). The results are horrendous. They start with a manual inventory of the configuration in question, type it ad-hoc into a spreadsheet, then go through making manual changes, notes and additions until it feels good. There's lots of highlighting, different coloured text, etc like layers of sedimentation. Formulas are only used for sums and counts in an ad-hoc way. The end plan always contains mistakes and omissions that really hurt during deployment time. The correct way requires discipline: immutable input sheets (from machine-generated config dumps), a parameter sheet, output tables (with consistent usage of formulas with "$" notation to lock rows and columns), and cross checks with conditional highlighting. Unfortunately this is really hard for people without programming instincts/experience. Good job security I guess. But if you can do it, it's both faster and safer than the manual free-form method.
演讲有偏颇：$ 锁定引用并不“幼稚”，而且“Google 表格做不到”的说法忽视了平台与价格因素。
我从中学到了很多，但提几点温和的批评：1）Joel 说“我没听懂这个问题”然后跳过，虽然干脆实用，但不太像他的风格。2）前 13 分钟他讲得好像 R1C1 模式是处理相对引用的唯一方式；我学 Excel 最早学到的就是用 $ 锁定行或列——也就是他所说的“婴儿模式”。用 $ 更简洁，改公式时还能立刻看到计算结果，他讲得太晚了。3）18:15 他说“这些在 Google 表格里几乎都做不到”，听起来非常挺微软；但看得出来他用的是 OS X，而 Office for Mac 历来不如 Windows 版完整。何况 Google 表格是免费的。
IANAD查看英文原文
First, I learned a lot from this. But, here's some light criticism: 1. Joel saying "I didn't understand that question" and then moving on might have been succinct and practical, but it was just not a good reflection of him. 2. He acts like R1C1 mode is the only way handle relative references for the first 13 minutes. One of the first things I learned in Excel was $ to pin a reference to row or column in what he calls "baby mode". I think it's not babyish to use $ which is more succinct; you can edit the formula and see the calculated value right away. It seemed like he waited a long time to talk about that. 3. "Almost none of which you can do in Google spreadsheets" at 18:15. Sounds so pro-Microsoft, right? Yet, if you look, he's obviously using OS X, which is surprising to me, because MS Office has historically sucked on OS X compared to its Windows counterpart, and it's been incomplete: https://9to5mac.com/2016/01/21/windows-mac-ipad-microsoft-office-comparison/ even though, yes, it's a lot better than it used to be. Also, Google docs is free.
记住 Ctrl+A 加“插入表格”这两步，就能立刻处理任何数据集。
这是我找到的最好的 Excel 教程。哪怕你记不住多少，光凭视频里这几步就能很快上手任何数据：1）Ctrl+A 全选数据；2）插入表格（Insert Table）——之后可以对任意列筛选排序，可以加一行统计，自动套用格式和配色，还能从这里直接转到数据透视表。
enitihas查看英文原文
This is the best Excel tutorial I have ever found. Even if you don't remember much about Excel, the following from this video allows me to basically get started with any data very quickly: 1. Ctrl A : Select all the data 2. Insert table : This will allow you to be able to filter or sort on any column, provide a row for stats if you want, and will auto format and color the table. You can also choose to go to a pivot table easily from here.
Excel 的真正价值是把数据处理能力交到没有编程训练的人手里，目前几乎没有对手。
如果你是会写代码、但某天可能要用 Excel 的人，这个视频非常棒（可以按列名访问列？！太想用了！）。不过我最喜欢 Excel 的地方，是它让没有受过正式编程训练的人也能对数据做这么多事，甚至在上面做函数式编程。有没有哪个工具在能力、易用性和普及度上接近它？这样的工具该长什么样？
phn查看英文原文
The video is amazing if you're a coder and might need to use excel at some point (access columns by name?! sign me up!). However, what I love about excel is to see what it enables people without formal programming training to do with data, and using functional programming on top of that! Is there any tool that comes even close in terms of power, accessibility and ubiquity? What would such a tool even look like?
历次讨论
同类还值得读
直接在浏览器中启动 Linux 内核
Boot a linux kernel right inside your browser.
Fabrice Bellard 的 JSLinux 页面，用 JavaScript 在浏览器里启动一个 Linux 内核，并提供一个可交互的终端环境。
工具与资源上首页 5 次 · 2011–2025bellard.orgHacker News 未公开功能与行为清单（2018）
A List of Hacker News's Undocumented Features and Behaviors (2018)
数据科学家 Max Woolf 整理的 Hacker News 未公开功能与行为清单，涵盖投票机制、排名算法、账号惩罚等社区运作细节。
工具与资源上首页 5 次 · 2019–2025github.comMapSCII：在终端中用盲文和 ASCII 渲染地图
MapSCII – Braille and ASCII map renderer for the console
MapSCII 是一个在命令行终端里渲染地图的开源工具，用盲文字符和 ASCII 字符把地理数据画成可交互浏览的字符地图。
工具与资源上首页 5 次 · 2017–2025github.com顶尖大学的免费在线课程
Free Online Courses from Top Universities
Open Culture 整理的一份免费在线课程合集，汇集了全球顶尖大学（如 MIT、斯坦福、耶鲁等）向公众开放的网络课程资源，涵盖音频、视频等多种形式。
工具与资源上首页 5 次 · 2010–2022openculture.com淘气字符串：容易引发用户输入问题的字符串清单
Naughty Strings: A list of strings likely to cause issues as user-input data
一个 GitHub 仓库，收录了大量容易让程序出问题的用户输入字符串，如特殊字符、emoji、SQL 注入片段、系统命令等，供开发者用于测试输入处理逻辑。
工具与资源上首页 4 次 · 2015–2020github.com