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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function formula.
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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER functions.
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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
Childcareland demonstrates how to make a Thanksgiving book of thanks with kids in this video. A book of thanks can be done by a group or an individual. It begins a title page which can be labeled to reflect whether it is an individual book called "My Book of Thanks" or an group book called "Our Book of Thanks" or a general book called "Book of Thanks". The back page is a blank match of the cover page. In the middle are five pages labeled "I'm thankful for" with a line for older children to wr...
In this Software video tutorial you will learn how to make a book cover in Photoshop. Go to file -> new. Give it a name, set width 900, height 1200 and resolution 300 and click OK. You can change these settings if you like. Go to your paint bucket tool and paint the background black. Then go to layer -> new ->new layer -> OK. Now select the elliptical marquee tool and holding ‘shift’ drag from the top left hand corner and make a circle. Go to your paint bucket tool and paint the circle with a...
This clip shows how you can draw a hypercube, which is a complex shape composed of cubes. You start with a series of equally spaced horizontal lines. Then you draw a vertical line from the origin (o, o, o). From the same point, you draw a horizontal line of the same length and two more lines at 45 degrees and 135 degrees from the horizontal. The vertical line and the 45 degree line form two of the vertices of one of the cubes. The vertical line and the 135 degree line form two of the vertices...
This is a great look if you don't have (or want) the hair that's required of it. It's a really awesome braids hairstyle. The best thing to do is to use your own hair extensions (yes, from your own hair) which you can use over and over again, and not have to worry about it not matching completely with your hair, because it will be your hair.
ConnersTutorials, teaches you how to put two videos playing simultaneously in one movie. You use Sony Vegas and drag both movies in the time-line below. Then you press Event pan/crop on the first video. Right click and choose Match output aspect. Then re-size and move the video as you want. Do the same for the other video. Go to Media Generators to choose the background, which can be a solid color, a picture or another video. Just drag that down in the movie time-line when you're pleased. All...
In this video from Polymer Clay Productions, we are shown how to make earrings out of polymer clay marshmallow Peeps. They use holographic yellow glitter for the sugar, polymer clay, and Sunny Side Up yellow coloring. Use a clay color and glitter color that match. Have some real Peeps handy for reference.
In this tutorial, the author shows how to determine if a point lies on a given line which is in Point Slope Form. To show the method he takes a sample point order pair and an equation of a line in its point slope form. Now he substitutes the value of the x, y order pair and the equation of the line, and solves the equation on both the sides. If both sides match it means that the point lies on the given line, or else it does not lie on the current line. In this video, the instructor shows how ...
Clean out the empty bottle that you are going to use. You can use a white dish-washing soap bottle or a cleaning agent bottle. Just make sure it is empty and clean. Use the pen to draw a wide rectangle that measures 3 inches long by 1/4 inch wide onto the bottle. The teeth you are making are going to stretch from either side of your canine teeth above and over your two front teeth. This will help them be more secure. Draw this onto a part of the bottle where it is curved. Draw two vampire tee...
This how-to video from Lowe's demonstrates how to replace a damaged screen. The tools required are fiberglass screen, spline, tape measure, spline roller, screwdriver, and utility knife. He shows the different options in screen material, and suggests taking pieces of your old screen and spline along to match it. He removes the old spline and screen, lays the replacement screen over the frame and trims it. He uses a spline roller to roll the new spline into the groove and attach the screen. Th...
Dawn is all ready to show you how to make an adorable lollipop candle using just a few basic craft supplies and some handy items from Stampin' Up. With a tea-light candle, lollipop stick and cellophane bag you can turn an ordinary candle into the perfect gift. Learn how to use the Stampin' Up stamps and accessories to customize your lollipop candle to fit any occasion. Dawn's video will even cover tips on how to match your ribbon to the color of your stamp ink. These lollipop candles are the ...
This tutorial shows how to identify the slope and y-intercept given the formula y=mx+b. In this formula m is always going to be the slope and b is always going to be the y-intercept. Therefore if your given a problem like the one displayed in this video: y= 8/3x + 9, the slope would be 8/3 and the y-intercept would be 9. When given these problems all you have to do is match the given numbers to the formula to find the slope and y-intercept.
Simon Plant of ProPhotoInsights.com shows how to use Photoshop to blend colors in images. He uses a photo of his son standing in front of Stonehenge to take us through each layer of the photo to alter the levels of hues, saturation, and opacity. The key to blending colors is a matter of playing with different hues and saturation levels in Photoshop to get the subject in the foreground to match the background. Follow Plant's thorough tutorial to find out how to get professional looking photos ...
This video shows you how to sharpen a jack knife or wood-carving knife using coarse, medium, and fine stones and cooking oil. Use the coarse stone, applying oil to the stone first then pushing the knife down on the stone in each direction, matching the bevel to the stone. Next is the medium stone. Add oil before continuing the sharpening process. Apply cooking oil to the fine stone and finish the sharpening process. Using a leather strop will remove any burrs and polish the knife.
Just by moving one match you can turn the math problem into a correct answer. Definitely use this to get some free drinks. And you already know the answer, so it won't be hard. If you want to try and figure this one out for yourself, pause the video before the reveal.
Creating a unique zebra print eye makeup design. Using a few different products such as a white base, liquid black liner, and hot pink eyeshadow you can create this effect. Video is complete with step by step pictures as well as finished photos. The color of the eyeshadow can be changed to match an outfit and create versatility. Watching this video allows you to create a very different style and look with the versatility to customize it to any particular outfit you are wearing.
Want to create a realistic or customized wood stain for your home? Learn how to get the exact color stain you need to match existing wood finishes or to create unique effects.
Transforming your school uniform to express your individuality can be done very easily with a creative mind. One thing you can do to dress up a pair of pants and a plain tee is to wear different scarfs and belts. Feel free to mix and match. You can even try them with a cute vest or a jacket. Another way that you can mix things up is to change your shoes; you can get a variety of interesting colors or patterns. Also, changing your totes to something cute and different can make you stand out.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
I was about to cut my hair, as I do about once/month or so, and figured I’d share some of my techniques. Cutting my own hair for roughly the last 10 years now has saved me time, lots of time, money, lots of money, and is way more custom. I have run into issues of bald patches here and there, but it’s always fixable for the most part. However, one time I did create a few too many patches that were too deep and had to have them filled in on a daily basis by my girlfriend for about a week with a...
Cary Kolat demonstrates wrestling technique in freestyle defense. Coach Kolat covers defending high crotch for 3 point throws.
Cary Kolat demonstrates wrestling technique of the freestyle offense. He shows you how to turn the basic takedowns into 3 point moves: Single Leg Come Up To Inside Grip Hip Toss. This is a wrestling demonstration from KOLAT.com
4v3 Moving Defenders drill is a great drill to get defenders and attackers on their toes for Australian rugby. It is important to match up fast on this drill as offense / attackers strike quick and defense doesn't want to be caught on their heels.
Learn how to recycle a frumpy winter sweater into a sporty strapless dress! The sexy GiannyL demonstrates this DIY closet hack that's simple and cheap. All you need is one old frumpy winter sweater, pins, scissors, and a sewing machine. Cut along the pattern that Gianny L has demonstrated and sew. It's that easy. Now you have a sporty strapless dress and a matching jacket, too!
Do you believe in fairies? Well, even if you don't you can look like Disney's most popular fairy, Tinkerbell. Learn how to create a Tinkerbell inspired makeup look with this tutorial. You will need Urban Decay Primer Potion as eyeshadow base, MAC Cream Color Base: Luna shadow base to help color stick and stay vibrant, Urban Decay Deluxe Shadow: Graffiti on lid, MAC Mineralized Duo: Fresh Green Mix in crease, Cuberry Shadow: Caribbean Soul in outer crease, MAC Eyeliner Mixing Medium patted on ...
This is an improved ssk (slip slip knit), for which I must give credit to Elizabeth Zimmermann and Meg Swansen. It's improved because it lays a bit flatter and more closely matches the right slanting knit two together (k2tog).
This is a four part series on remaking Cam'Ron's "Oh Boy" produced by Just Blaze using Adobe Audition and Fruity Loops (FL Studio). Part one covers sample chopping, Part two covers finding the tempo, part three covers pitch matching, part four covers arranging it.
F for FAKE. This video has been labeled a "Faux-To". Commonly contested as bogus science, we believe this video to be a hoax. What's your opinion? Comment below.
In part one of her three part instructional video series on setting a cabochon in a bezel, Art Jewelry Magazine associate editor Addie Kidd shows you how to adjust your bezel's height to match your cabochon. This technique is essential for making pendants or any jewelry with a large stone centerpiece. Learn how to set a stone or jewel cabochon by watching this video jewelry-making tutorial.
Have you accidentally been locked out of your mailbox, or lost the key for a cabinet holding all your important documents? For being such small locks, the ones on mailboxes and cabinets can be deceptively difficult. This tutorial shows you how to pick a four cylinder lock easily. You'll need some basic lock picking tools, scaled down to match the small size of the pick. Once you have the right tools and technique down, it's just a matter of being able to get past all the pins.
Is your love of Black Ops matched only by your love of skateboarding? This clip will teach you everything you'll need to know to draw skateboard logo playercard emblem in the Call of Duty: Black Ops Emblem Editor.
Muay Boran is the ancient relative of modern Muay Thai boxing. This clear how-to video shows the correct method of wrapping your fists to prepare for a match or training.
Is your love of Black Ops matched or surpassed only by your love of Android? In this clip, you'll learn how to recreate the iconic green Android logo as your Call of Duty: Black Ops playercard emblem.
Knee high socks are totally school girl chic and help warm up your legs on a cool fall day when you want to stay toasty while looking fashionable. But if you've ever walked around a shopping center for more than half an hour with your knee highs on, you know that they've now quickly turned into mid-calf socks.
Whether you want to make your own placemats for holiday entertaining or give them away as gifts, this is a tutorial for any intermediate quilter looking for some holiday ideas. Create a matching set of beautiful, holiday themed quilted placematas.
This video is an extensive and in depth analysis of how you can best play a four-person team on a multiplayer match in Call of Duty: Black Ops, especially on the Kino Der Toten maps. Always know where to look out for campers!
During the dead of winter when it's 20 degrees below freezing and you can barely feel your own eyes you really don't care that much about the style and fit of your coat. You just want something warm, thick, and cuddly and you want it FAST.
In this tutorial, we learn how to wear scarves for the winter months. For a thinner scarf, you can wrap it around your neck all the way, so it's just a round neck holder. In the summer, you can use this same scarf with a button up and make a bow with it in the middle of the chest! For a larger scarf, you can bunch it up in the middle and then let it drape over your chest, falling to the back. Then, wrap around the sides or leave it how it is. Either way you decide to wear your scarf, do what ...
