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… Read moreFavorite functions: Simple statistics

First off, in honor of spring I just want to say that it’s time to…

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… Read moreMaking 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… Read moreFormatting 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.