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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH functions.
In this tutorial, we learn how to pick a padlock with a single paperclip. First, check your lock to make sure it isn't broken, busted, or damaged. After this, take your paperclip and bend it out. Next, use pliers to bend the paper clip into a loop shape. Once you've done this, stick the loop into the lock in the middle and twist it. Play around with the lock for a few seconds and continue to twist until the lock comes unlocked. If it's not working, create a bigger or smaller loop in the paper...
This video tutorial is in the Education category which will show you how to solve single-step inequalities using the reciprocal. Let's solve the problem "negative 5/2 X is less than equal to negative 1/5". To solve for "X", we need to get rid of "negative 5/2". To do that, we multiply both sides of the inequality by the reciprocal of 5/2 and we need to keep the negative sign also. So, we multiply both sides by "negative 2/5". Whenever we multiply a negative to both sides of an inequality, the...
In this video, we learn how to set up the mast on the Open 570 single-handedly. First, look to see where the mast is going to fit on the boat. Pick the mast up in the middle so it balances out on each side, it's very long. Turn the mast around and place the edge facing the foyer. Put the base of the mast into the mast step, then let it rest on a step ladder. From here, get into the boat and add the safety pin into the base of the mast to keep it locked. Now take the mast and push it up into t...
In this video, we learn how to start a beanie. During this, you will increase the number of single crochet stitches in a chain. Start off with a chain three, then join them by crocheting a single stitch in the first stitch you made. Do this by pushing the hook through and pulling the yard over, then pulling through. After this, you will have a circle. Start to crochet inside of this by using your circle and inserting the hook into the circle. Crochet around the tail of the circle, then yarn o...
If you're interested in taking up wrestling, and need to learn some great moves, this next tutorial may have something new for you. In this video, you'll be finding out how to perform an outside single leg to double or knee tap in wrestling. It's a move that is very effective and can take down your opponent in a matter of seconds, if done correctly. And in order to do it correctly, check out the video above, practice and good luck!
In this video, we learn how to make single ended dreads. First, you will need synthetic hair, a hanger, and a steamer. First, take the hair out of the package and then cut a section out of it and put the other hair aside. Next, place the hair on a clothes hanger hook, then pull on the hair with your hands. After this, pull the ends down and then take a comb and back comb the hair piece. You want it to be in a big poufy mess what you are finished with it. After this, you want to braid the hair...
If you've recently found out that you have a broken tile in your kitchen or bathroom, not only can it bring you down but it can look a bit ugly as well. Some may think that the only way to fix it is by replacing the other tiles surrounding it as well, but that's not the case.
In this video tutorial, viewers learn how to make a beaded watch band with a non-loop watch face. Begin by cutting 2 pieces of the stringing materials to approximately 10 inches. Then put one end of the string through the hole of the watch face and pull it to about halfway. Now users will have 2 strands to work with. Users may choose to making a double strand watch band by putting beads on both strings, or a single strand watch band by running both strands of string through a single bead. Fin...
You only need one single sheet of paper for this card fold, so grab it an watch this tutorial to learn how to make a diamond pop-up cracker card. Don't know what a cracker card is? Watch thee video and find out what this 3D homemade card is all about. You only need a single strip of card stock (10cm x 29.7cm). So quick, so simple — so make one! This is a great little crd that's easy to send through the post office.
Go to the site www.downlaod.com and type in winrar in the search tab. Download the first search result and install successfully. Winrar helps you compress a large file into a smaller one, single or in parts. Right click on the file to be compressed and click on ‘Add to archive…’, a window pops up. In this window, in the left-bottom corner you get an option to compress the folder into a single file or into several files with the file size of your choice. Now it is easier to send the part...
To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...
This how to video will teach you how to perform the push pull technique on drums. If you want to throw a double, you can start with a single and get an accent on the double for an inverted double. Just push and grab really quick. For a double, use a controlled rebound. For the inverted double, start with a single and dig out the second stroke of the double. A french grip is useful for performing this technique. This is good for ghostings and shuffles. For shuffles, you can use a controlled re...
Danny Lipford shows us how to create a simple jig to hang picture frames. He believes that all the complicated gadgets many people use-including lasers and special levels-are unnecessary for successfully hanging a picture frame. All you really need is a strip of wood and a single nail. He shows us a single lath with a roofing nail in it, which he prefers for its broad head. Simply slip the nail onto the wire on the picture's backside. Then set the picture wherever you would like it to be. Sim...
To write the sum or difference of logarithms as a single logarithm, you will need to learn a few rules. The rules are ln AB = ln A + ln B. This is the addition rule. The multiplication rule of logarithm states that ln A/b = ln A - ln B. The third rule of logarithms that deals with exponents states that ln (M power r) = r * ln M. Using these three rules you can simplify any expression that involves logarithms to arrive at a single logarithm. The instructor shows how to apply these rules to a f...
In this video the instructor shows how to solve quadratic equations by factoring. You can solve a quadratic equation by factoring them. To do this first write the equation in the standard from which is a*x*x + b*x + c = 0. Now factor the equation into two smaller equations of single degree. Now you can apply the zero-factor property to solve the equation in this from. The zero-factor property states that for a real values a and b, if a multiplied by b is equal to zero then value of a must be ...
This video shows how to start a continual round in single crochet, half-double crochet and double crochet. The photography on this video allows you to see the motion of the crochet hook and the thread and really see observe the techniques as they are explained. Techniques are explained for starting and ending the continual round. This continual round technique including transitions between single, half-double, and double crochet allows you to crochet projects like skullcaps and hats using one...
This is the video about how to perform a single cast on. To work this open cast on you'll need one needle a couple of sizes larger than the needles you'll be using to knit with (or alternately, two needles held together) and a spare length of sturdy yarn several times longer than the length of the finished cast on. Make a slip knot with the working yarn and place it on the needle. For this cast on you only need to leave a short tail -- you'll be working with the yarn coming from the skein. Ho...
This video will show you the simple mathematical concept of solving a single-step equation using multiplication. This is very useful for equations in which you need to solve for a variable and the variable is a part of a fraction. The example provided in the video shows a very fast and simple way to solve these types of problems. By multiplying your fraction by the denominator of the fraction, you will cancel out the fraction and multiply the other side by the same number. By following these ...
Make a fun decorative design with this video tutorial. To create black and white with decorative swirls and dots:
In this money origami dollar bill origami tutorial learn how to make a peacock from money origami and a single dollar bill.
The slippers in this how-to video are a good example of how the same project, made by the same person, with the same hook and same brand yarn(different color) can create a different size. Both slippers were made with 4-ply Redheart yarn. The only difference is the color. The gray slipper turned out to be larger than the white slipper. Follow along with the instructions as the demonstrator shows the steps for making these cozy slippers. You will need to be able to single croche, slip stitch, f...
The PowerForce G4 Series 233 is the versatile single processor upgrade for PowerMac G4 AGP towers, G4 Cubes, PowerMac G4 Digital Audio, QuickSilver, and QuickSilver 2002 models. It features the G4-7451 and G4-7455 processors, with speeds up to 1.2GHz. The PowerForce G4 Series 233 processor card, like its predecessors - the Series 100 and 133 upgrades - is the most advanced, highest performance CPU card available on the market today. It's also easy to install Feature List: PowerPC 7451 or 7455...
In this video tutorial, Chris Pels will show how to use the aspnet_merge.exe utility to combine assemblies that have been compiled using the aspnet_compiler.exe utility. First, view the output of the ASP.NET compilation process to learn what assemblies are created. Next, learn the mechanics of using the aspnet_merge.exe utility to merge assemblies from the compilation of a web site, first seeing how to control the compiled assembly names with the –prefix option. Then see how to merge all the ...
While sliding doors is far from a new concept and will be obsoleted once we see wider support for multiple backgrounds (CSS3), it is still a good one for your bag-of-tricks. The theory is that if we have an extra hook in our markup, we can apply two overlapping background images to a single spot of text. When that text grows or shrinks, these overlapping images and reveal more of themselves creating the illusion it is a single expandable graphic. In this video screencast, we do a quickly exam...
Single-display performance mode: If you have only one active display, this is the setting for you. You can also specify this setting if you have problems with the multi-display modes.
In this video, Jennifer Taggart Of Healthy Child Healthy World shows us how to make a non-toxic disinfecting cleaner. You can use this cleaner for almost any surface in your home. What you'll need is a re-purpose spray bottle, some castile soap, some tea tree oil, and water. For the water, it's preferable to use distilled water, but you don't have to. The distilled water ensures there's no bacteria or anything in it. First, if you're re-using a spray bottle make sure it's clean. Add 2 cups of...
If you're new to the Visual Basic IDE, looking to brush up on your VB programming skills, or simply have a burning desire to code a simple calculator, this three-part video lesson is for you.
Learn how to do a single cable handle high, alternate swim stroke, with a wide pull-down, and squat. Presented by Real Jock Gay Fitness Health & Life.
This is a single Betta male live plant set up that looks awesome ^^
Puff and Po and the Empress's Treasures, is an inspiring indie game that stays fateful to the arcade single screen plat-former style and game-play.
Convenience is a big deal these days. You can buy single-serving or single-use sizes of just about anything, from fruits and vegetables to sanitizing wipes, and, apparently, even bananas. Uhh, it already has a wrapper...
Beeswax is a clean-burning and pleasantly scented wax for candles, and beeswax candles make excellent gifts. This tutorial shows you how to make your own rolled beeswax candles at home. All you need is your primed candle wick and a few sheets of beeswax.
Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If the...
Janice Cox shows how to make fizzing bath bombs like the ones you see in bath and beauty boutiques or department stores. These bath bombs can be very relaxing when dropped into a warm bath and can be given as gifts. She starts with about a cup of citric acid crystals which is also called powdered vitamin C or ascorbic acid. Citric acid can be purchased in places that sell wine and beer making equipment and online. The next ingredients come from right out of the kitchen cupboard: a cup of baki...
ClickHelps demonstrates how to treat hemorrhoids with home remedies. Hemorrhoids are swelling and inflammation of the veins in the rectum or anus. First, sit in a bathtub full of three or four inches of warm water. Keep your knees raised. The warm water will soothe the pain while increasing the blood flow to the area. And increased blood flow will help shrink swollen veins. Repeat this technique several times a day. Keep the anal dry and clean while avoiding using harsh toilet paper. Gently w...
If you would like to crotchet around the edges of a fleece blanket you will need a fleece blanket, yarn and a hook. You will first need to clip holes in the blanket with a slip stitch blade. These wholes will distinguish where the crotchet chains will go around the fleece blanket. The slip stitch will leave you with holes so you can crochet around the blanket. You should do a foundation slip. Start by doing a slip stitch and pull your needle through the back and from the front complete the st...
In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...
Bored? With only a single deck of cards, keep yourself entertained with this single-person game of strategy.
Is your old pet suffering from new pet envy? A new pet can make your best friend pretty doggone upset, but there are ways to help them get over their jealousy. In this tutorial learn how to prepare a dog for sharing his home with a new pet.
