Row Collaboration Search Results

How To: Knit a simple garter stitch scarf

Watch and learn the secret behind knitting a simple garter stitch scarf. Garter stitches are great for scarves because all you do is knit every row and both sides are the same. Cast on the number of stitches that you want and just start knitting! Judy Graham, Knitter to the Stars, shows you how it's done!

How To: Mak a vertical-striped bracelet cuff out of beads

In this video, we learn how to make a vertical striped bracelet cuff out of beads. Start with a long piece of string and string on your beads until you have a length that fits well around your wrist. After this, tie the ends together and cut the tails off the excess string on the short side. now, start to thread through new beads around the entire bracelet. At the end of every few rows, tie it to keep it tight at the end. When you are finished, tie the string and make a knot, then cut off any...

How To: Do look-up addition with VLOOKUP & HLOOKUP 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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.

How To: Edge a knitted piece with the crab stitch

In this video, we learn how to edge a knitted piece with a crab stitch. First, attach your yarn to the left edge of your work. After this, work one chain stitch, then go backwards with the hook. Insert it into the fabric and grab the yarn and pull it through the loop. Go around the yarn again and pull it through again. Keep going backwards and grabbing more yarn as you go in reverse. You are working with one loop on the needle while going into the fabric. Make sure you're consistent with the ...

How To: Crochet a left hand radiant flower

In this tutorial, we learn how to crochet a left hand radiant flower. First, make a slipknot, then chain four. After this, join the beginning chain and then chain three. Slip stitch through the center of the chain, then chain three and slip stitch again. Do this over again five times on your row. After this, continue making stitches until you have the shape of a flower. Add on green yarn to the back of the flower, by doing the same type of stitch. Work as many stitches as you would like. The ...

How To: Create a dynamic frequency table & chart 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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....

How To: Make a coffee cup sleeve and stitch markers

Get your sewing tools ready, because it's time for another great tutorial. In this video you'll learn how to make two cool objects easily. One being a stitch marker that helps mark a certain place in a row when knitting. The other object is a coffee cup sleeve that is perfect for making sure you hands don't get burned. A big improvements over the ones that you can throw away and never use again.

How To: Use VBA code for conditional formatting 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 and Mr. Excel, the 22nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use VBA code for conditional formatting as well as how to do it using the OFFSET, MOD and ROWS functions.

How To: Do reverse lookups with VBA code 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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...

How To: Return the address of the 1st non-blank cell 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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.

How To: Return every tenth value 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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.

How To: Dynamically count unique words in a column 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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...

How To: Properly do a double crotchet stitch

How To Crochet: Double Crochet Stitch is a short video that demonstrates how to create the double stitch. As show in the video, you will need yarn as well as a crochet hook. The video shows step by step how to create this specific type of stitch. The narrator explains that the double crochet stitch is twice the height of the single stitch and also has wider spaces between each stitch. Advice is also given to count your stitches at the end of every row as the narrator cites "losing" and "gaini...

How To: Check if a cell is empty using macros in Excel

Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this func...

How To: Navigate the homepage on an HP TouchSmart

In this video, we learn how to navigate an HP TouchSmart computer homepage (Windows 7). First, double tap the HP TouchSmart house icon. You will now see several different applications. On the top are applications that are running, on the bottom are applications that are not running at the moment. You can run your finger to scroll along the different windows that you have open. You can use Paint, internet, photos, videos and much more all at the same time! To scroll between pages, grab the top...

How To: Use Windows Live Movie Maker to edit videos

This Software video tutorial will show you how to use Windows Live Movie Maker to edit videos. Starting with the store board; here you can drag videos and photos or click to browse them. Click and it will open up a window with all your photos and video. On the left side is the preview window. As you scroll your cursor through the images, they will appear in this window. On top are a row of tabs. Each of the tabs is called the ribbon allowing you to select various tools. Here you can add or de...

How To: Make a squared-style friendship bracelet

Kiwua demonstrates how to make squares friendship bracelets. There are 3 pink threads on the left, 2 black threads in the middle and another 3 pink on the right. First, you take two from left and make a knot from left to right. Then, with the same threads, another knot from right to left. Now you take the next two, a pink one and a black one and makes a knot from right to left. She repeats this action, the same way. After that, she takes the next two threads and knots them from left to right....

How To: Make a stair step card using Cricut Storybook

Once you get started with the concept of "stair step" cards - it is hard to stop! It would be fun to try a double set of stairs, add another row for five letter words and cut letters into the bridging circles. Cut the extra panels for the front and emboss them with the Divine Swirls 'Cuttlebug' folder. Then use the Stardust 'Stickles' on the swirls to really make them pop! The extra letters from the name cutout were perfect for the envelope. Emboss the envelope with the Birthday Candle 'Cuttl...

How To: Install a solid hardwood floor with Lowe's

A solid hardwood floor offers a clean and simple alternative to carpeting. This video tutorial demonstrates how to install solid hardwood flooring in your home. Once you’ve prepped the subfloor, let the wood planks acclimate to the room temperature for at least 72 hours. Check the boarding for unusual warping or defects before drilling nail holes in even increments down the wood siding. After countersinking each nail, fill in the holes with wood nail putty. Continue the process for each inter...

How To: Add decimals

This video explains how to easy add decimals. Adding decimals can seem to be a tedious job, and a single mistake can result in a completely different number. In reality, it is quite easy, and with a good method and some practice it can be done quickly. Write the two sets of numbers out, lining them up in columns. Keep the decimal points on top of each other and line up the non-decimals with non-decimals and the decimals with decimals. Start at the right-most column and add it up. If it become...

