Blog Directory

PS - The opinions expressed in this blog are just opinions and personal preferences regarding the way I view life in general. Nothing in this blog is meant in any way to provide professional advice or guidance (no matter how good my opinion is) - seek a professional for your professional needs and just come here for entertainment and occasional tidbits of useful (again - my opinion) information.

Category Archives: Tips & Tricks

Do you ever create documents on your computer that you don’t want anyone else to be able to open? Most of use do. Or maybe you want to send a document by email but want to make sure only the intended recipient can open it. Follow these simple instructions to restrict access to certain documents on your computer to only those with the password.

This process needs to be completed for each document you wish to place a password on.

  1. Open the Microsoft Office (Word, Excel, Publisher, etc) document you wish to protect.
  2. On the menu, select FILE > SAVE AS
  3. Select TOOLS > GENERAL OPTIONSPassword Protect
  4. A new window will pop up. Somewhere in that window you will see a place to enter a “Password to open”. to openEach window will be slightly different based on the document you are saving and the version you are using due to a variety of options. Type in your desired password, click OK, Reenter password, click OK, click Save (if you are prompted to replace an existing file, choose yes) Close the original document.  Next time the document is opened there will be a prompt to enter a password.7-17-2009 7-11-04 PM
  5. If you would like to restrict modification to the document you can also enter a “Password to modify”. to modifyThis will add a second prompt for a password to allow only the users who know this additional password to make modifications to a document. modifyIf this password is unknown (but the password to open is known) the user can choose to open as a read only document but will be unable to make changes or save to the original document. (They will be able to save the document by giving it a new name however)
  6. Additionally, you can also choose to let anyone have access to view the document without a password but restrict modifications to the document to those with a password by leaving the password to open blank and only entering a password to modify.

That’s it. Don’t forget your password or you won’t be able to get back into your document without extra effort and cost.

If you do forget your password, you have two options. The first is to buy  password recovery software ($20-$100) or hire somebody (like me ;) ) to recover it for you.

  • Share/Bookmark

So I just made a pot of hard boiled eggs and when I was talking to my girlfriend she mentioned how her hard boiled eggs always are a pain in the rear to peel and have a green ring around the yolk. I rarely have that issue (and I say rarely since I do not always follow my own instructions) so I thought I would share my “recipe” for hard boiled egg success. Here are the two keys; the age of the egg is the most important factor in ease of peeling, and overcooking is the main reason for a discolored yolk.

So…age of the egg?

Yep – the older the egg the better. If you know you are going to be making hard boiled eggs in the future get eggs that will expire as close to the day you are making them as you can. If not, just buy the eggs that are closest to the expiration date. I usually find that the local “mini-mart” type stores sell eggs closer to expiration than supermarkets. Eggs don’t necessarily expire on the expiration date of the container (and that date is usually a sell by date anyway) . A simple test in water will answer the freshness question for you. Place the egg in a bowl of water; if it lays on its side, it is very fresh. As it ages, the air pocket inside the egg grows, which buoys the egg up so it stands on one end. If the egg floats to the top, it is ready for the trash. Sidetracked: This brings me back to a story about my mom from when I first ventured out on my own. I was making hard boiled eggs and reading the instructions from a cook book (yep). Something was not working out correctly so I called my mom at work and the conversation went something like this…”Hey Mom, I am trying to make hard boiled eggs and the instructions say to cover the eggs with at least an inch of water?” Mom: “yeah, sounds right” Me: “What if they float?” Mom: “I have no idea, hold on…” Now yelling over her cubicle at work to whomever is in ear range and can answer her “What do you do if your eggs float when you’re making hard boiled eggs? What? Eggs EXPIRE?” Now back on the phone “Throw them away, apparently eggs expire” Apparently? Well, I am still around so I must not have eaten too many bad eggs as a kid!

Now for the cooking part.

  • Place eggs in a pot with enough COLD water to have an inch of water above the eggs.
  • Place the pot with the eggs and water over high heat until the water comes to a full boil. IMMEDIATELY take the pot off the heat and cover with a tightly-fitting lid. The eggs will continue to cook from the heat of the water. The eggs do not need to be (and should not be) boiled. Overcooking eggs is what causes the iron in the yolk and the sulfur in the white to combine, and this makes that ugly greenish color around the yolk.
  • Let the eggs sit in the pan in the hot water for 12-18 minutes depending on the size of your pan and the size of your eggs (the larger the pan the less time you need since it takes longer to boil the water and obviously smaller eggs need less time).
  • Drain the eggs and fill the pot with cold water. I like to empty and re-fill the pot several times to make sure the heat of the eggs doesn’t heat the water back up again. You can also put ice cubes in the water. The water should be very cold. Letting the eggs sit in the cold water until the eggs are completely cooled helps the membrane stick to the shell, instead the egg, and makes the egg easier to peel.
  • Hard boiled eggs in the shell can be refrigerated up to one week. Hard boiled eggs out of the shell should be used right away.

