 
|
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 [...] 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 [...] 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 [...] 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 [...] Moved to the Excel Twitters archive: Excel Twitters 20090221 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" [...] 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. [...] 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. [...] Several times every day, I drag something from one part of a worksheet to another. If there's already something in that destination cell, Excel asks me if I'm sure I want to do this. About 99.99% of the time, yes, I really want to replace the contents of that cell. So, I click OK, [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
