tichiianon Hacker News • Recommends
On “Pyspread – Pythonic Spreadsheet”
That A1 mode is Excel "Baby-Mode", you can switch to R1C1 mode in settings. Things are far easier then, and more sane. His Excel-lence also recommends this: link to this video
0:00 / 0:00
#excel#joelspolsky#spreadsheets
You Suck at Excel - Joel Spolsky (Reupload)
Cool Bug Facts
71 subscribers • 1 video on Hallway
- Recommended by 7 people: 7 on Hacker News.
- Presented by Joel Spolsky
Beginner. No background in the topic needed.
26K views2 years ago7 recommendations
Tools and practiceDeveloper productivityData engineering and warehouses
Joel Spolsky teaches essential Excel features and practices, including keyboard navigation, named ranges, tables, and lookup formulas.
The original video disappeared, so this is a reupload from the Wayback Machine's archive.Why it's here
7 people recommend thisWhat people say. Engineers frequently share this classic video to help others dramatically improve their spreadsheet productivity and data analysis skills.
mbforbeson Hacker News • Recommends
On “Improvements to data analysis in ChatGPT”
Nothing capability-wise! Just speed and ease of manipulation. Maybe an analogy is doing image processing. One could write filters and other manipulations in code, or use something like Photoshop. It turns out Photoshop is a great interface for many of those tasks. I think the same thing is true for more data analysis than I'd realized because of my poor Excel skills. Still want to improve my spreadsheet abilities though. There's a fun video called You Suck at Excel by Joel Spolsky I'm halfway through 1. Would love to know of more like this. 1 link to this video
surfingdinoon Hacker News • Recommends
On “The Microsoft Excel superstars throw down in Vegas”
link to this video will turn you into a more proficient user of Excel. However, make sure you know the limits of Excel... link
egeozcanon Hacker News • Recommends
On “Show HN: Tenno – Markdown and JavaScript = a hybrid of Word and Excel”
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 light introduction here from Joel Spolsky: link to this video )
aleph_minus_oneon Hacker News • Recommends
On “Lessons from open source in the Mexican government”
…points holds for Word and Powerpoint with respect to some industries, but I think for these applications this phenomenon is a little bit less pronounced). Indeed, I'd claim that most books about how to use Excel are simply crap. To just give you a glimpse how to use Excel, here some internet classic on this topic: You Suck at Excel - Joel Spolsky link to this video Really understanding Excel is life task, similar to really understanding modern C++.…
imurrayon Hacker News • Recommends
On “Alternatives to Nested If Function”
I think you're thinking of "You Suck at Excel" by Joel Spolsky. link to this 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.
Arainachon Hacker News • Recommends
On “My Rules for Using Spreadsheets”
> 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: link to this video
tpoacheron Hacker News • Mentions
On “Use Microsoft Office Shortcuts in Libre Office”
…ot a simple matter of reassigning a keyboard shortcut. Switching from AB mode to RC mode is one example; in Calc you need to go to Tools::Options::Calc::Formula::Syntax to switch. But so far I've had no problems working in Calc in general. I was able to follow Joel Spolsky's infamous "You suck at Excel" video 0 with no problems, for example. 0 link to this video…