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!
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.
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.
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.
There have been numerous chairs made out of recycled or reclaimed cardboard. This week on the GreenerBusiness Podcast, we attempt to build our own unique comfortable cardboard chair.
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...
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...
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!
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 ...
Learn how to create unique designs and decorations for your clipboard.
It's a good sign for any emerging technology when one of the leaders of an industry adopts it. So when Mastercard, a brand so recognizable that it dropped its name from its logo at CES last year, decides to develop a mobile augmented reality app, the moment is a milestone for the AR industry.
My autistic son loves music. One afternoon, when he was nine, I downloaded GarageBand to his iPhone to help with the boredom of a long wait at a doctor's office. Instead of pacing or escalating into a meltdown, he spent the entire hour and a half practicing, learning, and composing. When we finally left that day, the rest of us exhausted and irritated, he shared his first composition with a big smile.
What's your top pet peeve? Open-mouthed chewing? Nail biting and knuckle cracking? The sound of silverware scraping? Or perhaps it's a bigger behavior, like leaving the toilet seat up?
This tutorial describes how to make a list with unique values in Excel.This procedure makes the defined cells in a column (called as list) NOT to accept repeated values, which makes the list more simple, readable, easy to manipulate when preparing a worksheet.
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!
Gilder's Paste is what distinguishes a so-so piece of jewelry from a truly dazzling, memorable one. That's because Gilder's Paste, which comes in a wide variety of colors and tints, is a type of colorant for brass that can be mixed and applied for a unique look.
Unlike being a square, being a square knot means you're multifaceted, fun, and unique. Of course, we're talking about square knots in friendship bracelet/jewelry making, in which you utilize two different colors of string to create a tight zig zag knot pattern followed by loops.
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.
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...
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.
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...
If you've ever gone Christmas tree shopping before at a Christmas tree lot, then you're probably more than familiar with Noble Firs, Douglas Firs, Grand Firs, and maybe even Blue Spruce and boxwood (used for wreaths). But have you ever considered using other varieties of evergreens in your decorating?
Mar Jennings shows you how to create a unique votive candle holder.
Pain is, for the most part, unavoidable when you stub your toe, break your arm, or cut your finger open. It's instantaneous and, in some cases, long-lasting, but it only feels as bad as you want it to. Yes, that's right—that pain is all in your head.
Bored of the same old tie knot? Now, add a little edge to your look with these unique knots that are so easy to make.
Video: . What is an isosceles trapezoid. The video goes over the properties that are unique to an isosceles trapezoid.
The unique Havel Armor in Dark Souls is well hidden, but if you follow these steps from Giant Bomb, you should be able to find the different pieces of the Havel Armor including Havel's Leggings, Havel's Gauntlets, Havel's Greatshield, and a Dragon Tooth.
The profile pages on Google+ allow you to represent yourself in unique ways to other Google+ users. If you want to edit the information displayed on your Google+ profile, such as the title that appears under your name or who is visible in your circles.
Killzone 3 is the biggest shooter to hit the PS3 in quite some time, and one of it's few awesome unique IPs. This video will teach you how to not be a n00b in this awesome game while using the Marksman (hint: spawn trapping), Infiltrator (stabby stab), Engineer (helps Marksman with ammo for more spawntrapping), Medic (revives Marksman for more spawntrapping), Tactician (spawn-point seizing) classes. Spawn
The Eldar are the Elves of the Warhammer universe, and like Elves they have all sorts of crazy pseudo-magical powers to destroy their enemies. Their tank is called the Fire Prism, and it is somewhat hard to use since it only has one unique gun. Watch this video to learn the proper tactics for using a Fire Prism in an Eldar army to crush your enemies.
There is no mistaking Lil' Wayne for any other rapper on the scene right now. His look is unique and classic. If you think you can rock being a female Lil' Wayne for Halloween, watch this video to learn how to recreate the amazing Lil' Wayne costume the girl in this video has created.
The beautiful game, Football (Soccer for those of you in the US) is full of all sorts of unique and advanced techniques that you can use in FIFA 11 to defend with! Things such as a Secondary Press, Jockeying and even Running Jockey. If you're still getting scored on and are looking for more advanced techniques to try, check out this video for some advanced tactics for defending.
As a guitar player, you will be faced with various challenges in your career, and one of those are being able to blend in with your rhythm section without stepping on anybody elses toes. One way is playing inversions of triads to give a fresh and unique sound to your rhythm and lead guitar playing. In this video you will learn about rearranging triad shapes to make inversions.
The Moog is the original and arguably still the king of the analog synthesizers. It looks like an old phone switchboard, and can create a dizzying variety of unique, warm sounds. This video will show you some advanced features of the Moog, including how to use the sequencer to add filters to your tones.
If you recently purchased Castlevania: Harmony of Despair on your Xbox 360, this next tutorial will help save your life. In this strategy how to tutorial, you'll find out how to defeat the game's most difficult enemies, the stage bosses. Each one has unique powers and attacks, but they also have some different weaknesses as well. They're easy to follow and should be easy to follow. Good luck and enjoy!
The Motorola Droid was one of the first and is still the most popular Android phone. It's hardware keyboard, a unique feature among it's competitors, will keep it there for a long time, but it's performance is starting to lag behind. Why not overclock it's processor, giving it some much-needed speed? This video will show you how to overclock a rooted Droid the easy way, and help you make your phone work faster.
Go simple this summer and turn your Le Sac dress into a cute line style. This is super easy to do and its always fun to try out new styles with your dress, so check it out, along with the other Le Sac options from American Apparel. There's at least TWELVE different possibilities for wearing this unique dress.
If there are words that you use often but Swype doesn't know them yet, you can easily add them to the database of your texting program. In this clip, learn all about adding uncommon or unique words to your Skype dictionary so that you can text even faster. You can even add web addresses, e-mails, nicknames and anything else you use often and don't want to tap out.
Snowflakes make great cookie shapes because each one is different and individualistic. This means that bakers, from seasoned pastry chefs to the miniature little elves whose tiny fingers help you out in the kitchen during Christmas, can have fun creating snowflake cookies of all sizes.
It's time to go achievement hunting! In this video from the great men at Achievement Hunter, you'll be playing the game Skate 3. In this tutorial, you'll be finding out how to get some extra characters and use a couple of cheat codes. The characters are unique and different and the codes are pretty fun to use. So check out the tutorial and have fun!
