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 521st installment in their series of digital spreadsheet magic tricks, you'll learn how to round numbers two different ways.
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 355th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP to create a mortgage calculator that can handle four different types of loans: begin annuity, end annuity, interest only and "other."
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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.
There are different types of Scene girl hairstyles, and in this video you will learn how to make your's extreme. Extreme Scene style is usually made up of crazy colours, and funky spikes and layers. You will be the hit of every party with your new, totally awesome Scene style.
Acting auditions are stressful, and are different depending on what type of project you are trying out for. In this tutorial, get tips from working actors on how to audition for a film or TV show. Learn how to work the camera, emote, and read your lines the way casting directors want you to. Follow these tips and break a leg! See you on the silver screen!
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 176th installment in their series of digital spreadsheet magic tricks, you'll learn how to get the last number or word from a column on a different sheet.
There are many different styles of dollhouses out there, and they are all beautiful. In this tutorial, learn how to make shingles and put the finishing touches on a Tudor style house. There is a great sense of accomplishment when you make one of these classic toys from scratch. This video will take you step by step through the shingles, and you will have a fantastic toy or collectible in no time.
This tutorial shows you how to polish the internals of a Tippmann paintball marker using the sandpaper method. Using different grades of sandpaper, you can smooth out the overspray so that your bolt can cycle more smoothly.
Anthony Persaud and Stephanie teach the basic Salsa dance steps. The steps are shown at different angles. The steps are basically front, middle, back, middle. Your hands should flow with the movement of your steps. This is a very popular dance and it is danced at many clubs.
How to make a creative card. You can use different colors of paper and decorative embellishments. This is a great idea for a scrapbooker that has supplies already on hand and wants to give a special gift to a friend or relative. This activity is a great idea for someone who needs a cheer-me-up but if you change the paper and embellishments, you can make any kind of theme card.
This video is very informative in explaining the different ways to convert. The man in the video makes key points about the rules to make these conversions. He is also helpful in explaining how to convert from every type of number. A viewer watching this video will be able to understand the basics of converting and how to apply the rules.
The creative Suzy Banyon describes in detail the process of applying a leopard print manicure in this easy to follow step by step video. She details the process vividly, from applying fake nails and filing them into shape, to what type of base to use and how to go about creating the leopard print pattern with the use of a fine point Sharpie pen. This video is great for those of you looking for new and different ways to apply unique nail art at home!
Wanting to try something new with your shoe laces? Have some fun by tying your shoes with two different colored laces, bar style. This look is funky and fresh, perfect for school or an afternoon out with friends.
Drawing a person sitting down and other sittign positions can sometimes be really tricky. The next time you run into a problem, be sure to use this great video as a guide. In this video, black charcoal is used and three different sitting positions are gone over.
Ever wanted to create your own X-ray without a doctor's visit? Learn how to create your own X-ray in Photoshop by compositing two separate images to make it appear as if you are holding your own X-ray. You will use different layers, layer masks, and levels to make a believable self X-ray image - and you don't even have to get it approved through your insurance!
In this video tutorial, learn how to create a really beautiful, eye popping, neon light "magic effect". Brighten up your asthetic presentation with this cool Photoshop trick, originally found on this blog. This tutorial is constructed using Adobe Photoshop CS3, but please note: This trick does work with CS4, but yields sightly different results. One can download the font used in this tutorial, here.
This step by step tutorial will guide you through the process of deciding what type of paint to use for your custom Xbox 360 controller. By the end of this tutorial you should know about the different types of paint available and decide which one you would like to paint with.
Learn how to perform an easy drop and grasp magic coin trick. First, see the demonstration performance of the drop and grasp coin trick, then see how the magic illusion is done, with different camera angles showing you the whole truth of how it's done. This is a great magic trick for your friends.
Learn how to score with Free Kicks in Fifa 09 (PS3/Xbox 360). Mastering all of the different techniques takes practice but it's well worth it! Learn methods to spin, curl, adjust power and distance.
Learn how to choose ladies underwear. There’s a lot more to picking a pair of panties than thinking they look cute in the store. This video outlines all the different factors in choosing the perfect panties.
Are you in medical school an planning to be a surgeon? Then here is a how-to video with various different surgical knot tips. The UT Huston Student Surgical Association (SSA) has put together this surgical knot tying online tutorial. Watch as Dr. John R. Potts, MD. demonstrates the two handed square knot. Practice the two handed square knot surgical suture before going into your surgical rotation.
This audio editing software tutorial will show you how to use the smart tool in Pro Tools. Besides showing you the smart tool, Connor Smith will cover the different edit modes (shuffle, spot, slip, grid, and relative grid) available in Pro Tools.
This audio editing software tutorial will show you two different types of editing in Logic Pro. First, Connor Smith shows how to edit multitrack drums in a group (to fix timing of hits) in Logic Pro. Then he covers how to ungroup your drums and take out pops, clicks (etc.) on individual drum tracks in Logic Pro.
This audio production software tutorial covers how to go sequence with the Keyboard Editor in FL Studio and covers creating notes with different pitches, moving notes, and using portamento. See all these ways to use the keyboard editor to make patterns in FL Studio.
In the new Photoshop CS4, there are some minor improvements to the Photomerge function, including the new collage option. Jay Kinghorn goes over the different ways of bringing your images into photomerge, the layout options, and some quick tips for creating better quality panoramas in Photoshop CS4. The following how-to video walks you through the entire process.
Should you fold your hand or chase the draw when playing Texas Hold'em after the flop? The first three community cards that are dealt are called the flop. This how to video addresses different situations that can occur after the flop. You will learn what hands you should chase and what hands to fold determined by your position. You can play smarter Texas Hold'em poker with these great tips.
Interested in Parkour? Take a look at this instructional video and learn how to perform a sideflip after a cartwheel. The sideflip after a cartwheel requires a technique quite different from the normal sideflip. It requires flexibility, height, lightness, and good air awareness.
Watch this ceramics tutorial video to learn how to use some more advanced glazing techniques to make the inside different than the outside. The detailed instructions in this helpful how-to video are best for intermediate to advanced potters who want to glaze both the inside and the outside of their pottery.
Watch this winds tutorial video to learn several different ways to play sharps and flats on your pan flute. You can push the flute into your lip, tilt the instrument, lower your jaw, or push your top lip out to cover part of the opening. These four methods allow even beginners to easily play sharps and flats on the pan flute.
Three different prank in order to scare your roommate. The only one that will cause harm to your friend will be the first one. So be careful and be safe. Use this as inspiration for one of your April Fools Day pranks!
Learn about all the different types of numbers, like integers, irrational numbers, and real numbers, in great detail. Also includes how to use a number line, a dichotomist tool, and other methods of number manipulation.
Watch to learn how to pronounce different combinations of vowels and "ch" in French.
52 year-old UniGeezer demonstrates four different types of drops with a Mountain Unicycle.
Be green and eco-friendly by learning about compost. This video shows the basics of compost, composting materials, and the different methods of composting.
Learn to speak English by understanding how adverbs work in different scenarios. Perfect for beginners, intermediate and advanced students, these video lessons are as good as having an English teacher in your pocket!
Learn how to belly dance, including the different styles of shimmy from Meital the exotic bellydancer. Shake you jelly belly like a pro.
We may not all be Macgyver, but we can certainly channel our inner detective by bolstering our lock picking skills. And some of the hardest locks to crack open are combination locks, which have several disks are require advanced lockpicking skills.
If you are a photographer and are handy with a screwdriver and electrical tape, this is a really cool project to do. Basically, you "Frankenstein" a camera, taking a camera apart and rebuilding it with different lenses and the like, which makes for really cool photo effects.
This video will show you 7 different ways to speed up Windows XP. This tutorial requires one freeware program that can be found at www.hoverdesk.net/freeware.htm.
Learn to restore four different types of files: deleted files, files from a damaged CD or DVD, files from a formatted hard drive, and files from unbootable hard drives.
