 
|
You know how tough it can be to maintain two versions of the same file. It creates twice as much work for you, and no extra rewards! So, instead of having two versions of the Excel weight loss tracker – pounds and kilograms – I've rolled them into one workbook. For now, there is a [...] Monday, October 17th, was Spreadsheet Day, and I hope you've recovered from all the festivities. Thanks to everyone who tweeted about Spreadsheet Day, and a special thanks to those who made a Spreadsheet Day post on their blog. In case you missed any of the posts, here's a list. If I omitted yours, [...] Happy Spreadsheet Day! I hope you're making time to cell-ebrate this special day. October 17th was selected as Spreadsheet Day, because that is the date that VisiCalc was first shipped. Student SpreadsheetsThe theme for this year's Spreadsheet Day is Student Spreadsheets. If you have uploaded a free, useful template or add-in for students, [...] Mock me if you will, but I use Excel to plan the timing for our holiday dinners. Monday was our Canadian Thanksgiving, so it was the perfect occasion to dig the planner out again. You know that it's a delicate juggling act, trying to get everything cooked and on the table at the same time. [...] Long ago, Dave Peterson created an Excel worksheet data entry form, so you could enter records on one sheet, and store the data on another sheet. Then, you can hide the data entry sheet, so users don't accidentally change any of the old records.
There have been a few version of the data entry [...] Can you afford that new car? Or maybe you loaned money to one of your kids, and you want to calculate a repayment schedule. (Oh yes, they will stick to the plan, without fail.) To help you figure out the payment amounts, here is a nifty Excel loan payment calculator. (The kids will think [...] Last year, you might have seen the Excel Weight Loss Tracker workbook that I posted, which used inches and pounds as its measurements. Even though we use the metric system in Canada, we still track our weight in the Imperial system. (I'm not sure why.) In May 2010, I posted the weight loss tracker in [...] In Excel 2007 and Excel 2010, when you create a new workbook, there should be 1,048,576 rows on the worksheet. However, one of my clients was creating new files in Excel 2007, and the sheets only had 65,536 rows, just as they did in older versions. Perhaps you don't need more rows than [...] There's a Golf Tee Time Excel workbook on the Contextures site, that I've updated, to add a few new features. You'll list all the players, then assign groups of players to a selected tee time. The new version has data validation in column C, which limits the selection to 4 names, and you can't [...] There is an Excel weekly meal planner on the Contextures website, in which you can select meal items, and create a weekly shopping list. Shopping List ProblemsIn December, I added an online recipe selector, created by Jimmy Peña, and described the new feature in a blog post. This weekend, Alyssa pointed out [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
