From the Wikipedia article on the planning fallacy: The planning fallacy is a tendency for people and organizations to underestimate how long they will need to complete a task, even when they have past experience of similar tasks over-running. The term was first proposed in a 1979 paper by Daniel Kahneman and Amos Tversky. Since […]
Pressing the Alt key and equal sign key (i.e., first press the Alt key and then while keeping it pressed, press the equal key) will autosum a contiguous range of cells. In the following example, the numbers 10, 20, 30 are typed into cells B2, B3, and B4 respectively. Then in cell B5, first the […]
Recently, both New York and The New Yorker profiled Ray Dalio. Dalio is the founder of Bridgewater Associates. Bridgewater runs the world’s largest hedge fund. Both articles provide fascinating and quite entertaining glimpses into the corporate culture at Bridgewater. Both articles, but the one in New York more so, focus on a document Dalio wrote […]
J is an obscure, but potentially very useful programming language for certain types of tasks. It’s a calculator language, and its specialty is manipulating arrays. J was created by some of the same people who made APL. Here’s a great primer on getting started with J, and here are some books on learning the language. You […]
In this post, I’ll cover a few more techniques for quickly moving around in Excel. Here’s the link to the earlier post on navigating in Excel. This screencast covers changing the direction the cursor moves after pressing the enter key, keeping the cursor from moving after pressing the enter key, and the keyboard shortcut for […]
