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...
PeteMcCormack2 teaches viewers how they can live off the grid! First, you will need shelter, heat and water! And possibly some electricity. You need head so you can use a high efficiency wood stove. You always need to have water so you can use a well or a water pump. Also, for a pump you will need power, you can use solar power for this! You can also use a pressure tank. This way of life does not necessarily cost much and with self installation it will lower the cost also. All you have to do ...
This video tutorial from TigerDirectBlog shows how to easily install or uninstall Internet Explorer in Windows 7 operating system.
Marie was asked by a viewer how to go about being more orally engaging with other people, as most attention he gets is attributed to the fact that he is very quiet, which doesn't sit well with him. Just like anyone else, he would like to get attention for the things he says, not for being quiet! He is under the impression that "cramming," or being knowledgeable on current events and other trivia will give him more to talk about and thus help him to be more talkative. Marie suggests, though, t...
Paint A House demonstrates how to roll paint the ceilings in your home. To roll paint your ceilings, first paint the edges of the ceiling where it meets the wall. Then, make sure you have enough paint on your roller. Raise the roller to the ceiling, making sure that you stand to the side and a little bit backed away from the paint roller. Move the roller across the ceiling in a sideways motion. Don't walk forward with the paint roller to apply paint to the rest of the ceiling. Instead, back u...
Real UGG boots or fake? You can tell if your Uggs are authentic by looking for the authentic sheepskin interior. It should have a creamy color and a full texture. Fake Uggs use an artificial fur interior that is grey in color and feels thin. Real Uggs say they are made in China on the label. Fakes claim to be made in Australia or New Zealand. Check for the registered trademark mark (R) on the sole. Real Uggs have it, fake ones don't. Finally, the uppers on real UGGS meet the sole smoothly, wi...
The Bespoke Center shows how to measure the right sleeve for a custom made men's suit. The Center recommends using a tape measure of course to do your measuring. These recommendations are easy and work well for custom made DIY projects. For this project the man will need to wear a shirt. Measure from where the seam on the shoulder meets and to the base of your thumb located at the wrist joint. The tailor also recommends that you do this so that you can decide where you want the sleeve to end....
That Paper Guy shows you how to make a simple paper airplane. First, get a piece of paper 8 1/2" x 11" and fold it in half lengthwise. Then fold on one side a triangle. Flip to the other side and fold a triangle as well. Fold the corners down in the same direction on both sides, making sure the edges meet the center fold. Fold the corners down one more time on both sides, again in the same direction. Open up the finished airplane so that you're able to grab the center with your thumb and inde...
Quincy shows how to jump rope like a professional or for competitions. 1. Make sure that the rope is the proper length. The rope should meet your armpits. He teaches that you'll start with the basic jump. 2. To initiate the jump, move the rope in a circular motion, make sure that it passes your head. 3. To do continuous jumps keep moving the rope in circular motions. 4. To do a double ended jump, the rope goes under your body two times and you move the rope faster.He also teaches advanced jum...
Fyeo shows a cool way to fold a bandanna. Naturally you start with a bandanna. Lay it out flat and fold it so you get a nice big triangle. Then, fold it one more time so you get a smaller triangle. You then fold it again. Not so the corners meet, but so that just a little is hanging off. Then you take the corner and fold it in and under. Take about five inches up and fold it under so that a tail is hanging out of your back pocket. Once you've completed this, place the bandanna in your pocket....
Men are sometimes hard to deconstruct, but when you know you like someone you just do. And sometimes it can be hard to make the right moves to shift your relationship in the direction you want. Well take a look at this video and my good paraplegic friend will show you exactly how to make any man fall in love with you.
First of all take a rectangular sheet of paper. Now take a corner and fold it across to meet at the corner. Now crease it. Now take another corner and fold it over to the other side and crease again. Now bring in the x as shown so the sides are drawn inside and they form a triangle. Now crease it. Now take one corner of the triangle and bring it to the top. Now crease it. Now do it similar for the other corner. Now fold the bottom piece over and bring it to top. Then fold once again as shown....
In this video tutorial, viewers learn how to seal gaps in houses using DAP foam sealant DAP 3.0 Weather seal caulk. The DAP products are designed to meet the tough standards demanded for professional window & door installations while effectively sealing large cracks, gaps and voids. Users learn to use the foam sealant to seal in gaps from inside the house. The gaps found behind wall trims. The seal caulk is used outside around windows. This video will benefit those users who want to learn how...
Accurate measuring is very important for ensuring the best fit on a dancer. Make sure the dancer is wearing a leotard for accuracy instead of street clothes. Girth is measured in the middle of one's shoulders, down through the body and up the other side until its met at the same point in the shoulder you started at. Make sure to measure at the fullest part of the bust. Now measure around the natural waistline. Then measure the fullest part of the lower torso, and then the inside of the leg fr...
Alazzo Clothing teaches the viewer how to measure their jacket length. You'll need a flexible measuring tape first. First, put your measuring tape at the point where the shoulder and neck seams meet. From this point, you will measure down to the length desired. Measure down the front of the chest and not the back. The length you will measure will end right around where your thumb joint is. Record this amount in inches and this is your jacket length! Take this number in and get jackets tailore...
In this video tutorial, viewers learn about overproduction and if they have a overproduction gait pattern. Overproduction is when, after heel-strike, the foot rolls more than 15 degrees inward to meet the ground. Overproduction is more typical in runners with low arches. To check if you have a overproduction pattern, check the wear marks on the bottom of your shoes. Overproduction causes heavy wear along the heel and inside of the forefoot. Overproduction is natural and can cause injuries. Vi...
In this Beauty and Style category video tutorial you will learn how to measure your shirt length. The video is presented by Alazzo Clothing. The process is very easy and simple as you will find out after watching this video. For doing this, the person must be standing in upright position. Place the measuring tape where the shoulder and neck seams meet. Then you got to measure downwards up to the desired length. The right length is normally right around the first knuckle of the thumb. The vide...
This is a very useful instructional video on keeping the conversation going when a man wants to talk with a woman. It is indeed an art to talk to women. It is not easy for many men to keep the conversation going. They don't know how to avoid conversation killers. They are at a loss for words when they meet a woman. If you ever find it difficult to keep the conversation going when you talk to women, this video teaches you how to avoid the biggest conversation killer. It helps you to keep the c...
In this video, Dan and Jennifer will teach you how to be safe while trying to meet girls or date online. Learn tips and tricks to avoid common scams such as identity theft and fraud, as well as things to look out for and early warning signs that your potential lover may not be all she says she is. Dan and Jennifer will also show you how to watch out for one of the most common scams online: "cam girls". Don't fall for that fake girl that acts like she's totally into you but really just wants y...
In this video from Patricia Stark of Craving Confidence teaches how to build confidence by untangling a necklace or bracelet. She says that the last thing you need before a big meeting or interview or event when you are on the road is to be untangling a necklace. She recommends saving the tiny Ziploc bad that is used to carry extra buttons for clothes and clothing. Small plastic space seems to keep the jewelry from tangling to itself. You can also use them as small compartments from keeping t...
In this video tutorial, viewers learn how to cut a scarf joint in crown molding and coving. Scarf joint is simply two flat planes meeting on an angle relative to the axis of the stock being joined. Users will need a magic miter. The magic miter is a miter box for cutting miter joints at any angle in crown molding, baseboard, chair rails and more. Adjust the machine to a 45 degree angle and lock it. Put in the mold and cut it. Repeat the same step for the other side. This video will benefit th...
Dan and Jennifer explain how to know if seduction and pick-up tactics will work for you. First, you need to learn to be yourself. Be wary of relying on pick-up and seduction books alone. Don't pretend to be something you're not to trick a girl into going out with you, because she's eventually going to meet the real you. You may get a lot of dates and have a lot of one night stands using pick-up tactics, but you're not going to get and keep the girl who you really want. Dishonesty is a sure wa...
In this video, Dan and Jennifer answer a 71 year old woman's question about her relationship. The asker has been staying with an 80 year old man that she met online, for three years. Throughout the duration of the relationship, the man has not told his family (which comprises of his two children) about the relationship. The woman is unsure about what exactly this means. In addition, the man has been over to the woman's house multiple times, but she has never been to his house. Dan and Jennife...
Elizabeth Chamberlain, with Space Lift, demonstrates how to make room for love with feng shui at home. First, find your focus room with your energy map by laying the energy map on top of your floor plan. The love area is the far right corner from the front door, facing in. If the love area turns to be an outside area like a patio, clean it up. Remove the cacti and pointy plants to reduce arguments in the relationship. Clear out any unfinished materials and projects. Next, complete the area by...
In this short video tutorial Jet and Star from The Wing Girls give advice on finding out if the girl you've just met likes you as a friend or more than just a friend. They advise you on how to ask the girl to "hang out", keeping it "chill" and casual. The video then deals with subjects like how to "get her alone", and "holding her hand". The video itself is short but entertaining, and the girls manage to explain their approach to the subject in an entertaining and casual way.
Life and dating coach Donna Barnes discusses dating if you're over 65. There are a lot of people out there looking for companionship, and just because you are over a certain age does not mean there isn't someone for you! Try to find places that arrange activities for seniors, look online and find fun things to do with new people. You don't have to spend your life alone, a lot of people are out there looking to meet someone like you.
This video by Good Housekeeping shows you how to improve your memory as you age. Follow these steps to improve your memory: Practice by paying attention. For example whether your husband was wearing a tie this morning, or what your friend ate for lunch. Organize information into smaller groups. Create a to-do list. Repeat the name of the person you just met. Play word recall quizzes, which can be found at Good Housekeeping.
David Wygant, the dating expert teaches how men can attract women using the right words in a conversation and keep them interested. He goes on to cite an example of how he started a casual conversation with a woman and kept her engaged and interested in it throughout. He provides tips on how men can overcome the problem of loss of words when they meet women. He explains in his own witty way the power of walk away, a technique he adopts with aplomb. David claims that this simple technique alon...
This video helps us learn how to make a well-balanced paper football. Get a square paper. Fold the paper in half. Fold it again in the same direction. Fold the paper diagonally to make a triangle. Flip the triangle up so the point lines up with the left edge. Continue folding triangles up the paper until you reach near the top. Fold the top corner down so that the two points meet, making a triangle in the opposite direction. Tuck the extra paper into the pocket. Now you have a paper football.
Learn from this video how to carve a turkey step by step easily. Start cutting in the loose skin area where the legs and breasts meets and carve it down carefully. Now remove the drumstick from the pork and slice down the meat from it and from the thigh part. Remove the wings from the breast either by twisting it with your hand or cutting it using a knife. Now find the breast bone and cut on either side of it trough the rib cage. Slice down the meat and repeat the same process on the other si...
In this video the instructor gives tips on how to erase a PC hard drive. An MIT study shows that 74 percent of the discarded hard drives contain private data on them that can be read and recovered by others. So you should learn how to completely erase all the data so that no one can recover or read from it later. Now formatting the drive or deleting a few files wont do it. For this you will need to have a proper software that meets or exceeds that US Department of Defense standards for data r...
David Wygant explains how to date online and grab a woman's attention. Emotional connections are important so tell your personal story with passion. Write your online profile like something a woman likes to read and then present her with a challenge. Your profile should be your personal story that's emotional, self-evolved, romantic and real. Pick up key things that are written in a woman's profile and cut and paste them into yours. Also, use a combination of humor and curiosity when initiati...
In this video the author shows how to draw a rhombus when given with the values of long diagonal (D) and a short diagonal (d). Now he draws the long diagonal of size D horizontally on a sheet of paper. Now he points the mid point of the line as he explains that the diagonals of a rhombus meet at midpoints. So now he takes the ruler and draws an another line perpendicular to the first line through its marked mid point such that the length of the perpendicular line is d/2 both above and below t...
For many men, the workings of the female mind are difficult to understand. In this video, Vanae helps her male viewers understand how to get out of the friend zone with a girl they might be interested in. First of all, when a girl meets a guy, she automatically will classify them into two groups: friends and guys she could potentially date. In order to get out of this friend zone, a guy must keep in mind some key facts, such as the fact that most girls do not want to be chased. Having a natur...
The Mean is the average number, the Median is the center of the group and the Mode is the number that shows most often.
Be kind to people on your trip to Poland by learning how to greet people in the streets! In this video, learn how to say "good morning", "good evening", and "nice to meet you" in Polish & the correct pronunciation for each. Before you know it, you may win over the entire country!
Hey ladies! On your trip to Poland, learn how to ask those cute Polish guys out on date with a variety of phrases and questions taught in this video. A situational conversation lesson, learn how to say the following in the Polish language: "Shall we go to the swimming pool?", "Have you got a map?", "Let's meet at the bus stop" and more.
This is how to calculate the area of a rhombus. A rhombus is a quadrilateral shape in which all sides are congruent. A rhombus has two sets of parallel lines, the diagonals of which form 90-degree angles at the point they meet. Also the angles opposite to one another are congruent. The area of a rhombus can be gotten by multiplying both the diagonals and then dividing the total by 2. Say one of the diagonals is 10 and the other is 12, the area will be 10 x 12 = 120/2 = 60. That is how to calc...
Want to munch a quick and yummy snack that is also healthy? This video shows how to make deviled eggs, a quick, easy, delicious and nutritious snack that meets your protein needs. It is simple. Even kids can make them during their leisure and enjoy the pleasure of cooking. This dish is attractive, healthy and rich in protein. All you need is simple ingredients. This snack is good for pregnant ladies and kids.
To refill your RC truck shocks the first step is to remove the shock with an alarm key located at the bottom of the shock. The next step is to pull the spring back and remove the lower joint and spring then remove the cap screw and be careful, their might be some oil still in there. Fill all the way up to the top if you want stiffer shocks and pump the shocks a few times to eliminate bubbles in the oil. Then reassemble and check to make sure it meets your needs and you are done.
