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...
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.
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...
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.
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....
Stabilize your sacroiliac joint with the side split Pilates routine demonstrated in this video clip. 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 instructions, give this free ...
In order to develop ballet turnout, it is important that you remember that relaxation is the key. Your hip joint must be loose and relaxed at all times, since all movement is done based on turnout.
If you plan on making any kind of cabinetry or beds or anything else like that, having a dado blade is a useful and handy tool. What this does is make a u-shaped cut into your piece of wood that is perfect for combing two pieces together to form a sturdy, solid joint. So if you want to find out more about dado blades and how to install and use one check this tutorial out. Enjoy!
Screen recording should be easy, right? So why can't you figure out how to edit your video in Camtasia 7? Well, you probably know the basics, but just in case you need a little help learning the editing must-knows, this video will show you how… learn to edit and cut video and audio in Camtasia. One of the main things you'll probably want to know is can you cut the audio and video indecently, or will it always be a joint venture for the two? Yes, you can easily edit the audio and video separat...
The iPhone is great. And so is Google Maps. And together, they define mobility. They go together perfectly. Like yin and yang. But how do you get the most out of Google Maps on the iPhone? Best Buy has answers. The Best Buy Mobile team explains how simple it is to use Google Maps on your Apple iPhone for directions.
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 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW 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 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT 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 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.
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 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.
