Unique Endeavor Search Results

How To: Pass a swimming test as a Boy Scout

As a Boy Scout, when the First Class rank is attained, a scout has learned all the basic camping and outdoors skills of a scout. He can fend for himself in the wild, lead others on a hike or campout, set up a camp site, plan and properly prepare meals, and provide first aid for most situations he may encounter. A First Class scout is prepared.

How To: Do a line rescue in the water as a Boy Scout

As a Boy Scout, when the First Class rank is attained, a scout has learned all the basic camping and outdoors skills of a scout. He can fend for himself in the wild, lead others on a hike or campout, set up a camp site, plan and properly prepare meals, and provide first aid for most situations he may encounter. A First Class scout is prepared.

How To: Avoid cyber bullies as a Boy Scout

As a Boy Scout, when the First Class rank is attained, a scout has learned all the basic camping and outdoors skills of a scout. He can fend for himself in the wild, lead others on a hike or campout, set up a camp site, plan and properly prepare meals, and provide first aid for most situations he may encounter. A First Class scout is prepared.

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: Jump into deep water and swim as a Boy Scout

Second Class Boy Scouts work on building their outdoor survival and camping skills. Compass work, nature observation, camp tools, and swimming are areas where new skills are mastered and demonstrated. A second class scout, having completed all the requirements, should be able to lead a hike, care for his own equipment, set up a campsite, and perform basic first aid.

How To: Complete an orienteering course as a Boy Scout

As a Boy Scout, when the First Class rank is attained, a scout has learned all the basic camping and outdoors skills of a scout. He can fend for himself in the wild, lead others on a hike or campout, set up a camp site, plan and properly prepare meals, and provide first aid for most situations he may encounter. A First Class scout is prepared.

How To: Do dumbbell squats

Squats are probably the most useful exercise you can do at the gym—no other single exercise encourages more muscle growth. With a range of motion that incorporates many different muscle groups in the legs, core and upper body, squats not only strengthen those muscles, but also strengthen the tendons and ligaments that connect them. In addition to their strength-building benefits, squats also teach you core stabilization, which is important for almost any athletic endeavor. Learn how to do dum...

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.