In this video, we learn how to perform a backward wristlock: Omote Gyaku. This is a basic move that can be done in different variations. First, place your thumb on the back of their hand and turn the wrist around. After this, turn it sideways and turn it up and over. Doing this will twist the wrist and lock it so the opponent falls down to the ground with pain. Just a small amount of force sets off a chain reaction in all the joints in the entire body. Once you have this down, it's a very eff...
In this video, we learn how to do parkour rolls. You will first drop to your right knee then reach your left arm through the right leg. Make sure you are tucking in and you're in a rolling position while you're doing this. Make sure you practice it from different heights so you don't get injured. Also make sure you are wearing supportive shoes and you are on grass so your joints don't get injured. If this starts to hurt your knees or back, it's not recommended to do this at all. Once you've g...
In this tutorial, we learn how to play the "a" note with fingering. First put your head joint into the main body of the flute, then grab it so the end is in the palm of the hand. Slowly turn it so it goes into the flute easily. Now, line the hole up so it's equal with the center of the keys and hold the flute correctly. Hold your fingers onto the flute so all your fingers on the right hand are up except for your pinkie finger. Your third finger on the left should be on the 'a' key and the two...
This clip offers an overview of a Pilates exercise routine that puts vectors of force through the hip joints and pelvis. With pilates, as with any physical fitness system, a basic mastery of proper technique is essential for both maximizing the effectiveness of your workouts and avoiding accidental injury. Whether you're looking to slim down or merely tighten up your core, you're sure to be well served by this home fitness how-to from the folks at Balanced Body Pilates. For complete instructi...
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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.
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 and Mr. Excel, the 23rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKINGDAYS.INT, RANK.AVE, PERCENTILE.EXC, CONFIDENCE.T, T.DIST, T.DIST.RT and T.DIST.2T functions in MS Excel.
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 and Mr. Excel, the 22nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use VBA code for conditional formatting as well as how to do it using the OFFSET, MOD and ROWS functions.
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 and Mr. Excel, the 20th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to summarize survey data with a pivot table (grouping & report filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function.
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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...
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 and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
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 and Mr. Excel, the 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.
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 55th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate probabilities with a pivot table (PivotTable). Specifically, you'll learn how to find joint, marginal and conditional probabilities.
This video by Matt Wright will teach you the easy way on how to truss and roast a chicken. Matt likes his roast chicken with a lot of pepper and salt on the outside. He seasons the insides of the chicken with a generous helping of fresh chopped rosemary, coarsely ground sea salt and freshly ground black pepper. Then the joints of the chicken are rubbed with the seasoning. The chicken is trussed up by bending the wings backwards on the body and tying a string across the breast and over the win...
In this video tutorial, viewers learn how to solder speaker lead wires. Soldering is a process in which two or more metal items are joined together by melting and flowing a filler metal into the joint. Viewers are shown how to solder speaker lead wires to the terminals. This video also shows how to solder two wires together and how to solder a wire to a slip on terminal. This video will benefit those viewers who want to learn how to solder and be able to repair other electronic devices.
This video is about how to make duct tape flip flops. For this you need cardboard, scissors, and three different colored tapes. Follow a few easy steps: cut two identical slipper shapes out of cardboard. Paste the first colored tape on the cut pieces. Fold second colored tape three times to make it thinner. With the help of the scissors create a hole and pass the second colored tape through it. Paste the tape at the back. With the last tape, strengthen the joints above the hole.
Ron Hazelton brings you this video on wainscoting. Wainscoting is paneling that runs about a third of the way up a wall. Ron shows you how to use a chair to figure exactly where to place the chair rail. When installing around electrical outlets be sure to turn off the electricity. Next cut all the panel sections to length. When you attach them to the wall be sure to attach at top and bottom. Next attach the paneling, you can use a scarf joint to hide the seams. When installing the chair rail,...
To solder copper pipes, start by using a sharp blade and scrape the end of the pipe you are going to solder. This will get all the burrs off of the pipe. Next, take some steel wool and clean the pipe so that it is nice and clean and shiny. The next step is to apply some flux. Use a rag to apply the flux to the end of the pipe. You want to make sure that the flux goes all the way around the pipe. After putting flux on the two pieces of pipe, put them together using the fitting. Take the blowto...
Muay Thai, a form of kickboxing and the national sport of Thailand, is an intense martial art that uses not just all the limbs, but joints, as possible weapons against an opponent. This how-to video clarifies some basic Muay Thai kickboxing moves, with step-by-step instructions accompanied with demonstrations shown from multiple angles. Whether you're looking to work on your technique, or pick up a new sport, this video tutorial will help you improve your Muay Thai skills. Follow along and le...
Muay Thai, a form of kickboxing and the national sport of Thailand, is an intense martial art that uses not just all the limbs, but joints, as possible weapons against an opponent. This how-to video clarifies some basic Muay Thai kickboxing moves, with step-by-step instructions accompanied with demonstrations shown from multiple angles. Whether you're looking to work on your technique, or pick up a new sport, this video tutorial will help you improve your Muay Thai skills. Follow along and le...
Muay Thai, a form of kickboxing and the national sport of Thailand, is an intense martial art that uses not just all the limbs, but joints, as possible weapons against an opponent. This how-to video clarifies some basic Muay Thai kickboxing moves, with step-by-step instructions accompanied with demonstrations shown from multiple angles. Whether you're looking to work on your technique, or pick up a new sport, this video tutorial will help you improve your Muay Thai skills. Follow along and le...
Muay Thai, a form of kickboxing and the national sport of Thailand, is an intense martial art that uses not just all the limbs, but joints, as possible weapons against an opponent. This how-to video clarifies some basic Muay Thai kickboxing moves, with step-by-step instructions accompanied with demonstrations shown from multiple angles. Whether you're looking to work on your technique, or pick up a new sport, this video tutorial will help you improve your Muay Thai skills. Follow along and le...
Muay Thai, a form of kickboxing and the national sport of Thailand, is an intense martial art that uses not just all the limbs, but joints, as possible weapons against an opponent. This how-to video clarifies some basic Muay Thai kickboxing moves, with step-by-step instructions accompanied with demonstrations shown from multiple angles. Whether you're looking to work on your technique, or pick up a new sport, this video tutorial will help you improve your Muay Thai skills. Follow along and le...
Getting regular cardiovascular exercise is extremely important to maintain good health but it can be difficult to find an exercise that isn't strenuous on the joints. Luckily aqua jogging is a great workout for any age.
If you've lived in your house for a number of years, chances are you got yourself a drywall patch, which when sanded, will create a lot of dust in the room. Watch this video tutorial from home improvement expert Danny Lipford to see how to sand a drywall patch with a wet sponge to prevent dust.
Enterprise augmented reality developer Atheer is bringing its AR solution for enterprise businesses to the HoloLens by way of a joint venture with fellow AR developer Design Interactive.
Jeep has now jumped on the AR-retail trend with their introduction of the Jeep Compass Visualizer. Customers can now view and customize a Jeep Compass to their liking, all without a real Jeep even present.
In this tutorial, we learn how to draw hands in the anime style. When you are drawing hands, they have a square look to them. So, start out with that shape and then start to draw the fingers onto the hand. Indicate where the joints will be and then you can further elaborate with the fingers. Make sure you make the fingers the correct sizes. The pinkie should be away from the wrist, as well as the thumb. Use a line to help center all of the fingers and then draw them around this. When finished...
In this tutorial, we learn how to draw Optimus Prime, leader of the Transformers. First, draw the outline of Optimus Prime, use basic lines and circles to show where the joints are going to go. After this, draw the full outline around the character, using a dark line to make it look 3D. Then, draw in the rest of the details for the character, giving him a look like a machine or a bunch of metal. Next, you will start to shade in the different parts and add colors that were used in the movie. W...
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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.
In this tutorial, we learn how to prepare the bird for buttermilk fried chicken. First, take off the wing tips, then de-joint the wings. After this, take off the wings and thighs from the body and the legs. Now, use a large clever to remove the breasts from the chicken. Now, season the pieces with white pepper, dried herbs, cayenne pepper, paprika, salt, and pepper. After this is tossed, top this with buttermilk and let it soak for 6 hours. Now, prepare flour with salt, white pepper, garlic s...
In this tutorial, we learn how to install crown molding to your room. First, choose the right size and style of molding for the room, then measure your room to find out how much you need. After this, you will need to buy a saw to cut the molding when you're ready to install. After you have the pieces cut, you will need to place these against the wall and then nail them in with a nail gun. Secure the molding to the joints in the ceiling and to the studs in the wall. To finish, putty the holes ...
In this video, we learn how to change your toilet into a silent toilet seat. A silent toilet seat will shut itself by going down slowly without the loud slam. To remove the old toilet seat, go to the back flaps and pop them up. Remove the plastic screws with a screwdriver and then set them aside. Replace this with your new toilet seat and screw the screws back into the back. Now, lift your seat and the lid up and tap them gently. After this, the toilet seat will slowly start to lower and clos...
In this tutorial, we learn how to draw Karin 2. Start out with a circle for the head, then draw in your reference line so you can align the different features of the face. After this, draw in circles where the joints of the body would be for the upper body, then draw around this using bold lines. Once you are finished with this, draw in the rest of the arms and create clothing on the body as well. Next, you will need to draw in the features of the eyes as you would like, then add in the detai...
In this video, we learn how to draw a decent horse. First, start with two circles connected by two curved lines. Next, add a sausage for the top of each leg and add a small circle for the front of the knee. Then, add another for the lower part, and add two hoof outlines at the base of each leg. Then, add the back of the hooves. Next, draw two more lines that are far apart at the bottom and narrow at the top for the neck. Then, draw two circles for the top of the head and the muzzle. Join the ...
In this tutorial, we learn how to draw a female anime or manga school girl. Start out by drawing the outline of the character, then drawing in the details along the middle and the body of the character. Use circles inside the body to create a references as to where the body joints would be. Then, draw in clothing on the body and add a sword in the hands of the girl. After this, draw in additional details to the drawing and then focus on the face. Draw in the facial details, then add the hair ...
Stretching isn't just good for humans, it's a great way to keep animals loose and healthy, especially dogs who have suffered bone deformities, muscle aches or arthritis. This video will show you how to give your dog passive range of motion (PROM) exercises on its hind legs. Perform these exercises daily if your dog has recently had orthopedic surgery or suffers from arthritis. Doing so helps maintain flexibility, reduce stiffness and increase blood flow to painful joints. For more information...
Balloons too, can be used to make complex geometrical shapes if aligned properly and made skillfully. For this video however, you would only need standard cylindrical shaped balloons.
Balloons come in various shapes and sizes and if used properly, can be combined to create complex shapes that mimic real life objects. Choosing the correct color of balloons also adds to the realism in the completed object.
In this tutorial, we learn how to make a Freddie Krueger glove. You will need: a saw, sandpaper, silver spray paint, black paint, brown paint, old glove, tin from a can, plexi glass, shiny cardboard, and a hot glue gun. Start off by using your paper roll to cut off a strip of it that will start on the joints of your hands, then cut this in half. After this, make a cut in the top of it and on the sides of it. Do this again for the four fingers, then wrap it around the glove fingers. After this...
In this tutorial, we learn how to properly build a firepit. First, prep your base by filling it with dirt and small rocks. After this, set your ring down onto the dirt and make sure it's level. You can also raise it up if you want a foot rest or beverage holder. Next, apply your stone around the ring and then mortar it. Make sure all the pieces of stone fit nice and tight together. After you've done this, lock in all the joints on the stone patio by using sand and brushing it into the middle....