Worth a mention, never tried: I have heard the following… If you are making deviled eggs, place carton of eggs on its side for a day or so. The yolk will then center itself so you have it directly in the middle of the white. No more off centered deviled eggs.


  • Share/Bookmark

So I get a call from a client today – all of his data is gone. He has no clue what happened. He was cleaning up his computer “to make it go faster” (as I am sure many of you have, PLEASE have someone who knows what they are doing complete this task as you can end up doing more damage than good to your computer ) and “I may have accidentally deleted the my documents folder”. He is in full blown panic mode. All of his spreadsheets and tools to help him manage his daily business were in that folder. I log onto his computer (remote access via logmein) and sure enough – it’s gone. This is where I become the hero. Unbeknownst to him I had previously installed Mozy , an online backup system, on his computer to back up this folder. I am a HERO. In just a couple of hours all of his important files are restored!
(click logo)

There are many options out there to backup your files. Mozy offers 2GB of free space to anyone and you can increase the amount of free space you get by referring other people via a special link or by giving them your referral code. If you have a large amount of data to back up you can get unlimited backup space for $4.95/mth. Another popular online backup option is Carbonite which also has unlimited at $54.95/yr. Both options are similar so you will just have to check them both out to see which better fits your needs. After the initial setup they both backup based on the schedule and files you choose provided you are connected to the Internet during the entire backup process. The initial backup can take more than a week but depending on the size of data to be backed up, subsequent backups can take a few minutes to a few hours.

If you are one of those people that does not feel secure sending your information into cyberspace (my husband), you can opt for a desktop backup drive which is essentially an external hard drive connected to your computer via a usb port and comes with software to set up an automatic backup of your hard drive with your preferences – you can choose to backup your entire computer or just select files. The only stipulation here is that you choose a backup drive that is large enough to accommodate all of your current and future back up needs. I would recommend at least twice the size of your current hard drive. These drives can be purchased online or at any office supply store as well as many other stores that sell computers. The only downfall is obvious…this drive generally sits on your desk right next to your computer. So… if something happens to your computer (fire, theft, etc) chances are it is going to happen to your backup drive as well. One way around this is to purchase two (you can get a 500GB for under $100 and smaller drives for less) and rotate them, always keeping one off site.

If you only have a few folders or files to backup you can copy them to a a portable flash or “thumb” drive. These range in sizes from 128mb to 32GB or more and range in price from $5 – over $200. The sky is the limit on what you can do with these things. You can have several and each can hold specific types of data backups (Music, pictures, documents) – the nice thing about these is, as the are titled, they are portable. These types of devices also make it very easy to share your documents and files with other people or computers.

If you really want to go old school you can still purchase programs that will copy your files to a CD or DVD, OR complete the process manually this can be very tedious and time consuming, but it works nonetheless.

Whatever your backup method/device preference is I urge you to BACKUP! Also, on a semi-regular basis, check your backed up files to make sure they are actually being backed up – nothing worse than THINKING you have a backup in place when it is not working properly! You may never need to revert to your backed up files but if you ever do, even for just one critical file, you will be glad you had it.

***Added note since I have received a few emails about “liability”. I did tell the OWNER of the company that I had installed the backups on the office computers (I would never place software or any other program on a clients computer without permission), it was the general manager that lost the data and was unaware.

  • Share/Bookmark

So this post is kinda of two fold. First off I decided I need to add another column to the left right of my blog posts to display advertisements. This is a much debated topic among the blog world but my personal preference it to have them. Why? you might ask. Well… I like ads. I think they provide me with links to places I may otherwise not find – especially if they are relevant to the specific content listed on the page I am looking at. Also, the few extra bucks they provide me in a month (about $10 to date) is a nice perk. I know most people block them out or overlook them completely but I do not happen to be one of those people. Here is a prime example…

So I decide I want to add this column, I contact the person who helped me add this page to my blog and his suggestion is to find a new template that already has a column where I want it. My gut reaction is capital H-E-double hockey sticks no! I spent HOURS customizing the blog I have getting it to look how I wanted it to (and still spend time tweaking it). But I think, fine – I will look around. So I spend a couple hours looking at different templates and can’t find anything I like – It took me forever to find the one I have. So then I decide there has GOT to be a way to add this column to my current blog. So off to Google. I find a couple of different sites that explain the process but it could be written all in French as far as I am concerned – WAAY over my head here BUT when I am on one of these other blogs an advertisement on THEIR sidebar caught my attention ScriptLance.com - Here is information on how it works from their site…

