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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...
This video tutorial belongs to the Autos, Motorcycles & Planes category which is going to show you how to replace a power lock on a Ford Excursion. This activity is neither easy nor cheap. But, you will save a lot of money if you do it yourself. Before starting you got to remove the side paneling, speakers, outside door handle and insulation. Then you remove the door lock system. Remove the cable connectors and replace the solenoid unit. Now you can check that the power lock is working and th...
For the first part, make chroma key blood: Ingredients: glue, flour, mix with water like papier mache, three drops of green and two drops of yellow food color. This combination gives more of a fluorescent chroma key look.
Accidents happen all the time. When these accidents happen, things tend to break. When an accident happens with a vacuum cleaner, it's usually the handle or bin lid that becomes damaged.
In this tutorial, we learn how to wash your hands the correct way. First, let the water run for a few seconds until it gets hot or warm. After it's done warming up, run your hands through the water, make sure to get your wrists wet as well. Next, apply a quarter sized amount to your hands and scrub through your fingers as well as underneath your fingernails and around your wrists. When you are finished scrubbing, rinse your hands with the warm water and then pat dry with a towel. If you are i...
Importing custom brushes and patterns into Photoshop is not too complicated, you can probably handle that already. But what if you want to create your own? This video will teach you how to create your own custom brushes and patterns within Photoshop, which you can then use yourself or make available to others on the web. The former will save you lots of time when you find yourself making the same pattern over and over again because you can make a brush that will draw it automatically. How handy!
Blender’s curves tools are quite a powerful and convenient way to model all kind of things. Tubes, lathe-objects, logos, tentacles and much more. This tutorial shows you how to use the different types of curves, control-points and handles and how to use them. You will learn how to trace a logo and to give it some depth, and how to create lathe-objects within Blender and add some variations to them by using the lattice- and the cast-modifier. Whether you're new to the Blender Foundation's popu...
Stop serving a scoop of ice cream and put some effort into your next dessert dish! Steal this recipe from Sue McMahon, cookery editor at Woman's Weekly, for a delicious chocolate ruffle cake. To make this ruffle cake you will need about two-and-a-half hours and the following ingredients:
The University of Michigan teaches you how to use nasal irrigation to get rid of common nasal sinus symptoms without reaching for those over the counter medications. The best part of nasal irrigation is that it handles conditions that medication cannot - such as post nasal drip and the common "stuffy nose". This can work for most allergies, even if you are already on medication. Water used for nasal irrigation should be luke warm and should contain about a quarter teaspoon of salt into an 8 o...
This video illustrate how to boil water without pots or pans. Here are the following steps:Step 1: You need fire, water and any plastic container with lid.Step 2: Now take water and fill it in the bottle so that there is no air present in the bottle.Step 3: Now put on the fire and put the seal bottle on fire with a distance of around 12 inch.Step 4: Now let the heat warm up the bottle and be careful while handling the bottle.Step 5: After the water has heated up, bubbles will appear in the bo...
John White shows how to clean and sharpen your tools by using a file and WD40. He also advises to repair the wooden handles of your tools to prevent injury. Run the file along the back and sides of the shovel. Leave the front part smooth. Make sure you remove any mud to prevent corrosion. Use steel wool to achieve this as well as WD40. Use the file to sharpen the edges of your hoe and again clean with steel wool and WD40. The file is also useful for sharpening trimmers. Clean all the dried pl...
This great series of videos teaches you how to handle different terrain while riding your cycle. It gives different techniques and tips to really master your cycling skills.
This is a video demonstrating how to open a can with a Swiss Army Knife can opener. To begin, place the can on a flat surface. Open the can opener on the Swiss Army Knife. Make sure that the hook of the can opener is on the outer ring of the can and that the cutting part is on the inside. Use the blade to puncture a hole in the can, pulling up on the handle and pushing the blade along the can. Move the can in a counter clockwise motion cutting along the way. Use the tip of the can opener to p...
Properly measure liquid and dry ingredients Diane Morgan describes the basic technique for measuring ingredients, which is critical to baking. There are two types of measuring cups, one for liquids and a different type for dry ingredients that need to be leveled off, such as flour or sugar.
On this video from Bushcraft Machete, he explains the purpose of a scandi edge and how to use it. He uses the machete as a planer, stripping the bark from a log by holding the machete almost flat against the log and tapping the back of the blade with a stick. He explains that a scandi edge is sharpened all the way down to a point and has a very low angle. This type of edge makes the machete useful for carving off thin strips of wood. He has sharpened his machete with a scandi edge near the ha...
This video teaches the viewer how to hard boil eggs. Insert the eggs into a pot of water at room temperature. The water should come two inches above the egg. With the pot on the stove, turn your heat setting to simmer. They can boil for 2 to 3 minutes for soft boiled eggs and 7 to 9 minutes for hard boiled eggs. When the eggs are done boiling, put them in a separate bowl. Pour cold water into the bowl and allow the eggs to sit. When they are cool enough to be handled, you can peel the shell o...
In this video, Steven Marin shows us an interesting method to recycle old CDs to make beautiful flower arrangements along with other recycled materials. In order to make the flowers, you need to take your old CDs and heat them up in a toaster oven. As demonstrated in the video, the CDs are very hot when they are taken out and should be handled with care. They are easily molded into the interesting flower shape by pressing them down over the neck of a bottle or by holding them in a cloth and s...
In this tutorial you'll learn how to make a cardboard shield, quickly and cheaply. All you need is some stuff you've probably already got around the house. Get to work, so you'll be ready to defend yourself against any barbarian invaders with cardboard swords!
In this tutorial, you will learn how to model this cool looking diving knife. The model can be set apart into two pieces, blade and handle. Both having some nice features.
Go beyond the traditional 3D workflow to an immersive creative experience with the software Modo, created by Luxology. Modo is the next evolution of 3D modeling, painting and rendering for Mac and PC. Modo includes 3D sculpting tools, animation and network rendering, and advanced features such as n-gons and edge weighting.
Instead of using Photoshop, why not give Apple's Aperture a try? Aperture is designed more for post-production work for professional photographers, letting you cull through shoots, enhance images, manage massive libraries, and deliver stunning photos.
Watch this video tutorial from the Polish Guy to see how to clean and polish Ford Ranger alloy rims using Autosol Polish. In this polishing tip, we polish an alloy wheel on a 2004 Ford Ranger 4X4 pickup truck. The tutorial includes detailed work instructions and best practices.
Here's a quick and simple booklet that can be made out of two sheets of paper. It's great paper craft for a school project or just fun. All you need is paper and scissors. Fold both pieces of paper in half hamburger style. Use scissors to cut knotches into your fold. Fold your other piece of paper hotdog style. Follow the rest of the instructions, assemble and you have a quick and simple paper booklet.
So you've done it. You've been wanting to have your own jewelry business since you were six, and you finally saved up enough money to purchase all the materials and are now making more moolah than you can count with your on-trend wire wrapped earrings. But how do you handle packing and shipping so many orders without going crazy?
If your bathroom faucet is old and leaky, it may be time for a replacement. But don't worry about expensive installation cost, because you can install it yourself! It's one of the easiest home maintenance repairs possible. Chrysten Cotney shows you the step-by-step DIY process of successfully tearing out an old faucet and installing a new one. You'll need an adjustable wrench, some plumber's putty and a roll of teflon tape.
Jim Winter gives you a complete lesson on reading the Line of Mercury (or Mercury Line) on your hand. The palmistry meaning behind the Mercury Line deals a lot with communication and also deals with health and the liver, which is why it's also sometimes called the Liver Line or Health Line. Watch to see the complete deals for this palmistry tutorial.
In this tutorial, we learn how to cut open a coconut. Coconuts in nature look different than they do when you buy them at the grocery store. They come in green, orange, and yellow. The white ones you see are shaved off before you buy them at the store. To open up a coconut, you are going to need a machete, which is a very large knife. Make sure the knife is sharpened, then hold the coconut on the handle and slice it at an angle using the machete. Use force when cutting so the coconut comes op...
If you're ever stuck in the jungles of Southeast Asia, then your only hope for survival is the parang knife, which is a Malayan type machete. This is the ideal tool for the jungle, especially in Malaysia, where the typical vegetation is more woody, and needs something thicker for stronger chopping action. A parang has three different edges: the front is very sharp and used for skinning, the middle is wider and used for chopping, and the back end (near the handle) is very fine and used for car...
In order to fix a broken power window, you will need the following: a screw driver, a socket wrench, a plastic pry tool, and a Phillips head screw driver.
In this Autos, Motorcycles & Planes video tutorial you will learn how to inspect hail weather car damage. Paint loss dent repair is the most common method used for this purpose. The first thing to do is to count the number of dents based on half dollar, quarter, dime and nickel size. All you need to do is to place the coins over the dents and count how many dents are there of various sizes. Once you have this information, you are on your way to handle the hail loss assessment correctly. If th...
In this how to video, you will learn how to dual boot Windows 7. To do this, first back up your hard drive. Download the Microsoft Windows 7 adviser to see if your system is able to handle the operating system. Next, download and burn the Windows 7 64 bit ISO. Shrink your existing partition to at least 16 GB. Next, insert the Windows 7 CD and reboot. You should make sure that you can boot from the optical drive. Once that is done, you can begin installation of the operating system. When it is...
This video shows us a tool that can be used to split and merge pdf files without having to buy any software.
The Amazing Origami channel takes you through step by step instructions of how to build a triangle origami box in this video. Six pieces of origami paper, three different colors, are all the supplies you will need to make your very own box! First, separate the origami paper into two groups of three, all three colors should be in both groups. These groups will make the top and bottom of your box. The three pieces of paper used for the bottom will all use the same folding technique, this is als...
Using multiple layers of clay, garden of imagination shows how to make a hamburger and fries out of polymer clay. This decorative item would then be placed into a miniature dollhouse being displayed as a food item. She rolls a peppercorn on brown clay to give it the texture of meat. She mixes together green and whit clay for lettuce, and uses another piece of clay to ruffle the edges of the lettuce. She uses small round cuts of clay for tomatoes. Using an embroidery needle with a clay handle ...
First cut out card stock using the Big Shot Dye. This card stock is great as a template to make sure you are getting the most out of your felt. Cut out pieces of your felt around your card stock template trying to get as close as you can to the border of the card stock. Next take your Big Shot machine and place your cutting plates on the bottom, as well as your dye. Then layer your cut out felt pieces on top of your dye. Start rolling your felt through by cranking the handle on your Big Shot....
In this video you will learn how to build a LEGO stroller. The materials you will need are 4 of the small slanted bricks, one two by four thin brick, 3 two by 1 thick bricks, 2 one by one thin bricks, 2 one by one by four studded bricks, a small smooth brick, two odd angled smoothed bricks, 4 wheels, one one by two with dot in center bricks, and one one by two handle bricks. Then after carefully assembling the bricks as shown he will show you a example of what it will look like when you're fi...
Chopsticks are widely used in eastern countries and suffices as a great alternative to most western eating utensils. Chopsticks may be super cool to use but they can also be quite difficult to handle. This video will show you exactly how to eat using chopsticks properly.
Robert Scot, from ModernMom, shows viewers how to shrink an enlarged skin pore. Scott reminds us that genetics and aging do contribute to enlarged pores and skin condition, but there is still a way to deal with this. There is no way to permanently shrink enlarged pores but you can handle them with time. You can use cleansers and exfoliation to do the trick. Your cleanser should be for oily skin that will naturally purify your skin. You really want to focus on exfoliation and use exfoliates wi...
This video tutorial is going to show you how to steady your shots with a homemade fig rig. The camera is mounted right in the middle of the top bar and it uses the iron as the balancing mechanism. The official fig rig is about $300. But, the one shown in the video will cost you around $10. Cut a PVC pipe about 2 feet in length and glue on two T joints on either end parallel to each other. Now fix the two feet into the T joints as shown in the video. The larger the camera, the longer will be t...
Whenever deciding to use fields in FileMaker Pro 10, some fields require special handling like the date field. Date field is able to store any date between 1/1/0001 to 12/31/4000. It stores dates in the form of whole numbers. Now, to create a date field, it shows at the bottom of your data and date can be stored. The format of the date can also be changed. One can add dates as well as get the number of days elapsed. This is quite flexible in terms of format as well as keeping records.
