How To: Make egg carton lights
Turn your home or patio into an incandescent flower garden with plain holiday lights and egg cartons.
Row Collaboration Search Results
How To: Plow without rows in Facebook's Farm Town (03/23/09)
This video teaches how to plow without rows in Facebook's Flash game Farm Town. It is easiest to start at the top corner of your farm. Notice, put your cursor on the green highlight (or JUST below) of the plot. Then click left mouse button hold down and BARELY drag up and toward the plot to the left. It is tricky at first but after a field or two it is easy. This will DOUBLE the amount of crops you can plant on your farm.
How To: Edit Structures in Fortnite Battle Royale
One of the more unique aspects of Fortnite Battle Royale is the ability to create structures. Using in-game materials, players can create walls and ramps for cover and to extend mobility. But creating isn't limited to just the basic generic structures. To really maximize their benefits, great players edit their creations to fit their needs.
How To: Join knitted squares for sweaters or a hat
If you're an avid knitter, then you're probably making dozens of different pojects at the same time: scarves, Afghan quilts, hats, and wee slippers for your dog. So you need a video that doesn't waste your time (so you can finish that last row on your striped rugby scarf) by giving you an all-in-one tutorial.
How To: Knit a bracelet with an "A" letter
Already a bona fide friendship bracelet weaver? Then get ready to knock your friends' socks off with this personalized bracelet emblazoned with the letter "A." This step-by-step video will turn your mind to a whole new world of friendship bracelet possibilities, and you may find yourself stringing together batches of these for friends, family, and coworkers.
How To: Add up a column of figures with Apple's Numbers '09
Apple's iWork '09 is full of great features, including a simple and elegant way to add up a column of numbers in a spreadsheet. This detailed video shows you just what to do to get down and add up.
How To: Knit cables
In this tutorial, we learn how to knit cables. You will need to place stitch markers where you are going to begin your pattern for the cable and end it. Now, take a double pointed needle and make sure it's not bigger than the needle you are knitting with. Work your pattern throughout the middle of your project by making a robe one, then begin the cable knit. Purl the first two stitches, then knit the next six. After this, purl one stitch and knit three other stitches. Continue to do this proc...
How To: Solve the six problem solution
Solving 6 math problems using different methods is the idea behind this video. First, you make three rows of numbers vertically from 1-9. All the numbers match across for example, 1 1 1, 2 2 2, 3 3 3, and so on. Each set of numbers creates a mathematical problem who's solution is the number six. These problems require some thinking to solve. The only one that is immediately apparent is 2 2 2=6 which is, of course, 2+2+2=6, (3x3)-3=6, the square root of 4 =2. This done on all three of the four...
How To: Knit double motifs
In this video, we learn how to knit double motifs. First, make a grid so that you have an even number of stitches all the way around your motif. After this, cast two colors onto the needle, making sure they stay in order. Cast on a total of twenty stitches, which will be just one side of the square for your motif. After this, start to stitch the rows until you reach the middle where your shape will be. Exchange the colors so the pattern in the middle looks how you want it to. After this, bind...
How To: Customize your Safari toolbar
In order to customize your Safari tool bar, you can alter your buttons. All you have to do is click on "view" and "customize tool bar". Select a button that you like from the 2 rows in display. Then, click on the button you would like to add to your tool bar and drag it to your tool bar. You can use buttons as shortcuts to go back and forward, with the back and forth arrows and to take you to your favorite sites, with "top sites".
How To: Earn the "Dodge This" achievement in Red Dead Redemption on the Herd mission
This achievement can be earned on the Outlaw to the End downloadable cooperative mission in Read Dead Redemption. To get the Dodge This achievement, start a private match with a friend on the Herd mission. Once the mission starts, select the bolt action rifle and the rolling black rifle. Use the bolt action as your primary weapon, and shoot the TNT crate next to the tent on the righthand side. Quickly switch over to your rolling black rifle. Have your teammate use one of the repeaters to weak...
How To: Do 21 exercises using the TRX Suspension Training for big arms
Suspension training offers an unparalleled way to train your entire upper body, from your pecs to your core to your triceps and biceps. So if you're lucky enough to have the TRX Suspension Training machine at home, or have one at the gym, then try commiting yourself to actually using it once in a while.
How To: Increment numbers in formulas in Microsoft Excel
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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.
How To: Learn five basic seed beading terms with Melinda Barta
Consider this Beading 101. In this video, you'll learn the five basic beading terms used in many beading magazines and beading patterns. These terms refer to how you pass needles through your beeds (from the back or from the front), how you separate irregular beads out of your main beading inventory, rounds and rows (different ways of beading), waxing your thread, and thread tension.
How To: Average the last three values for an entity in Excel
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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.
How To: Ignore nested subtotals with AGGREGATE in MS Excel
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.
How To: Ignore filtered values making calculations in MS Excel
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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.
How To: Crochet an extra puffy puff stitch
In this tutorial, we learn how to crochet an extra puffy puff stitch. First, insert the hook and pull it through. Pull all the loops up even so the hook is horizontal, then wrap the yarn over and enter the hook through the top of the stitch. Pull the loop up and then wrap the yarn over, pull it through, then pull the loop up so the hook is horizontal with your work. Continue to repeat this process until you get to the end of the row. Place chains on the top to secure them, then you will have ...
How To: Recycle your plastic grocery bags into a dog leash
In this tutorial, we learn how to recycle plastic grocery bags into a dog leash. To begin, you will cut the plastic bags in half, then cut off the handles of the bags. Next, apply glue to the entire bag, then roll up into a straight line. Continue to do this for several different bags, depending on how long you want your dog leash to be. When you finish this and the glue is dried, tie several bags together end to end, and have three rows of these. Now, take the bags and tie them in a knot aro...
How To: Count unique items in a list in Microsoft Excel
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.
How To: Make an Excel formula for a decimal stem & leaf chart
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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula for a stem and leaf chart for decimal numbers using the IF, COLUMNS, SUMPRODUCT, INDEX, INT, RIGHT, SMALL, ROW and TEXT functions.
How To: Extract only numbers from a text string array forumla
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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM functions.
How To: Use the "adult blatt" deer call for hunting
In this how-to video, you will learn how to do the adult Blatt call. This call is made by an adult deer about 18 months old. There are many types of Blatt calls. The Estrus Blatt is the most effective in getting a Buck to respond. The key is to keep the call short. This call will be made by a Doe when in peak heat and looking for attention from a Buck. Turn the calling device quickly. This will be done several times in a row. Do not make a loud alarm Blatt. Keep it short. This video gives you...
How To: Randomly generate letters in an Excel spreadsheet
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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.
How To: Generate a dynamic list from a table in MS Excel
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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
How To: Care for your garden In March by applying insecticides
In this Home & Garden video tutorial you will learn how to care for your garden In March by applying insecticides. John White presents this video. During this time roses get a good growth and along with growth come aphids. For tackling aphids you can a variety of insecticides. One such insecticide is called Rose Defense whose main ingredient is ‘neem’ which comes from the neem tree. You can also use Rose Food insecticide. This is also the time to fertilize rose plants since they will be getti...
How To: Count unique items with multiple criteria in Excel
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. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
How To: Make a 3D domino pyramid easily
This shows you how to easily construct a 3D domino pyramid. First, line up your dominoes on their sides in a zigzagged diamond-shaped pattern. Then, stack dominoes on the left side facing vertically-going from one to another-on all the dominoes except the three in the top left side of the pyramid. Continue to build this way, moving up and alternating in placement in the middle of the diamond. Finally you'll work your way up to one top piece. Then you add a row of dominoes around the outside t...
How To: Do a Running Volley soccer drill with Nike Bootcamp
You run. You volley. It sounds like the most natural thing in the world. But perfecting your finishing on the move calls for hours of training before you’re skilled enough to send the ball crashing into the top corner instead of row Z. Outfield players, sit up and take note. Keepers, get low and take cover: Bootcamp's clinical Dutch striker Klaas Jan Huntelaar is about to bring the latest drill of the week to life. Nike Bootcamp brings you this pro soccer training video. Brush up on your socc...
How To: Make beaded brick stitch or chevron stitch earrings
In this two-part jewelry making tutorial, learn how to make earrings using the brick stitch, also known as the chevron stitch. The earrings are made by decreasing the rows thus creating triangles that will be sewn together. Swarovski Briolette dangle is added to to the bottom creating an elegant look.
How To: Create a falling leaf animation in Illustrator
Ah, falling leaves: They remind of the beauty of nature, fall, and the changing of seasons. And if you've ever walked alongside a row of oaks on the street it seems as if their leaves fall to some unknown, hidden perfect orchestration.
How To: Create the Incredible Hulk makeup look
Want to look like a superhero? Check out this very helpful beauty video for all of you who have troubles with makeup every now and then. Xsparkage shows you how to create the Incredible Hulk makeup look. Don't be afraid, it will be awesome!
How To: Do the E wrap cast on for knitting
Pay attention to this knitting demonstration video and learn how to do the e wrap cast on. This is not a good knitting cast-on for long lengths because it is not possible to control the tension well when knitting the first row, resulting in a loopy, uneven edge.
How To: Attach an I-cord by knitting
This video knitting tutorial shows how to attach an I-Cord onto another knitted piece. Start by picking up stitches along the edge to which the I-cord is to be attached. Break the yarn, and cast 3 stitches onto a double-point needle. Slip these stitches onto the front end of the needle that is holding the edge stitches, such that the working yarn is 3 stitches in, next to the first edge stitch. Begin by knitting 2 stitches, pulling the working yarn across the back, as for regular I-cord. The ...
How To: Change your automobile spark plugs
A worn spark plug on your vehicle can cost you big time. Avoid these expensive repairs by replacing them every 30,000 miles.
How To: Draw the human skull in frontal view
Halloween is the holiday of goblins, ghouls and witchcraft, and also death. So, what better way to celebrate the spooky season than with a skeleton drawing? More specifically, a human skull? Merrill K has you covered with this drawing tutorial. He'll show you the trick to sketching out a human skull (frontal view) in step-by-step instructions. Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.
How To: Build a wave machine out of household items
In this tutorial, we learn how to build a wave machine out of household items. You will need: 20 straws, 40 paper clips, 2 pieces of tape, and 1 washer to make this. First, you will need to pull out a long string of tape and lay it down with the sticky side up. After this, you will need to stick the straws on top of the tape in a row all going next to each other. Do this from the top to the bottom until all of the straws are stuck on. Then, stick the washer to the top and you are finished wit...
How To: Retrieve the cell address of the minimum value in a column in Microsoft Excel
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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.
How To: Crochet a left handed slinky flower
In this tutorial, we learn how to crochet a left handed slinky flower. You will first start row 1 by working a single crochet in the second chain from the hook. Then, chain 2 and skip a chain. Continue across, then make the last chain 2 and single crochet. After this, start to make the petals. For the first petal, you will do a chain 1, then do a half double crochet followed by a chain one all in the same loop. Continue to repeat the petals until you have seven of them in total. When finished...
How To: Make a tubular peyote bracelet
In this tutorial, we learn how to make a tubular peyote bracelet. To get started, string your beads onto the string and leave a 10 inch tail. Then, bring it into a loop and tie it into a square line. After this, use a needle to sew more beads through the beads that you just strung on. As you do this, skip beads so that you have interchanging colors around the circle. You will have a total of four beads on top of the eight that you started with. Continue to do this until you reach rows that go...