Digital Life Search Results

How To: Use Camera Raw in Photoshop

In this video, we learn how to use Camera Raw in Photoshop. This is a great program to use with your SLR digital camera that will make your photos come through more clear than ever before. After you have downloaded this application, you will load your photos to it and open up your desired on to edit. On the right hand side you will see a toolbar allowing you to edit and change different effects on the photo. Move the bars from left to right to edit how the photo looks to your liking. On the t...

How To: Prepare a wall for drilling

In this video we learn how to prepare a wall for drilling. First, check for pipes and cables in the wall using a digital detector. After this, it's a good idea to tape some masking tape with an envelope on the wall to catch and dust and debris that falls off while you are drilling. When you're finished drilling the hole, remove the envelope from the section you are on and continue on to the next part of the wall. It's just that easy to drill a hole in the wall once you know you won't be hitti...

How To: Build a DIY bicycle basket

Moving cargo on bikes is not commonly done in America, but in the rest of the world people carry their whole lives on their bikes with ingenious storage methods. If your bike doesn't even have a basket, watch this video to learn how to make one yourself and make your bike much more practical.

How To: Calculate hours worked in a shift with a lunchbreak in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.

How To: Boil vigor into your bass guitar strings for a "brand new" tone

This is an old school trick to revitalizing your bass playing skills— on the cheap. If you're in desperate need of some new bass guitar strings, but can't afford the cost, then there's a solution to bringing new life into them for that "brand new" tone— boil them. Boiling bass guitar strings is a great trick to restoring your sounds, but you can only do this a couple times or it will stretch them out too much and break.

How To: Ride a bike with no handlebars

Being able to rid a bike without holding on to the handlebars allows you to do all sorts of useful things while on your bike and makes your look like a pro. Watch this video to learn how to do it easily and open up your biking life.

How To: Make an awesome zombie cocktail

Feeling like a zombie? Like rum? Really like rum? Here's a drink that's gonna put life right back into you, grow hair on your chest and make the hairs stand up on the back of your head. This drink uses three different types of rum (dark, light and 151-proof, WHEW). In this video you will learn how to mix the cocktail correctly.

How To: Do a calming yoga flow to increase leg flexibility

There are a plethora of reasons why you should practice yoga, from easier breathing to increased flexibility to clearing your mind. But there's another super important reason you should take up the art of the pretzel-limbed: It helps build strength all throughout your body, which means you'll be less likely to pull a muscle or throw out your back in real life.

How To: Light digital home videos like a professional

Shooting home video is fun, and is a great way to get started on the path to a film career. But one thing that can kill your video is poor lighting. Not everyone is rich enough to a professional light kit, so what do you do to compensate? In this video you will get some great low budget, and even some free, tips on how to create proper lighting both in-doors and outdoors and tips on what to avoid in your scenes.

How To: Build a DIY outdoor movie theater

Watching movies outdoors is gaining popularity again. If you want to really impress your movie-loving friends at your next party, blow them away by making a backyard outdoor theater at your home. It works great and won't take your whole life to build.

How To: Use makeup to hide pimples perfectly

Pimples are the bane of many teenagers social lives, and covering them up is big business, especially for girl for whom the tools to cover zits are more readily available. This video will show you how to use exfoliator and concealer to hide zits completely.

How To: Open a stuck jar lid

Everyone has been daunted by a stuck jar lid at least once if their lives. If you're sure that you aren't dealing with a crossed thread and need a little extra grips to get that jar lid open, this video will show you how a rubber band can help you out.

How To: Put together a Zen garden

Zen gardens and gardening are serene places and activities. If you want to make your own Zen garden and add some harmony to your life, watch this video to learn some general guidelines for going about it. These tips are for full-size Zen gardens, not the desktop models.

How To: Normalize a data set into another scale

Comparing evaluations of the same thing done on different scales can seem difficult, but there is a simple equation you can use to translate something expressed in one numerical scale into another. This video will show you how to use it and make your math life easier.

How To: Calculate weekly gross pay from time values in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Avoid double-counting duplicates within a list in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.

How To: Fix a jam in your printer

When your printer jams, it can destroy your productivity and even your professional life! If you want to be able to fix the problem quickly, watch this video. It will give you ideas for steps to take to repair the problem and get your document.

How To: Compare a list of numbers where one group is entered as text in Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.

How To: Rotate and crop a digital photo in Adobe Photoshop CS5

Need some help figuring out how to rotate and crop images in Adobe Photoshop CS5? It's easy. And this clip will show you precisely how it's done. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.

How To: Create a data validation drop-down list from a table with duplicates in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.

How To: Fix a transmission leak at the speedometer drive gear on an LLV postal truck

A common problem for an LLV postal truck is a transmission fluid leak at the speedometer drive gear on the side of the transmission. This video will show you how to repair this transmission leak at the seal. LLV stands for the Grumman Long Life Vehicle, which the United States Postal Service (USPS) for all mail delivery. More than likely, it's an O-ring problem (speedo seal) where the speedometer cable attaches.

How To: Troubleshoot the dashboard gauges on an LLV postal truck

The United States Postal Service (USPS) use what's called a Grumman Long Life Vehicle, or LLV, for their postal trucks. This video will show you how to troubleshoot the dash gauges in an LLV that are acting crazy. If you;re a mechanic and you have the same sort of electrical problem with the gauges when using turn signals or hazards, this video will help you find the solution, which could involve the parking brake.