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 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel 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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.
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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
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 sketch the graph a square root function.
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 problems with the Pythagorean theorem in geometry.
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 statistics tutorials, you'll learn how to use visualize data by graphing it in a box-and-whisker diagram.
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 use statistical range, variance and standard deviation to measure dispersion in a data set.
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 an equation in which to rational expressions are said to equal each other.
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 two-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to simplify rational expressions in algebra.
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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate the asymptote of a rational function in college-level algebra.
In this video Andrea shows us how to make a facial mask with French green clay for oily skin. You will also need rosemary, lavender and water. First, take one tablespoon of French green clay, one drop of rosemary and one drop of lavender. Then, mix with desired amount of water. Mix this all together and you will be ready to apply to your clean skin, avoiding the eye area (especially underneath the eye). After you've applied the mask, let it rest for about 10-15 minutes and then rinse off with...
In this how-to video, you will learn how to replace a broken axle on a Volcano SV. First, take off the wheel. Next, remove the axle piece out with a hex wrench. To get it entirely out, use your hex wrench to move out the long screws. Make sure you take them out at about the same time, or you will break one of the screws. You can remove the screw to free the upper suspension arm. This will make it easier to remove the broken axle. Next, replace it with a new axle. Clean the axle before making ...
In this video, we learn how to make a milk, egg and honey facial mask to help achieve younger looking skin. First, take a whole egg and break it into a bowl. After this, place 2 tbsp of powdered milk into the same bowl. Next, place 1 tbsp of honey into the bowl. Now, mix together with a fork until they are all well blended. Make sure you have a clean face, then apply mask to your face. Leave for around 10 minutes or until mask is completely dry. After this, rinse your face with warm water and...
In this tutorial, Kandee shows us how to tie a wrist bandanna. First, roll up your bandanna and lay it on your hand. Wrap it around your wrist several times and tie at the bottom of your wrist! This is not only a cute way to make a fashion statement, it can also be used for when you're doing your makeup! If you mess up, it's an easy way to clean up any messes. You can choose different colors and designs for your bandanna and match them to your different outfits. You can also wear bracelets an...
In this video tutorial, viewers learn how to check and replace the cabin air filter of a car. Most cabin air filters are located behind the glove box of the car. Now go into the car and remove the glove box and put it aside. Some cars may need the glove box to be unscrewed. Now reach in and remove the air filter. If the air filter is dirty, replace it with a new one. Once finished, simply put back in all the parts. This video will benefit those viewers who have a vehicle and would like to lea...
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 45th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract a number from a text string.
Instructions on how to disassemble and reassemble on a Tipmann 980. He explains that you have a sear, sear spring, trigger, trigger spring, and five pins. They all come right out. The sear pin is supposed to be black. Take the pine, clean them up, dry them up, and put them back. Four of the pins go right along the top and the sear pin goes on the right of the other pins. The sear spring goes over the sear spring and is snapped in. You then place the trigger and trigger spring back on the gun,...
This video illustrate us how to deal with broken tree branches and problems with grapes. Here are the following steps:Step 1: First of all clean the broken branch with water.Step 2; Now apply some tree primer or tree paint on the exposed area for quick healing and to prevent any infection.Step 3: To deal with problems in grapes first of all look for any infection on the leaf, stalk or the fruit.Step 4: If in case there is some infection ,identify the problem and sprinkle the pesticide for tha...
Navigating on your HP TouchSmart 3.0 PC is easy, fun and takes nothing more then your fingers. To click, simply create a single point of precise contact between your finger and the screen. The HP TouchSmart uses optics to determine clicks so avoid leaning on it with your hands, knuckles, large jewelry or the random fly. The screen is not pressure sensitive so pressing harder has no effect. To right click you simply press and hold. For tasks that require multi-touch input use more than one fin...
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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
Whether updating your home design or protecting against mold and mildew, the installation of kitchen tiles is a simple process that any home crafter can do. This video tutorial shows how to install backer board and tile your kitchen floor. Once you've cleaned the area where your backer board will go, measure to make sure all materials will precisely fit into place. Before setting the tiles, plan the layout on a sheet of graph paper to figure out if you'll need to cut tiles. Finally, apply gro...
This two part video walks you through the steps of in proving Heron's formula. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
This three part video walks you through the steps of solving closed line integrals on conservative fields. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
This three part video walks you through using Green's theorem to solve a line integral. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
Delicious shrimp scampi is easy to make with this video. A half stick of butter is melted in a pan, to which 2 chopped green onions, 3 minced cloves of garlic, and some lemon zest. Sautee about one minute, then add 1/4 cup of lemon juice and 1/4 teaspoon of salt. After the sauce become bubbly, add a pound of shelled, cleaned shrimp and cook just until pink - 3 to 5 minutes depending on the size. Add some hot sauce to taste, and toss. Add 1/4 cup chopped, fresh parsley to bring out the flavors...
How do you salvage a clogged caulk tube? In this Quick Tips with Chuck Miller video, you will see there is an ingenious and simple way to salvage a clogged caulk tube. Take a utility knife and simply make a slice on the side of the caulk tube nozzle. Probably the entire length of the nozzle is clogged and you may not be able to clear it with a wire or nail. After slicing it, take a sharp tool and remove the clogged material from the nozzle and clean it up. Then wrap the nozzle with electrical...
In this video, we are given ways to clean up an image, or remove unwanted objects in an image using Adobe Photoshop. The first tool that we are shown is the clone stamp tool. It allows you to clone a certain sample of an image, for you to use to paint over the object in the image you don't want anymore. In the video, the narrator shows us how to seamlessly take a man out of an outdoor setting. The next tool that we are shown is called the patch tool. In the video, the narrator uses the patch ...
When you apply cologne you want to get the ban for your buck, and you want that bang to smell perfectly. There are a couple key points that you should keep in mind when applying scents. This video will show you exactly how to apply cologne, fragrance, or perfume and love it.
If your computer is working slow--or not at all, there could be some unsavory programs running amok in your system. Trojans, malware, viruses, and hacks are dangerous to the health of your operating system. This video tutorial demonstrates the measures to take in order to rid your PC of malicious programs. Stop being bullied by harmful applications and use such programs as AVG Antivirus and Malwarebytes to protect your computer. Once you've cleaned up your system, be sure to configure your se...
Cast-iron provides one of the best cooking surfaces for any cooking. Learn how to season it to perfection.
Build a fire with a Duraflame firestarter. This video is going to show you how to do this. Crystal Whole from Duraflame is demonstrating the process in this video. First get your chimney cleaned and inspected. Keep all inflammable material at least 3 feet away from the hearth. Use dry wood that has been seasoned for at least six months. Or you can use stax logs in lieu of wood. Three stax logs are sufficient to keep the fire burning all evening. Open the flue of the chimney, put two stax logs...
Rather than throwing out your old furniture, learn how to give your old dresser a modern makeover by following this video tutorial. To begin, pull off all of the old drawers and other pieces that do not work. You will need to sand down the frame of the dresser and then replace all of the problematic parts. You may also need to rebuild the center supports so that your dresser drawers slide in and out easily. Wipe down the dresser with a cloth and then coat it with a latex primer. The primer is...
This video shows us how to draw a Dale character. First you draw a ball about the size of an orange. Insert construction lines in the shape of a cross. Starting with the small middle area, draw the mask outline and add the ears at the top. Draw in the nose under the middle line. Draw the cheeks outside the construction line on both sides. Add smile lines on each side and draw a curve between them for the mouth. Extend the lower part of the mouth outside the construction line. Insert teeth and...
He starts with a pumpkin and some flowers from the supermarket, and some greens that he trimmed from a bush in his yard. He first cuts off the top of the pumpkin and cleans it out. He put newspaper in the bottom of the pumpkin, then puts a container with floral foam inside the pumpkin so the foam is sticking up a bit. He attaches the lid of the pumpkin to the foam with a piece of wire. He starts with the foliage and then begins adding flowers. He puts a tall stem of Japanese Lantern in the mi...
