Unique Faith Search Results

How To: Develop psychic powers

Roughly half of all Americans believe in extra sensory perception... Are you part of that statistic? Ever get the feeling you have a paranormal ability? You can investigate your psychic abilities and hone your skills with these tips.

How To: Acquire the Cram Opener rare weapon in Fallout New Vegas

In Fallout New Vegas, Obsidian decided to spread and equal amount of unique weapons all across the Mojave wasteland! Ranging from deadly axes, rifles, pistols, submachine guns and more! In this video you'll learn the three ways of acquiring the Cram Opener weapon, a unique version of the Bladed Gauntlet, from Little Buster!

How To: Get the unique Knock Knock unique Fire Axe in Fallout New Vegas

Camp Searchlight may be an infested ghoul town, once owned by the NCR, that's completely engulfed by radiation, but popping a few Rax-X's and a healthy supply of RadAway should do the trick! If you can last long enough and find Logan you'll be able to get the key to the Fire House there in town. Inside of the Fire House lies a unique weapon called Knock Knock, a powerful Fire Axe that looks similar to the ones used by the Pyro in Team Fortress 2! To learn the location and get the axe yourself...

How To: Export OpenOffice.org Draw files to an email

Learn how to share OpenOffice.org Draw files via email from within OOo. More than just a free, open-source clone of the Microsoft Office productivity suite, OpenOffice has its own unique feature set and its own unique way of doing things. Happily, the Internet is awash in free video software tutorials like this one, which make learning the application a breeze. For complete details, watch this OpenOffice.org video guide.

How To: Create drawings in OpenOffice.org 3.2.1 Draw

Learn how to create simple drawings in the OOo graphical editor, Draw. More than just a free, open-source clone of the Microsoft Office productivity suite, OpenOffice has its own unique feature set and its own unique way of doing things. Happily, the Internet is awash in free video software tutorials like this one, which make learning the application a breeze. For complete details, watch this OpenOffice.org video guide.

How To: Work with vector & bitmap graphics in OpenOffice Draw

Learn how to create, edit and otherwise work with vector and bitmap graphics in OpenOffice Draw. More than just a free, open-source clone of the Microsoft Office productivity suite, OpenOffice has its own unique feature set and its own unique way of doing things. Happily, the Internet is awash in free video software tutorials like this one, which make learning the application a breeze. For complete details, watch this OpenOffice.org video guide.

How To: Use the OpenOffice.org 3.2.1 Calc user interface

Learn how to navigate the OOo Calc graphical user interface or GUI with this video guide. More than just a free, open-source clone of the Microsoft Office productivity suite, OpenOffice has its own unique feature set and its own unique way of doing things. Happily, the Internet is awash in free video software tutorials like this one, which make learning the application a breeze. For complete details, watch this OpenOffice.org video guide.

How To: Create nested unique lists in Excel via array formulas

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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.

How To: Do hot pink butterfly nails

In this video, JulieG shows you how to create a unique and artsy nail look. Why bother with plain old red nails when you can get a unique nail look with hot pink butterflies? Bring your childhood back and bring out the art supplies. JulieG will walk you through each step of the way, until you have gorgeous nails to show off!

How To: Make white bean hummus with parmesan and basil

In this clip, learn how to create a unique hummus dip with Dede. Dede loves adding interesting twists to her dips and this one is especially exciting. This hummus is made with white beans and prepared with parmesan and basil for an interesting and unique taste. Follow along with this clip and serve this with chips, pita, veggies or even on a sandwich. Enjoy!

How To: Make a unique paper rose

In this video we learn how to make a unique paper rose. First, grab a square piece of paper and fold it into quarters while maintaining the fold. Then, fold along the diagonals and fold lower in half twice and the top in half twice. Then, fold the halves in half and repeat the previous steps. After this, follow the folds that you created, rotating the paper as you continue to fold. After all of the lines are lined up and you have folded it, it will become a unique paper rose that you made! En...

How To: Make a multi-colored duct tape wallet

Why buy a brand new wallet when you can make one? And out of duct tape! Take the original duct tape wallet idea and kick it up a notch with help from this tutorial presented by Seasonal Science on how to make a multi-colored duct tape wallet. Show off your unique style at school with this unique accessory!

How To: Use the "Unique Records Only" filter 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 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.

How To: Count unique & duplicate records 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 272nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count unique records and duplicate records using the SUMPRODUCT, COUNTIF, COUNT, COUNTA, IF and SUM functions.

How To: Build a simple electromagnet

Electromagnets are super cool to experiment with. In this educational video, Science Bob teaches us about electromagnets - what they are and how to build one of your own. These magnets are are very powerful and make an extremely neat experiment for the science fair. Electromagnets are unique in the sense that they convert electricity into magnetism. Try this experiment with your kids for a unique science lesson.

How To: Make a cute Thanksgiving card using stamps

In this tutorial, we learn how to make a cute Thanksgiving card using stamps. First, cut an oval shape with an oval template. After this, you will stamp the image from the harvest home stamp set on watercolor paper. After this, outline the image with SU markers and color the image in with an aqua painter brush. From here, scallop the edges of the design to make it look more unique. Then, glue the stamp to the card stock and use it as the front of a card for the holidays! Experiment with diffe...

How To: Create a distribution for categorical data in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...

How To: Make a ring from a coin without power tools

Looking for an incredibly unique gift? In this video, learn how to make a cool, long lasting ring out of a coin! All you need is the coin (whichever size is best suited for your finger), hammer, file, emery cloth, saw and a hand drill. With this method, you will be able to see the writing on the outside of the ring, so everyone will know how unique it is. This would make a perfect gift, fashion statement or even wedding ring!

How To: Fold an origami Christmas tree ornament

Origami is simple and fun and our host proves that right off by displaying how little we actually need material wise, to make something unique and pretty. Just two swathes of patterned paper, put flush together and a paper clip. First folding your little construction into the shape of a tiny kite It gets very precise from there. Incorporating smaller and smaller folds, but with a close-up view and a step by step explanation, this video will ensure success. After creating your unique abstract ...

How To: Make a beautifully unique beaded windchime

Do you have a bunch of flawed beads left over after you make your crafts? You know the ones, the chipped, cracked, sharp ones that don't make the cut and usually get tossed in the garbage? Why not make those into something lovely, where the cracks don't matter? In this two part tutorial, learn how to turn your discarded beads into a beautifully shiny wind chime for your backyard. This chime is unique and makes a lovely noise in the wind. Let's get crafting!

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: 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...