This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
TutCast shows viewers how to create the blood spatter from Watchmen in Photoshop! First go to TutCast.com/watchmen and download the given file that will provide you with the layers needed for this project. First, click layer and click bevel and emboss. First, start with Inner Bevel, Keep it smooth and leave depth at 100. Direction is up and change the size to 8 and soften to 10. Now, set the angle to -70 and altitude to 30. Now, the gloss contour you should pick the fourth option and the high...
There is now a way to watch and stream Netflix movies to your PlayStation 3 (PS3). Netflix will give you a free disk to do this and you are able to choose from thousands of titles to watch instantly as long as you maintain a minimum $8.99/month Netflix membership. Once you receive your disk, insert it into the PS3 and enter your provided code to integrate your particular PS3 with your online account. This brings up your instant watch queue and allows you to browse the Netflix inventory of new...
In this video, Steven Raichen demonstrates how to make a quick and delicious meal of Argentine "gaucho grilled" filet mignon with grilled eggplant and peppers. In his travels around the world, Raichen became fascinated with the rich, slightly smoky flavor of steak cooked in the traditonal Argentine method, and decided to find a way to replicate that flavor quickly and easily. To do this , Raichen uses a traditional wood-burning grill from Grillworks (to purchase, contact Grillworks at 202-758...
This is a handy tutorial about creating the favicon. A favicon is an icon which appears on the tab, in the address bar and in the favorite menu of browsers. To make a favicon:
Making a Elephant Toothpaste Volcano!
Macheads demonstrates how to install wine on mac. What is wine? Wine allows you to run and install windows program on Intel based machine. This program will work only on Intel and wont work on power PCs,unfortunately. First, we have to install macports which is something similar to installing unix programs on mac. The following are a bunch of requirements in order to install wine - an intel mac, admin account, X code installed, X11 (which comes mostly with intel macs). First of all we have to...
Diva Dan provides you with a simple tutorial on how to roast pig tails. Remember, because the meat of the pig tail can turn very tough, you must cook them slowly. Begin by making the sauce you will let the pig tails simmer in for about two hours. In a bowl, mix in corn syrup (at least 3/4 cup to a cup), catchup (1/4 to 1/3 of a cup), Worchestershire sauce (1/4 to 1/3 of a cup), 2 teaspoons ginger, and 1 tablespoon dry mustard. To make it hot, you can add a little hot sauce. For extra flavor, ...
In order to create a custom caption box in WordPress you'll need to go to your dashboard. Here click on appearances, then on editor. Now over on the right select the sidebar option. Here you'll see some code, what you need to do is find the word that you want to replace on the main page, you can use ctrl+F to find the word. When you've found it within the code just replace it with whatever you want and then press the 'apply' button. You'll see that the main page will now be displaying the wor...
Curtis Smith, Extension Horticulturist, and Jeff Hart of the Albuquerque Parks Department discuss the types of trees that grow in Albuquerque.
This video provides tips on how to determine whether your Coach purse (or bag) is a fake. In order to spot a fake Coach purse, you have to look at the details closely. If there is a fabric pattern on the front, make sure that the letter is clearly a “C”. If it looks more like an “O” or a “G”, then it is a fake.
Kimchi is a traditional Korean dish that is as tasty as it is spicy. This video tutorial demonstrates how to make apple kimchi in your own kitchen. Follow the provided guidelines or add a few delicious changes to suit your taste.
In this video tutorial, viewers learn how to chuck when playing the ukulele. The chuck is a different type of strumming technique. It looks like the user is slapping the ukulele. To chuck, users are to slide the fingers quickly down the string. The chuck is used as an extra beat and helps add rhythm to the song that is played. This video provides a visual demonstration and step-by-step instructions for viewers to easily understand and follow along. This video will benefit those viewers who ar...
RabbidHedgeHog shows viewers how to easily make a podcast. This features how to make the podcast with the program Audacity. First open your internet browser and go to Audacity. Scroll down to download Audacity 1. 2. 6, save the file, Install and download the program. Now, open up Audacity which is basically a recorder. Connect your microphone which will allow you to record. Click edit, preference, find microphone and select the device you will use. Now, record your podcast by clicking the red...
If you want to know how to do Michael Jackson's moonwalk, you should watch this. 1. Find a flat, smooth surface that won't provide an immense amount of friction and wear any comfortable clothes and trainers. 2. Stand with both feet flat on the ground. Lift your left leg into "L" position so that the toe of your right leg is pointed to the floor. 3. Learn how to balance your self. With your weight on your bent leg, slide back your left foot. Be sure to keep your left foot flat on the floor as ...
This video demonstrates how to use Skype to make calls. The best thing about it is that it is free. You only need a computer, a microphone and a web camera. To use Skype, you first have to download the Skype software. This can be done through the website of Skype. Then install the Skype on your computer. Next you need to have an account created. For this you have to provide a screen name and also your email address. You need to type a password for your account too. Once your account is create...
To correctly provide nostril to nostril irrigation, first fill the Neti pot with warm water or water a little warmer than body temperature. Mix one level teaspoon of salt into half a liter of water. Taste and spit the water to check the correct salinity. Place the nose cone into the right nostril, twisting it and applying pressure to it to make a seal. Do not move air through the nose. Bend forward from the waist and tip your head to the right so the left nostril is the lowest point of the no...
Tim Brownson talks about how to tap into self-confidence during this video. This technique is called anchoring. An anchor is an idea or event that links to another event that is usually not related in some way but provides some kind of reminder of an emotion. This can also be called a conditional response. Tim gives a lot of real examples of anchors and conditional responses. First start by calming down as much as possible. Then think of some activity that you are confident you can do, and th...
This video demonstrates how to assemble a kitchen flat pack. Everything needed comes packed flat, plus cupboard doors and bench tops are included. The flat pack is a pre-cut custom designed kitchen that can be assembled by yourself. First assemble the cabinets according to the instructions that are provided. The holes are pre-drilled making assembly quick and easy. After you have completed the assembly of your cabinets, attach the adjustable feet to the base so you can level the cabinets with...
Debra Hardy provides detailed instructions on how to make darling decorative Santa soy votive candles in this video. She first cuts the red felt into 6 3/4 inch by 2 inch strips for the Santa suit, wraps it around and adheres it to the bottom of the glass votive. Next, she secures a smaller strip of the white faux fur on top of the red felt also towards the bottom of the candle to create the bottom of Santa's jacket. Debra then instructs the viewer to cut a 6 3/4 inch by 1/4 inch black felt s...
This video shooting taken at Pacific Home Furnishings explains the way to extend the life of your carpet. The lady presenting the video explains us the ways that can help extend your carpet's life. She says that when you go shopping for the carpet, after thinking about your budget, the next important thing to consider is the underlayment. She presents us with some samples of underlayment ranging in quality and pricing. First she about the least expensive one which she calls the after thought ...
To start with you have to write the author's name, with the last name entered first followed by first name and then the period. Title of the article should be in quotation marks. Do not use italic format. Title of the actual journal must be written. After this there is a series of numbers the volume number, issue, year, pages number separated by a colon. Don’t write 'p' for pages as the number itself is a standard for it. Write the period and also the dates.
Parenting Coach, Nancy Stone provides a few tips and techniques for easing your toddler through the transition from diapers to being toilet trained. First off, Stone suggests allowing your toddler to help pick out their potty seat. Secondly, keep in mind that boys and girls are different - tossing a few Cheerios into the potty and letting your boy aim for them makes it kind of a game, which Stone says is important. Thirdly, ask your toddler quite frequently, point blank "Do you have to go pot...
Ina Garten is going to provide you with an amazing recipe to roast a chicken. Begin BY THAWING the chicken under RUNNING cold water and then pat it down with a paper towel. Now make sure the inside of the chicken is empty and add a good amount of salt and pepper. Also, add in a QUARTERED whole lemon , a whole clove of garlic chopped in half, fresh thyme and just make sure its all stuffed inside pretty good. Now, you want to melt down enough butter to be able to brush the entire SKIN of the ch...
In this video, the poster is teaching YouTube users how to use Daemon Tools mount games image files. That’s very useful to many people that cannot burn ISOS or any other image files into a blank media (CD, DVD). With the tips provided by this video, anyone can use Daemon Tools to mount the image in a virtual CD/DVD drive. Daemon Tools is a Freeware program and you can download it at many websites on the internet.
In order to achieve the Kat Von D look, first you must use eyebrow liner that gives off a strong presence. Next, a matte brown palette should be applied to three quarters of the eyelid; the remaining quarter will be used for the highlight. A pencil brush should be used (or cotton swab if you don't have a pencil brush) for eyelining the edge of the eye. A matte black color is then applied to the outer corner of where the brown was applied, to add more depth. (Try your best to blend the colors)...
This video shows how to change the advanced settings to make Firefox faster on Mac and PC.
Jim Reppond of Coldwell Banker Bain demonstrates the way of getting postlets into Facebook. He says that by adding the postlets in your Facebook page, one can click on the link and directly go the postlets page if they are interested. He asks you to then go to the postlets page and log in using your username and password. Once inside, you can click on the 'My Postlets' tab to see your active postlets. Then chose the postlet you want to add to Facebook and click on the respective 'HOST' button...
Building a frame for your paintings can save you money and provide one more creation of which to be proud. Normally recommended for abstract paintings, basic float frames offer a professional feel to your art. This video demonstrates how to build a very simple float frame, which compliments a modern, contemporary, abstract painting rather nicely.
Roasted peppers are a great treat for any occasion especially for a nice salsa or even to add to a nice roast. This video will demonstrate exactly how to roast peppers over an open flame. This technique provides the BEST flavor for your peppers.
In the spirit of foods stuffed with other foods such as Turducken and macaroni and cheese stuffed meat loaf, comes this seafood inside seafood dish. This video tutorial shows how to make King Crab stuffed lobster tails. This gourmet meal is surprisingly easy to pull off, provided you’re working with some decent crustaceans.
A guy shows you how to cook a delicious smoked bologna. You will need: wax bologna, knife, chopping board, a core, barbecue sauce, mustard, a teaspoon of paprika, a tablespoon of seasoning salt, a teaspoon of pepper, a teaspoon of garlic powder, fresh lettuce, sliced onions, tomatoes, feta cheese, cucumber, oregano, olive oil, vinegar, asparagus wrapped in bacon. Remove the wax from bologna meat using your knife. Make diagonal cuts around the sides of the bologna with about 1/4-inch depth. Ma...
Award winning author Susan L. Reid teaches us how to write a great mission statement for your business. 1. First, write your "purpose statement". This answers what your business wants to accomplish and what problem or need your business is trying to address. Simply state the answer to this question. 2. Write your "business statement'. This describes the activities or programs your business must do to support it's purpose. Ask yourself what you are doing to address the need identified in your ...
Crimp can be made easily and covered to the jewelry by using the following instructions. First purchase the proper supplies of crimping tool. This tool acts like pliers and is used by placing the bead in the appropriate slot at the tip and then squeeze the handle together. The multiple slotted tips are the key to the tool, and are needed to create a proper crimp. Then, select the proper crimp bead. The thin metal crimp beads come in a variety of materials and sizes. This will be used to secur...
In this video from George3694 of TheiPhonePress he explains how to edit your iPhone or iPod system strings using Winterboard. First you download the system strings folder from the link provided in the comments section. Then click all the way into SpringBoard.strings. Once in there you change the original strings to the ones you like. So for instance you can change "slide to unlock" to "slide to unleash" on your iPhone. After you change it you can close and save it. Then you launch your SSH pr...
Knitting blogger Sapphires'n'Purls provides step-by-step basic instructions of the magic loop knitting technique. To begin Magic Loop knitting, you will need the following supplies: One circular needle with flexible cable, skein of yarn of your choosing. To begin, you will cast on 12 stitches onto the circular needle. Next you will slide all your stitches onto the flexible cable. Once all your initial 12 stitches have been cast, divide the stitches in half, putting six stitches on the left si...
This video tutorial is about how to install Adobe Shockwave Player in Internet Explorer browser. This video tutorial is provided by ClearTechInfo.com. One can clarify any computer technology-related doubts using this site.
This how-to video is about how to make homemade ginger and garlic paste. This video is provided by Anuja and Hetal, and they explains us the simpler method of preparing ginger and garlic paste which is used in most of the Indian dishes.
The Mr.G Show presents how to make "hot ice" more commonly known as sodium acetate in the kitchen. You start with one liter of white vinegar which you place into a sauce pan. You add four table spoons of baking soda to the pan being very careful because both chemical together will react an may cause a big mess so be prepared to clean up any boil over that may arise. Wait while this mixture boils down for the real fun to starts. The hot ice created will transform from a liquid to a solid befor...
This video is provided by Mr. Binley. Let's learn this with an example, let's say that we want to divide 0.492 by 0.4, the most important thing remember while dividing the decimal numbers is that we need to convert the divisor into a whole number, here we need to convert 0.4 into a whole number. To do this we need to move the decimal to the right, then 0.4 becomes 4, now do the same thing to the dividend (0.492), move the decimal to the same location that we followed while moving the decimal ...
