It's your lucky day! I have two brand new digital photography tips for you today and I think you're really going to enjoy them. The two topics really have nothing to do with each other, but I figured they were both something you all might be interested in. Let's take a look!

Tip #1 – Photographing Your Pets

People love to take pictures of their pets, but this is how the photos usually turn out:

As you can see, that picture definitely requires a lot of help. Luckily, if you just follow the simple tips below, you can fix up your pet photos in no time at all!

Get Down and Dirty – You usually see your pet from above, but that's not the best angle for a portrait. Instead, flop down on the floor and meet them at eye level. Shooting from their height presents them as an equal in the photo, which will help bring out their personality.

Light it Right – Direct on-camera flash will give your pet a killer case of green, yellow or blue eyes. Try to avoid any direct flash if possible. If you can, bounce the flash off the ceiling or a wall. Or, you can just ditch the flash and use the light around you, both indoors and out.

Fill the Frame – I'm sure you've heard of this one before. It's important to fill your camera's frame with your subject in order to make the subject prominent in the photo. You can then crop out any distractions later on.

It's All in the Eyes – You might find yourself shooting with a shallow depth of field, so no matter what else you do, make sure your pet's eyes are in focus. The eyes are the window to the soul and they must be kept clear.

Ahh, that's a much better picture, don't you think?!

Tip #2 – Shooting Water

When drinking, some like their water icy, while others like it tepid. It's simply a matter of taste. In photography, moving water can be recorded with various appearances, depending on the shutter speed. Some like it frozen in an instant of time and some like it blurred with a long exposure. There's no right or wrong. How you like to photograph water is also just a matter of taste. Here are three other approaches you may like as well.

Glass Sculpture – Fast shutter speeds like 1/500" or 1/1000" will depict moving water as frozen solid. Splashes and droplets will hang suspended in online viagra australia the air.

Minor Blur – Intermediate shutter speeds like 1/15" or 1/30" give some motion blur to the water, but individual ripples and splashes are still discernible. You'll probably need a tripod or other camera support when using such slow shutter speeds.

Silky Smooth – Shutter speeds of 1/2" or longer will smear the water out to a smooth, cottony, smoky look. You'll definitely need a tripod to achieve this look when photographing water.

Now, go on and take some great shots of your pets and of water. Or, your pets in water. You decide. Have fun!

Do you work with MS Excel a lot? Do you use multiple sheets inside the same workbook?

If so, have you ever found yourself trying to reference a value from a worksheet other than the one you're currently working with?

I bet you noticed a problem when you tried the same old formula, am I right? For example, if you need online purchase viagra the value from cell B2 from sheet 1 in a formula on sheet 3 and used =B2 as your formula, you were in for a surprise. You got the value from cell B2, but unfortunately, it was from worksheet 3, not worksheet 1. What a nightmare!

Looking for the "magic" you must add to your formulas to get Excel to behave the way you'd like?

Was that a big yes I heard? I knew it!

Here's the trick: unless you tell Excel to look on a different worksheet, it's going to pull numbers from the sheet that contains the formula. So, you need to tell Excel exactly where to go (that is, tell it where to find your data). You'll need to add the sheet name to your formula so that Excel knows which sheet to look on for your value.

Continuing with the example from above, if you want to pull a value located in cell B2 on sheet 1, you would enter in this formula:

=Sheet1!B2

Yep, that's it! You simply have to add the sheet name (with the !) before the cell address and you've instantly got the value you really wanted.

Even more, the value will automatically update as you change the original data in cell B2 on worksheet 1. How great is that? Give it a try today!