If you are out with friends and don't have anyone to take your photo for you, you will need to take a self portrait. Instead of fumbling with a self timer, most people hold the camera themselves and take a snap. Unfortunately, these photos are hard to center and you often cut people off and lose what could have been a great shot.
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 605th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function to fill in column with missing values then use Paste Special Values to create the final column with correct values. Also see three methods for Paste Special Values.
Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to use a number of string methods that will allow you to do useful things like count characters and find substrings when writing code in the Java programming language. For more information, including detailed, step-by-step instructi...
You know that moment of slow motion when you realize your keys are still in the ignition while the car door is closing? If you've accidentally locked yourself out of your car, check out this tutorial.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Formula Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.
This video shows the method to create a messy bed hair for men. Straighten your hair with a GHD ministyler. The product to be used to style your hair is ID hair dusty Bronze "clay wax". This should be applied in dry hair. You can wash the wax out by shampooing your hair twice. The shampoo to be used is Crew or ID hair peppermint. Put the finger in the wax and take out the wax. Rub the wax in your palms and apply it on your hair. Apply it in the front, back and sides. Use the wax again if it i...
This video shows the method to cook spaghetti squash in the microwave. Take a winter squash and punch some holes in it with a knife. Put it in the microwave for 20 minutes. After every five minutes, take the squash out and turn it after checking whether it is cooked or not. You can also take a crock pot with couple of cups of water and put the squash in it for 6 to 9 hours. After this, cut the squash along its length. Use the spaghetti lifter and remove the seeds. Now take out the spaghetti w...
There are many ways to prepare spaghetti squash but this video takes your through a quick and easy method. First, pierce your squash with a fork and microwave it on a microwave-safe dish. Note that you should microwave the squash for an average of five minutes per pound. In this video, the cook is using a 3 pound squash so she microwaves her squash for 15 minutes. After it's done cooking, allow the squash to cool and cut it in half to remove the seeds. Now you are left with the squash flesh. ...
This video tells us the method to transfer photos from your iPhone to your Mac. In the first step, launch the image capture. Connect your iPhone to Mac via a USB cable. 'Download To' option is used for specifying the folder in which you want the downloaded files. 'Automatic Task' specifies the task which the application must do after the transfer of files is over. Go to the 'Download Some' option. Select the file(video or photos) you want to transfer. Choose the download folder and click 'Ope...
Ultimate Handyman demonstrates how to remove a threaded stud from a threaded hole. You will often find threaded studs when you are doing car repair. First, remove the nut from the stud. Then, spray it with lubricant. Next, screw the nut back on the stud. Screw another nut on top of the first nut. Grip the bottom nut with a wrench while tightening the top nut. Grip the bottom nut and turn it in a counter clockwise direction. The stud should then pull out of the threaded hole. It may be difficu...
This is a great method to use squash as an alternative to pasta. Take spaghetti squash and slice it in half. Scoop out the inside and discard. You now season the two sides with butter and want ever other seasonings you like. Preheat the oven to 350 degrees. In a baking dish place the squash upside down and add an inch off water in the bottom. Bake the squash for one hour. It will now be soft and the middle is easily scooped away from the skin. Just add some spaghetti sauce and Parmesan cheese...
This video shows the method to solve a pair of linear equations by plotting their graph. Look for points of intersection of the two graphs which is the solution. Let us solve 5x-y=6 and 2x+y=8. Writing the equations of lines in slope intercept form, we get y=5x-6 and y=-2x+8. Now we plot the two lines. For the slope 5 or 5/1, we go up 5 units and left 1 units from the point of intersection on the y axis. For -2 or -2/1, we go down 2 units and left 1 units from the point of intersection on the...
The University of Michigan teaches you how to use nasal irrigation to get rid of common nasal sinus symptoms without reaching for those over the counter medications. The best part of nasal irrigation is that it handles conditions that medication cannot - such as post nasal drip and the common "stuffy nose". This can work for most allergies, even if you are already on medication. Water used for nasal irrigation should be luke warm and should contain about a quarter teaspoon of salt into an 8 o...
In this Home & Garden video tutorial you will learn how to step down or end your patio wall. This video is from www.allanblock.com. Get the installation details and the location of the nearest dealer from the website. The instructions are on How-to sheet #160. The easiest way to create step down is to create corner blocks. Simply place corner blocks at the end of each course overlapping the block as the wall steps down. Finish the wall with wall caps. Once the wall caps are in place, you can ...
Another way to track your ovulation cycle is with a fertility microscope. A fertility microscope allows women to identify their most fertile days by testing and viewing the visual changes that take place in saliva throughout the monthly cycle. This method is reliable and effective, and can greatly increase your chances of getting pregnant. All this requires is saliva, so it is not invasive and doesn't use needles. So, check out this tutorial for advice and instructions on how to use one of th...
If you are stuck using a computer in a place with safety filters, you can use this tutorial to bypass those controls and get to your YouTube account. So, whether you are in a school, library or your parents have parental controls activated, just follow along and you will be able to get past them every time. There are two methods described in this tutorial, one is easy for beginners and the other more advanced. They both work like a charm, however, and you will be watching your favorite videos...
Mold is not good for your home or your health. It creeps across damp ceilings and shower curtains, leaving a musty smell behind. In this tutorial, handyman Jay Baker shows you how to rid your home of mold before it gets a chance to make you sick.
In this video, Extension Horticulturalist Curtis Smith talks with Master Gardener Marsha groves about controlling harmful pests that are damaging to plants throughout the year in both outdoor garden and greenhouse environments. The first part of the video covers the issue of plant eating snails, and how they might best be dealt with. Smith explains that there are a number of non-toxic methods which one can use to rid a plant of snails. The process of introducing predatory creatures such as tu...
In this instructional video, the young host demonstrates an excellent method for cleaning your DVD's, CD's, and Game discs using simple, easily found items that you always have laying around your house. The toothpaste he uses acts as a super mild abrasive (almost exactly the same that is used in professional kits, except they don't get the benefit of a minty fresh smell) that removes minute dirt and debris that gets stuck on the disc. When cleaning your discs, be sure to rub the toothpaste in...
Patricia Aaron shows us how to safely pickle peppers. Pickling is one of the earliest known methods of preserving food. She starts by describing the various types of peppers.
This video illustrates the quick and easy method to Draw Donald Duck on your own . The process is comprised of the following steps:Step 1: Take a blank sheet of paper and a HB Bonded lead pencil.Step 2: Draw a face that resembles a duck's face. Make sure you don't make the ears too large as Donald Duck has got small ears.Step 3: Another point to consider is the length of the beak. Make sure it is elongated and oval shaped.Step 4: Now , make a oval shaped figure and shade it's outline to form ...
This video shows you how to clean a compact disk using peroxide and toothpaste as the cleaning agents.First of all, put the disk in a mixture of water and a bit of peroxide and let it stay there for about 5 minutes. Then, you must take out the disk and apply a thin layer of toothpaste on the whole disk's surface. Let it sit like that for another 3-5 minutes. After that, clean the disk with water. Use it only when it is dry. If this method does not work, then you should either take the disk to...
The first way the she explained tying a scarf was "belting a pashmina." Which is taking a pashmina scarf, placing it around your neck and securing it under a belt that you fasten around your waist. The second method was "Be a wrap star." Get a really long scarf, tie it around your neck twice loosely, keeping it uneven and adding fullness to your neck. The third way was to "rethink your evening scarf," where she describes a bow scarf. You put the scarf around your neck and put one side over th...
This video is about how to fix an iPod Touch that will not open applications. You fix it by pressing and holding the power or home button which will restart your iPod that will only take a few minutes. If this does not work, fix it by uninstalling or deleting all the applications and re-installing it from the Appstore for it to work again. If both these two methods will not work, then you can restore your iPod through iTunes by clicking the button "restore". The whole process takes for just a...
In this video, Jessica shows us how to change eye color using Photoshop. First, open up Photoshop on your computer. Open up your picture and zoom in on the eyes so you have a great view of it. Then add a new layer or "control +j". Where it says "normal" change that to color. Then select your paintbrush tool and make it a reasonable size for your eye. Click the color palette square and change the color to whichever one you choose. Now, paint over the eye and it will completely change the look!...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
In this video Sue demonstrates how to cut a pineapple quickly and easily .surely this method will help to cut a pineapple without any mess. At first she cuts off the top of the pineapple and then the bottom ,then she places the pineapple standing on its base and bisect into two half at the middle and again she cuts the half piece at the center to get quarters. Then she cuts the quarters core away ,then she begin to slit the fleshy part of the fruit without cutting the skin ,after that she run...
This video will show you what your head voice is and how to sing high notes. Your head voice is a higher range than your normal chest voice, which can only go a certain range. Your head voice is the voice that occurs when your singing and vibration of your vocal chords is felt higher up than your chest, in your head area. This tutorial will show you how you can find this head voice and demonstrates a good method for exercising your voice so that you will be able to more efficiently sing highe...
This is a Computers & Programming video tutorial where you will learn how to hack Google to find anything. There are no audio instructions; only a demonstration of the steps to follow. Go to Google and type into the search box: intitle:”index.of” (type anything here) and search. For example, type in: intitle:”index.of”Shakira mp3. And click search. Then you will get the search results. Now you can click on Index of…/songs and it will take you to the songs index page. From there you can downlo...
This video shows how to wash a horse's sheath. The instructor notes that you do not want to wash the horse's sheath to often because certain good bacteria needs to exist in the horse's sheath. It is noted that you can use soap but his method of choice is to just use water to clean the sheath. This sort of sheath cleaning is only necessary with tame horses and must be done very carefully. The instructor notes that you can just let water run into the sheath and just let it remove any dirt. It i...
This exercise video for women, featuring Autumn Calebrese and Brooke Burke from Modern Mom, show you how to work your abs and stomach area! In "the Bridge," you arch your back slowly, working the gluteus maximus as well as the core area in general. Do about twenty-five repetitions, if possible, in three sets; afterwards, you can try a "pulse" method for an increased rate of "burn." This activity can be repeated until you are fatigued, and possibly consider holding at the top for increased fit...
This video shows the viewer how to make Halloween style lanterns using commonly available items. The base lantern is a Chinese style paper lantern; these can be purchase from home retail stores. The general principal is too cut out the shapes of insects from black paper. These can then be fixed to the lantern to project the image. Additionally holes can be cut in the insects and covered with red tissue paper. The light will shine through the red tissue paper giving the appearance of blood. Th...
Skip Steele and Terry Black of the award winning Super Smokers BBQ Team share their method for making championship barbecue ribs.
This how-to video is a vibrant and animated tutorial on how to paint children’s furniture: in particular, a little girl’s tea table and chairs. It’s fast paced yet easy to follow. The video couple takes you from the taping and preparation of the table and chairs to the completed and professional quality finished product, which would thrill any little girl. Their method of communicating the most important steps is to race to the camera and speak to the audience, in an amusing sort of wink, whi...
YOUTUBE Shigeru Miyamoto demonstrates using simplistic shapes and lines, how to draw his freehand creation of Mario. Shigeru, without speaking, begins by drawing two ovals for the eyes, and then adds a third oval for the nose, sticking to a very simplistic, shape-oriented method. He works outward from the details of the face, to the surrounding details, such as the facial structure and then finishes by adding the hat with the characteristic capital "M". A few minimal additions, such as shadin...
Drawing scales of a dragon could be difficult so lets try this method. First get the basic shape of the body,then draw those curves under the belly. After that,the scales which are on the top. Now the middle scales come in place. As we are done with our basic sketching,now its time to use a sketch pen for finalization. One can even add some shadows and highlights. This will help you draw some other amphibian as well as mammal figures.
This video shows how to make a quick pivot table data filtering by using Excel 2010's ‘Slicer’ functionality. ‘Slicer’ delivers enhanced visual filtering method to allow you to get the data you need more quickly. When selecting a cell in the pivot table you will find ‘Slicer’ in the filter group of the ‘Insert’ tab. Click on ‘Slicer’ and an 'Insert Slicer' dialogue shows up where you can pick particular data fields from the slider list. Once you click on ‘OK’, the ‘Slicer’ objects with filter...
This video describes the process of tuning the E string on a guitar down to D. The presenter explains this is a great effect for heavy metal and hard rock and makes playing power chords much easier. The method is to listen to the open D string on the guitar and then tune the E string to the same pitch. Since this is the thicker string it will sound one octave lower than the open D string. After the tuning is complete the presenter demonstrates several power chords and how they are much easier...
Lowe's presents a video that can give you a few tips on removing wallpaper from a room. First off you do not want anything to be in the way so clearing the room out is a must. This video shows you a abundance of products that can help you with the task. Also it shows some safety precautions to take before you take on this task. This video will show you a few different methods that can help you when giving a room a new look.
Katherine Miller teaches the secrets of starting your term paper research by using concept mapping method. Use a large sheet of paper and a marker to map out our ideas. First take an example like "Succeeding at college and grades" and write down the factors affecting your goal. The most common factor is money, now write down the things that has an impact on money like jobs, business and loans. The other factors are outside life, health, places for help and study habits. Simultaneously write i...
