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: March 2011

Hiding and Showing: Basic How-To

March 27, 2011 gexner

Okay, let’s say you’ve got an inventory with all the information you could possibly want… but you don’t necessarily want it all right now. Let’s say you’re browsing in a bookstore, and have your inventory on a chip in your… Read moreHiding and Showing: Basic How-To

Selecting and navigating cells, rows, and columns: Basic How-To

March 20, 2011 gexner

Okay, time a brief introduction to some techniques that we’ll be needing from here on out. I’ve previously mentioned selecting one or more cells, but if we’re talking about potentially large detailed lists it’s now time to discuss how to… Read moreSelecting and navigating cells, rows, and columns: Basic How-To

Inserting columns: Basic how-to

March 13, 2011 gexner

Continuing with the example of the book inventory, let’s say that you set up the perfect inventory — and then realized you needed something else. The last time we moved, I had had enough of not being able to find… Read moreInserting columns: Basic how-to

Project 5: Book inventory

March 6, 2011 gexner

To start off the discussion of detailed lists in spreadsheets, here’s a simple example: a book inventory. While this project focuses on books the techniques it demonstrates can be used for almost any sort of inventory. I’ve always wanted to… Read moreProject 5: Book inventory

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