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...
There are so many ways to enhance your photos in Photoshop these days, it is amazing we need actual models at all! In this video, learn how to add or change the makeup on your model. If you have changed your artistic idea after shooting, or feel like your subject could just use a little something, check out this tutorial and learn how to add color to your photos.
In this video from ChickerOutItsSARA25 we learn how to make a fake lip or nose ring using a spiral notebook. At the end of the spiral notebook, pull out the spiral so one loop is out and take your scissors and cut it. Bend it until it breaks off. Now you have a small ring. Bend it into a circular shape to it looks like a nose ring or lip ring. Now before you go and get an actual piercing, you can see what you would look like with a nose or lip ring by making your very own face lip or nose ring.
Step1. Determine the type of job you want. Make sure that you have a detailed and complete profile on ‘linkedin’. You must also have a number of connections. Then decide which job you are looking for and the typical functions and titles. Also choose which type of industry you would like to work in and also choose what locations. You also need to write down specific names of organizations that you want to work for and who are they.
This video shows how to hack the computer password for Vista. We can change the computer password without knowing the actual password. First go to Start menu. Type in the Search "cmd". Then right click on that folder and run as administrator. Then we get a pop up. Type in their net users. Pick the user that we want to hack into. After picking the user type in net user the username and then * . After typing this hit enter key and it should say the command completed successfully and we have to ...
Christine from ExploreModeling.com shows you how to tweeze your eyebrows yourself without painful waxing or expensive treatments. First, you need a high quality tweezer with a very small point and a tweezer with a wide point. The small point tweezer is good for plucking single hairs, and the wide point tweezer can pluck a few hairs at at time. The first area you need to tweeze is the area between your eyebrows. Don't go too far into your actual eyebrow area. Then, to make your eyebrow natural...
To remove grout from a tile patch area, use a scouring pad on a sponge to gently go ontop of the tiles to remove grout and see where you need to rub harder, but dont rub hard on the actual joint. Don't get your sponge too wet. Once you have everything off the tiles, work on the grout. Make sure you get the grout lines to make them look neat and clean. Make sure the seams are tight and flush, run your sponge over it to clean it up a bit. If you have a missing tile filled with grout, use a wet ...
The Gardening Guru demonstrates how to prepare and lay pavers in a multi-level adjoining area. First, get a garden stake use it to measure the evenness of the terrain and to set the height. Put the leveling tool on top of the pavers to even out the dirt. Then, lift out the rails. Once the rails are removed, you can then set the pavers directly on the dirt. If you prepare your area correctly, you will save a lot of time when you execute the actual project. This technique is useful when dealing...
This is a video tutorial on how to perform the "Out of Order" card trick. For the trick, you need a deck of cards. The effect of the trick is that after showing the deck to the spectator, the performer deals out the deck into 3 piles. He collects all the piles and makes a new deck. Then he cuts the cards and deals out the deck in the same way one more time. Then he makes a new deck and deals the cards into 12 piles. Every 13th card is an ace and all the piles have all the numbers together i.e...
Would you like to impress all your friends by making 23 different smileys/emoticons on Facebook while you chat with them? Some of them are simple and easy to guess because they are used almost everywhere, but some of them are not so common.
This video provides a diagram and explanation of the some of the more common mysteries in palm reading. Although the video does not provide much instruction for the actual act of palm reading, the diagrams are very helpful in determining which lines on the palm of the hand would be used to conduct a reading. The diagram shows the names and locations of each line that can be read on the palm. The life line, line of affection and line of intuition are explained in detail. The psychic cross is a...
In this video, Marc Nelson describes how to make large hoop earrings to the wearer's choice out of silver wire and beads. The process if very simple and inexpensive. First he takes a larger gauged silver wire for the actual hoop earring. Then taking the smaller wire for bead placement, he preemptively threads the smaller wire through the beads. Because you have to use the smaller wire for holding the beads in place, the wire must be much longer. It seems with enough practice and know how, mak...
Have you ever thought about creating small boxes out of newspaper? Tomoko Lipp shows you a simple folding and cutting method to do this. Making these can be another way to recycle and be environmentally conscious. You might also consider using them for a unique gift box idea or for storing small items. All you'll need is some newspaper, a pair of scissors, and a pen to mark a few measurements.
This video demonstrates the cross court backhand shot in a Racquetball match. It demonstrates the proper form and timing in an actual racquetball match. It provides helpful tips: for example, the cross court backhand shot should be employed strategically. The best time to consider using the cross court backhand shot is when you see your opponent leaning on the down line: i.e. use the cross court backhand, if it appears that your opponent has already committed to a line of attack. If it appear...
This is the first part of a two-part video by Diane Morgan, in which she demonstrates how to make pizza dough. This part describes the actual making of the dough. First, she shows how to proof the yeast in warm water to make sure it is active. The flour goes into the mixer bowl with the dough hook attached. Next she adds he yeast, along with sea salt dissolved in water. This is kneaded together until the dough has formed a nice soft ball. Then she gives it some final kneading by hand and cuts...
This video demonstrates the process of drawing flowers. The camera is over the artists shoulder shooting down at a sketch pad the artist is drawing flowers on. There is no audio or sound in this video so you must simply watch the artist draw. She is using a pencil and draw a larger flowering plant in great detail. The camera zooms out and we see that the artist is actually sketching the flower that is directly in front of her. When she is finished she zooms in on the actual flower and the mov...
This video shows how to create a search bar in Photoshop. To begin creating a search bar you must select the template and start with a black page. The following step include choosing the color you wish to apply. The instructor explains that you must manually make your tool bar by hand and the pixels set to option five. The final step includes turning on grade in to show the program that what you are creating is an actual tool bar.
If you want to learn how to play David Bowie's "The Man Who Sold the World" on the acoustic guitar, follow the steps in this video tutorial by TboneWilson. Tbone begins his tutorial with the introduction showing what strings to strum and what techniques to use. He then takes us through the various verses and chorus first strumming the strings, and then playing them at the correct tempo of the actual song. Follow the steps in this video to learn how to play "The Man Who Sold the World" on the ...
This video will show you how to resize an image using Photoshop. Select the image you would like to resize and follow these steps: See what size your image is by clicking on "image" and "image size". Play around with your resolution, and see what happens. Uncheck the "Resample" option and not how your pixel dimensions stay the same. Select the size you want your image to print, and check the "Resample" option. If you click on "print size" you will be able to see the actual print size on your ...
In this Tasktutorial video, learn how to create a button for a website using Illustrator software. To begin, create a rectangle with the rectangle tool and then make the outline gray with a stroke of 3 points. Fill this box with a gradient and change the angle to 90 degrees. A second box within this rectangle, will contain the actual text. Then follow the rest of the steps in the tutorial to show how to change the opacity and color so that the two boxes match in color. To actually animate thi...
In this Excel basic video the instructor shows how to setup a spreadsheet and use cell references. Cell references are used in Excel to refer to other cells in a formula. When a formula contains data based on the cell reference the formula auto generates the result each time the value in the cell changes as the formula contains only the reference to the cell and not the actual data present in it. In this video the tutor goes on and shows how to write a few basic formulas using cell references...
To find the slope of a line you must have two points and then you must plug in the two points into the slope formula. The slope formula is m= y2-y1 over x2-x1. If the slope is a fraction be sure to reduce to the lowest. Remember if a number is divided into zero it is zero, if zero is divided into the number it is undefined. A calculator can help one remember this. Horizontal lines have slopes and vertical lines do not. Drawing the lines on a graph can help you see the actual slopes and which ...
This tutorial will show you how to apply basic eyeshadow for beginners, regardless of your skin tone. A lighter eyeshadow should be used on your actual eyelids, ending at your crease, so that this lighter color may be able to absorb other further eyeshadow colors. A darker color should be used on the eyelid crease itself in order to make your eyelid more prominent. A matte color should also be used above the crease, extending towards your brow bone in order to enhance your eyes. For any begin...
KnitWitch.com will show you how to take out purl stitches in your knitting on this easy to follow video. Tinking, tink, which is knit spelled backwards, is the actual knitting term for removing stitches. This shows how to tink purl stitches and gives great advice on how to hold the yarn to make it easier to see and remove the stitches. As you can be sure that at some point you will have to take out stitches when you knit by following these steps and tips it will be a much easier process.
Many of us would like to draw a cute anime face smiling back at us, on a white sheet of paper. To see how it's done watch this fine art video that will show, how an anime face is drawn and colored.
Wavy hair is a classic, glamorous look, but not everyone has the exact hair for it. With this video, we learn a quick and easy way to get that timeless wavy look using extensions. It's entirely easy. Beginning with a spritz of water or your best anti heat damage spray, you then merely use your crimping or curl iron the same way you would with your normal hair, applying a light touch, not going for actual curl, and checking your results often. When done, you can spritz your hair again, and run...
The best way to clean a hardwood floor is to make sure that you don't use excessive moisture. For the actual process, you should just get a dry mop. You should try to make sure that your hardwood floor never gets wet at all. In the event that someone steps on your floor with their muddy shoes, damp mopping is the way to go about dealing with that. Even if it looks messy, it is better not to douse the floor; the moisture seeps between the cracks in the boards and gets underneath it, doing dama...
Fixing a flat bicycle tire is a skill every cyclist should know. This video tutorial shows how to fix a flat tire on a mountain or road bike using a patch. The best way to avoid a flat is to keep your tires properly inflated between 40-60 psi. However, in the event of an accident, it’s important to pack along a patch kit, tire levers, and a pump. To access the damaged tube, release the brakes and remove the actual tire. Apply the patch and replace the inner tube for continued riding.
A dimmer switch lighting system in your home can offer a relaxing midpoint to the standard on-off option and even cut down on energy costs. This video tutorial by Lowe’s shows how to install a single pole dimmer switch in your home lighting system. Depending on the total wattage of the lights to be controlled you’ll need to install a compatible dimmer switch. Before replacing the actual switch plate, check the power with a circuit tester to insure that the power is off.
To draw a spiral staircase: Basic materials needed
Mike gives us useful tips to make different sizes of baby socks with this video tutorial. Directions:
The padlock knot is designed to look like a padlock, but without the actual function of one. In order to tie this knot take your rope or string and fold it in half. After you have done that make a loop with both sides of the rope making sure you leave a loop at the top. Put the two loops together the one in the front turning clockwise and the one in the back counter-clockwise. Make sure to leave a hole in the center for the rope to pass through. Now wind each piece of rope through the hole in...
Internal linking is a valuable way to improve search engine optimization on your website or blog. This component of organic search engine optimization we going to focus on web copy threading.
You can't have a werewolf movie without a werewolf, but how do you make one. Well, you should start of small. Try your hands at the wolf claws. To create these furry werewolf claws, you'll need a glove and some other materials. Watch this video tutorial to learn how to make a breakable prop computer. For written instructions on the actual claws, check out the WikiHow article, "How to Make Origami Paper Claws".
Hacking into computer systems to steal passwords could be a bit complicated for the average everyday joe, but for all of your tech illiterate folks out there, there's any easy way to get that password, and all it takes is a camera.
An invisible number controls your financial destiny. So until the revolution, you might as well learn how to raise your credit score.
The impossible vanish is one of those card tricks every magician needs to know, so watch this video tutorial to learn how to do the "impossible vanish" magic card trick. With just a little sleight of hand and a little confidence, you can easily do this magic card trick. See it revealed, now!
Whether you're rooting for one of the teams or just love a contest, a pool will have you cheering. You will need:
Whether you're just learning to draw or already have some illustrating skills, this how-to video series can offer you some tips. Demonstrating artist Stephie shows how to start sketching, offering advice on everything from equipment to the actual rendering process, all while whipping up a wolf drawing. Check out this video drawing tutorials and learn how to draw a wolf.
Watch this instructional poi spinning tutorial video that describes how to start spinning poi isolations. This video is intended for those beginning poi spin isolations, not for those beginning poi. A decent aptitude in poi is recommended, but move-wise, there are no other prerequisites.