Moved to the Excel Twitters archive:
Excel Twitters 20090228
var fbShare = {size:’small’}

It’s finally Friday, so here’s another Excel game to help you relax this weekend. This is a Jawbreak game, adapted for Excel by Andy Pope, who is a very creative guy. Like Doug Glancy’s Concentration game, this game is based on a UserForm, with a button on the worksheet to start the game.

The object is [...]

At YourFonts.com you can create a font based on a sample of your handwriting, then use it in Excel, Word, or other programs.

My handwriting is terrible, much to my mother’s dismay, so I thought this might give documents a personal touch, with a bit more legibility. I could use my best writing to create a [...]

One of my clients coached his women’s hockey team to a provincial championship last weekend (and this is the medal they were awarded). Congratulations to him and the team! I don’t think he used Excel in planning his coaching strategy, but I’m sure Excel has other uses in sports.

Assign Baseball Players
For example, one of [...]

While working at a client’s office, I sometimes create an Excel workbook that a user will enter data in every day. To make it easy to open the workbook, I add a shortcut to the user’s desktop (with their permission, of course). This makes it easy for the user to open the file, without trying [...]

Roger Govier has taken the pain out of creating dynamic ranges, by creating a macro to automatically create the ranges for you.
When you run the macro in Excel, it creates a series of names for each of the column headings on the sheet. In addition to the Names for the column ranges, 3 extra names [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090221
var fbShare = {size:’small’}

A couple of Fridays ago, in the What’s in Your Desk Drawer comments, Doug Glancy mentioned that he had created a concentration game in Excel.
One of my first Excel VBA programming fun projects was to write one for my daughter and I to play. It had multiple decks, 3 user modes and “animated” cards [...]

Recently, I’ve been using Google Spreadsheets, to help plan a family event. I created a file and shared it with a few people, and it’s a quick and easy way for us to keep track of who’s doing what.
Then it dawned on me that we’re storing all this information online, with no backup. What [...]

To help users enter data in a spreadsheet, you can create drop down lists with Excel’s Data Validation feature. For example, in an order form, you could provide drop down lists of customers, products, colours, sizes and shipping methods.
Usually, each of these lists would need a different Source in the Data Validation dialog box. The [...]