Remaining Non Metropolitan Search Results

How To: Replace bathtub sealant or caulk with Rob Hazelton

In this video tutorial, viewers learn how to replace caulk on a bathtub. Begin by placing a fresh blade into a utility knife. Then use the knife to cut out the old caulk. You want to make 2 cuts. The first cut with the knife plying flat on the edge of the tub. The second cut with the knife tip up at about a 45 degree angle. This will allow most of the caulk to come out in one piece. For any remaining caulk, take a razor blade and scrape it off. To remove any remaining mildew, apply 6 ounces o...

How To: Use non-standard page protectors when scrapbooking

In this Arts & Crafts video tutorial you will learn how to use non-standard page protectors when scrapbooking. It is a tip on getting a large number of photos in an album without taking up too much space or using too many supplies. You can get 12 x 12 page protectors in terms of size but with pockets for 4 x 6 photos. This way you will have 6 photos on each side of the protector. Or maybe you put 5 photos and a card on one side. If you don't want to mess around with extra page protectors, you...

How To: Return the address of the 1st non-blank cell in 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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.

How To: Return a row's first non-blank cell 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 364th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the INDEX, MATCH & NOT functions that will return cell content from the first non-blank cell in a row.

How To: Make non-toxic play dough

This video shows how you can make non-toxic play dough at home. The ingredients that you will need are flour, water, oil, cream of tartar, salt, food coloring, and peppermint essence oil if you want a scent. Put in a medium sauce pan 1 cup of flour, 1 cup of warm water, 2 teaspoons of cream of tartar, 1 teaspoon of vegetable oil, and 1/4 of a cup of salt. Turn on the stove to medium heat. Stir ingredients and you can add food coloring now or wait later and make separate colors. Remove when it...

How To: Make your own non-toxic surface scrub

It is of course, non-toxic, and usable on just about anything, from counter tops to pots and pans. To make the basic scrub, you simply need baking soda, as well as essential oil for scent. The advantage of this is that there are a variety of different essential oils out there--if you're tired of the typical commercial cleaner smells, you can make your cleaning scrub smell just about any way you want. To make a more powerful scrub, you can add Borax to the baking soda mixture. The result is a ...

How To: Add decimals

This video explains how to easy add decimals. Adding decimals can seem to be a tedious job, and a single mistake can result in a completely different number. In reality, it is quite easy, and with a good method and some practice it can be done quickly. Write the two sets of numbers out, lining them up in columns. Keep the decimal points on top of each other and line up the non-decimals with non-decimals and the decimals with decimals. Start at the right-most column and add it up. If it become...

How To: Explore Shamanism through Ayahuasca

"Shamanism: Other Worlds" explores the ancient spiritual Amazonian enlightenment drug Ayahuasca. This documentary investigates Ayahuasca and its use largely as a religious sacrament. Those whose usage of ayahuasca is performed in non-traditional contexts often align themselves with the philosophies and cosmologies associated with ayahuasca shamanism, as practiced among indigenous peoples like the Urarina of Peruvian Amazonia. The religion Santo Daime uses it. While non-native users know of th...

How To: Prep any non-patent leather shoes for custom painting

When fancy kicks started making their way into the indie scene, the art of custom leather shoe painting exploded. If you want to custom paint some kicks to show you creativity in this high-visibility area, watch this video for an in-depth guide to prepping any leather (not patent leather) shoes for painting by using Acetone, cotton balls, and other basic materials.

How To: Crack the lock on a safe without destroying it or leaving a trace

Safecracking is something that most of us will only come in contact with in the movies, where strange men and women stick their head against safes and twist dials until the safe magically opens. If your interest in gaining entrance to safes that aren't yours goes beyond that, this video will teach you most of what you need to know. It features a prominent lockpicker giving a 30 minutes presentation on non-destructive safecracking techniques.

How To: Model in Cinema 4D

Nick from Greyscale Gorilla shows you how to use primitives, splines, nurbs, deformers, and Mograph in order to model in Cinema 4D. It's not necessarily great for organic modelling but is wonderful for inanimate, non carbon-based objects.

How To: Make magic rainbow milk

