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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.
Getting text from one area to another is quite simple. You can do so between any text frames. This video will demonstrate exactly how to cut, copy, and paste on your Macintosh.
Hemp jewelry is very trendy and eco-friendly. They are easy to make and don't take long. In this three part tutorial, learn the basics for making your own hemp bracelet.
For anyone new to cooking, this basic tutorial shows us how to mince garlic, an ingredient often used in a variety of recipes. If you are going to mince a clove of garlic, you will need to separate the clove from the bulb. Before you mince your garlic, you will need to peel it, which is simple. Simply take a heavy gauge knife and smash it against your clove. The skin will break away very easily so that all you have to do is pull it off. Cut off the hard end of the garlic clove and then smash ...
This Outdoor Recreation video tutorial shows how to use your legs while riding. Rick Gore from thinklikeahorse presents this video tutorial. The way you use your legs will depend on whether you are wearing spurs or not. When you are not wearing spurs, use the bottom and top of your leg. If you want to move forward, just squeeze in both your legs. If you want to go left, give a light pressure with your right calf. Similarly, for going right apply pressure with your left calf. To move backwards...
The man was requested to solve a short, basic chemistry exercise. He starts by explaining the meaning of the terms involved in the problem: molecular mass, empirical formula and molecular formula. He also explains the way the are connected, for a better understanding of the way the exercise is solved.
A video from http://www.donpower.me that shows how to draw a simple Christmas tree. This video is basically for kids. The presenter in this video, shows how using simple crayons a Christmas tree can be drawn in not time. The short duration of this video (0:59 seconds) is proof enough.
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...
In this video tutorial, viewers learn how to turn on and off an iPod Touch. This is very simple, easy and fast to do. It is very basic and essential for those who have an iPod Touch. To turn on the iPod Touch, press and hold the power button until the Apple logo appears. To turn the iPod Touch off, press and hold the power button until the red slider appears. Then slide the slider. This video will benefit those viewers who have just recently purchased an iPod Touch and would like to learn how...
Properly measure liquid and dry ingredients Diane Morgan describes the basic technique for measuring ingredients, which is critical to baking. There are two types of measuring cups, one for liquids and a different type for dry ingredients that need to be leveled off, such as flour or sugar.
Being able to shoot a low free kick can lead to a lot of goals in Fifa 2009. This video will show you the various ways you can take a low free kick and gives you quick, to the point instructions on how to execute them. Keep in mind that not every player can do this, so be mindful that you have a skilled free kick taker before attempting. Watch this video, practice, and start crushing the competition!
With paper crafting you can build intricate paper models of your favorite characters, from Jack Sparrow to Nintendo's own Toad. This video tutorial shows you how to rip 3-D characters from your favorite Nintendo 64 games for the purposes of paper crafting. It will take some editing to be able to get your favorite videogame characters into a workable papercraft format.
This video instructs you how to use the "Finder" Button if you own a Mac on OS X. The "Finder" window shows the Mac user the contents of the hard drive. It describes functions of the Finder folder: i.e., adding an untitled new folder in the Finder file. It also discusses how you can view the "Finder" in a variety of layouts: grids, lists, etc. The video shows you how to use the buttons on the upper left hand corner of the "Finder" screen to maximize, minimize, or close the window. It also dis...
This video shows how to do audio side chain compression to improve your production audio mix. Side chain compression is an easy way to balance the base and the drums. Using a compressor, you can cause your base to drop in volume when the drums are hitting so that one is not over-powering the other. This video walks you through step by step instructions for configuring your compressor to balance based on threshold level, the attack time, and release time. This is an excellent source of audio p...
Using a Strat guitar since it has a basic type of string system, this demonstrator shows how to properly adjust the string height of a guitar. In order to do this, one must use an Allen wrench screw or a screwdriver for each saddle, a flathead screwdriver, and a 64th ruler. The viewer is given an example of a height that could be used for a solo guitar. It is important to measure the distance you want correctly by measuring from the top of the fret, not the fretboard to the string. This video...
If you own the paper cutting craft device, the Cricut, you can make Happy Howlidays Christmas cards by using the Cricut Paper Pups cartridge. The Cricut machine is for crafters who want to cut out paper and graphics for scrapbooking and card making. The card shown will have a dog on the front and your choice of colors for paper. Red or green paper would work well since this is a Christmas card. You can also use the basic Christmas shapes with you Cricut machine and add those to the card as we...
Interviewing lighting basic training tutorial provides easy to follow instruction in this step by step video. Set up the interview area to allow the best camera angles. Place your lights in key, fill, and backlight positions. Use back lighting spillover to fill subject area without camera spillover. Check your setup with the subjects and make any necessary adjustments to your camera or lighting angles. Place your crew and your ready for your interview. This scenario using key, fill, and back-...
This video is about adding motion to photos with the help of Photoshop. The video has clear picture with good audio. In a few minutes the video gave easy step by step instructions about adding motion to a particular object in the photo and it also gave an easy tip to get it gelled with the background. The instructor was good but needs to modify his pace for better clarity. The video surely gives the basic steps to be followed to add motion to a photo and will also be very useful in the field ...
The video creator attempts to teach us how to add and subtract fraction. He goes very slowly and assumes that the viewer only has a very basic knowledge of math. He starts with a division of a pie. If we were to divide a pie into four pieces, you would get four pieces of a pie. If I ate one, there would only be three fourths of the pie left. He uses this basis in order to explain this mathematically.
In this video from Fashion Face, we are shown how to do a 1920's pink film noir makeup look that was actually requested by Courtney Love and originally created by a makeup artist for the brand Illamasqua. This is an extreme look, and there are a lot of tools and makeup involved, but it creates a really cool look, and provides some great tips.
Is your computer mouse filthy? It wouldn't be unlikely considering computer users have their hands on their mouses all day, collecting dirt & grime in its crevices. In this two-part video tutorial, learn how to clean it up to make it look like new! This process is fairly easy to do. The first video of two, will show you the basics of why your mouse gets dirty, how to take it apart and tools you will need. The second video, will go into more depth about how to clean the hard to reach places.
For people who would like to learn how to make a professional tattoo, this is the tutorial to watch. For making a basic arm tattoo, the subject should be seated upright in a military position. You should apply some alcohol and then some antiseptic to the area to disinfect the area and place the stencil over the area. It is suggested that the subject shave his or her arm in order to get the best effects. The tattoo stencil should be placed over the center line of the arm and align it properly,...
Writing a song? Want your chorus to have a strong impact? Jimmy Kachulis of Berkleemusic gives songwriting tips on how to make the chorus stand out from the verses even when you use the same chord progressions.
If you're wondering what FoWsc stands for in Guild Wars and what it's all about, here's your lesson. Dooom Box teaches us everything we need to know when it comes to Fissure of Wo Speed Clear: The basics, the parts, the teams, and more.
Fractions can be tough, but in truth, they're one of the easiest concepts to understand in math. Figuring out fractions is the last thing you really have to worry about in math class, unless you have a horrible teacher, then you might want to check out this video tutorial to help you learn how to add fractions with unlike denominators, including how to find the LCD (lowest common denominator).
Thanksgiving is all about the turkey. So much can go wrong with a turkey, though. The turkey could come out tough and dry, and totally unappetizing. Learn how to combat gross turkey, and turn out a moist, flavorful turkey for an awesome Thanksgiving.
Learn how to use Thinking Particles in Cinema 4D. Working with these programs could be pretty complicated if you're not sure what you're doing, but this two-part tutorial covers some important topics when using Thinking Particles. As the name suggests, it is a particle-based system, just so you know.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
Kids... it's dance time! Check out this dance video tutorial on how to do a ball change step in hip hop dance for kids.
Watch this cooking video tutorial on how to make chocolate Nutella tarts - kids can cook! You will get all the necessary information to make this chocolate Nutella tart recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make salsa - kids can cook! You will get all the necessary information to make this salsa recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to bake a party pizza - kids can cook! You will get all the necessary information to make this party pizza recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make a frozen fruit smoothie - kids can cook! You will get all the necessary information to make this frozen fruit smoothie recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make a French crêpe - kids can cook! You will get all the necessary information to make this French crepe recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook macaroni and cheese - kids can cook! You will get all the necessary information to make this macaroni and cheese recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook a hearty hamburger - kids can cook! You will get all the necessary information to make this hearty hamburger recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook kickin' chicken - kids can cook! You will get all the necessary information to make this kickin' chicken recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make a popover balloon dessert - kids can cook! You will get all the necessary information to make this popover balloons dessert recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to make a fruit smoothie - kids can cook! You will get all the necessary information to make this fruit smoothie recipe, including a list of all the ingredients needed, all right in the video.
Watch this cooking video tutorial on how to cook beef skewers - kids can cook! You will get all the necessary information to make this beef skewers recipe, including a list of all the ingredients needed, all right in the video.