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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a date label that adds leading zeros appropriately.
Marie Dubuque offers tips on keeping a conversation flowing and avoiding awkward silences. She suggests asking the other person about themselves. Everyone loves to talk about themselves, and sometimes if you ask one question they go on and on. Ask about their favorite food, favorite restaurant, how they get along with relatives. Questions about in-laws can lead to some interesting dialog and can get the conversation going better than it was before.
This video illustrate us how to apply competitive cheer leading tournament makeup. here are the following steps:
This video shows us how to perform a round off back somersault. Firstly you have to make sure that your leading leg must be wide when you put your hands down. And when you place your hands down, don’t place them parallel to each other but just place them slightly tilted. While you place your hands down, keep your head within your shoulders and when you place your hands down your back leg kicks back and you will rotate on your hand. When you go down, both your legs will be kicked to the back a...
In this video Dee Holt is going to show viewers how to prevent motion sickness when they're taking their dogs for a nice ride. First she starts off by telling listeners that if they happen to have a new dog or puppy it's very important that they get their pets used to riding in a car. A dog can get motion sickness so it would be very helpful if you always take a sheet or towel with you just in case. A person should never feed their dog or give them a lot of water within four hours of a car ri...
Ever wonder how WWE star Ric Flair did his face bump? Will now you will know how. This is when Ric Flair would come out of his corner and just fall flat on his face. To do this move you need to do a controlled fall. You kick out one of your legs to start your fall. When you fall you want to fall with most of your weight into your lead shoulder and chest. So, if you fall to your left you want you left shoulder and chest to absorb most of the weight. Use your other hand out to break your fall b...
If you an outdoors man or maybe your planning on going to the woods for a camping trip, then watch this video and use the tutorial to learn how to make your own compass. A compass is a great tool to have in the wilderness and can always lead you in which ever direction you want to go. For this home made compass all you are going to need is a magnet, a cup of water, a piece of foil, and a needle. All you want to do to make this compass is put the piece of foil on top of the water and then put ...
Professional Wrestler John will show you how to perform a Figure-4 leg lock, step by step. He first leads in with a Snap Suplex to put his opponent on the ground, and then demonstrates a proper Figure-4 Leg Lock. John then talks you through the entire process, while demonstrating. He first instructs you to grab your opponent’s left leg, lift their foot up, and step in with your right foot while bringing your left foot over their hip to their other side. Extend and bend their knee, and then br...
This video shows how to find the equation of the line perpendicular and parallel to a given line. The video starts off with an example, given the lines and the slopes (m). When 2 lines are parallel to each other, they have the same slope. When 2 lines are perpendicular to each other, the slopes multiplied together will give -1. Knowing these rules, the tutorial maker provides an example with numbers. He then leads each step of the process. Each step is written out in either black, red, blue o...
This video shows how to use a Neti Pot for treating sinus cold. The lady who demonstrates first takes out the Neti pot and sinus pills. She next takes the distilled water and pours it into the neti pot. She then mixes the sinus pill in the water. She explains how to go about doing procedure how to use it. Now she leads over to the sink and takes the pot with the solution and keeps her face little inside the sink. Next she keeps the pipe of the neti pot into her right nasal and pours the water...
In the summer and fall, swim baits are very effective in luring in forage fishes that have reached their maximum size. In this video, expert Wayne Gustaveson gives an overview of what swim baits are and how you can use them to catch more fish. Swim baits are plastic figures that imitate small fishes. There are various swim baits to chose from and one thing fishermen look for in the bait are the specific sizes and shapes. Each swim bait also contains a core components that is reusable. This in...
To fish with a plastic grub or a plastic worm, rig with a lead head so that the lure will go to the bottom and "swim" back to the boat, imitating a crayfish or a baitfish. First, cast your lure out to a likely spot like a rock or a tree or some place that looks like a good habitat for a fish. Let the bait hit bottom because bass like to watch it come down. They will swim over and inspect the lure on the bottom. You can raise your rod to lift the lure up and down or you can reel in the lure sl...
If you're looking for a solution to keeping your books open during a read, you might have considered using a book weight. In this video tutorial, the author will be showing you how to make your very own homemade book weight using a few inexpensive house hold products. The entire procedure can be completed in about 10 minutes, and all you need is some uncoated lead shots, a bag of lentils, a zip lock bag and a sock. You will also need either a sewing machine or a needle and thread to keep the ...
Adam Harrel a lead master instructor at Jim McLean Golf Academy is going to help improve your golf game by showing you how to improve the use of your delivery position in your golf swing. The delivery position in your golf swing is when bringing the club down to hit the ball the club is parallel to the ground. Some tips to improve is first your right knee and right arm should be bent inward and on the same line, reverse is true if your a lefty. Common problems of getting t far on your back le...
Bill D, lead tech at All 3 Sports, shows you how to remove the rear wheel of a bicycle in a few easy steps. This task is daunting to most triathletes around the world.
In this video, the instructor shows how to factor trinomials. An equation is a trinomial if it has three terms. If you factor a trinomial, you are left with two binomials which are the factors of the original trinomial. Multiplying them would result in the original trinomial. Now factor the last numerical term such that the sum or difference of those factors gives you the numerical coefficient of the middle term. Now split the middle term according to the factors obtained in the previous term...
This video questions whether or not the writer should stay with her boyfriend who is living with his last girlfriend. The advice given is it's dangerous. If you truly love this guy then you want a personal relationship with him. It’s going to be hard with him living with his last girlfriend. He may be truthful about not wanting to be with her. On the other side of the coin it would be so easy for him to accidentally slip up. Since the ex-girlfriend and he have been down that road before it wo...
We need a pen, thread or twine, small stick or wooden skewer, and scissors to make a mini bow and arrow.
Without good navigational skills, your expedition could lead to failure or result in a dangerous situation. Try to use a laminated map which is better in wet conditions. 1:25,000 scale maps provide the greatest detail. One grid square equals 1 kilometer. Use map keys for reference. Don't mistake boundary walls for footpaths. A compass points to magnetic north and the top of the planet is called true north. Magnetic north is constantly moving and its position relative to true north is differen...
In this video the instructor shows the different methods of solving quadratic equations. There are many methods to solve quadratic equations each with its pros and cons, each method suitable for a particular situation. The first method to solve quadratic equation is factoring. The advantage of using this method is that it is quick and easy. But the problem is not all equations can be factored very easily. This method requires a lot of practice and intuition. Use this method when the discrimin...
In this video, Mike shows us how to throw a curve ball with the right grip. The instructions to be followed are quite simple but also needs concentration on the gripping while throwing the ball. Playing of baseballs leads to a great practice but here you first need to focus on the gripping of the baseball. The ball is held on the inside seam with the first two fingers on the inside seam and thumb on the bottom forming a C. When you are about to throw a curve ball, instead of holding your ball...
There are few greater additions to your guitar playing vocubulary than Led Zeppelin's "Stairway to Heaven." This instructional video demonstrates how to play the classic rock song with a few easy steps. Legend has it, that if you play the song perfectly Jimmy Page himself will appear out of thin air and jam with you--not really, but this acoustic guitar lesson is still very much worth your while.
To break up with your long-distance boyfriend and still be on good terms with the guy is hard, but you need to be honest tell him exactly how you're feeling. Say what you have to quickly, and tell him it's not working out how you want it too. Tell him it's not satisfying you, and that it is not the type of relationship that you wanted or would be capable of continuing. Let him know that having a piece of him from a long distance is not cutting it and you just can't do it anymore. Don't lead h...
If you have an older Mac with a Magic Scrolling mouse and you'd like to enable scroll momentum on it, simply follow CompHelp's video tutorial. Now, don't expect a simple, just-click-a-setting solution here: you'll have to copy some code from the video and run it in the terminal in order to enable the scrolling feature. Despite that, the author leads you through the steps steadily and doesn't get you lost. So go ahead, get your older Mac in order and watch the video!
EggBram walks you though changing background colors in Xara3D and shows where to find the transparency setting. This is a simple walk through in high detail, very visible. Xara has been a part of internet development from the very beginning. Xara one of the original Internet service providers when it came about in the 1990s. Xara does most of its work online and has millions of customers online around the world. Xara Online is a leading edge online web service that gives you solutions for a m...
Gary Bunzer the RV Doctor shows how to avoid potential RV problems by cleaning your electrical hookup cord. Before you connect your RV to an electricity supply, make sure to clean and brighten the metal contacts on your shoreline cord. Use fine-grade steel wool to clean all surface corrosion off your cord's prongs. You can also use sandpaper, emery cloth or any other gentle abrasive. After you get the metal prongs clean and shiny, use a dauber or brush to coat the surface of the prongs with a...
In this instructional dance video, learn how to perform the famous "Salsa Disco" dance move using different amounts of spin. A lot of dancers get caught up in the fact about knowing very little moves, but in reality, by adding doubles and triples in their current salsa dance combination - they become almost new.
One of the many features that comes with the 2010 Toyota 4Runner is Rear Parking Assist. To use this feature, press the button to the left of the steering wheel that is marked P. The system will beep and the green LED will be lit, confirming that the feature is turned on. When the car is put into reverse, the parking assist will start beeping. As the car gets closer to an object, the beeping will gradually get faster and faster. When the car becomes very close to an object, the beeping will b...
It is a tutorial that explains the basic guidelines of Nikon D40 and D40x cameras. This enables everyone to take photographs successfully and prepare the camera for use. Attach the lens of the camera by rotating towards the right; make sure that no dust gets into the camera. Then remove the protective cap from lens and align the white dot on the lens with the white dot on the camera's body. Turn to the left until it clicks in to place. First, we must charge the camera's battery; when the LED ...
Simone Harvey's training for boxing is really an eye catcher. She teaches about the hand-eye coordination, speed and shoulder balancing. The pace of speed she maintains while kicking the speed ball is perfect. For the beginners, usage of one hand to kick the speed ball is a good method of training. This automatically leads in kicking the ball at a greater speed by using two hands. The training induces the viewers, who have less knowledge about boxing, to get trained with Simone. This is a ben...
Select Toyota 4Runner models are available with two 120-volt AC power outlets. To use this feature, the engine must be turned on and running. Press the AC switch to the left of the vehicle's steering wheel. The LED will be illuminated when active. One outlet is located in the center console. The other outlet is at the rear of the vehicle in the cargo area of the Toyota 4Runner. Use the outlets as needed.
Would you like to learn how to draw amazing anime cartoons? This excellent and entertaining video demonstrates step by step how to draw a flawless female anime face in 3/4 view. It discusses the challenges of 3/4 views, how to practice difficult facial drawing techniques, and offers helpful tips on how to produce anime drawings that really stand out. It provides helpful tips on proper pencil and lead choice to quickly and easily get fine, clean and perfect lines that are a must for modern ani...
Watch this amazing tutorial on how to play "Crush Crush Crush" by Paramore. Paramore is an American rock band formed in Franklin, TN back in 2004 with singer Hayley Williams leading the band as the only female. Crush Crush Crush is a song that was released on their album The Final Riot back in 2008. This song is geared more towards acoustic guitar players but some notes could be adjusted so that you could play on bass or electric guitar and still get the same sound.
Cut out the core of the onion - where the root comes out. This is the section that has the most tear-inducing properties. Soak the onion in water before cutting - water will dilute the sulphuric compounds -or else, freeze the onion before cutting. The sulphuric compound that leads to tears will not react as quickly when it's cold. However, don't freeze it for too long because it can affect taste. 10 minutes should do it. Cut the onion in a well-ventilated room. Give the fumes a chance to esca...
Finding horizontal asymptotes is very easy! Not all rational functions have horizontal asymptotes. the function must satisfy one of two conditions dependent upon the degree (highest exponent) of the numerator and denominator. If the degree of the numerator is equal to the degree of the denominator, then the horizontal asymptote is y= the ratio of the leading coefficients. If the degree of the denominator is greater than the degree of the numerator then y= 0. If the degree of the denominator i...
Every woman wants herself to look beautiful and fresh from morning to evening but some may not find time to do a make up because of their busy schedule, this video give a tip on how to make up with in 10 min and make yourselves look attractive.
Thebiketube will show you how to prep spokes to build a bike wheel. Prior to lacing the wheel prep the spokes. it provides a lubricant that dries and becomes a lead lock. Use linseed oil, found at an art store or a spoke prep. Use a separate color for the sides so you don't mess up. Use a separate color for the drive and non drive side. Take a little and put it on all the spokes. You will have to do this for all 18. Then let it dry.
In this episode of Science Theater Dr. Carlson helps you understand the concept behind Density and how it relates to Mass and volume and how to calculate the Density of a substance if its Mass and Volume are known. The Density of various metals is demonstrated using aluminum, tin, zinc, lead and copper of the same mass but different sizes. The easiest way to measure the density of a substance is also mentioned. Next, Dr. Carlson measures his own density using a scale and a bathtub.
Learn exercises and information to help underweight people gain weight. Jack Lalanne cites poor nutrition and lack of exercise as the reason for being underweight. He recommends the correct balance of vitamins and minerals to help combat the poor nutrition that leads to a low body weight. He also recommends whole grains and many other natural foods to correct a personal weight problem. Lalanne believes that exercise is a normalizer that helps correct weight for both the underweight and overwe...
This video is a discourse about saltatory conduction in the neurons. According to the author, it begins with the opening of a gate on the membrane of one of the dendrites of a neuron, and positive charge enters through this gate. The positive charge spreads throughout the cell, and gets dissipated as it spreads, so that, by the time it reaches the Axon hillock of the neuron, it is left with very little potential. However, the potential which results from the simultaneous excitement of many de...
