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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to visualize chiral molecules in organic chemistry. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.
In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to create and interpret Newman projections in organic chemistry. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.
What's in a name? Well, your chemistry grade, for one. In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to use the the cis-trans naming system for alkanes. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.
What's in a name? Well, your chemistry grade, for one. In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to name alkenes with alkyl groups. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.
In this tutorial, we learn how to replace the clutch shoes in RC Nitro Trucks or cars. First, stick a screwdriver through the back of the clutch and remove the bolt from the back. Now, you will see the clutch and a spring that is on the side of it. Take this out, then you will be able to replace the clutch shoes that are underneath it. After you have replaced the clutch shoes, put the spring back on. After this, replace the bolt and then screw back in any lose screws that you took out. After ...
In this video, we learn how to tune an RC nitro engine. First, you will need to adjust your needles. Make sure you know which way to go as you are adjusting them. After this, you need to find your high speed needle and find where you will hook up your fuel line. Lean the motor by turning a screwdriver into the barrel. This will screw your needle in and make the engine restricted to fuel flow. Now you will want to test out your engine to see how much lean you are getting. Make sure it's oiled ...
In this video, we learn how to remove and perform maintenance on Nitro brakes. First, you will need to make sure you have the correct size of screwdrivers before you begin. Now, you will proceed to remove the brakes from the transmission. Make sure to handle these with care and take your time. Set all the parts that you remove aside and in order so you don't forget where they are and where they go. After this, align your brakes so they work correctly, then start to replace all the parts that ...
In this tutorial, we learn how to fix an Xbox 360 Phillips Benq Drive. First, you will open up the broken drive using a Philips head screw driver. Next, desolder the chip from the broken drive with a soldering iron. After you do this, you will be able to slide out the motherboard from the device. Now, grab a new chip and place the board back into the device. Make sure all the wires are out so they are not underneath the board. Now, solder the wires and any other ribbons back onto the main boa...
In order to build your very own home studio, you'll need the following: a microphone, drafting tools, paper, contractors, the Internet, and recording equipment.
In this video, we learn how to add the Gmail button to the toolbar. First, log onto Google and go to your Gmail account. After this, drag the icon for the Gmail to the toolbar on the screen. After you do this, test out if it is working correctly. Exit out of your browser, then go back into it. Now, click on the icon that has the envelope with red outlining. Once you click this, a new tab should open up with your Gmail opened up! This is great if you want to check your e-mail quickly, without ...
In this video, we learn how to replace a windshield washer nozzle. First, use tape to mark where the wipers were at so you know where to replace them. After this, remove the wipers from the vehicle by using a wrench. Now, pop the hood of the car and remove the screws that are on the front of the car surrounding the nozzles. Once you get the top area removed, you will find the nozzle and hose underneath it. After this, replace the old nozzle with the new one and then put it back. When finished...
In this video, we learn how to hide a crimp bead with a crimp bead cover. First, string your spacer followed by a crimp bead and another spacer. At the end, you will have the end piece with the wire protector next to it. Then, bring the piece of jewelry through the crimp bead twice, then through the spacer once more. Now the spacers and crimp beads will be pressed with the crimping tool tightly. Pull on the string to test it out, then slip in your crimp bead cover so it looks like another bea...
In this video, we learn how to build a magnetic stirring device. First you will need: a block of 1 inch thick Styrofoam, a piece of cardboard, 2 magnets, a small electric motor, a piece of non-magnetic metal, a hot glue gun, and a soldering iron. First, draw the shape of your cardboard square on the foam and cut it out. After this, take your soldering iron and melt away the Styrofoam from the outside. Then, make a hole in the middle for where the motor will be placed and push it inside. After...
When you get you're "My Kitchen" cartridge from Cricut, you will need to test the cartridge, in order to make sure it works. Then, you should look at the manual. Remove the pages that you don't need: those in foreign languages.
In this tutorial, we learn how to add the YouTube button to the toolbar. First, log onto your internet browser and then add the button that says YouTube on it, so there is an icon that shows up on your toolbar. After you do this, you will be able to search for things without being inside of the YouTube website. To test this out, simply type in something you want to see on YouTube in the left hand text box, then click on the YouTube icon. After you do this, the website will pop up showing the ...
If you're just getting into woodworking, one of the most simplest and common projects involves making a birdhouse. A birdhouse is a common project that many can build and doesnt require too much work.
In this video, we learn how to replace a keyboard on a laptop. First you will want to remove all of the screws from the back of the laptop where the keyboard lies. After this, remove the bezel then take the keyboard out completely. After this, clean out the area where your keyboard was at, making sure not to loosen up any wires. When you are done with this, place the new keyboard back in as well as the bezel. Replace any screw that you took out and make sure everything is secure again. After ...
In this video, we learn how to make the world's loudest alarm clock. If your alarm clock does not wake you up, this is for you! First, you will need to take apart your alarm clock and find the wires that are connected to the tiny speaker that is inside of it. After this, grab two very large horns that have enough decibels to wake you up. Now, find an old 12 volt ac adapter and solder two wires from the adapter to the spot where the alarm sends signals to the alarm clock. Now, test out your al...
In this next video tutorial, you'll find out how to remove the rotors on a motorcycle. If you need to find out whether or not it's bad using your fingernail is a good way to test it. Switching the rotor is important for ensuring that your bike will last for a long time and that you'll be safe of any kind of injury. It's easy to follow and doesn't require a ton of work. So check out the video, pay attention, and enjoy!
In this video, we learn how to check your engine health with a PICO scope. First, you will want to attach your computer to the PICO scope that is connected to your vehicle's "brain". After this, you will run through the different sections of the car to see how each of the different functions are running. Compare the results you are getting to a chart that shows what the healthy charts should look like. As you go through these, record the results you get, then print them out if you need to. Wh...
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 finish your homework or 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 unpack and solve problems requiring you to compare two or more whole numbers.
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 finish your homework or 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 unpack and solve problems requiring you to add whole numbers.
In this video, we learned how to repair a crashed 3D helicopter. If you have a crashed helicopter that isn't flying or is flying off center, repair it. You will have to have some knowledge of how to repair helicopters, and know which part is broken. Repair the parts that are broken and when you are done you will need to replace all the parts that you previously removed. After you are done with this, you will be able to turn the helicopter back on and test its flying abilities. If the helicopt...
In this tutorial, we learn how to upload HTML files without a FTP client. First, go to your HTML files and name the home page "index". Next, go to Zymic and sign up with the website. Next, go to your account management, then click "create new web host account". You will now enter in your website, then login. Now, you will click on file manager and click "upload files". Browse to find your index page and anything else you want to upload. When finished, copy your URL, then test it out to see if...
In this tutorial, we learn how to install a car alarm on a Viper 5900. First, read your manual and figure out which wires go where, then label them so you don't confuse them. Next, grab all the tools you will need and have them prepared and ready. After this, find the electrical box on the car and remove all the wires that are inside of it. Now, you will take out the wires that go onto the current alarm system. Replace with the new alarm system and apply the wires where they belong. You may n...
In this tutorial, we learn how to connect your PS3 to the internet. First, go to settings on the game console, then go to network settings. After this, go to internet connection settings and click on "custom". Now, go through all the different steps, then wait while the game finds your internet connection and save all your information. After the connection test is completed, you will be able to connect to the internet to play your games! You will have to have a wireless router to do this, as ...
In this tutorial, we learn how to clean a Spyder marker paintball gun. Before you start, disconnect your air source and turn the gun off to a safe position. Now, remove the barrel and slide out the pin. Now, the marker should fall out on its own. Make sure not to lose any of the parts that come out with this. Pull out the string, bumper, and striker as well. Now, use paintball oil to clean all of the parts that you removed from your gun. Only use the paintball oil, because other oils contain ...
Giving your kid a bath is an integral part of child care. What's that saying? Cleanliness is next to Godliness? Okay, maybe not, but a clean baby is a great sight, but there are things to worry about when filling up the bathtub. Could the water temperature be too hot? NFPA's Amy LeBeau on the importance of testing the temperature of bathwater before putting children into the tub. Safety also comes first.
In this video, we learn how to butcher a pig with Chef Dave. From the top, you will see the pork shoulder, the ribs, then the ham, the loin, the belly, lard, kidney, and then the leg of pork. If you touch the fat on this pig, you will notice that the fat is very firm, not soft. Usually, the head does not come with the pig because it's not in high demand and butcher's don't want to pay for something that the customers don't want. There is also a kidney that will come with the pig, but there wi...
In order to cleanse your body of toxins, you first need to determine the types of toxins you've been exposed to. This can be done with blood screening or urinalysis or liver function tests. If the liver isn't functioning properly, then there will need to be some steps taken or the benefits of cleansing won't last very long.
In geometry class you learn that circles most definitely aren't squares. But in the crochet world, circles can become squares, triangles, and even hexagons. How, you ask?
In this video, we learn how to fix a leaky faucet in the kitchen. This is for a faucet that is leaking around the handle. You will want to start off by figuring out what type of faucet you have, and get the proper parts and repair tools for it. Next, you will need to turn off the water that goes into your faucet, and then remove the hardware from the top. Once you get to the inside of the faucet head, put the replacement part in and then turn your water back on. Now, test your faucet to see i...
If you are having a hard time with starting your lawn tractor, there may be several reasons behind this. One being the battery. Just like a car, the battery brings life to your lawn tractor and makes sure that is is working properly. Without the battery, you can't use your machine.
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 finish your homework or 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 and work with problems involving inductive reasoning in math.
If you recently have replaced the distributor in your car or plan on doing so, prepare to set the ignition timing in your car. This is a process that can take some time and requires the right tools for the job. Trying to start and use your car before you set the ignition timing can be a bad idea since it can mess up your car in the long haul. This tutorial will tell you what tools you'll need and how to find the area in which to test.
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 finish your homework or 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 multiply and divide monomials in algebra.
In order to repair a trunk that won't open, you will need the following: a screw driver. You will need to climb into your trunk, through the back seat. Remove the back seat. Pull the emergency release. Remove the trunk lock. Unscrew it. Look for anomalies. Bent screws could be the cause. You will need to repair any broken parts or replace them, if you decide not to replace the entire lock. Reinstall the lock in the trunk.
Spinner bait are good for attracting and catching bass when fishing. In order to have the lure and the bait working correctly when using this type of bait, you will have to attach the bait directly to the lure. This can be done using the improved fisherman knot. After threading the line through the bait, you should leave about 6-8 inches of line to tie the knot. Begin by making about 5 twists around the line and then thread the line through the hole created below the twists. After threading t...
This video is a do it yourself project which will show viewers how to fix a leaking kitchen faucet which is leaking water from around the base of the handle. This problem is most likely caused by a broken cartridge, a Moen 1225B cartridge is used to replaced it. The first step which should be taken is to shut off the flow of water from the sink using the shutoff valves under the sink. Then, remove the handle and its adapter depending on the style of the handle which is leaking and remove the ...
