How To: Dance the Harlem Shake
Dance the Harlem Shake with help from this free dance lesson taught by two experts! The Harlem shake is a dance move that involves pivoting the shoulder out while bringing the other shoulder out at the same time.
Involved Multiple Search Results
How To: Make an Excel dynamic named range across multiple rows
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
How To: Use VLOOKUP with multiple lookup values in Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
How To: Get a career in affiliate marketing
Big business is on the web these days and you don't have to build a shopping website or blog to get involved.
How To: Draw a mysterious woman
This masterful drawing session from idrawgirls instructs us how to draw a mysterious girl specifically the facial figure, face, hand and upper body front view. First you will establish, very lightly, the facial shape, direction of the eyes, and the shoulders and upper body. The key here lies in the direction of the eyes, casting the face slightly downwards, creating that ineffaceable mysterious effect. Another important factor specific to the female face is keeping the nose close to the eyes ...
How To: Combine multiple PDF files on a Mac
In this video from middiablo we learn how to combine multiple PDF files into one document on a Mac. Navigate to where the PDF files are in the finder and command click on them and then open with preview. Make sure the thumbnails button is checked at the bottom right. In order to select them all, click on one page, hold down shift and then click on the last page. It will select every page. Now click and drag and you can put the pages anywhere you want. Now go to File and Save. An even easier w...
How To: Make the perfect egg omelette
Jack from "Cooking with Jack" shows you how to make the perfect omelette in this quick video. You'll learn the common problems and mistakes made when making an omelette and how to make some simple corrections. He discusses the wide variety of ingredients that you can use. Jack then shows you a new method that a viewer sent in that involves broiling the omelette in the oven to ensure you end up with a perfectly cooked omelette every time!
How To: Draw multiple manga facial expressions
Koizu brings you another lesson in how to draw manga. He describes how he begins with the eyes as guidelines that are used as the base for each facial expression. This immediately begins to capture and illustrate the specific expression for which you are going. Multiple facial features are illustrated in the manga style of drawing and range anywhere from angry to happy and beyond. This video will definitely either teach you how to draw the facial expressions using simple features or help you ...
How To: Feed your dog multiple pills without fuss
Most dogs will be able to tell the difference between a pill and, let's say… a piece of cheese. They aren't as stupid as you think. One is for eating and one is for spitting out. Well, this is a short video tutorial to teach you how to feed your dog multiple pills without fuss.
How To: Do a slant gainer/cheat gainer
In this video tutorial the performer demonstrates the slant gainer, also known as the cheat gainer. Basically, it involves hurling yourself away from the ground, spinning in the air for a while and then trying to land without busting your ankles and/or head. If accomplished successfully, it looks extremely cool. If it ends in failure, at least you might get a hit YouTube clip out of it.
How To: Draw with graphite and pastel on tinted paper
Using graphite and pastel on tinted paper is a great way to give drawings depth and weight. Used right, these materials can really make a drawing pop. In this video tutorial, the artist walks you through the process and discusses the various steps involved.
How To: Spring bump locks
This is a great spring bumping demo from UK Bump Keys. Spring bumping involves inserting a spring over a bump key to disledge the mechanisms in a lock. This is a locksmith and lockpick demonstration.
How To: Do an Elmsley count card trick
Learn to do an Elmsley count card trick. With this video tutorial, you'll better your skills as a magician, and learn the proper techniques and presentation involved when performing an Elmsley count magic card trick. This is a great addition to your sleight of hand repertoire. Made by Richard Scorpio.
How To: Windmill in break dance
This is a video guide on how to do windmills in break dance. He's doing a counter-clockwise version. This is very difficult and involves balancing on your hand while twirling around. You must support your whole body weight with one arm. It is good to practice this breakdancing move on carpet so you don't smash your face up.
How To: Do advanced C-walk dance moves like the shuffle spin
Advanced crip walking takes lots of control and practice. This shows you moves like 'The V', 'quick step' and 'shuffle spin'. He breaks down this form of hip hop that is popular on the street. It involves a lot of feet shuffling and is often accompanied by rap or hiphop music.
How To: Perform the Devil's Thirteen card trick
Here's a different take on the same trick with the explanation of how it works. IT always works unless you screw it up. This is a magic shuffle trick that involves placement. You need another person to cut them so it doesn't look like you are cheating.
How To: Meditate to relax with Tara Stiles
Here are some meditation tips from Tara Stiles. Tara Stiles is a revered Ford Models yoga instructor. Meditation is a mental discipline by which one attempts to get beyond the conditioned, "thinking" mind into a deeper state of relaxation or awareness. Meditation often involves turning attention to a single point of reference. It is recognized as a component of almost all religions, and has been practiced for over 5,000 years.
How To: Do a knee hold in pole dancing
This is the knee hold trick, not the genie move for pole dancing. It is an advanced move that involves balance, core strength and intense control to balance in mid air as if defying gravity.
How To: Properly cross a stream in trekking or hiking
A short how to video on how to perform a safe stream crossing or ford using trekking poles when ultralight backpacking. Hiking or trail running often involves crossing or fording rivers and streams. Make sure you cross the water properly so that you don't get caught in a current or injured on rocks.
How To: Practice a simple interrupted suturing technique
An important part of being a surgeon involves knowing how to do various types of sutures. This medical how-to video demonstrates how to do a simple interrupted suturing technique. Simple interrupted sutures are great for closing skin wounds. Follow along and learn the proper method for using this type of suture on your patient.
How To: Hold a lacrosse stick properly
Check out this instructional lacrosse video that demonstrates how to hold a lacrosse stick. Holding a lacrosse stick correctly involves adjusting the hands for catching, cradling and passing. Learn how to hold a lacrosse stick in this video.
How To: Hula hoop with multiple hoops
When one hoop just isn't enough, multi-hoop moves are the only way to cure hula hoop boredom. Spinning four rings around your body is no easy trick, but fortunately there are some tips to help you work up to multiple ring hula hooping. Safire, expert hula hoop dancer, walks through the steps of working your way up to multi hoop hula hoop moves, covering everything from how to practice to how to just get all those hoops on your body. Watch this video hula hoop tutorial and learn how to perform...
How To: Create exploding water
Watch this instructional science video to learn how to create hydrogen from water, salt and electricity, for only a few dollars. This is an experiment that produces explosive gases, involves electricity and water and a number of risks so please be careful. Not an experiment to be performed by idiots. Create exploding water with this educational tutorial.
How To: Create an iMac in Photoshop
This Adobe Photoshop tutorial shows you how to create an iMac in Photoshop. Now, there's no magic involved so you won't be able to use the iMac you create as a computer, but if you need an image of an iMac, you will learn how to create one yourself using Photoshop.
How To: Set up the SQL membership provider in ASP.Net
Join Patrick Hynds as he demonstrates how to set up the SQL Membership Provider to add Forms authentication to your ASP.NET 2.0 Web site, in this video tutorial. There are a few tips and tricks involved, such as using the aspnet_regsql.exe utility, which are covered in the video.
How To: Levitate
After a silly opening with some amazing levitation we learn how to do a much simpler levitation. This video is hilarious and you can learn a thing or two from it. This is not the Balducci levitation. It is an ingenious bootleg solution that involves taking off one shoe, and a blanket that disguises some of the method.
How To: Scout for locations, guerilla style
No, this isn't location scouting in the professional, industry term, where often paperwork and legal matters become involved. We mean it in the way that guerrilla filmmakers mean it.
How To: Analyze the drinking bird toy
When was the last time you saw one of these? This classic children's toy seems very simple, but the chemistry involved is very interesting. Do you know how it works?
How To: Make fire starters with lint and soap
Make fire starters that can be used when camping, fishing, or any other outdoor activity involving fire...or just for use in your home fireplace. Requires only dryer lint, a paper egg carton, and some old candles
How To: Make a hover craft and play shoverboard
This is a two part video. The first part of the video shows you a bunch of people playing shoverboard, a combination of hoverboards and shuffleboards. However, if you skip to a little less than halfway down the video you will see some of the process involved in creating hoverboards, the interesting part. Yet another fantastic time spent with Bre Pettis and Make Magazine.
How To: Get Drunk Fast
Sick of pounding beer and shots to get drunk faster? Here's a sure-fire way to get drunk faster, be forewarned, this involves using your anus. If you can't view the video below, you can check out this MANswer over on Spike.
News: Mindfulness App Aura for Sale on Android
Aura, a highly rated app for mindfulness and mental health, just became available on Android and is currently on sale.
How To: 3 Pranks You Can Pull Off at a Party!
Some parties may be so lame that only a good prank can make them more exciting. If that's the case then you can pull off one of these simple party pranks. All three are messy so be prepared to do a little clean up afterwards. Two involve cups and punch and the last one involves a piece of pie. Refer to the instructional video for further instructions and demonstrations!
How To: Find Out What Personal Data Your Mobile Apps Are Leaking with Mobilescope
If you use apps on your smartphone, chances are you have no idea what those apps are doing with your information. Just this year, there have been several scandals involving apps transmitting user data, like Path uploading users' entire address books onto its servers, HTC's Security Flaw, and Brewster exposing users' personal information (even Ashton Kutcher's). A new service called Mobilescope wants to make sure you always know where—and to whom—your data is going. Lots of apps copy your cont...
Do mathematical card tricks: "The Power Of Three"
Ever wanted to perform a magic trick but didn't really have the hand eye skills most magicians seem to have? Always thought magic can be performed only by face-to-face and not long distance (say over the phone)? Well think again as I teach you how to do the Mathematical card trick "The Power of Three"
How To: Work with layers in Photoshop
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to work with layers in Photoshop.
How To: Add multiple email addresses on your BlackBerry smartphone
Well, you've got your friends & family email account, your email account for buying junk and that little secret email you keep for all other reasons. If you've been looking for a way to get them all onto your AT&T BlackBerry, here's a clear & concise tutorial teaching you how to do just that.
How To: Use multitasking and homescreen wallpaper iOS4 jailbroken iPhone 3G or Touch
If you have an iPhone 3G or iPod Touch 2G, you're probably having problems with iOS 4 of multiple kinds. If you have just jailbroken one of those Apple devices and want to activate some of the sexy new options available to you, watch this video. It will show you how to enable multitasking and homescreen wallpaper on your jailbroken iPhone 3G or iPod Touch 2G with iOS 4 using winterboard.
How To: Manage your contacts on Android cell phones (2.0)
The Contacts application on Android-powered cell phones provides a powerful way to manage your address books and keep in touch with friends and family. You can even add and manage multiple accounts from various sources. Watch these tips from Google to learn who to get the most of the Contacts Android app.
How To: Be a better bartender with tips from a pro
Expert bartender Jason Griffin from quickstrain.com has tons of helpful tips for all you aspiring bartender out there. Jason will show how a pro does the little things that separate the good ones from great ones. Watch this video to learn how to pour multiple drinks, upsell to customers and so much more!