Unique Obstacles Search Results

Walkthrough Assassin's Creed 2: Mission 56

And They're Off: Time's crucial in this missions, so be careful. You've got a limited amount of time to complete this fairly challenging obstacle course. A series of waypoint show up one after the other, and you've got to run through all sixteen of them, quickly. The first four are on ground level, so you don't waste time climbing any buildings. The fifth waypoint will start you on an ascent up the side of a building, and from then on you can expect next bunch to require some careful platform...

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: 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: 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 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 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: Teach a dog agility exercises

Learn how to train your dog for an agility course for exercise, obedience, show or competition. Teach them techniques on agility obstacles, such as Chute, Table, Tire, Tunnel, See-Saw, Jumping and other moves in this free video series and guide.

News: Baidu Teams Up with Leading Chinese Tier-Ones for Driverless

Baidu signed a cooperation agreement on June 7, the first day of the CES Asia conference, with multiple companies in the autonomous vehicles industry. The companies listed in the press release include Desay SV, United Automotive Electronics, and Hangsheng Electronics, as well as possibly additional auto manufacturers. Baidu plans to "jointly develop" upcoming intelligent driving production plans.

Meet Tanky: The Super Smart DIY Tank Robot That Can Map Its Own Surroundings

There are plenty of tank robots out there, but how many of them can recognize 3D objects and map their environment? Tanky, the tracked mobile robot, can do all that and more while rolling around on his bicycle chain treads. Created as a Master's thesis project, Tanky is made almost entirely of parts you can find at your local hardware store. It was built in two "layers" with the motors, electronics, and batteries on bottom and the processing unit, a laptop, on top. The motors came from cordle...