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 177th installment in their series of digital spreadsheet magic tricks, you'll learn how to format a column as text numbers to avoid data validation trouble.
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 169th installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly select an employee from a list using the INDEX and RAND and INT functions (also RANDBETWEEN).
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 155th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the TRIM function to get rid of extra spaces when a VLOOKUP function should work but doesn't.
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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP 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, the 145.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to a formula that will calculate the mode when you have more than 1 criterion.
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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.
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 138th installment in their series of digital spreadsheet magic tricks, you'll learn how to name individual cells after their cell content (i.e., the name of the cell is in the cell).
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 136th installment in their series of digital spreadsheet magic tricks, you'll learn how to do two-way lookups with the VLOOKUP & MATCH 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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.
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 91st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the FORECAST function to solve linear algebra problems.
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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to import data from Microsoft Access as well as how to use the VLOOKUP function to populate data into a printable form.
Have you ever wanted to give a Podcast maker a piece of your mind? Did they say something that really irked you, or how about something that really inspired you? In this video, learn how to write a review for a podcast in iTunes. Tell that person what you think!
This video illustrates how to clip hair extensions. 1: First of all take the hair extension and clean your hair. 2: Hold your hair all together and clip them leaving the lower most layer. 3: Now take the extension and release the clip and tie it to the lower most layer. 4: Now release another inch of the hair and again take the extension and clip it. 5: Release the crown area and carefully clip the extension by hiding the extension clip under the top most layer. 6: Leave the top most layer an...
In this video, we learn how to make a homemade facial mask for acne prone skin. First you will want to clean your face and make sure it's dry. You will need healing clay, water, a bowl and spoon. Now take 2-3 tbsp of healing clay and add desired about of water, mix together until you have a paste that's not too watery. Now you can apply your mask avoiding your eye and mouth area. After waiting for 10 minutes or until the mask is fully dry, you can wash the mask off with lukewarm water. Pat dr...
In this video tutorial, viewers learn how to build bigger breasts or pecs while doing a dish rag house cleaning. The materials required for this workout are 2 dust rags, a dirty floor and a pillow. Begin by resting your knees on the pillow and go into a semi push-up position while holding the rags in each hand. Now slide your arms horizontally out as slow as possible, until your chest touches the floor. Then return to the starting position and repeat this movement several times for a set. Thi...
This video will show you how you can increase the speed that your Microsoft Windows Vista runs by using several different methods. You can disable the transparency function and go to a basic mode. Clearing disc space will also make your computer run faster. You can just run a disk clean up. Finally you will want to do a disk defragment your computer. If your computer is running a little slower than you’d like then try doing these three things and you should gain a little speed.
New to 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 Excel tutorial from ExcelIsFun, the 294th installment in their series of digital spreadsheet magic tricks, you'll learn how to filter a pie chart.
New to 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 Excel tutorial from ExcelIsFun, the 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.
All around your house there small cracks and spaces that are letting air out of the house. You can stop the air leaks through an inexpensive way saving money from being wasted, it's called caulk. You have to select the right one for what you need, there are many different types for different applications so be sure to pick the right one. Clean the area you want to apply the caulk in and then put the caulk in the device with which you're going to use it. Push the plunger until it stops and cut...
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to work with the quadratic formula on your graphing calculator.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to rationalize a denominator.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to solve a complex radical equation in algebra.
In this Outdoor Recreation video tutorial you will learn how to pump out the waste on your boat for winter. This video is from LIBoatersClub. Take your boat to the waste disposal area and secure it. Remove the cap from the waste tank. Be careful not to drop the cap. Operating the waste disposal unit ashore is very easy. Just switch on the pump, take in some water in to the hose and then attach the hose to the out let on your boat. Hold it tight and open the valve. It will suck out all the was...
This video shows us the method to reconstruct your t-shirt with a fringe design. You will need a long fitted t-shirt, scissors and a sewing machine which is optional. Cut off both sleeves of the t-shirt. Now cut the middle of the shirt on only one side. Cut off the collar. Hem both sides of the cut so that you have a clean finish. Now take the scissors and start cutting the fringes. Open the t-shirt so that all the fringes are even. Mark the length of the strips and start cutting. Once you ha...
This video, which was made at Peopleprint Community Media in Rochdale, teaches how to easily silk screen print a t-shirt in only four minutes! First, design the artwork to be used for the print, then print it on acetate. Next find a clean screen. Put some emulsion in a coating trough and slowly and steadily coat the screen in emulsion. Then dry the emulsion in a dark room and expose the screen to light. Next wash the screen with water and the artwork should become visible. Mask the exposed ar...
This video demonstrates how to wax your car or truck. Make sure that your vehicle is clean in advance. For this project, you will need the following: McGuire's Cleaner Wax, applicator pad, and towels.
This video shows the viewer how to start a fire using a steel wool and a 9 volt battery. This is done by first selecting a charge battery and clean steel wool. The gently rub the battery terminals across the steel wool and blow gently. The wool should glow and become superheated. This happens because the battery is short circuiting and the very thin steel wool is being melted by the high current. Once the steel wool is hot it can be used to ignite small pieces of flammable material such as ki...
In this video Rich explains how to maintain a grout and tile floor. He uses a chemical cleaner which he describes as a "grout-smart type product." For regular maintenance of the floor Rich recommends using only 1oz of the product per gallon of warm water but for really badly stained floors using up to 12oz per gallon of warm water. Rich mixes the chemical into his water then applies the mixture to the tile using an ordinary deck scrubber, he then uses an angled scrubber which has bristles tha...
How to spackle a crack or a hole
Shelley Lovett from childcareland demonstrates a fun activity involving finger paint that parents can do with their children. She uses finger paints and a pan to make a virtual canvas that is self contained and easy to clean up. She first recommends that only one color be used. She indicates that by using multiple colors, it may result in a brown ugly color and therefore should be avoided. She then spreads the paint onto a flat pan. After the paint is on the pan, parents and children are able...
In this video, we learn how to remove our browsing history on Internet Explorer. First, click on "tools", then click on "delete browsing history". If you want to delete all of your browsing history, then click on that option. Most people are content with only deleting temporary internet files as well as browsing history. Getting rid of these will speed up your internet a bit. Another way is to go into "internet options", click under the "general" tab and choose which files you'd like to delet...
In this how-to video, you will learn how to put back a 2 speed central gearbox in your RC vehicle. Take the time to clean your car. Remember that the shorter dog bone goes to the rear and the longer one goes to the front. Slide the dog bone in and make sure that it spins the wheels. Now, raise the dog bones and slide them into the drive cuffs of the central transmission. Once this is done, check by moving the tires to see if the gears are moving. Make sure the box fits into the place provided...
In this video tutorial, viewers learn how to polish a car with a round orbit polisher. This polishing technique will remove the swirls on the car. Before polishing, users should wash the car and wipe it clean. Then tape the areas that you do not want polished. Now attach an orange medium cutting pad to the polisher. Apply the polish on the pad and dab it onto the areas that you want to polish. Start the polisher at a low speed and gradually turn the speed faster. Then attach a honeycomb waffl...
co23ghttoe is here to show you how to draw a manga fox girl. You first start with a circle and two lines to line up the eyes on the face. The eyes can come out looking pretty rough but with the proper use of eyebrows, it can make a "cuter" expression. You then outline the bottom half of the face, like the cheeks and the chin. Follow up with the hair by dashing your lines down her face. Finish up with her neck and shoulder line. Now is time to add the fox ears. Erase some of her head as demons...
Make sure you nails are already clean and dry. Choose you colors. Add the lightest color first. Using a makeup sponge works great to apply the fading effect. Apply to French manicure area not straight. Reapply pink polish just at the tip of the nail. Apply glitter polish over the pink on the tip of the nail. After applying the shimmer get the nail art polish and make your deign. Make sure your brush is thinned out. Add your design then you can add your gem stones and finish it off with some c...
In this video, we learn how to make a facial mask for oily/dry skin with natural ingredients. First, take a bowl and place a half of a banana in it, smash the banana in the bowl until it makes a paste. Now, take a 1/2 of a lemon and squeeze the juice into the bowl. After you mix this together, add 1 tbsp of honey into the bowl. Mix this all together very well until it makes a paste. After this, apply the paste to clean skin. After about 10 minutes, rinse this off and pat your skin dry.
To make this recipe you will need leftover bread, milk (evaporated is best, but regular will do), sugar, baking powder and egg. In a bowl, mix together the eggs and the milk. Add sugar, and mix again. Add baking powder, mix again. Now you will put in the bread and mash it all in. Then bake for 25 min or steam in your steamer. It is done when fork poked into center of pudding comes out clean. You can add an optional topping when it is finished cooking. In this video, the person spreads some me...
How to caulk the baseboards in your home
In this how-to video, you will learn how to groom your dog. Grooming is important for any kind of dog. It is important to find a groomer if you cannot do it yourself. Hair under the arms should be trimmed, otherwise it will become dread locked. It is also important to brush your dog's teeth on a regular basis. You can feed your dog with a brand that is good for teeth care. Purchase and use a brush specially designed for dogs. This will help keep your dog's hair from becoming matted. Teach you...
When re-potting a juniper bonsai tree you're going to have to go through the following procedures. First get it out of the existing pot and then rake out the soil at it's base. After doing so for a while, blast the soil with a water jet. If by chance you encounter stubs of ground level branches, try to remove it with a cutter, otherwise use a pruning saw. Now go back to cleaning and reducing the root mass, having done so as much as possible move the tree into another container. Start backfill...
