There’s a lot of pretty amazing things that a trained statistician can tell about a set of numbers, given the right statistical tools. I, however, am not a trained statistician, and neither are most people.
For most people, there’s really only three things that they want to know about most things: how many, how much, and the average. Fortunately, in addition to a dizzying array of tools to perform higher level statistics, every spreadsheet will provide basic tools to answer these three questions. Continue reading Favorite functions: Simple statistics
First off, in honor of spring I just want to say that it’s time to…
Continue reading Formatting elements: Alignment (Nifty tricks)
Last week I promised that I’d discuss how to use text orientation in spreadsheets to make regular geometric figures.
To start off with, a regular geometric figure (also known as a regular polygon) is any figure where all the sides are the same length, and all the angles are the same size. A square is a regular polygon, but a rectangle isn’t because the sides aren’t all the same. Continue reading Making geometric figures (a nifty trick with text orientation and cell merging)
This week I’m going to discuss the last two aspects of alignment: text orientation, and text direction. It’s easy to get these two confused, but if you don’t remember which is which it’s not like it hurts anything to try one. I often end up trying both to see which will look better, anyway.
Continue reading Formatting elements: Alignment (About direction and orientation)
Another extremely commonly used option for adjusting the flow of text is merging cells. This lets you tell a spreadsheet to treat two or more adjacent cells as a single cell. Continue reading Formatting elements: Alignment (About cell merging)