New to 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 Excel tutorial from ExcelIsFun, the 261st installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random numbers within a certain range and with certain supplementary criteria (e.g., values that are not divisible by three) via the use of large array formulas.
This is a Hobbies and Toys video tutorial where you will learn how to use a Micrometer. Micrometers are precision measuring tools and they can be calibrated in inches or in metric system. There are also digital micrometers available where the reading switches back and forth. Generally they are right handed. The micrometer shown in the video is calibrated in inch. Each division is one thousandth of an inch. A whole rotation of the knob is 25,000 and one division is seen on the bell. Two rotati...
In this video you will learn a simple double-handed turn using the same principles as leading a right turn. Then you'll learn a slick little combo for switching hands as a starter for any other combos you might learn in your life!
Looking to get into the weird world of circuit bending? In this four part video tutorial geared towards beginners, learn in thirty minutes how to circuit bend. Tools you will need include a soddering iron with innerchangeable tips (thin pencil preferred), thin sodder, hook-up wire, a wire cutter, a wire stripper, a drill with drill bits, plyers (needle nose included), and screw drivers of various small sizes. Other useful tools include cresent wrenches for toggle switches, jewelers files, & a...
dekePod, a tutorial show on computer graphics and digital imaging from O'Reilly Media, Inc., shows us how to fake an HDR (High Dynamic Range) portrait in Adobe Photoshop. What's HDR? An HDR image packs more pixels than normal into a picture creating billions of color variations and razor-sharp detail. Think your camera can do that? Well, it's possible with special software, but here's how to fake it (good) equipped with only your drab jpeg image, Adobe Photoshop, and this tutorial.
In this video tutorial, Creative Cow leader Michael Park shows you how to recreate the opening gun barrel sequence from the two newest James Bond movies in 3d Studio Max using the default scanline renderer, minimal modeling, and only standard materials.
Check out this informative video tutorial from Apple on how to build songs in GarageBand '09.
Check out this informative video tutorial from Apple on how to mix songs in GarageBand '09.
Jason shows you in this video tutorial, how to make char cloth to start emergency fires. Making your own emergency fire-starting material could someday save your life! Making char cloth is an easy way to make an emergency fire starter with materials you already have lying around the house, for use in camping, backpacking, hiking, and survival in the wilderness.
See how to shoot a time-lapse video using a DSLR and intervalometer. This video tutorial covers everything from settings you should use to making the time-lapse video in QuickTime.
Do you need to create graphics for video editing systems like Final Cut Pro, Avid, or Adobe Premiere? Are you looking to get more from Apple Motion or Adobe After Effects? Then you need to learn Adobe Photoshop.
Pet-proofing your house won't just protect your possessions from becoming chew toys—it could save your dog's life. You will need a dog crate, a dog who's ready to move in, dog manuals, pet repellent, electrical cord covers, baby gates and a dog bed or towels for bedding. These are helpful tips for pet proofing your home for your new puppy or dog.
In this Photoshop CS3 tutorial you will learn how to use the knockout feature. This advanced masking technique allows you to move a targeted layer around, revealing the layer underneath. This video will show you how to reveal a creepy skeleton under a monster werewolf right in Photoshop. This classic technique lives again! Learn the subtle qualities of the Deep, and Shallow, Knockout feature in Photoshop.
This video Adobe Photoshop CS4 Extended tutorial will shows you how to create 3D objects from grayscale imagtes. Bring 2D images back to life with this new Adobe Photoshop CS4 Extended technique for converting grayscale images into 3D objects. This instructional video will also demonstrate how to generate 3D depth maps directly from 2D images in CS4 extended.
Check out this cinematography tutorial video that demonstrates how to use the GY-DV5100U Professional DV Camcorder. JVC has upgraded the camera's features and digital processing circuits to meet the requirements of a growing number of broadcasters looking for cost effective alternatives to the over-priced tapeless solutions of other manufacturers. This video is great for cinematographers and filmmaking aficionados alike. Learn all the functions and settings on the GY-DV5100U with this instruc...
Running a triathlon could be the biggest accomplishment of your life, but it takes a lot of exercise. Here are some workout tips for you to use in this instructional video.
Around half the UK population will develop piles at some point in their life. In this exclusive guide, Dr Jessen explains the causes of hemorrhoids and dispels some myths along the way. He also discusses treatment options – from over-the-counter creams to surgery – and advises on the best way to prevent piles occurring in the first place. Watch this video tutorial and learn how to diagnose and treat hemorrhoids.
In this how-to video you will learn what trout eat and what lives on the river bottom. Have you ever wondered what you have to do in order to properly fish for trout? This clip explains what you will need in order to find these trout.
Check out this how-to video to start a fire using an AA battery and a staple. You can do this while listening to the classical guitar piece, "Malaguena" if you feel like it. It could save your life! With your battery: start by cutting the plastic away from the negative terminal. Watch the video survival training tutorial for more tips on starting an emergency fire!
Today, you are going to learn how to dissect the structures in both the forearm and hand of a human cadaver. This anatomy video tutorial will show you how to do it.
In China, bargaining is a way of life. Learn how to bargain like the locals with the help of this video.
A stethoscope, often considered the symbol of a doctor's profession, but also used by safe-crackers and auto mechanics to hear sounds that otherwise couldn't be heard. Well, it's time to make a high-tech electronic spy stethoscope with Kip Kay in this gadget video tutorial, for only twenty-five bucks! You can hear and record heartbeats with this spy gadget, or even listen through walls!
Feel like there's something missing from your life? Just hop on Google, and follow these simple steps to pinpoint whatever you're looking for in a jiffy.
Donnie Hoyle shows you how to fix mistakes you've made in life using Adobe Photoshop. Here he puts an unwanted rescue cat in a plastic bag and replaces its carpet shadow with an unidentifiable stain.
In honor of hurricane season, bartender Anthony Caporale gives you a tutorial on how to make a Hurricane. Originating in New Orleans, this drink is always served in a hurricane glass (reminiscent of hurricane lamps), and always sure to add some life to the party.
Why role play online with an avatar when you can live out your princess-rescuing and spellcasting fantasies in real life? Amtgard is a real life, live action RPG in which people roleplay in set up situations.
Money, as we all know, creates stability and ease of living. But an unfortunate consequence of having money is all the work you have to do to get it.
It commonsensically goes that your heart breaks after a break up. Everything seems bleak and sometimes it's even hard to get out of bed or to function properly. As such, if you've had a friend who's recently gone through a break up, it's your duty as a caring friend to comfort her.
Want to play "Good Riddance (Time of Your Life)" by Green Day on baritone ukulele? Learn how with this video tab, which presents a complete breakdown of the song's component sections, chords and strumming & picking patterns. For all of the details, and to get started playing "Good Riddance" on your own baritone uke, watch this free video ukulele lesson.
In this tutorial, we learn how to read the intuition and success lines in palm reading. The affection lines are the lines that go vertically and are underneath your pinkie. The lift line is the line in the middle of your palm the curls to the right. The head line is in the middle of the hand and meets up with the life line, this line shows success in business. It also shows someone that will go into business and tends to take control of businesses. The ring around the pointer finger also show...
If your arm is tingling all fuzzy-like the way it does when you've slept on it wrong all night but you've been up for more than a few hours, then you may have a case of the stroke rather than sleep-induced wonky arm.
What's better than chocolate cake, flan, and caramel sauce? All three combined into one heavenly creation? We're serious: Take a bite and your life - or at least your foodie life - will be complete. This "chocoflan" can be served at any special occasion or as a treat for your family after dinner.
In this video tutorial, viewers learn how to get the attention of women. Before approaching the woman, walk by her and have a feel and sense of what she's really like. She may look beautiful, but she may also not be your type. Objectify and thinking about the woman is not going to help you to approach the woman. To get a woman's attention, always smile and be full of life. Appreciate your life and don't be afraid or nervous. This video will benefit those viewers who are single and are looking...
In this tutorial, we learn how to palm read the hart line and affection line. When we get two affection lines close together, it's a sign of a marriage or common law relationship is in your life, and that there is an affair happening outside the marriage. If there are three lines, that means there will be more than one marriage, and the last one will last the longest. Two lines can also mean that you will have two great loves in your life, as well as two marriages. Lines that come down toward...
This video illustrate us to read a palm for heart and head. Here are the following steps: step 1: First of all take the hand of the person and view it under a hand lens so that you get a clear view.
Just like in real life, every once in a while you run into people on Facebook that you just don't want to see. In this tutorial, learn how to block users on Facebook and prevent them from seeing you or your profile.
Isn't it annoying how fast the battery dies on your iPod or iPhone? It seems like you charge it for hours, only to have it die in half the time. Well, in this tutorial learn a few tips and tricks that will increase the battery life of your phone.
In this video, we get tips on how to get into shape and add fitness into our lives. One alternative to get fit is to just add fitness into your everyday routine instead of having to add in a specific work out regimen. Something you can do is take the stairs instead of the elevator and park further away from the store. You can also place things to keep active at your desk including weights and doing leg exercises. While on breaks, you can also do exercises with co-workers. All of this exercise...
Picking up dog poop is not one of life's great joys. It is, however, a necessary evil to owning an adorable dog, or having a lawn that someone else's adorable dog may want to use as a toilet. When it comes to this unpleasant task, the shop vac is actually a very good way to pick up dog poo. You want to make sure, however, that you're not using your shop vac for anything but this one task. It can easily vacuum in small objects with weight in them and, better yet, you never have to touch it!
In this video from RawRadiantHealth Natasha talks to us about getting back to basics and not getting overwhelmed. A lot of times we can feel like we have too many responsibilities and we can get burnt out. Having a strong foundation and basics like getting enough sleep, eating your meals, your home is clean, you're taking care of yourself can really help you. When the foundation is a bit shaky these things can overwhelm us. If the basics are not taken care of the rest of your life can be a me...