How To: Make a cubed herringbone bracelet

Get that Bohemian look this summer with homemade chunky jewelry! In this three-part jewelry making video tutorial, learn how to make a Cubed Herringbone Stitch for bracelets. From Auntie's Beads" "Ladder-stitched cube bead rows work as a foundation to this bracelet. The stitch is easy to learn and the tapestry like look will invite multiple color combinations!"

How To: Jerk (dance) - "Pin Drop & Break Leg"

JusJerk and Jerk dance crew, the Stick Figures demonstrate how a "Pin Drop" is done in the world of Jerking, and later, how variations of the Pin Drop (sometimes also referred to as the "Knee Drop") can lead to multiple Pin Drops in a row and/or some pretty impressive acrobats. Later in this tutorial, the Stick Figures show how to do "The Break Leg Pin Drop" by dipping and "breaking the legs". We're guessing they mean this figuratively.

How To: Make a hippie chiffon one shoulder top

This is a video tutorial in the Fine Art category where you are going to learn how to make a hippie chiffon one shoulder top. The materials you will need are chiffon, studs, elastic thread and elastic. Use a simple tank top pattern to cut out the chiffon. Elongate the center of the fabric; this will give it the flowy look. Shirr 5 rows into the middle of the fabric making sure the elastic is on the wrong side of the fabric. Fold in half, right sides together. Sew the side seam and the shoulde...

How To: Create and use hyperlinks in Microsoft Excel 2011

Need to know how to create and use hyperlinks in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.

How To: Paint nails with an orange, white, and brown theme

In this video, we learn how to paint nails with an orange, white, and brown theme. First, apply an orange shimmer polish from the top to the bottom of the nail. After this, let them dry and then grab a brown nail polish with a pointed brush. Then, draw on three stripes from top to bottom with the brush. After this dries, use another pointed brush to draw three flowers in a row on the nails. Use the brown to create the details for the petals. Then, you will finish this off by applying four sma...

How To: Knit a scalloped edge

In this video we learn how to knit a scalloped edge. This forms a shell along one edge! First, attach your needle to the yarn on the right edge. Then, make a slip stitch and yarn over. Then, stick then needle through the fabric and yarn over again so you have three on the hook. Then, yarn over and pull through the first two loops in the hook. Then yarn over and go into the fabric and over again. Pull through a loop and then yarn over through all the loops on the hook. Now, do another one foll...

How To: Pick up stitches along a curved edge

In this tutorial, we learn how to pick up stitches along a curved edge. You can see the slope on your fabric that you can work with. If you slip the first stitch you can avoid this. First, slip the first stitch and then bind off the next stitch as usual. This will create a nice curve. To pick up stitches, you will use a circular needle and then poke it through the area in the last row. Find a 'v' shape and then push the needle through this. Pull through just like you are normally knitting and...

How To: Straighten American Girl Doll Julie's braid

In this video, we learn how to straighten American Girl Doll Julie's braid. First, you will need to take the hair out of the braid and then separate that area. From here, cover the doll with a towel and brush her hair out. Wet down the area by dipping the comb into the water and brushing it in the hair. From here, you will bring the doll over to a flat surface. Then, lay some really heavy books down on top of the strand that needs to be straightened. Do this four nights in a row, then the hai...

How To: Make a cake American beauty rose

In this video, we learn how to make a cake American beauty rose. First, place your icing into a plastic bag and then place the tip inside of it. From here, you will twist the surface where you are putting your rose and let the icing roll into a round shape. After this, make additional rows of petals until you have the size of flower that you want to create. When finished, you will have a gorgeous rose on your cake or cupcakes! Add in green icing to make leaves on the side of the flower and yo...

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula 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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Left-hand crochet a wide headband

In this tutorial, we learn how to make a left handed crochet wide headband. First, make a slip knot on the crochet hook and then make a chain of two. Next, wrap the yarn over and pull through once. Repeat this and then wrap the yarn over the hook, then wrap over and pull through once. Repeat this fourteen times to make the entire foundation for your headband. Once you have made this, you will need to repeat this on top of the first foundation several times until you have made several rows so ...

How To: Crochet a fringe on a scarf

In this tutorial, we learn how to crochet a fringe on a scarf. Start be going to the end of your last row with your hook. Then, chain one and pull it tight. Next, decide how long you want your fringes to be and pull your thread that long. After this, cut it on the bottom and pull the loop out of the chain. Now, take your hook under the first stitch and fold three twelve inch strands in half. Then, hook these onto the crochet hook and catch the tail with the strands. Continue to crochet the fr...

How To: Crochet a round shell Catherine's Wheel left-handed

In this tutorial, we learn how to crochet a round shell Catherine's Wheel left-handed. For the first round you will start by doing four single crochets after the slip stitch. After this, do seven double crochets, then a single crochet followed by seven more double crochets. Make two more chain stitches, then a single crochet and three double crochets. After this, start the next row which will be a chain stitch, then three double crochets. Next, you will do seven double crochets, followed by a...

How To: Play "Leaving on a Jetplane" by John Denver on guitar

In this video, we learn how to play "Leaving on a Jet plane" by John Denver on guitar. This is a very easy song to sing and it's recognizable so that a group of people will be able to sing along with you. The chords you will need are a G, C, A minor, and D. These are the only chords you will need for the entire song. Start out by playing these chords for the intro twice in a row. After you have done this, play the chords throughout the rest of the verses. Make sure you pause and go down and u...