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

Formatting elements: Borders (About)

January 29, 2012 gexner

If you use only one kind of formatting on a table, make it the borders. The borders are the lines around the cell . Like the borders around a comic strip, lines around a table give it visual definition, and… Read moreFormatting elements: Borders (About)

Debt payoff spreadsheets: updated

January 22, 2012 gexner

Earlier this week, a reader asked about adding some functionality to the debt payoff spreadsheets I posted a few weeks back. One of the things he wanted was a way to enter base income and subtract expenses, rather than having… Read moreDebt payoff spreadsheets: updated

Debt payoff spreadsheets: formatting

January 15, 2012 gexner

Last week I discussed the formulas in the debt payment calculator spreadsheets, but before jumping back into the why-should and how-to’s of various types of formatting I wanted to take a little time to point out the formatting that I… Read moreDebt payoff spreadsheets: formatting

Debt payoff spreadsheets: formulas

January 8, 2012 gexner

Last week I shared a debt payment calculator spreadsheet, and promised that this week I’d discuss how I did it. I’m not going to write out the formulas here, but my explanations here are designed to help you read through… Read moreDebt payoff spreadsheets: formulas

Debt payoff spreadsheets

January 1, 2012 gexner

By the time this post goes up it’ll be 2012, and a lot of people will be starting on their new year’s resolutions. Any resolution that’s done in stages (like weight loss, or debt reduction) can be tracked in a… Read moreDebt payoff spreadsheets

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