Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.
Making delicious hand pulled noodles is no longer Asia's best kept secret! In this two part tutorial, learn exactly how to create those delicious noodles - fresh from your own kitchen! Enjoy these noodles in all of your favorite Asian inspired dishes. Delicious!
Watch this science video tutorial from Nurd Rage on how to lower electrical resistance with liquid nitrogen with Dr. Lithium.
If you're a little boy (or a little kid at heart), then Transformers are like the coolest thing ever. They're super hot cars, trucks or bikes that then transform into super hot robots with missles and impenetrable armor and all that jazz. Make your son's favorite transforming robots a reality by dressing him up as a Transformer this Halloween.
What better way to end a perfect day than by learning how to play one of your favorite songs? In this free video keyboard lesson, you'll learn how to play Lou Reed's "Perfect Day" on the piano. While this lesson is geared toward intermediate players, beginners are certain to take something away as well. Watch this tutorial to get started playing "Perfect Day" by Lou Reed!
Want to play Canned Heat's "On the Road Again" but your harmonica's in the wrong key? No problem: in this elaborate instructional video you'll learn how to tune your harmonica to the key of A by raising the pitch in draw hole 6. And remember: before attempting to adjust the tuning on your favorite harp, it might be wise to practice pitch adjustments on an old, used, broken or cheap harmonica.
The hot dogs are all eaten and the fire is still crackling; it's the perfect time to make some delicious s'mores. You will need marshmallows, chocolate bars, graham crackers, a wooden stick or metal roasting fork, and a campfire. S'mores are a camping and outdoor food favorite, but can be made at home with a microwave. Watch this video cooking tutorial and learn how to make s'mores.
This is my favorite video of all time. Watch this fantastic gentleman teach you how to spin a plate in a whisking motion. Be sure to stay for the out takes. Cracks me up.
This video includes a disassembly slideshow for the Microsoft XBox. Intended to be instructional in nature, the disassembly guides at http://www.takeitapart.net help users to better understand and maintain their favorite gadgets.
Bring your favorite software, files, and settings with you on a USB drive
To pick up some sexy belly dance skills, check out this how-to video. A belly dancing pro gives some basic steps in this alluring dance. This teacher pretty much sums up why this is a dance favorite for many. Watch this video tutorial as she shows you how to move your hips then watch the rest of the links below the video for complete moves and history.
Learn how to make the party favorite, guacamole. Sarah McColl takes you though the necessary steps to make the perfect party staple. Guacamole is a Mexican dish.
In this video from AppleGenius0921 we learn how to export videos using Screenflow in HD. Launch Screenflow, make sure you're editing is complete and go to File, then Export. A window will come up asking the name you want to save it as and where you want to save it. Make a good title that is relevant to your video. Now click customize. Then click settings. Now go to compression type and double click H.264. Set the quality on Best. Click OK and use no filter. Now go to size and click 1280x720 H...
In this how-to video from the TyingItAllTogether Channel, learn how to tie Clifford W. Ashley's flower knot. Ashley is the author and illustrator of a book he wrote about tying various types knots, including ones that he created himself. In his book, Ashley shows how to tie this knot, but does not show in his illustrations how to actually hold and tie the knot in one's hand. This video tutorial seeks to clarify those steps. You will need to begin with a piece of rope folding it in half to eff...
First you need to download Aircrack-ng and Second thing you need to download is CommView for Wi-Fi. Now you have to install CommView for Wi-Fi and then install the right driver.
In this tutorial, we learn how to hem your favorite jeans with Laura. First, place your jeans on your body, then cuff them where you want to hem them. Next, take your jeans off and pin the cuffs where you wan to hem them to keep them in place. Next, measure out the length of the hem and mark it with a piece of chalk, then you can take out the pins. Next, you will cut the pants, then pin them back where you want to hem them at. After this, you will take them to the sewing machine. After this, ...
In this tutorial, we learn how to do hair and makeup for going out. Begin by applying your favorite foundation, along with bronzer and blush. Next, apply eyeliner to both the top and bottom lashes. After this, brush on a layer of dark eyeshadow onto your eyelid, going up to the crease. Next, use a white eyeshadow to brush on the inside crease of the eyelid. When finished with this, use a black eyeshadow on the outer edge of the eye, then blend all the colors together. To finish the makeup, ap...
There's nothing worse than pulling out a pair of your favorite pair of pants and finding a big hole in one of your favorite pair of underwear. You find a couple of nails in the dryer from when you last worked on a house project.
Photoshop is a useful software program that allows its users to make any photo look better or different using a couple of easy techniques. You can turn one of your favorite photos into a comic book, add some clouds in a cloud free sky, and even show you and your favorite celebrity sitting next to each other side by side. In this video you'll be taught the steps of making stencils using the tracing method and brush tool in Adobe Photoshop, version CS3. Enjoy!
In this video, we learn how to cover up dark circles and blemishes using foundation. Start off by applying an eye cream underneath your eyes, which will make a base and remove puffy-ness. Next, you will need to apply your favorite concealer in your color over where you applied your eye cream. Go ahead and apply this foundation wherever you have blemishes, using a makeup tool. Now grab your favorite foundation and brush, and brush the foundation on your face making an even coat to cover and re...
Did you know that your Nintendo Wii can go online? If you haven't been using the Internet with your Wii, you are missing out on some of the system's coolest features. With an Internet connection, your console can surf the web, watch movies from places like Netflix, or connect with other players to compete online. In this tutorial, learn exactly how to connect your Nintendo Wii to the Internet and start using your system the way it was meant to be used.
In this video we learn how to crack WPA using Back Track. The first step is the boot into Back Track using a VMware Virtual Machine Image. Next you need to open a shell console. In the console you will type "airmon-ng" and press enter. This does a check to find the wireless guard interface name. Next, type "airodump-ng wlan0" and press enter. This will tell it what wireless card to use and scan for wireless networks. You are looking for the one that comes up WPA. Copy the MAC address then typ...
Marie Dubuque offers tips on keeping a conversation flowing and avoiding awkward silences. She suggests asking the other person about themselves. Everyone loves to talk about themselves, and sometimes if you ask one question they go on and on. Ask about their favorite food, favorite restaurant, how they get along with relatives. Questions about in-laws can lead to some interesting dialog and can get the conversation going better than it was before.
This video clip from The Crafts Channel shows how to make a bead cage. A bead cage is where a piece of wire is wrapped decoratively around a large bead. For the example bead cage .8 mm wire was used. If the wire is too thin it will not hold its shape, but if it is too thick it will be hard to bend into the desired shape. Take some needle nosed pliers and make a complete circle, and then use some flat nosed pliers to begin forming a spiral going outwards. Now do the same thing beginning at the...
In this tutorial, we learn how to make crock pot chicken fajitas. First, you will need 1 1/4 pounds of chicken, 2 onions, 3 cups salsa, crock pot, 1 large red pepper, 1 package of tortillas and your favorite condiments. First, chop up the onions and pepper into thin slices. After this, trim the chicken and cut it into thin slices. Now, you will take the veggies, chicken and salsa and place into a crock pot for 6 hours at low heat. Make sure you stir well to cover all of the veggies and chicke...
This video tutorial from noxad presents how to backup and burn games for Nintendo Wii game console.To setup game transfer from computer to your console you'll need any type of SD memory card. In this tutorial it's Lexor 1 GB SD card.Insert SD card into your computer card reader. Autoplay window will open, asking what action you want to perform. Select Open folder to view files.You can open SD card manually from My Computer window. (Start button-Computer).Make sure your SD card has folder name...
Basically, a "Kook" is the type of surfer everyone hates. Kooks put themselves and others in danger by their actions in the water. In this video, learn the rules of the ocean and avoid everyone staying far away from you at the beach.
In this demonstration, we learn how to make a phone call on the iPhone. 1. Tap the phone icon. 2. Tap the keypad icon. 3. Tap the number you wish to dial. 4. Tap "Call. "5. To end the call, tap "End Call. "6. If you wish to call one of your contacts, tap the "Contacts" icon, tap the contact and the number you wish to dial. 7. To call one of your favorites, tap the "Favorites" icon, and tap the contact you wish to dial.
Deke McClelland explains what the Levels and Histogram commands can do in Photoshop in this video tutorial. Levels allows you to adjust the luminance levels allowing you to adjust the contrast and colors within each color channel of an image. Thus, Levels allows you to adjust the individual colors that can be found within a gradient. This command is very similar to the curves command but to a less powerful extent. It is also more efficient than the curves command. The Histogram is another col...
This video shows you how to make a custom Facebook Fan Page for your favorite Celebrity, Club, activity or anything you choose! First thing you must do is activate a Facebook account. Its really simple, just go to www.facebook.com and create a profile. After that type in FBML in your search bar and click on Static FBML. That application will enable you to create many different settings for your Fan page including ads and different looks and security measures for your profile. Now get to creat...
This video shows us how to make a healthy artichoke guacamole. Prepare 6 cooked large fresh artichoke. Remove the hearts and bottoms from the artichoke and place in a medium-sized bowl. Mash it with a fork or simply use a food processor. Add the juice of a lime or a lemon, 4 tbsp of reduced-fat mayonnaise and 1/2 cup of fat-free sour cream. Put garlic, salt and pepper to taste and 1/2 cup of your favorite salsa. Blend all the ingredients. Finally, serve together with the artichoke leaves or y...
Here's how to copy Joker's look of the Dark Knight. 1. To create the scars, start by applying a spirit gum on each side of your face. Wait till it dries up. Then apply a scar wax using a small spatula or any type of applicator that is available. 2. To achieve that clown white face, get a pancake makeup, cream or anything (as long as it's white) and start applying it all over your face. Be careful when you reach your scars so as not to damage them. 3. Fill-in your eyes with really dark eye mak...
First you take a glass, then put 3 ounces of your favorite gin into it. Then, choose 2 of your favorite tea bags (and tea leaves if you want) drop it in the gin. Let this fuse together for 2 to 2 1/2 hours. Gin will turn a dark gray color when done fusing together. Grab a lemon wedge with a slit in it and rim the edge of a martini glass, the dip the martini glass into the granulated sugar to make a fine rim of sugar. Then take 1 1/2 ounces of Tea Infused Gin, 1 1/2 ounce of lemon juice and 1o...
In this Photoshop tutorial the instructor shows how to do retouching to produce undead skin makeup. This video shows how to make a convincing, undead like, vampire skin make up. First open a image of the face which you want to make it look like undead face. Go to the channels panel and make a selection of just the face with the skin and exclude the rest of the head which includes the hair and other stuff. Now open a new adjustment layer and open the color balance tool. Fist select the mid ton...
Chances are that there are videos on YouTube that you wish you could download to your Mac or PC in order to transfer them to your iPod or other media player so you can watch them on-the-go. Whether it be your favorite music video or the new and hilarious comedy skit from your favorite comedians, this video will show you exactly how to do that, simply and safely in just a few steps. The video is only a minute and thirty seconds long, which is nothing compared to how many minutes you could be a...
Tank tops are relatively cheap, and cutesy bags can be expensive from designer shops and street vendors, so your only solution for saving money is… using your tanks for homemade bags. See how to transform a tank top into a magazine bag in this video from GiannyL.
A riptide can be terrifying. But if you keep your cool and know what to do, you'll stay safe. You Will Need
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to install the MediaInfo GUI on Ubuntu Linux.
In just a few simple steps, you'll have your piano keys sparkling like new. You Will Need
Herbs are an incredible addition to your garden. This week, Meg talks about some of her favorite herbs and shows us how-to make a new moon herb tincture! Follow along with the advice in this video gardening lesson and start incorporating fresh herbs into your cooking!
