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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...
Cooking quinoa is similar to preparing cous cous. Both are grains and both will soak up the water or broth you place them in to become warm and fluffy. If you have never had quinoa before, you should definitely give it a try. This delicious grain is one of the most healthy things you can feed your family.
You will see a great way to light and set up a blue/green screen for your next video. There are a lot of tips that will come in handy if you want to film on a blue/green screen and don't want to pay outrageous fees to do so. The key in setting up is to block out all outside sources of light so you have just the desired amount of lighting coming just from your own sources and also setting up the screen and stretching it out as tight as possible so you won't see any creases or snags in the mate...
If your garbage disposal is backed up and starting to smell, you will need to unclog it. In this tutorial, learn how to do this all on your own and avoid the hefty fee that comes with calling a plumber. Although this seems like a difficult task, it is really much easier than you would think. So, if you are having trouble getting food and water to flush smoothly down the disposal, follow this step by step lesson and clear up that clog!
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform debt analysis with the following input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Pay...
In this video, we learn how to prepare a meal for a Crested Gecko with Wally. The complete nutrition for gecko's is the two-part MRP pre-packaged meals. All you have to do for these is mix with water. These are the only meals that combine all proper nutrition for your gecko and avoid killing insects that don't last long and don't provide all nutrition they need. These packages come in two parts that can be store in Ziplock bags that will last for 6 months when stored in the fridge. Not much e...
Jerry Lavender demonstrate how to build confidence in your children. Use secure attachments to provide a stable base for your child. Your child will fee safe to explore the world. Provide structure and predictable environment for your child. This will enable your child to relax. Use a stable routine so that your child knows what to expect during the day. Encourage your child to play with people in their environment. Sports and physical activity raise endorphins and increase happiness. Remembe...
Before you make that extended camping trek out into the wilderness, there are a few things any self-respecting camper should know how to do. And one of those things is how to safely feed oneself. With this free video guide, you'll learn how to practice food safety when roughing it in the wild.
Kale is a hearty and delicious vegetable that packs tons of health benefits. Kale is inexpensive to buy, can feed many and is hard to ruin because its leaves are so strong.
In this video, learn how to use Google Reader with RSS, Atom, and/or XML feeds. Feeds allow sites to "pull" information from the web without having to visit the site manually. It also helps prevent web users from having to go "check" a site for updates because the feed will check for you! In this video, learn how to add and remove feeds from Google reader and get tips on how to sort & read them these feeds effectively.
In this video Dee Holt is going to show viewers how to prevent motion sickness when they're taking their dogs for a nice ride. First she starts off by telling listeners that if they happen to have a new dog or puppy it's very important that they get their pets used to riding in a car. A dog can get motion sickness so it would be very helpful if you always take a sheet or towel with you just in case. A person should never feed their dog or give them a lot of water within four hours of a car ri...
Whitney shows a quick way to make a bag out of t-shirt sleeves. This bag has so many household uses and is easy to make. You'll need a sleeve, safety pins, scissors, scrap fabric, pins, thread, an iron, and a ruler. Start by cutting a 1 inch wide strip of fabric and any design you'd like. You can make the bag as large as you like. Cut your rectangle using the ruler. Position your design to the fold. Sew around the design you choose, refold your rectangle and pin. Sew along those two lines. Tu...
In this Electronics video tutorial you are going to learn how to hook your phone up to your computer using Bluetooth. Keep only one phone around the computer while doing this. On the phone go to options, discovery mode and ensure discovery mode is ON. Then go to ‘horizon’ > menu > settings and tools > Bluetooth menu > add new device. Now on your computer go to Bluetooth and ensure discovery mode is ON. Then click on ‘set up Bluetooth device’. Now select ‘mobile phone’ and click ‘continue’. Pu...
In this how-to video, you will learn how to groom your dog. Grooming is important for any kind of dog. It is important to find a groomer if you cannot do it yourself. Hair under the arms should be trimmed, otherwise it will become dread locked. It is also important to brush your dog's teeth on a regular basis. You can feed your dog with a brand that is good for teeth care. Purchase and use a brush specially designed for dogs. This will help keep your dog's hair from becoming matted. Teach you...
Fetch is an FTP program for Macs (Smart FTP can be used if you don't have a Mac). These can be downloaded from Download.com
This video visually explains how to convert your hoodie into a strapped bag. First lay the hoodie face-up onto a table or other flat surface. Then you take a normal belt and, holding it in one hand, feed it in from one sleeve all the way through to the opposite side. Once the belt is peeking out through both sleeves, buckle it together. You can then place the items of your choosing inside the hood, tying it shut, while using the belt as a strap that you can hang around your shoulder like any ...
This video explains how to create a pair of Swarovski crystal earrings. You will need a tooth headpin, two pear-shaped crystals, two spacers, two diamond beads, and sterling silver ear hooks. First, slide the pear-shaped crystal onto the head pin. Follow with a spacer, a bead, then use a pair of pliers with a side-cutting edge to cut the wire and bend at a 90 degree angle. Use round-nose pliers to then create a circle at the end of the wire, then 'squash' a bit with the other pliers. Then ope...
This is a very useful instructional video on how to use Skype to call anywhere in the world. You can go to Skype .com and click account and open a new account with Skype. Now log on Skype using your user name and pass word. now you can click the free calls button and you can call any one from any country across the world. You can also call mobile phones in the USA and Canada by paying a nominal fee. However you can talk with any one for unlimited time. It is very easy to use Skype. Your priva...
Laura Bateman, of Extreme Fitness Now, demonstrates how to wrap your hands for boxing. Wrapping is important for protecting your wrists and knuckles from injury. Mexican hand wraps are longer than the typical hand wraps. Place the looped end of the wrap over your thumb. Be sure to position the wrap the right side down. Next, wrap it around your wrist three times. Feed the wrap under your thumb, under the palm and up to the knuckle of the index finger. Wrap the knuckle two times. Cross down to...
The video shows us how to solve a system of equations with the elimination method. First write the two equations one on top of the other, as it is going to be elimination method and it is recommended to write it in that way. Here the 2 equations are x+y=-3 and x-y=1. In the elimination method we need to add the 2 equations by columns. So adding it column wise we get to have 2x=-2 and solving this we will get the value of x=-1. Then you need to substitute this value of x in any of the two equa...
This video explains how to make authentic French toast when entertaining guests. The recipe requires some preparation to be performed the night before the guests arrive, as well as some baking the morning of the event. This recipe really captures the essence of French toast by using nutmeg, cinnamon, freshly baked French bread, milk and eggs. While ideally designed for entertaining guests, this recipe can also be modified to feed a family for breakfast. In the video, the recipe feeds about 12...
The video shows a unique method of solving a Rubik's cube. The method is called F2LL or 'winter variation'. There is very little information about this method on the internet. It deals with Corner Orientation. The person in the video is a skilled cube handler. There are 27 algorithms and their mirrors in the F2LL method. While you form an F2LL pair, you need to orient the corners at the same time. This method makes cube solving all the more easy.
Becca from Amazing Paper Grace demonstrates how to make crepe paper flowers. The supplies needed are a roll of crepe paper, scissors, a ruler, and a sewing machine or needle and thread. Measure a yard of crepe paper and trim it narrower if you want a smaller flower. Use the sewing machine to sew a straight stitch along one edge with the longest stitches. Pull the thread to gather the paper so it curves around to form a flower shape. Layer the curves around in a spiral to form the flower. Feed...
How to Use the Highest Common Factor method for Factoring
Is it getting to that time? When the strings on your bass need changing & you're not sure how to replace them? Don't take it in to a guitar shop and pay a string changing fee... Learn how to change bass strings yourself! In this two-part video tutorial, learn step-by-step how to replace old bass strings with brand new ones.
In this math tutorial, you will learn how to reduce fractions using the prime factoring method. The narrator, a math teacher, of the video begins by defining what prime numbers are. This is important to know. When reducing fractions you need to reduce both the numerator and the denominator down to numbers that cannot be reduced by any other numbers but 1 and itself (prime numbers). The method the video teaches is to find the prime factors of both numerator and the denominator to simplify the ...
The method explained in this video is a very simple method to get rid of fruit flies. Materials required for this method are:
A video from free math tutoring that teaches you a method of factorization of a complex polynomial. The tutor shown in the video demonstrates how to factorize common functions of a variable by the factor method. This video isn't for advanced learners of mathematics. It is for beginner to intermediate level viewers.
How many times have you locked your key inside your car and had to pay those outrageous locksmith fees? Ever worked for an hour or sometimes longer trying to coax a coat hanger in through a window, all the while wishing there was an easier way to unlock your car door? Well, there is, and this video will show you how. You can pop that lock open in a matter of seconds with something as simple as a tennis ball. Check it out!
Do you want to learn how to make fire with a magnesium fire tool? Then all you need is a magnesium fire tool and this video. First of all, you need some kindling ready such as dry grass, small leaves, twigs, etc. Create a small pouch for the magnesium strips, then shave small pieces of magnesium into this pouch. Then, use your knife and move it against the flint side of the tool. This will cause a spark, which will catch on fire and the magnesium will assist in allowing this flame to grow. La...
Jeff White gives guidelines in this video about bed bug bites. The first thing is that bites will show up in clusters or rows. They feed at night and it takes 5 to 10 minutes to fill up on a blood meal. That is why there are rows of bites or a cluster.
Patti Moreno, aka “the Garden Girl” shows us how to make compost tea for your garden. You need to prepare compost tea and feed to the plant. To prepare compost tea, first you need to take coconut fiber soil, put it in a cloth, and tie it. Place in a 4 gallon of bucket of water. A little bit of compose may fall out, and slight bubbles gases may form, but this is not a problem. Keep it like this for 24 hours, and your compost tea will be ready. Take this mixture to where you keep your soil and ...
Looking for a cheap stabilization method? Look no further. In this vieo, learn a great (& inexpensive) stabilization method steadicam steadytracker using a cheap tripod with your Canon 7D/5D.
Check out this video cooking tip from The Chef's Toolbox in Australia. Watch this tutorial to learn how to cook rice with the rapid boil method like a chef. Cooking rice is easy with a little know-how, see how to do it right here.
A great way to rack your brain is by trying to solve a puzzle, so grab your puzzle and get solving! If you need a little help, this two-part video tutorial will show you how to solve the classic Rubik's Cube F2L with the Fridrich Method. The 3x3 Rubik's Cube is one of the most baffling puzzles on the market today, so make sure your up to speed on solving it. Watch and learn a few algorithms to get your puzzle solved! Wait, there are no algorithms for the Jessica Fridrich Method when solving t...
Find out a new way to solve the Rubik's Cube made famous by Erno Rubik, master puzzle maker. Try to get the OLL (Orientation of the Last Layer) using a new method that lets you look at the cube and figure out a two algorithm move solution to orienting them correctly. Just watch this video tutorial to see how to solve a Rubik's Cube with the Compound OLL method.
Need to know how to tie a Bowline with a few ways of securing it? This way shows you how to secure it with a seizing so that it won't accidentally come undone. Included is a little variation of the bowline with a built-in seizing. If you don't have electrical tape to secure the bowline feed the bitter end back through the hole. It also makes it so you don't have a tail line dangling if you're towing something.
The English or throw method, shown in this how-to video, is a way of purl knitting with the right hand. Yarn is held in right hand, then, by necessity, wrapped around the right needle before pulling the stitch through. Watch this video knitting tutorial and learn how to do the purl stitch by the English or throw method.
The Neelys are cooking up a feast big enough to feed the whole clan, including dessert. Watch as they make honey cornbread muffins. This cooking how-to video is part of Down Home with the Neelys show hosted by Gina Neely. Pat and Gina Neely and their family own and operate some of Tennessee's best, and devilishly delicious, barbecue restaurants. But when they are relaxing at home in Memphis, they love to create tasty dishes their whole family can enjoy. Now they're ready to share secrets from...
One important part of jewelery making involves properly attaching clasps. This how-to video jewelry making tutorial demonstrates the proper way to attach them. Begin by threading the crimp bead and the clasp onto the bead wire. Using chain nose pliers feed the thread around and loop it back around through the crimp bead. Use the pliers to hold the crimp bead tight. Crimp the bead down securing the wire and clasp.
