Last week I talked about all the options for changing column widths and row heights, and explained how to do each one using the headers to manipulate the sizes. This week, as promised, I’m going to cover how to do… Read moreFormatting elements: Column Width and Row Height (How to part 2)

Last week I talked about why you might want to change the column width or the row height, and this week I’m going to talk about the mechanics of how to actually do that.

Last week I talked about changing column width and row height for readability purposes, and this week I’d like to look as the aesthetic possibilities in a little more depth. And, as you probably know if you’ve been reading this… Read moreFormatting elements: Column Width and Row Height (About aesthetics)

Another formatting element that I’ve mentioned frequently, but not explained, is column width and, by extension, row height. In a lot of ways wrapping the text, decreasing the font size, and changing the column width are all ways to do… Read moreFormatting elements: Column Width and Row Height (About)

There are a lot of things you can do with fonts, and a lot of things you can accomplish with them. You can make things prettier, of course (or you can make it hideous, if you go too far), but… Read moreFormatting elements: Font (Nifty tricks)

Last week I talked about the various options for formatting the font, and this week I’m going to talk about how to actually access and use them.

In making last week’s post, I realized that I had missed a couple of the formatting types I’d promised to talk about. One of those things was what you can change about fonts, what you can do with them, and… Read moreFormatting elements: Font (About)

To help illustrate how countif() can be used to generate useful statistics, I’ve created a example. This example is for a library which has librarians teaching library instruction classes to a variety of group types. The first sheet has the… Read moreSimple statistics: countif example

While countif() can count the number of times a specific thing appears in a set of cells, countifs() counts the number of times a corresponding set of things appears in a corresponding set of locations. For example, countif() could count… Read moreSimple statistics: counting compound things

If you want to count something specific – say, the number of “Yes” entries – then the function you want is countif(). Countif() is, without a doubt, my favorite counting function. I honestly didn’t even know the others existed, or… Read moreSimple statistics: counting specific things