If you want to round a price to nearest nickel (multiple of 0.05), or a length to the nearest inch (multiple of 1/12), or a number of minutes to the nearest second (multiple of 1/60), you can use the following formula (where mult is the multiple to round to):=ROUND(number/mult,0)*multor just=MROUND(number,mult)(Thanks to mmmoj's comment for the MROUND function)If you want to round UP or DOWN, you
. Read More........Changing the Default Number of Sheets in Excel
[For Excel 2000/2002/2003]To change the default number of sheets in a new Excel workbook, go to Tools > Options > General tab and change "Sheets in new workbook". The default in Excel 2003 is 3 sheets, but I find that extremely annoying and instead of always deleting the other 2 sheets, I just set the default to 1.
. Read More........
Changing the Number of Recently Used Files in Excel
In Excel 2003, you change the number of recently used files listed in the File menu by going to Tools > Options > General tab and editing the number in the "Recently used file list:". The maximum if 9.In Excel 2007, the new recently used file list is probably one my most favorite updates. Instead of just listing the files, you can also "pin" the files that you use all the time so that they remain
. Read More........
Telecommuting Position: Bloggers and College Interns needed to write for �Eco-Friendly� Website
GreenHandsUsa.com is seeking Bloggers and college interns for their �eco-friendly� network of blogs and sites that provide useful information about living �green� both individually and with a community approach. This is a great website with so much �fresh� content and information regarding green events. If you have a knack and interest in �green� and have the ability to write short impulsive articles about people engaging in �green� community events both on campuses and in communities then you should apply. In order to apply you need to send three things: (1) Your bio, (2) a short blog post-writing sample and (3) cover letter.
Microsoft Layoffs - Cinco de Fire-O
Well, if ever you wanted to console yourself with some tequila, today might be your day. Phase Two of the big Microsoft 2009 layoff engages today.
- Microsoft continues layoff plan, eliminates thousands more jobs - TechFlash Seattle's Technology News Source
- Steve Ballmer's internal memo on Microsoft's latest round of layoffs - TechFlash Seattle's Technology News Source
- Microsoft Starts The Layoff Machine Again Steve Ballmer�s Memo To The Troops Peter Kafka MediaMemo AllThingsD
Is this it? Will there be more? From Mr. Ballmer's email:
With this announcement, we are mostly but not all done with the planned 5,000 job eliminations by June 2010.
Strangely, Ms. Brummel have asked folks to avoid emailing each other today because the last layoff's email volume was so distracting. Gee, sorry to be a bother while people are trying to figure out what the hell is going on. Let's see... how to avoid that... I know, tell people what the hell is going on and which people / groups are affected. Oy.
Please, if affected by today's events, note which group you're in and any messaging about things going forward (as appropriate and proper).
(And please, Ms. Brummel, if you talk to the troops about this, don't share how people affected by the layoff are thanking you - that just seems creepy.)
Dropping moderation for today, but as usual: be responsible. I will delete comments later that are off-topic, along with any other comments that react to the deleted comments. If in doubt, go visit the CRF parallel thread: http://minimsftcrf.blogspot.com/2009/05/comment-stream-microsoft-layoffs-cinco.html
. Read More........
Use the OFFSET Function for a Running Balance
If you have a spreadsheet that uses a running balance, the OFFSET function is a great way to allow you to easily insert and delete rows, without messing up the balance. To see how this works, take a look at the image below which is a screenshot from a modified version of my Checkbook register template.To start, let's talk about the formula in column B. In cell B7 let's say I used the formula =B6+
. Read More........
Langganan:
Postingan (RSS)
