Records Forwarded Search Results

How To: Get fitted for a tuxedo

Have a formal event on the horizon? Want to put your best fashion foot forward? Looking your best at a prom, wedding or black tie event means wearing a properly tailored tuxedo. Take the proper measurements to ensure perfectly fitted menswear.

How To: Make picture frames for vinyl record covers

This video tutorial is in the Home & Garden category where you will learn how to make picture frames for vinyl record covers. These frames do not use nails or clips to hold the covers. The covers slide in and out of the frames so that they can be changed easily. For this you will need 4 pieces of wood 3/4" thick, ¼" wide and 14" long. First you sand all the pieces. Then you set up your router and the rabbeting bit to cut out the four wooden pieces. Now you need to make indentations on the to...

How To: Mute the vuvuzela sounds from an audio recording

If you are watching the World Cup live and the vuvuzelas are driving you slowly (or quickly) insane, this video isn't going to help, sorry. However, if you are recording the World Cup or working with someone else's recordings of it, it is possible to almost completely eliminate the sound of the vuvuzelas while mixing in Garageband or another audio editing program. This video will show you how to create the proper parametric EQ's and mute the vuvuzelas while preserving the rest of the audio tr...

How To: Highlight rows that contain unique values in MS 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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...

How To: Use VLOOKUP to verify a record is in an Excel table

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 558th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See also how to add a concatenated column and concatenate lookup_value in VLOOKUP function.

How To: Extract part of a table from a larger table in Excel

New to 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 Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Create a Gwen Stefani inspired look

In this video you'll learn everything you need to know and have to create your Gwen Stefani inspired look. A fashion forward super cool, unique look to rock a night on the town or your next performance. Get ready to go from lame to punk with this video.

How To: Batch automate in Photoshop

This how-to video produced by Photoshop Universe gives step-by-step instructions on how to batch automate a process in Adobe Photoshop. With this tutorial you'll be able to learn to correct white balance, enhance colors, resize, and save for the web whole folders' worth of images in one go. The first step to doing this is to open up one of the images in your folder and correct the white balance, enhance the colors, resize the photo and save. The next thing you want to do is to record all of t...

How To: Turn your doorbell into a guard dog alarm

This video shows you how to make a security device out of a door bell. The concept is that most thefts happen when people are away from home. To make sure of this the thief rings the door bell to make sure that nobody is home, if nobody answers then they will break in. A lot of people have dogs and alarm systems which will scare off the thieves, but this alarm system combines both. To make this devise you have to buy a speaker system that connects to your door bell. When the door bell rings i...

How To: Play basketball with help from Kobe Bryant

L.A. Lakers superstar Kobe Bryant shares some tips with TIME Magazine's Sean Gregory on how he puts his best foot forward everytime he steps onto the court. Areas gone over in this video include: The proper grip & shooting form, attack the foot & sell the fake, the pull-up jumpshot, the art of the foul shot, playing to the opponent's weaknesses, getting in character, and stretching.

How To: Do a front flip

In this video, one of the gentlemen from the London stunt team 3Run shows us how to do a front flip. This is a very impressive trick that sends the performer spinning forward over the ground. Common sense would lead you to think that this trick requires a lot of strong, fast movements, but as the performer demonstrates, it's all about a light, delicate touch.

How To: Upload HD videos using Camtasia Studio (WMV)

In this video the instructor shows how to upload High Definition HD videos using Camtasia Studio. Here the instructor shows how to upload the videos that you recorded using Camtasia in HD to YouTube. Now to generate a HD video you will need to record in high resolution like 1280 by 800 pixels. Now record the video at full screen. Now after recording you will have your HD video. Open the video in Camtasia and add the clip to the time line by right clicking it and selecting the option from it. ...

How To: Stretch hamstrings, quads and feet with a yoga pose

In order to stretch your quads and feet through yoga poses, begin by sitting on the floor with your right leg in front of you. Your left leg should be folded back behind you. Your foot should be just outside your hip. Your foot should be pointed behind you. You can use props to help you. Pillows or folded blankets can help. Lean forward over your forward leg. If you have difficulty reaching your foot, you can use a stretch to help you. Remember to exhale, as you lean into a stretch and inhale...

How To: Reject or jerk dance

If you want to learn how to Jerk or Reject dance first you have to skip backwards with your feet! Your first move will be to start off by jumping forward with your right foot and then come back with your right foot in the air. Next jump forward with your left leg and bend up your right leg. Then put your right leg down and your left leg up. Now repeat this same step over but with your other side. This is the simple easy jerk! Another way is to put your right leg up bent to the side and bring ...

How To: Fold a frog using origami

Kevin demonstrates how to make a paper frog. Take a regular sheet of construction paper. Fold the outer ends towards the center forming a triangle. Fold a crease at the base of the triangle and cut it out. Open the folds and you can observe two creases. Create two X-shaped creases by bending the opposite corners. Hold the triangles on the side of the X and squash it down such that the other two triangles meet. Repeat the process on the other side. This forms a square with a diagonal cut conta...

How To: Install memory in a 2009 Mac Pro

MacOSG demonstrates how to install memory in a 2009 Mac Pro. When performing this upgrade, be sure to take precautions for static by discharging static electricity before beginning. Shut down, unplug and place the Mac Pro on a static-free surface. To access the memory, you need to open the side access door by lifting the latch located on the rear of the Mac until it locks in the open position. You can then the door forward and then remove from the body. The memory is attached to the processor...

How To: Do squats for dummies

Squats strengthen your butt muscles, hamstrings and quadriceps. First, pick up your dumbbells. Bring the dumbbells by your hips, thighs or let them hang by your side. Next, stand with your feet shoulder width apart, toes pointing forward and stand straight and tall. Sit down like you're sitting on a chair. Don't let your knees pop out in front of you. Go down slowly and don't let your knees lock on the way back up. Don't shift your body weight forward. Instead, push through your heels. You ca...

How To: Do a super lunge workout for super legs

Yuri Elkaim, virtual fitness coach, demonstrates how to do a super lunge workout for super legs. First, grab a weight and focus on technique. Then, set yourself up in a lunge position. Your forward leg's knee should not go past the toe. Your back leg should be at a right angle at the knee. Your torso should be perpendicular with the floor. Next, lower your torso on an incline by keeping your torso straight. Then grab the weight of the arm that is opposite of the leg that's forward and pull yo...

How To: Do a half side split

Paul Zaichik of Elastic Steel explains how to do a half side split. The half side split is a very basic technique. First, kneel on the floor and lean forward. Then extend one leg so that it is perpendicular with your torso and so that both your body and foot are at 45 degree angles. The other leg will remain bent. You can also lean forward so that both your body and foot are leaning against the floor. Bend the leg to match the other leg and rest in that position before extending the other leg...