Skip to content

Swiss Army Spreadsheets

How to do just about anything with software you already have

  • Home
  • About
  • All
  • Author
  • Presentations and Publications
  • Welcome to Swiss Army Spreadsheets

Month: July 2012

Formatting elements: Column Width and Row Height (About)

July 29, 2012 gexner

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)

Formatting elements: Font (Nifty tricks)

July 23, 2012 gexner

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)

Formatting elements: Font (How to)

July 16, 2012 gexner

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.

Formatting elements: Font (About)

July 9, 2012 gexner

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)

Simple statistics: countif example

July 2, 2012 gexner

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

Recent Posts

  • Working with big data sets: using different functions
  • Working with big data sets: streamlining formulas
  • How big is big?
  • The same but different: conditional formatting in adjacent cells
  • Identifying opening and closing tags

Archives

  • January 2014
  • December 2013
  • November 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010

Categories

  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2025 All rights reserved
Proudly powered by WordPress | Theme: Simple Life by Nilambar.
Go to top