Unique Method Search Results

How To: Learn the 'quilt as you go' method

Quilting! Is there anything better!? Well, no, but one thing easier is the quilt as you go method. This video will show you what to do and how to do it. You'll want to have some baton, backing, thread, scissors and of course lots of pieces of fabric. The fabric doesn't need to be the same color or style and in fact, the more different the fabric the crazier your quilt will be. Check it out! Get quilting, and learn the quilt as you go method today!

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: Highlight rows that contain unique values 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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...

How To: Solve two linear equations by the elimination method

\When both equations in a linear system are in the form Ax + By = C, you can solve the system using elimination. How is this method different from substitution? The idea behind the elimination method is to create a new equation from a combination of the original equations in the system. The new equation is formed by adding or subtracting the originals. When we combine two true equations, the sum or difference must also be true.

How To: Use polymorphic methods when Java programming

Want to write Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to work with polymorphism when coding in Java. For more information, including detailed, step-by-step instructions, watch this programmer's guide.

How To: Count unique values greater than a hurdle in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

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: Solve a 5x5x5 Rubik's Cube faster

This video shows an explanation for an Advanced Edge Pairing method for the 5x5x5 Cube. The method used is as follows. First, you should match up edges on the middle layers (in the build ring) to form complete "tredges," or triple edge pieces. Then replace and store these tredges on the Up and Down faces of the cube. This method CAN be applied to any size big cube!

How To: Stand up on a surfboard

Surfing: Hang Ten The ocean is a force of nature that refuses any effort to tame it. To throw one's self on the mercy of this beast is a courageous act. With the help of this trick guide, you can learn to harness that power and push your water-borne adventures to new heights. See how to stand up on a surfboard.

How To: Wrap your hands for Muay Thai boxing

There are many different methods of wrapping ones hands when they are doing Muay Thai boxing. This clear, concise video shows a simiple method that you can try as well before you start your mortal combat. The emphasis on this tecnique puts wrist protection over knuckle protection.

How To: Return values from a method when programming in Java

In this clip, you'll learn how to return a variable value from a method when coding in Java. Whether you're new to the Java object-oriented programming language or are a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.

How To: Use the pour over method to make coffee fast and easily

Drip coffee makers are fast and easy, but make a lot of coffee that doesn't taste very good. If you just want one good cup of coffee in the morning and don't want to buy any special equipment, watch this video. It will show you how to brew coffee using the pour-over method, in which you make one cup at a time without expensive machines or equipment.

How To: Roast potatoes like a restaurant chef

A classic side dish for any hearty meal is roasted potatoes. Works for breakfast too for home fries! (kinda) If you've been trying but haven't quite found the right way to cook your potatoes then you're in luck! In this video, chef Jason Hill goes into detail on his methods of making perfect roasted potatoes every time and it all starts with the right cooking method.

How To: Change the oil in your car to help its engine last

Changing your engine's oil yourself isn't just great for your car, it's great for your pocket book. This DIY auto maintenance guide presents an overview of the standard method for changing a car's oil, a method which applies for most modern automobiles. For a detailed walkthrough, and to get started changing your own car's oil, watch this home mechanic's guide.

How To: Factor trinomials with the "bottoms up" method

After an easy way to factor trinomials in algebra? Try the bottoms up method! Learn how with this free video lesson. 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 finish your homework or study for that next big test).

How To: Create a simple java program with the printline method

Want to write Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to create a simple Java program that utilizes Java's built-in println method. For more information, including detailed, step-by-step instructions, watch this programmer's guide.

How To: Get rid of ants using safe methods

One of the most annoying insects out there would be ants. Not only are they small and tiny, but when you find one you'll more than likely find a great big colony. They're annoying to deal with and when not taken care of, can live inside your home for many years to come. So in this tutorial, find out some safe methods to getting rid of ants. Enjoy!

How To: Change eye color using Photoshop

This seven minute and three second how-to YouTube video, uploaded by user ranash19195, instructs it's audience to 'Change eye color in Photoshop'. There are two methods that are taught: using a hue/saturation mask or a color change mask. The instructor uses clear and concise language to teach both methods. He takes you on a step by step visual and auditory journey and makes learning to change eye colors (retouching photos) both exciting and extremely easy to accomplish.

How To: Solve a system of equations via the elimination method

Elimination in mathematics is used to find the solution set of a system of equalities. This video tutorial shows how to use elimination to find the solution set of a given equation and offers several examples to illustrate the process. Before applying this method, the equation must be in the form “Ax +By=C.” When graphing a set of mathematical equations that intersect, the answer to the elimination is the point on the graph where the two lines cross.

How To: Insert and remove a menstrual cup

This menstrual hygiene video offers information on the insertion and removel of wearing a menstrual cup, the latest method in menstrual/period protection. Menstrual cups provide an alternative to potentially unhealthy and wasteful methods of feminine hygiene such as the tampon or sanitary napkin. Follow along with this feminine hygiene video and learn how to properly insert and remove a menstrual cup.

How To: Wrap gifts with the furoshiki eco-friendly method

Join Molly de Vries and pick up some new holiday tricks with a green conscience. She shows us how to make a festive fabric garland from attractive scraps, then shows a furoshiki fabric gift wrapping technique. Molly is a sustainable textiles maven and creator of Ambatalia "The Fabric Society." Learn how to wrap gifts the furoshiki method.

How To: Use authentication in Axosoft OnTime

There are two different methods of Authentication in OnTime, and each method has two different ways that the authentication can take place. In this installment from Axosoft's own series of video tutorials on the OnTime Project Management Suite you'll learn about these forms of authentication.

How To: Stockinette stitch for knitting projects

Watch this instructional knitting video knit a stockinette stitch using the Contintental method. This means you will knit on one side of the piece and purl on the other side. Stockinette stitch tends to curl at the edges, which add a nice finishing touch to sweaters or hats. Knitting with the Continental method only means that you hold the yarn with your left hand.