The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the 3 default sheets. This video puts the macro in a module. The procedure starts with typing sub and a name which can be easily recalled. The rules for naming the macro are also covered briefly. After the macro code is writ...
Is the spacebar on your keyboard out of whack? This simple video will show you how to re-seat it in less than two minutes. Start by using your fingers (or a small screwdriver or spudger if needed) to gently pry up along the top of the spacebar, working from one direction to another. Continue working along the top until the key is free from its mounting clips. Observe the location of the mounting clips. After the key is free from the keyboard, you can also remove the metal support bar from the...
Nichole Young demonstrates how to hand color using layer masks in Photoshop CS4, which also works in Photoshop CS3. The procedure can be summarized in two stages: turning the picture you would like to edit black and white and then bringing color back into it to give it a hand-colored look. The black-and-white effect is achieved by creating a new layer over the background layer. The next step is to give the picture a warm look by adjusting the layer’s respective color balance. Then bring the c...
The metal clay must be completely dry before you begin the torch fire procedure. Set up your work space in a well-ventilated area with your metal clay on a fire brick. Start your flame and move around the piece in a circular motion, not staying on one point for long. You might see little flashes of flame. Don't panic. That is to be expected. Time yourself for about a minute. Your metal clay should take on a peach color. It is important not to use a butane torch and metal clays that contain or...
In this video tutorial, viewers learn how to tie a scarf into a bow. Begin by finding a long rectangular scarf of your choice. Now slightly twist it up a bit. Then put it on the neck and wrap it around from the back once. Finish the procedure by tying the ends into a bow. To make a bow, create 2 loops and cross them over each other. This video is very simple, easy and fast to do. This video provides step-by-step instructions for viewers to easily understand and follow along. This video will b...
This video details how to survive a knife threat from behind. When threatened from behind with a knife, do not attempt to move the body first, this will result in the attacker maintaining the capability to thrust the knife into the body. When threatened, place arms out and low in a submissive position, this is to be followed by moving the left arm backward in a sweeping motion to push aside the arm which is holding the knife. Once the arm is moved, turn the body and bring the elbow up into an...
Making cold brew coffee can be done simply with only a jar, water, a coffee filter, and ground up coffee. Though it seems like it would be more complex, the procedure to making cold brew coffee can be easily achieved in just a couple basic steps. The steps do not require too much work and can be done in a matter of minutes. Simple measures are taken to making cold brewed coffee, such as by mixing the coffee and water through shaking up the jar. Using a coffee filter, just pouring the mixed gr...
This is a video about "How to Hack: Demolition City 2" by Travis. This is a flash game. To begin hacking, go to the game and enter the first level. At this point, you do not have any cash. Specify that you are using Mozilla in the cheat engine. After you have completed the first level, write "double" variable in value type and then type the value for the first level, and you can easily notice the game appearance seems to be changed, because the second level of the game consists of first level...
In this video tutorial, viewers learn how to fix the XBox 360 "red ring of death" using a heat gun. To begin, users must disassemble their XBox 360 console. Users will be doing this procedure on the motherboard-heat each side for 4 minutes. Then let the motherboard cool down for about 6 hours. Finally, add some thermal paste on the GPU and CPU of the motherboard. Once finished, reassemble the XBox 360 console. This video will benefit those viewers who have an XBox 360 and want to fix the "red...
This is a fantastic video, which guides us how to adjust auto play setting in our laptops. It shows systematic moving snapshot demonstration of the auto settings procedure of Windows 7. The speaker tells us to go to the start menu and then click on the control panel. Inside the Control Panel click on the Hardware and sound menu, which will open a new window, and then click on the Auto Play option? The window that opens now gives us several options to choose when we insert different types of d...
This video teaches you how to tie a blood knot which is used to tie two lines together in a very strong knot. Fly fisherman use this knot for making their own fly leaders. Wrap the right line around the left line five times. Take the end of the right line and put it in between the left wrapped line and the back of the right line. Wrap the left line around the right line five times, repeating the earlier procedure. Make sure you bring the line up through the hole that is created in front of th...
The video describes a method of doing the twiddle scratch on a DJ turntable. The sound one gets is like a double-click flair, as it’s similar to the double-click flair. In order to do the twiddle scratch, keep your stronger hand (the hand u frequently uses) on the dies while your other hand is on the log. Keep your thumb against the log lightly, and tap back and forth with your two fingers while scratching the disc with your other hand. The whole procedure is given step by step.
This video shows us how to create an amazing 3D design using a single sheet of paper. You will need: cutter printed template of the 3D design. Procedure: Download the template using this link. Print the template. Cut all the solid lines on the template. Fold all the broken lines on the template as shown. Arrange the paper in such a way that it looks like the 3D design shown on the video. Follow these steps and you will have your very own amazing 3D paper design!
Bill Myers shows us how to record live video direct to your computer from your camcorder. You will need: long firewire cable, camcorder with firewire output, computer. Procedure: Connect one end of the firewire cable to your camcorder, then connect the other end to your computer. Start your video editing program. Turn the audio down on your speakers to avoid feedback. Turn your camcorder on then check the capture option in your screen. Record the video then hit the stop button when you're fin...
This video shows the procedure to draw a face. The video shows various stages to draw a face. These include drawing an egg on the paper, dividing the egg into various parts by horizontal lines, drawing the nose and lips, drawing the eyes and ears. The video cleverly deals with issues relating to the evidence of not being a professional. The video shows the various choices that can be made by the artist in drawing the face like the pencils to use.
This video makes you understand Flash Cookies and teaches "How to remove them" to keep your privacy.
Ingredients required: 1)3 eggs
This video shows you how to make a crunchy shrimp sushi roll. The first step is to roll out the rise of a stick roller. You then lay seaweed down over the rice and add the type of meat of your choice to the roll. You then use the roller to compress all of the content together correctly. You then cut the roll into 16 identical pieces to complete the procedure. This instructor has many other videos on similar ways to make this type of sushi.
This video demonstrates the procedure involved in writing an uppercase "G" and lowercase "g" in Copperplate. You will need a writing utensil and something to write on. In the video, a nib and black ink were used on lined paper. The letters should be written slowly and carefully to avoid errors. The video may be useful for people who want to learn how to write a "G" or "g" in Copperplate style. After watching this video, a viewer would know how to correctly write a "G" or "g" in Copperplate.
You can remove upper lip hair easily and safely in a few minutes. You must clean the upper lip first remove the oil and makeup. Put a small amount of wax on your hand using a flat wooden stick to test the wax temperature. Hold your skin towards your ear and apply a small amount of wax downward to one side of the lip. Place strip over the wax and press gently a few times. Remove the strip upwards removing the hair. Repeat as necessary. Do the same procedure with the other side of the lip. Remo...
This simple video tutorial teaches you how to change the pivot point position when using Flash. The tutorial handles drawing basic shapes, such as squares and rectangles and converting them to movie clips.
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
Studying to be a nurse? Then follow along with this nursing how-to video to learn how to start an IV on a live person. Starting an IV is an important and common part of a being a nurse. Follow along with this video to learn the proper technique and procedure for starting an IV line. Before starting, always make sure to double check your the doctors orders and have your materials handy.
Going to be a nurse? Then here are a few things you should know how to do. Follow along with this nursing how-to video to learn how to insert a nasogastric tube in a live person. Watch the demonstration of NG insertion on a live patient. Once you pass around the septum ask the patient to bend their head forward to advance the NG tube into the stomach. Practice inserting a nasogastric tube on a manikin during lab to perfect this technique. And remember to always have your equipment ready befor...
Altering the preloading screen in Flex 3 sure can be complicated, to say the least. Wouldn't it be awesome if the whole process was easier? Maybe if someone made, I don't know, a tutorial that walked you through the steps so that even a beginner could understand the procedure. Wouldn't that be fantastic? We thought so too... so here it is. Watch and learn how to change the Flex preloading screen in this programming tutorial.
This motorcycle maintenance video shows you how to change the oil in a Kawasaki KLR 650. You do not need to remove any body work to change the oil. The procedure is the same for all years of KLR 600 and 650 (thank you fixer). So watch and learn how easy it is to change your own oil in the KLR650.
This four-part video tutorial gives a step-by-step procedure on how to close an in-ground pool over the winter. This video explains all the necessary chemicals needed to keep the pool clean over the winter as well as all the tools and covers needed to close the pool.
After you've taken the gun away you have to create distance from your attacker. This is the fifth and final step in surviving a hand gun attack. The series also gives a few final tips on how to decide when you should use these procedures.
BD Quikheel Safety Lancet The BD Quikheel Lancet is a safety-engineered product designed for heel sticks on infants and premature babies. It features a sweeping surgical blade that permanently retracts after creating an incision. Additionally, it offers a tapered window providing the healthcare worker with the ability to accurately position the lancet.
Check out this video tutorial to see how to use the BD Genie Safety Lancet blood sampler device. BD Genie Lancets are high quality, safety-engineered, single-use capillary blood sampling devices. They offer a permanently retractable blade or needle feature that minimizes the possibility of injury or reuse. BD offers a full range of blade depth and needle gauges for sufficient blood volume in multiple sample requirements. All Genie's can be used in conjunction with BD Microtainer Tubes.
Check out this video tutorial to see how to collect blood with the BD Vacutainer Safety-Lok Blood Collection Set.
Even those with hearing impairments need to know basic first aid procedures, because everyone, including deaf people, can save a life one day. People may collapse unexpectedly for a number of reasons, and people who faint periodically, or those who suffer frequent seizures or from epilepsy need help from others, so it's important that everyone know the proper first aid procedure for saving a collapsed victim casualty.
First you make the crust by putting a bowl of flour and a bowl of brown sugar together into a large bowl. Whisk the flour and brown sugar together in the bowl. Next add two sticks of margarine cut up into smaller pieces. Use a pastry cutter and work the butter into the mixture until you have a bowl full of small uniform chunks. Next pour the mixture into a parchment lined baking pan. It will look really crumbly but that's okay. Once it is poured into the pan use your hand to smooth it out and...
Whitewaterinstruction.com presents a lesson on Paddle Awareness by Shane Benedict.
For about a million Americans each year, a joint replacement brings relief from pain and restored mobility. But, 5–10% of those people have to endure another surgery within seven years, and most of those are due to an infection in their new joint. If doctors could treat infections more effectively, patients could avoid a second surgery, more pain, and another rehabilitation.
I don't know anyone that likes going to the dentist—few things are more uncomfortable than having someone else's hands in your mouth. But outside of that, not only can the pain of certain procedures be unnerving, the drugs used to numb those pains can be just as uncomfortable. Not being able to feel your mouth for hours on end is a disconcerting feeling. But all that could soon be a thing of the past, thanks to virtual reality.
The term blog is a shorthand for web-log. It can be considered as a online and publically viewable diary of user generated content usually sorted by date.
This video begins by showing what a folding painting canvas looks like and what the final stretched canvas should look like. The first step shown is to make sure the bars are measured and marked with a simple A and B for easy measurement recall. After a wood frame is added over the canvas you must fold the material over the back of the wood and nail in place. Once the canvas is nailed to the frame you must add A, B, C and D markings to continue proper alignment procedure. The last step shown ...
ISO recorder is a freely downloadable software that can be used to create ISO images of CD's DVD's. The very format of these images allows for easy replication, storage and virtual mounting using appropriate software.
This video tutorial is in the Sports category which will show you how to adjust your front brakes on your bike. The brake pads are very adjustable. It has 360 degrees rotation which helps in installing it on the bike easily. First install the brake arms. Then loosen up the brake pad screw and lower it to bring it in line with the rim of the wheel. Now hold it in place and tighten the screw. Thereafter you can any vertical and horizontal adjustments. You can then repeat the same procedure for ...