# Favorite functions: Simple statistics

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

# Formatting elements: Alignment (Nifty tricks)

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

# Making geometric figures (a nifty trick with text orientation and cell merging)

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)

# Formatting elements: Alignment (About direction and orientation)

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.