Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...
3D seems to be all the rage right now. You don't want a logo that is behind the times! In this tutorial, learn how to make text look 3D using Adobe Photoshop CS3 or CS4. Your graphics will look much more up to date and really pop out of the page with this cool technique.
In this tutorial, learn some easy leg exercises that you can do at home or the gym. These exercises don't require much space or any equipment and you can learn them pretty quickly.
Need to replace a button on a shirt? How about sewing something new with buttons? Learning to sew is a great way to get creative and to customize clothes you love by either tailoring them to fit your body better or embellishing designs by adding extra buttons or fabric. In this tutorial, learn how to hand sew a button onto a garment.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
In this tutorial, learn how to bypass Nintendo's copyright protection and burn Wii games to share with your friends. This video will show you exactly what you need to know to outsmart the system and copy your games to another disc.
Anime is a very cool, fun form of animation. In this tutorial, learn how to draw one of the genre's most famous characters. This video will take you step by step through the process of drawing Goku, a character from DragonBall Z. This very cool Manga character is not too difficult to draw once you get the hang of it. Japanimation takes a bit of practice, because it is a much different style from more Western cartoons, but is not difficult to master.
In this video tutorial, viewers learn how to make a ribbon covered pinch clip. The materials required for this hair clip are 4 1/2" x 3/8" of ribbon, glue gun and an alligator clip. Open the pinch clip and place the ribbon inside it. Align it to the clip so that it is straight. Then apply some hot glue onto the surface of the pinch clip and then fold the ribbon to glue it. Alight the ribbon to the top of the clip and flatten the ribbon. Now apply some more glue on the ribbon and push it into ...
Smoked pork ribs are a wonderful treat when prepared correctly. In this video, learn how to smoke spare ribs and baby backs, as well as how to prepare, remove the membrane, apply a mustard/rub slather and then smoke them to delectable goodness. Learn how to prepare a delicious main course with help from this video.
In this video tutorial, viewers learn how to cook cook kale, collard, mustard or turnip greens. The ingredients required are: frozen greens, chopped onion, chopped carrot, chopped celery, 2 cloves of garlic and 1 1/2 cups of chicken stock. Begin by putting the frozen greens into a pan and then add all the ingredients into the pan. To add flavor, add in 1/2 tsp of salt, 1/4 tsp of pepper, 1/4 tsp of freshly grounded nutmeg and 1/2 tsp of grounded mustard. Then cook it at low heat for 3 hours. ...
Tuning is an essential part of the upkeep for your ukulele. In this tutorial, learn how to easily tune your instrument and preserve that cool, island sound.
In this video tutorial, viewers learn how to convert You Tube videos to MP3. Begin by going to the You Tube website and find the video that you want to take the audio from. Once you have found your video, copy the URL of the video. Then go to this website: and paste the You Tube URL. Change the Convert to format to MP3 and click Start. Now wait for the website to finish loading the MP3 and provide you with a download link. This video will benefit those viewers who enjoy lis...
Deleting your Internet history once in a while is important. Not only will doing so protect your privacy, but it will also clear up much needed space on your harddrive and help your PC run quicker.
If you find yourself stranded somewhere, or hungry in the wild, you will definitely need this tutorial.
In this tutorial, learn how to make delicious homemade sauerkraut. Sauerkraut is a tasty tradition, and no summer picnic is complete without this classic topping.
In this video tutorial, viewers learn how to create a .torrent file using u-Torrent. Begin by opening the program. Click on File and select Create New Torrent. Now select the file, select the directory and type in the tracker code. Then click on Create and save as. Once the file is created, click on File and select Add Torrent. Locate the .torrent file click OK. Now wait for the torrent file to finish downloading. This video will benefit those viewers who use u-Torrent and would like to learn...
In this video tutorial, viewers learn how to pan for gold. Users will need a gold pan. Begin by add some dirt and rocks into the pan. Then pan has ridges that will keep the gold in the pan. Dip the pan and fill it in some water. Now gently shake the pan from side to side for 20-30 seconds. The gold will sink to the bottom as you shake. Then slightly tilt the pan forward to pour out some water as you're shake the pan. This video will benefit those viewers who are interested in searching for mi...
In this video tutorial, viewers learn how to use the Sticky Keys feature in a Mac OS X computer. The Sticky Keys feature is found in the Keyboard tab in the Universal Access menu. To turn on the sticky keys, check the On option. Underneath, users are able to set some options for how the modifier keys are treated. Sticky Keys will allow users to press the keys in a sequence, instead of all at once. This video will benefit those viewers who use a Mac computer and would like to learn how to conf...
In this video tutorial, viewers learn how to make a shimmer mist mixture for cards. Begin by filling a small spray bottle with rubbing alcohol. Now add about 1/2 tsp-tbsp of Champagne Mist shimmer paint into the spray bottle and shake it to mix it. Users can also use frost white or platinum shimmer paint. To apply the shimmer mixture on a card, spray the mist in the air and wave the card stock into the mist. The alcohol will help dry the paint faster. This video will benefit those viewers who...
In this video tutorial, viewers learn how to write their own business plan. This video provides several options for viewers to decide from to write a business plan. Users may choose to purchase a business plan software for $50-$65, take a business plan course for $75-$500 or hire a consultant for $1000,-$5000. Business course plans are usually located at college campuses. It is not recommended to hire a consultant as it is very expensive and you will ne the one giving the consultant the infor...
In this video tutorial, viewers learn how to flash the screen when receiving an alert in a Mac OS X computer. To turn on this option, go to the Universal Access window and select the Hearing tab. There will be 2 options for users to use. The first feature allows the user to flash the screen when an alert sound has occurred and the second feature allows users to stereo audio as mono. To test the flash the screen, click on Flash Screen. This video will benefit those viewer who use a Mac compute...
In this video tutorial, viewers learn how to properly hold a guitar pick. Don't hold the pick with the point facing down because it can easily slip and cause you to lose accuracy. Instead, hold the pick with the point facing forward. Don't let the pick stick out too much. Secure it behind the index finger and under the thumb. This video provides a visual demonstration for viewers to easily follow along. This video will benefit those viewers who are beginning to play the guitar and would like ...
In this video tutorial, viewers learn how to make decorative wreaths from garden plants. Users will need a wreath thorn. Users may choose to make the wreath or purchase it. Then add on some greenery such as bay leaf. Now place the greenery onto the thorn wreath and secure it by wrapping it 3 times around with wire. Continue doing this for the rest of the wreath. This video provides a visual demonstration for viewers to easily follow along. This video will benefit those viewers who are interes...
In this video tutorial, viewers learn how to apply a digital tattoo using Adobe Photoshop. Begin by adding the image and tattoo image into the program. Then drag the tattoo image over the image. Now in the layer menu, change Normal to Modify. Now re-size the tattoo image to a preferred size (PC: Control and T, Mac: Command and T). Now right-click the tattoo image and select warp. Form the image so that it is perpendicular to the skin and decrease the Opacity. This video will benefit those vie...
In this video tutorial, viewers learn how to set a beautiful dinner table. The utensils, flatware and glassware is paramount is correct setting. The utensils are arranged in the order that a person uses them. The butter knife, forks, napkin and bread plate are placed on the left of the dinner plate. The knives, spoons and drink-ware are placed on the right of the dinner plate. Utensils and flatware are lined up about 1" from the table. There should never be more than 3 utensils on the side of...
In this video tutorial, viewers learn how to create a red carpet look with the undone bun hairstyle. Begin by bringing all your hair to one side and apply a band around the bun to secure it. Then take a clip and randomly pin it to the ends of the ponytail. Continue doing this for the rest of the ends of hair in the bun. Users may use up to 30 pins. Make sure the pins don't move and don't overdo the pins. This video will benefit those viewers who are interested in beauty and fashion, and would...
In this video tutorial, viewers learn how to import and render footage in Adobe Final Cut Pro. To import files, begin by going to File, select Import and click on Files. Then browse for the file and click Open. Now drag the clips into the time line to edit. To render the footage, begin by selecting it. Then click on Sequence, select Render Selection and click on Both. This video also shows viewers how to cut a clip and add effects. This video will benefit those viewers who are just beginning ...
In this video tutorial, viewers learn how to use the Mouse Keys feature in a Mac OS X computer. This feature can be accessed under the Mouse & Track-pad tab, in the Universal Access menu. Turn on the feature by checking On. Once turned on, users can use the number keys on the keyboard to move the cursor in any direction. Users are also able to use a keyboard shortcut to turn on or off the Mouse Keys, adjust the Initial Delay, adjust the Maximum Speed and change Cursor Size. This video will be...
In this video tutorial, viewers learn how to make a real flame text in Adobe Photoshop. Begin by opening a flame image in the program and select the text tool. Type in the text and position it over the flame. Now go to Select and click on Load Selection. Once the selection is created, delete the letter. Then select the marquee tool. Right-click above the selection and select Feather. Now create a new sheet and fill it in black. Using the move tool, drag the selection to the new sheet. Go to F...
In this video tutorial, viewers learn how to create a 3D sphere and reflection in Adobe Illustrator. Begin by using the ellipse tool and create a circle. Select the black and white gradient, and drag the colors that you want into the gradient panel. Now hold the Alt key and draw a smaller circle inside. Fill it with white/transparent gradient. Select the sphere and go to Object/Group. Now go to Effect/Distort and Transform/Transform. Tick the Preview and Reflect Y, insert 1 copies box and sel...
In this video tutorial, viewers learn how to make a toy parachute. The materials required are: lightweight fabric, ruler, scissors, string, 4 hole button and a toy army man. Begin by measuring a 10x10 inch square on the fabric and cut it out. Fold over each of the 4 corners and cue a small hole. Measure and cut 2 lengths of 36 inch string. Take the string and tie it to one end of the hole on the fabric. Run the other end through the button hole and tie it to the diagonally opposite hole on th...
In this video tutorial, viewers learn how to disable pop-ups in Google Chrome. This task is very fast, simple and easy to do. On your desktop, begin by right-clicking the Google Chrome icon and select Properties. Click on the Shortcut tab and in Target, add "-disable-popup-blocking" to the end of the code. Now click Apply and click OK. Then restart Google Chrome. This video will benefit those viewers who use the Google Chrome web browser and would like to learn how to disable the pop-up block...
In this video tutorial, viewers learn how to ice cupcakes. In order to ice a cupcakes, users will need a piping bag, tips, coupler and a spatula. Screw the coupler at the end of the piping bag and select a tip to put on the end of the coupler. Fold the bag 2-3 inches downward and place it into a cup to hold it. Now scoop some icing with the spatula and place it inside the bag. Squeeze the bag to bring the icing down and tie an elastic on top to close it. Viewers will learn how to 3 different ...
How classic is "Smoke on the Water" by Deep Purple, right? It's one of the greatest classics of all time! And now, you can learn how to play this hit on your acoustic guitar by yourself. Impress anyone who's listening with this rockin' tune. This tutorial will show you exactly how to play "Smoke on the Water" with your guitar, from finger placement to the proper chords.
There are many ways to play acoustic guitar. Often, you will need to learn different styles to enhance your songs. In this tutorial, learn step by step how to apply muted percussive techniques to acoustic guitar playing and get a new sound.
Jack Johnson is a great musician. His music is catchy and heartfelt and it seems like everybody is a fan. In this tutorial, learn how to play your acoustic guitar in the style of Jack Johnson and impress your friends.
Have you decided to learn how to draw? Are you looking for a cute new character to doodle during math class? Well, you have clicked on the right video!
In this video tutorial, viewers learn how to create a photo-montage using Adobe Photoshop. Begin by inserting the images into the program. Then double-click on the montage image to unlock it and select the eraser tool to remove the background. Once the background is removed, select the move tool and move the montage image to the background. To modify the dimensions, go to Edit and select Free Transformation. Hold the Shift key to maintain the proportions. This video will benefit those viewers...
In this video tutorial, viewers learn how to add custom music in the game, WWE Smack Down vs. Raw 2009. Users will need a blank recordable CD and cannot use MP3s or any other audio format. Begin by recording all the music files into the CD and the insert it into the Xbox360. In the Xbox360 dashboard, go to My Xbox and select Play CD. Click on Rip CD and name the information of the CD. Now select the song that you want and add in into a play-list. Now to select the song in the game, select use...
In this video tutorial, viewers learn how to use the full screen view in Apple's Pages. To enter the full screen view, click on the the Full Screen button on the toolbar or click on View and select Enter Full Screen. Users will only be able to see the document on the screen without the tool bars and desktop. If you hover your cursor over to the left side of the screen, you will be able to see the total number of pages in the document. This video will benefit those viewers who use a Mac comput...