Though your kids will think this "rainbow" milk looks really cool and will instantly want to consume it, doing so may not be the best idea. That's because in order to create this rainbow milk you'll need to mix in color additives and very non-edible soap.

How To: Make chocolate rice krispies treats

In this tutorial, we learn how to make chocolate Rice Krispies treats. First, you will need 1 stick of butter, 12 oz package large marshmallows, 6 c Rice Krispies cereal, microwave safe bowl, and nonstick pan. Now place your butter and your marshmallows in the bowl and microwave for one minute. Then, use a spoon to mix together the mixture and place in the microwave again if it isn't melted, two more minutes should be perfect. After this, spray non-stick spray on the pan and then mix the mars...

How To: Make cottage pie with minced beef

In this video tutorial, viewers learn how to make a homemade cottage pie. The ingredients required for this recipe are: minced beef, non hairy mushrooms, frozen peas, 1 diced onion, carrots and beef stock. Begin by heating a pan and start adding the onions. Then add the minced beef and cook until it is brown. Users may choose to add some garlic. Now add the non hairy mushrooms. Then add the peas and carrots. Season with some pepper and add in a few dashes of Worcestershire sauce. Finish by ad...

How To: Make a beaded watch band with a non-loop watch face

In this video tutorial, viewers learn how to make a beaded watch band with a non-loop watch face. Begin by cutting 2 pieces of the stringing materials to approximately 10 inches. Then put one end of the string through the hole of the watch face and pull it to about halfway. Now users will have 2 strands to work with. Users may choose to making a double strand watch band by putting beads on both strings, or a single strand watch band by running both strands of string through a single bead. Fin...

How To: Clone a hard drive from a non-bootable computer

Although computers are intended to make life much more easier, they can sometimes be confusing as cheese! So, it's fine if you need help trying to figure out how to do certain tasks. Like this one here. In this tutorial, you'll be finding out how to clone a hard drive from a non-bootable computer in no time at all. So check out the video above, good luck, and enjoy!

How To: Extract records from non-blank fields 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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).

How To: Make non-mushy quinoa

Marni Wasserman at the Toronto Vegetarian Food Fair demonstrates how to make non-mushy quinoa. The trick to making quinoa that doesn't come out in a big clump is to dry roast it. Take the quinoa and put it into a pot and put it over heat. Move the grains around until all the water is evaporated. You'll smell the nutty aroma of the quinoa as it's being dry roasted. Once the quinoa is dry roasted, add two cups of water to one cup of quinoa. Let that come to a boil with a little bit of sea salt ...

How To: Understand different immune system responses

This is a presentation of different types of immune responses in human body. There are two types of immune systems i.e., non specific and specific or adaptive immune system. Again, non specific immune system is sub- divided into barriers. It is the first line of defense. The second line of defense is the inflammatory response. They are phagocytes. These are all products of white blood cells. It is also called as leukocytes. Lymphocytes are another type of white blood cells which are carriers ...

How To: Use non-destructive editing with Camera Raw

This video shows you how to non-destructively edit camera raw, JPEG, or TIFF files using Camera Raw in Photoshop. You learn how to manage basic settings, as well as manage settings for curves, sharpening, HSL, grayscale, and split toning. Check out this video created by Katrin Eismann now! Use non-destructive editing with Camera Raw.

How To: Send Animated Activity Stickers (That You Didn't Earn) in iMessages

If you have an Apple Watch, you might know that the activity awards you earn can be shared with your friends as iMessage stickers on your iPhone. However, you first have to earn achievements in order to use them as stickers. That changes somewhat with iOS 12, as Apple added animated activity stickers for all Apple Watch users, whether they've earned award badges or not.

How To: Make your own non-toxic disinfecting cleaner

In this video, Jennifer Taggart Of Healthy Child Healthy World shows us how to make a non-toxic disinfecting cleaner. You can use this cleaner for almost any surface in your home. What you'll need is a re-purpose spray bottle, some castile soap, some tea tree oil, and water. For the water, it's preferable to use distilled water, but you don't have to. The distilled water ensures there's no bacteria or anything in it. First, if you're re-using a spray bottle make sure it's clean. Add 2 cups of...