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 ...
Learn how to take a quadratic equation in standard form and change the trinomial into a binomial product. Using the zero product rule, the zeros of the graph can then be found. The grouping method is effective when the leading coefficient (the number factor of the squared term) is some number other than 1 (one). From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easi...
Whether you are just starting out doing Chinese calligraphy and painting or a have been doing it your whole life, practice is crucial. Rather than wasting ink, paint, and paper on practice pieces that you are going to discard or throw away afterwards, now you can use a Buddha Board! These devices allow you to use a waterbrush pen and water, no paper, ink, or paint, to create images that will disappear after the water dries! No mess, no waste, just an effective way to practice your art and sav...
Being able to zoom in and out of an image in Photoshop can save you precious time and can be more effective. If you don't know how to do so, it can be challenging. There are various ways to do so and this video tutorial is going to show you them. So find out how to zoom in and out and move your image in the workspace in Photoshop CS4. Sit back, take notes, and enjoy!
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how c...
Do you think you need to spend a hundred bucks to have good cup of coffee? This is not the case! All over Europe, they have been using the French press forever, and now you, too, can take advantage of this energy saving method. This is one of the cheapest ways there is to make a fresh cup of coffee and it is extremely easy to use.
In this video, Merill Kazanjian explains a new effective strategy for drawing cartoons for new artists who wish to draw what they see. For this, we need a highlighter, pencil and a paper. Use the highlighter to make a silhouette of the character. Now draw the outlines of the character correctly over the mass drawing.You will get a perfect cartoon image by doing so. If you are new to drawing, it is recommended that you draw the mass drawing somewhat the same size of the image. It takes about t...
In this video tutorial, viewers learn how write a resume in the table format. A table formatted resume is one of the most effective formats. It highlights metrics in a particular field that potential employers are looking for in a presentable quick overview. At the top of the table, provide your name, contact information and location. In the table, list your skill, experience, role and products from each of your previous jobs and experiences. This video will benefit those viewers who are sear...
Forget to put on lipstick before a photo? Or perhaps you want to spice up an old photo of someone you love. Well their is a way, as 4YouTutorial demonstrates step by step using Photoshop CS4. First upload a photo or image into Photoshop. Next access your Photoshop layers and delete the default locked layer. After, activate the zoom tool and zoom in on the photo where the lips are located. Next choose the quick selection tool (make sure it's on plus) and drag it over her lips. This process can...
A reoccurring problem that many iPod Touch/iPhone users are encountering is their device entering a permanent "recovery mode" state by using firmware. SamlvnErin has an immediate, and effective solution which can fix your problem with little hassle and the procedure is absolutely free. SamlynErin starts off by showing us an iPod in "recovery mode". He then logs into Mega Upload and downloads Quickpwn2.2 by filling a little code fill at the top right hand corner. It then will give you the opti...
This video shows tips on how to use insects to benefit your garden. This will teach you ways to reduce the insect load in gardens without the use of chemicals. Rose aphids can be controlled with lady beetles, for example. Although these techniques have been used for agricultural use, they will work in your home garden. Asian Lady Beetle, tend to stay put. They won’t migrate. They will attack Pecan Aphids. Trichograma, a wasp that is effective against larvae and eggs.
Ever hear of David and Goliath? Well the weapon that David used was none other than a sling. A sling is a very old, but still effective tool that can possibly help save your life someday, especially when it comes to facing wild animals. Find out how to make a parasling using #550 paracord. Enjoy!
This Home and Garden video tutorial shows how to deal with fire ants in the garden. This video is from Danny Lipford. These fire ants have been travelling fast and are spreading rapidly throughout the USA. When a mound of the ants is stepped upon, the entire ant colony will bite and each ant will bite repeatedly. Some people have severe allergic reactions to the ant bites. There are some new products in the market like Over’n Out. You spread it on the entire garden. It takes about six weeks t...
In the summer and fall, swim baits are very effective in luring in forage fishes that have reached their maximum size. In this video, expert Wayne Gustaveson gives an overview of what swim baits are and how you can use them to catch more fish. Swim baits are plastic figures that imitate small fishes. There are various swim baits to chose from and one thing fishermen look for in the bait are the specific sizes and shapes. Each swim bait also contains a core components that is reusable. This in...
This video demonstrates how to play the deadly wide angle pass in the racquetball. The video shows that one of the best kept secrets in racquetball is wide angle pass. It is similar to a cross court pass, but it hits the side wall on the fly around the dotted line. Then it "wraps" around behind your opponent and bounces twice before hitting the back wall. A scene of two players playing the racquetball and making the deadly wide angle pass is shown. The videos tells the wide angle pass is very...
If you're looking for a solution to keeping your books open during a read, you might have considered using a book weight. In this video tutorial, the author will be showing you how to make your very own homemade book weight using a few inexpensive house hold products. The entire procedure can be completed in about 10 minutes, and all you need is some uncoated lead shots, a bag of lentils, a zip lock bag and a sock. You will also need either a sewing machine or a needle and thread to keep the ...
This video shows you how to do interval exercises to build muscle in your legs. Darin Steen, creator of the Fat Loss Lifestyle 12-Week Body Transformation Program, shows you how to do the king of all leg exercises... The Squat! Not just any squat, the smith machine back squat. It is the most effective and safe exercise for massive leg development that you will ever see! For safety purposes make sure you use a weight belt when doing this exercise. Keep your feet shoulder width apart, squat dow...
Kathy Kaehler, a Personal Trainer, talks about how to use an exercise ball. Exercise balls are very effective because they allow you to do multiple exercises at once. Even just sitting on an exercise ball makes you use your core muscles, so you can sit on an exercise ball at your desk and exercise your core muscles at the same time. First you will want to buy your own ball. Make sure to get a quality ball from a reputable seller or brand. Make sure that it is the right size for your height. S...
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 ...
Find out how to give yourself the perfect beard treatment as common misconceptions are unveiled. This video will not only show you how to execute the simple processes of shaving correctly, but also tell us what not to do, and why the barbers we have been going to have not strictly been doing their job right! For a good shave the hot towel should be applied before the lather is applied to the beard. This makes for a smoother and more effective shave, not to mention a more comfortable one. This...
In this video tutorial, viewers learn how to make a tumbler bin composter and compost in 14 - 21 days. The materials needed for the composter are: 1 plastic drum, 6 nails or strong pins, (3) 1 square inch tubes, 3 hinges and lock, 3 yards of wire, and 1 square foot of zinc. Begin by drilling 3/8" holes all over the composter. Use a lawn mower to grind down the compost and then dump it into the composter. Activate the compost by adding some water. This video will benefit those viewers who want...
This video shows how to control a fire ant problem in your yard. Fire ants don't do any damage to your yard, but they can cause damage with their bite.
GiantsMan5 demonstrates how to throw a basic curve-ball. First, don't listen to people who say there's only one way to throw a pitch. Position your fingers on the four seams of the baseball. Unlike a fastball, which you throw straight, to throw a curve-ball, move your wrist in and let the baseball drop during the pitch. By throwing an effective curve-ball, you give it top spin so it drops after you release the ball. Use different grips to control the speed of the curve-ball. You can also thro...
This video is about staging a home for sale. Bridget Kiene, a real estate broker, describes home staging and its significance. Bridget starts with defining home staging and mentions that 92 percent of people advertise their house for sale on the internet. This video also has some tips on home staging, such as, always stage an empty house, create a neutral color palette, eliminate clutter and modernize your decorations. Bridget clearly explains the basic steps we need to follow to sell a house...
In the video, a physical trainer, namely Daryl Stain, explains Fatloss life style exercises. In the video, he explains an exercise to develop top abs with the most time-efficient body transmission exercises. For the exercise, we need a decline bench and a medicine ball. First, take a decline position, then toss the ball to a partner in a slightly bent position. Catch back the ball from your partner. Keep it behind your neck, and go down slowly. Take a deep breath. Relax a second, and come up ...
A boxer knows that during and after a fight, their bodies will be aching. As a part of the job, they grit their teeth, focus and get past the pain. The most important part of a boxer's body, though, is arguably his hands. A boxer depends on his hands to win fights and to train. The best thing one can do to protect their hands is to wrap them properly. This video will show you exactly how to wrap your hands so that they are cushioned and protected against injury. An ideal wrapping job would pu...
Make and apply your own cheap and effective toner and mask for your acne prone skin. 1 Combine apple cider vinegar, sugar, honey, brewed green tea as shown in the video. Be careful to follow the instructions and use APPLE vinegar, not WHITE vinegar. Mix together. 2 Use a pad to apply the mixture to your face. Spread evenly. 3 Use your finger tips, not your palms, gently, rub into your skin. 4 Let the mask stay on for 10 minutes. 5 While you are waiting make a toner by mixing the green tea and...
In this video from Rivalbox, we learn how to throw a right uppercut in boxing. Timing is very important when throwing it. This is thrown when the opponent is trying to box low. Bend the body a little to side, throw the jab, and rip the shot up underneath with the right hand. The power of the shot comes from the shoulder not the elbow. It involves a snapping of the shoulder as the shot comes up under. Viewers of this video will learn how to throw an effective right uppercut in boxing.
Art enthusiast Bob Davies demonstrates how to use charcoal pencils in your drawings. Bob explains that charcoal pencils are useful when you simply want to experiment with a new idea without getting too detailed. What makes charcoal useful is that a wide range of shades, tones, and textures can be produced simply by smudging it with your finger! Bob goes on to show how to draw a quick, simple, yet surprisingly realistic tree using charcoal! This video is a great introduction to an easy, yet ve...
Use this tutorial for a simple and shot accuracy improving technique in pool! The steps for this tutorial are simple, yet effective in improving shot accuracy in pool. Align pool balls in a triangular formation at the far side of the table. Note that this is not the standard triangular formation for pool. Two lines are to be made diagonally from the center back of the table outward. Similar to this formation: \/ where the point would be directed to the back of the table. Leave space in betwee...
Fruit flies are an incredible nuisance, as anyone in any warm climate knows all too well. In this video, with Chef Keith Snow of HarvestEating.com, we learn a simple but effective countermeasure against these aggravating little pests. Most successful, he says, is the use of vinegar.
Working on the inside requires great cardiovascular training, be prepared to train hard. These shots are effective against people who do not know how to defend themselves on the inside. If you are up against someone who is very smart at shots it is essential to know how to defend yourself from the inside. This is very basic and easy. Stand in basic boxing position: hands up, tucked in, not panicking, using the strength of your arms. It is pretty easy, you are in good shape if you can counter ...
A simple yet effective technique which demonstrates how to best cut a pomegranate. Start by cutting out the upper part of the pomegranate. Afterwards continue by applying cuts from top to bottom at regular intervals all around the pomegranate. At this stage you can easily tear the pomegranate open thanks to the cuts applied. At this point you can easily gather the seeds from the pomegranate, in fact some of them start falling off on their own. Follow this video to learn how to best go about c...
In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if you pay attention during this presentation you'll pick up the skills quickly! Several ideas covered in this video are Formulas with cell references, how to find various Excel functions to use in formulas, and the Effect f...
It's never a bad time to get excellent abs. This instructional video demonstrates how to exercise your lower abdominal muscles with hanging leg raises. This routine is especially effective because it maximizes spinal flexion and extension. The focus of the exercise should be about rolling the hips up to generate an abdominal contraction, then returning to a good lumbar curve to relax and stretch out the abs. A good stretch at the end range of motion allows for a better workout and builds flex...
In this tutorial, you are shown very simple steps to put live chat option on your website. In this video web designer Jeff shows you how to put free Yahoo live chat on your website in very easy steps. This tutorial will change your website look more effective and useful. This tutorial shown in very detailed explanation about creating live chat box on your website. He shows a live demo creating professional chat box on your website, but also shows that you can create your live chat box per you...
This how-to video is about how to find a number when its percent is given. This video is really helpful and effective in finding the number when the percent is given, the following steps are explained in the video to find the number when its percent is given:
In this Excel basic video the instructor show how to setup a page in Microsoft Excel. Now you before go to a page setup, first you have to make sure that all the cells are visible in a spreadsheet by extending or contracting the size of different columns. You can also select all columns and make their column width a constant. Now go to the orb and select a print preview to get a preview of how the print out is going to be. Now after checking it out you can make necessary changes in the origin...
The producer of this video is Chaya Radin from the Massbay Community College, Academic achievement center and her video is titled "The effective use of quotes in academic writing". It teaches students how to learn effectively, the topic that is focused in this video is very useful for college students especially for those who write a lot of college paper. When writing college papers and if most of the ideas in the paper are derived from another source, it is always useful to use quotes so you...
Having problems with dandruff? Cant seem to get rid of it?? This instructional video shows you the "right way" of shampooing to get rid of that pesky dandruff. The right shampoo is the key, then comes the technique. Many people are incorrectly shampooing their hair causing large amounts of dandruff. With this video you will learn the correct way to wash your hair learning to keep it clean longer and getting rid of dandruff in an effective way that will keep it away.
