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 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro to take a data set and add a new column, concatenate data from 3 columns, and delete unwanted columns.
This is a crochet super star featuring 10 points to the star. This video will take you through this crochet tutorial teaching you what to look for and how to make it. Going step by step, you will be great. This is a wonderful afghan, doily, table setting, baby mat and more. Good luck and enjoy this crochet tutorial.
dewalttv teaches you how to cut nested crown molding with a DEWALT miter saw. The advantage of this position is that it doesn't require a bevel angle. The bottom of the molding should be placed against the fence. To cut the right piece, set the miter to 45 degrees to the left and make the cut. To cut the other piece, the left one, set the miter angle to 45 degrees to the right and cut. You are done. This technique is useful when you don't want to worry about setting up a level cut.
The video is about how to find the variance of the set of data. They found the variance by using the variance formula. Variance formula was represented by square of S, whereas S is the Standard Deviation.
This video basically shows you a set of minor hand techniques (cues) that might help you when you are dancing salsa.
In this video from ExtremeBartending, you can learn how to heat up and serve warm brandy, a classic drink, which is particularly nice to sip on a cold night. The video offers three separate ways to achieve your warm brandy, using hot water in a brandy snifter to warm the glass, and then pouring in the brandy, putting hot water in a separate glass, and then resting your brandy snifter on that, or finally, a bold method that actually involves setting the brandy on fire!
Ever wonder how to create movie magic right in your own home? This video shows you step by step everything you need to know and do to create the green screen effect, from properly setting up your green screen, to lighting it, as well as your subjects for a successful effect. Filled with tips and instructions this is a great video to watch for filmmakers, and special effects artist of all kinds.
Managing screen real estate can be a chore on any operating system. In this video, learn how to set up a split-screen display for your machine running Windows Vista.
Learn how to create a warm, grungy background in Photoshop. - Open up a brand new document at 1280 x 720.
Do you remember "The Heist" from episode 21? Well, the sequel is even more unfair than the original! Check out this video if you want to stump people with a trick called "The Heist II." For this trick, you need only a few simple supplies: a match, a cup, and a nickel.
Check out this informative video tutorial from Apple on how to set up iChat to text, video or audio chat with friends. iChat is an application that's part of every new Mac. It lets you stay in touch with friends and family in fun innovative ways.
d-CON is here to help identify and remedy rodent problems in your bedroom. Watch this video tutorial on how to use d-CON Ultra Set Traps to kill mice in the bedroom. Signs of a mouse in the bedroom include droppings, footprints, gnawing, rubmarks, unusual pet activities, strange sounds, and burrows or nests.
See how to escape from a set of professional handcuffs. If you ever get arrested, see how you can get out of those handcuffs with just a bobby pin. It's a pretty easy trick, you just need to modify the bobby pin a bit and you're almost there. The police will never be able to hold you down, but this is actually more for a magic show, like magicians perform.
It's time to pick a few locks, but with what? Check out this video tutorial to see how to make a cheap lock pick set from saw blades. You can make any lock pick you want with saw blades, a little grinding, a little more grinding, and yes... grind, with a few finishing touches.
A light meter can prove to be an invaluable tool on any film set, allowing you to quickly and efficiently set lights and know the correct exposure values of those lights. Light meters were initially designed for still photographers and cinematographers can easily calibrate them to a given film stock speed for shooting film. But what about today’s digital cinematographer? I’m glad you asked. In this video tutorial you'll see how you can use a light meter to quickly and efficiently light a scen...
Want to mix and scratch like a professional DJ? To be a good DJ you need to understand the concepts of mixing tracks, adding cool effects, and of course you need a good sense of rhythm to line up the beats. This how to video explains how you can set up the American Audio TT-Record Turntable. This is a Belt Drive turntable that can record your vinyl with a press of a button. All you need to do is plug in your memory stick and off you go. This unit does not need to be used as a direct drive sin...
Jerome Basillio shows the gogoplata set up reaper in this how-to jiu-jitsu video. Learn some new skills or just practice your jiu jitsu skills. Follow along with this video martial arts tutorial and learn how to do a jiu jitsu gogoplata choke reaper move.
The spy camera shown in this how-to video has a 60 foot cable, and is full color and has audio. This spy cam can be used as a security device, or to feed paranoid delusions or stalking urges. Watch this video tutorial and learn how to set up an X10 spy camera.
In this video tutorial dedicated to the Google's Gmail, you'll learn how to set up Gmail to retrieve mail from a second email account. This tutorial also looks at how to set up labels and filters, and explains the Gmail Archive function and Gmail Conversations. Become an advanced Gmail user with this video tutorial!
New to the Ubuntu Linux distribution? Ubuntu has a great built-in email client in Evolution. This video tutorial will walk you through the Evolution setup process, using the Evolution Setup Wizard. To get started setting up your own Evolution client, watch this Ubuntu tutorial!
If you visit the same pages over and over, you may want to consider setting multiple start pages. While you may not have even known such a thing was possible, the set-up procedure is simple in both Mozilla Firefox and Windows Internet Explorer 7. Learn how to use browser tabs to open up multiple websites when you launch your browser with this how-to.
Aperture's levels adjustment provides a refined level of control over your tonal corrections.
If you're interested in learning a general purpose, high-powered programming language, Python might be the way to go. In this installment from his video tutorial series dedicated to programming in the Python programming language, you'll learn how to install the Cygwin Windows environment. To get started setting up to program with Python, take a look!
This is a cinematography tutorial video that demonstrates how to control the aperture and shutter speed on the HV20 high definition camcorder. This is the PAL version, so it's basically the same except the NTSC version would have different shutter speeds. You will also need a miniSD card in your camera for this technique to work. Learn how to set the aperture and shutter speed on the HV20 high definition camcorder with this instructional cinematography video.
Watch this professional cinematography video to learn how to make linear tracks on the P+S Technik SKATER Mini dolly to better utilize and maximize its performance. It's actually extremely fast to get the Skater ready to shoot. Learn how to make straight tracks inward as well as a typical linear tracking shot. View final footage of the Skater used on professional film sets.
Watch this professional cinematography video to learn how to pan and lock to enhance and maximize the performance of the P+S Technik SKATER Mini dolly. This allows you to either lock the wheels for fixed camera angles, or execute basic panning shots. View final footage of the Skater used on professional film sets.
Watch this professional cinematography video to learn how to use the Steadybag to enhance and maximize the performance of the P+S Technik SKATER Mini dolly. The Steadybag allows you to work with angled shots. Just place the bracket into the frame of the skater and then place the camera on top of it. View final footage of the Skater used on professional film sets.
Watch this instructional video to learn how to use periscopes and borescopes to maximize the performance of the P+S Technik SKATER Mini dolly. Working with periscopes and borescopes can add interesting perspective to the shots you do with the SKATER. View final footage of the Skater used on actual professional film sets.
If you're new to Ubuntu Linux and, for whatever reason, not so very keen on Ubuntu's default email client, Evolution, then you might like to try Mozilla Thunderbird. In this tutorial, you'll how learn how to go about setting up an email account in Thunderbird. Take a look.
In this Ovation TV original special, acclaimed photographer Gregory Crewdson shares with us his insight into his photographic techniques. Like a film, he uses a lot of production, a lot of lighting, a lot of set design. He is an American photographer best known for elaborately staged, surreal scenes of American homes and neighborhoods. Learn how to take pictures like this master artist.
Gumpaste is very versatile for cake decorating. This how to video guide you through the step by step process of cutting and shaping a bra and panty set out of gumpaste. You can use your gumpaste bra and panty to decorate any birthday cake.
Bill Myers shows you an easy way to quickly set project properties so the video displays better and smoother in Sony Vegas and Sony Movie Studio. This is great for when using different video formats.
This tutorial video will teach you how to properly install rollers in hair. Setting rollers in your hair will make it extremely curly.
Watch this tutorial video to learn how to get your work e-mail on your iPhone using the latest firmware upgrade. New iPhone users will find this how-to video particularly helpful because it shows an easy way to set up Exchange email on Apple's iPhone.
This tutorial shows how to set Internet Explorer to always show the latest version of web pages by changing the cache settings. Produced with Camtasia by Bill Myers
In this video tutorial, Keith Code walks you through how to set the sag on your motorcycle's suspension. If your sag is too loose or too tight, you can damage your bike and potentially damage yourself. Watch this video to become a pro at setting up your motorcycle.
This video shows how to set up an enclosure suitable and realistic for a White's tree frog. Learn how to build a welcoming home for a pet White's tree frog.
Each client is different so it is important for a massage therapist to explain the process and adjust the chair before starting a chair massage. Watch this video by Massagenerd to learn how to set-up the chair to give your client a very comfortable and relaxing massage.
This video shows you how to set up a scheduled task to run anytime your computer is idle that defragments your computer. Defragmenting is important because it will allow your programs to open much faster.
This video offers a quick way to set up your Voltz effect pedal board in one minute.