ScriptLance connects your business with programmers and designers

If you require professional programming or website design for your business, whether its a long-term job or just a single project, you will find the help you need here at the prices you want to pay. No matter how big or small your budget is, freelancers from around the world will compete for your business at ScriptLance.

Step 1:Post a project (FREE).

Step 2: Receive bids by interested freelancers.

Step 3: Choose a bid.

That’s it! Your project is then closed, your are put in contact with the chosen freelancer who will begin working, you can leave a review, and pay them when you are ready to pay them. Our fee: only $5, which is deducted from your ScriptLance account only after your project closes. We even give you 30 days time to pay that fee! Why? Because we are confident you will be satisfied with the service ScriptLance provides.

So I figure – it’s free, why not. So I sign up and post a simple project in about 2 minutes – I leave the min and max bid amount blank, I have no clue? In less than 30 minutes I have 3 emails from programmers with additional questions and 7 bids ($10 – $100). I exchange a few emails, check the ratings of those that contacted me, pick my favorite and  and she is off and running. I sent in my project at 8:30pm and it is complete before I go to bed that night – EXACTLY what I wanted (after a few emails back and forth). I worked with Amy from Texas (quickcoder on Scriptlance) and her bid was $15! Are you kidding me! I paid her that plus another $15 as a bonus because she was FANTASTIC! As you can see I now have ads to the left right of this post – just what I wanted to have. I would recommend this website to everyone who has a project to be done, especially for those of you who are mostly “do-it-yourselfers” like me. And if you are a programmer or a website designer, this could be a great source for some additional income.

  • Share/Bookmark

In bookkeeping, Debit means left and Credit means right, not decrease and increase like most people think. In other words, debits are left-column entries and credits are right-column entries. A debit may increase one type of account and decrease another. So if your bookkeeper tells you they made a debit to your bank account and a credit to your loan they actually mean they increased the amount in your bank account but also increased the amount of the loan you owe. (and if your bookkeeper likes you, they would never say that to you – unless they want to mess with you a little bit)

Did your head explode yet Simone?

  • Share/Bookmark

Okay – THIS is about the coolest add-on I have come across – mainly because I am a huge craigslist fan. You need to be using Firefox (Mozilla) as your browser, (and why wouldn’t you be?), and you need to have Greasemonkey installed (and why wouldn’t you?). This add-on allows you to view the pictures in a craigslist ad without opening each ad – check out the link for more info.  Craigslist Image Preview

  • Share/Bookmark

Adjust several column widths at once by selecting multiple columns and double clicking on the separators, this will make the column (or row) fit to the width of the longest date in that column. You can do this with single columns as well.
Adjust column widths by selecting multiple columns and double clicking on the separators

Image courtsey of http://chandoo.org/

  • Share/Bookmark

For those of you who collect and pay sales and use tax in Minnesota you have probably already been made aware of the new .375% additional tax added to most items taxable in the state of MN that is now in effect (this new tax does excluded the purchase of vehicles which will remain at 6.5%). This makes the new MN general or “base rate” at 6.875%.  This new rate does not include any additional “special” tax rates or local sales tax rates. For further information visit the MN Department of Revenue’s Sales and Use Tax Website. The good news is that this tax will expire July 1, 2034. ;0)

  • Share/Bookmark

Ever find that pictures or fonts on a specific website are hard to read? Maybe the website is too wide and you can’t view all of the content without scrolling? Or maybe you just want to view the Internet game you are playing larger (Paul)?

Try this tip (does require a roller ball mouse).  Hold down the CTRL key on your keyboard while rolling the ball forward (to make larger) or backward (to make smaller) to adjust the screen magnification.

You can also accomplish the same thing by holding down the CRTL key and tapping the (+)  key to make it larger or the (-) key for smaller. This works in both Mozilla (Firefox) and Explorer. Make sure to adjust back to the “normal” view mode when you are done by holding the CRTL key and pressing the zero key  (or like me leave the font really really tiny to mess with people).

PS – this works in many other programs as well – including Excel and Word

  • Share/Bookmark

So for those of you who went kicking and screaming to Office 2007 and can’t seem to find ANYTHING you are looking for with the new “ribbon” menus (where the heck is the print?) this tip is for you. It is the “Scout” Search commands here is a blurb from the site…

“You know there’s a button for it, but you don’t know or remember where it is. If this ever happens to you, check out Search Commands. You can use this concept test today to quickly find the commands you need in Microsoft Office 2007 Word, Excel and PowerPoint. Just search with your own words and click on the command you need.”

Hopefully you will find this as useful as I did.

PS – add a quick print to your shortcuts like this (or anything else you want using the more commands selection from this same menu)

Quick Access

  • Share/Bookmark