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: April 2012

Favorite functions: Simple statistics

April 29, 2012 gexner

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

Formatting elements: Alignment (Nifty tricks)

April 22, 2012 gexner

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)

April 15, 2012 gexner

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)

Formatting elements: Alignment (About direction and orientation)

April 8, 2012 gexner

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)

Formatting elements: Alignment (About cell merging)

April 1, 2012 gexner

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.

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