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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
Setting up a hydroponic herb garden might sound like a dauntingly big project but, as this clip demonstrates, it's much more manageable than you might expect. It's so straightforward, in fact, that this gardener's guide can present a complete and thorough overview of the process in just over three minutes' time. For more information, and to get started setting up your own rooftop hydroponic flower or vegetable garden, take a look!
In this tutorial, actress and producer Kathleen Cooke tells you how to prepare yourself for stepping foot on a television or film set for the first time. As an actor, you must be aware of the set and protocol. There is a heirarchy on every set, and you must know how to respect it. You must also learn the vocabulary - if you do not know what a gaffer or a honeywagon are, it's time to hit the books and study!
Thwart would-be snoopers by protecting your Apple iPhone with a passcode. Learn how to set one up with this clip. It's easy! So easy, in fact, that this free video tutorial can present a detailed, step-by-step overview of the process in under a minute. For more information, and to get started setting up a passcode on your own iPhone, take a look!
Learn how to use a 'do while loop' in your Java programming. 1. Set up an 'int' variable named 'counter' and assign it a '0' value. 2. Set up a standard 'do' loop. Make sure to add a counter, so the loop will end 3. Then write the 'while' condition. Make sure that you set the condition to the same variable name that you used in the counter from step 2. Set the variable to '=' 10 (or any number desired)
Learn how you can remove the blue haze from photos in Photoshop with this tutorial! 1. Select any image and right click on the menu click on Levels. 2. Select each and every channel and set input levels for red, blue and green and see the preview of the image. Set as RGB in Channels. 3. Now, click on "Sample in image to set gray points" and click on the area of the image which need to be set gray click on ok button. 4. From the picture icons select eye dropper and make sure it is set as 5 by ...
Learn how to do a dumbbell freestyle swim stroke drop set. Presented by Real Jock Gay Fitness Health & Life.
If you want to set privacy rules or moderate who has access to the different content that you share on Google+, take a look at this tutorial. It will walk you through the settings and features of Google+ that allow you to restrict who can view and see the information you post to your profile.
If you want to permanently set the default browser on your Mac notebook or desktop, take a look at this walkthrough. You can set any browser to open up by default when you click a link or try to access webpages in OS X.
Buy a DSLR just for the video? You're not alone. In this video tutorial from renowned DSLR cinematographer Philip Bloom and the staff of Vimeo, we receive some tips on how to set up a DSLR like the Canon 7D, T2i (550D) or 5D Mark II for shooting video.
Find My iPhone is one of the best Apps of all, allowing you to find your iPhone no matter where it is, lost or stolen. This video will show you how to install and set it up on any iPhone or iOS 4.2 device, even those not technically supported by the newest free release of the software.
The Sony Dash is a hot tablet, and like most tablets it can be used for all sorts of awesome purposes that full-sized computers are not suited for. Alarm clocks, for instance. This video will teach you how to set music and video to your alarm clock on the Sony Dash.
Practicing your lockpicking skills without ruining the doors around your home might seem impossible. With a little DIY knowhow, not so. Watch this video to learn how to easily make a lock picking practice set that will allow you to work on different types of locks easily without having to worry about your home locks.
The Microsoft Kinect represents its attempt to steal the Wii's thunder, and it work pretty dang well. Watch this video for a guide to plugging the Kinect into your XBox 360 and setting up your gaming area so that you'll be able to play it.
Do you want to bust out your talkbox vocals really gorilla style? Hauling a synth keyboard and a talkbox around is a lot of baggage. Did you know, however, that you can set up a talkbox WITHOUT a synth keyboard? Watch this video to learn how to do it.
Light shows are one of the best parts of raves, bringing people together to participate in a whole new type of social interaction. Gloves have become the most popular tools of the lightshow trade, and this video will teach you how to make your own custom set exactly how you want them. It discusses types of lights, batteries, and everything else you need to know to make your first set of gloves.
If you already own a Canon High-def digital SLR, you can set it up as a virtual webcam. This will allow you to record video podcasts or chat on Skype. You'll also need the CamTwist software and the Canon EOS utility (available from your install CD).
Learn how to unbox and set up a brand-new BlackBerry Storm 2 smartphone with this video guide, which covers, among other things, inserting the SIM card and charging the batter. This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.
Learn how to unbox and set up a brand-new BlackBerry 9700 smartphone with this video guide, which covers, among other things, inserting the SIM card and charging the batter. This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.
Learn how to set the current layer by selecting elements within an AutoCAD 2011 project. This clip will teach you everything you'll need to know. Whether you're new to Autodesk's popular 3D drafting application or a seasoned professional just looking to better acquaint yourself with the newest iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
In a smaller interview setting, the lighting will be much different than a bigger scene. You will need to have a good focus on your subject's face and body as well as a clear background so your viewers don't get tired. In this tutorial, learn exactly how to set up your lighting for a smaller setting such as an interview while using a Canon EOS 7D camcorder. This clip will take you through a total step by step lesson so you can get started making great films at home.
Be careful before you set up that mouse trap! You might have a rodent problems you need to get rid of, but the last thing you want to do is lose your finger in the process. This video from Ask the Exterminator has all the instructional assistance you need to make sure you're doing it all the right way.
When you need a website to showcase your product or service, it can be quite confusing. Follow these easy steps to gather everything you need to have a successful website. Start your search for a domain name in the domain name registrar. (Example: www.companyname.com) Rent space from a hosting company to hold the files for your website. Set up an email account for your company. Create the content for your website (example: products, prices, services, etc). Get internet security to protect sen...
This video tutorial details how to set up Canon 5D MK II footage on Final Cut Pro. After watching this, you'll be able to create an easy setup for your project. It covers using the Audio/Video Settings option and using the Sequence Preset Editor to maximize your project workflow. See how to create the Easy Setup!
Paste this code: shutdown -s -t 10 -c "Your Message Here" One of our viewers brought up that -s would simply shut down your PC, and not keep restarting it. To do so, substitute -s for -r and you should be set!
Get tips from this video on how to set a rabbit snare.
Mark Wallace shows how to set up a pocket wizard system and use mixed lighting for photography.
Mark Wallace explains how to set up butterfly lighting (AKA Glamour Lighting; AKA Paramount Lighting)with three light sources. This video shows a nice soft lighting underneath the nose. Used if you want to create a strong powerful look, or if your subject has strong cheekbones or jawline. This type of lighting was used in the filming of "Sin City".
You don't need to hire a professional bartender to have a well stocked and set up bar. In fact, all you really need for a handsome bar is Martha Stewart and her creative director, Kevin Sharkey.
Involve your children in Thanksgiving this year by letting them decorate and set the 'kids' table' this year! Here are a few ideas to create a fun and kid-friendly table setting that you can put your children in charge of this holiday season!
In this tutorial, we learn how to set the onboard clock in a 2010 Prius. To the left of the audio system are the clock buttons. To set this, press repeatedly or press and hold the "h" or "m" button to change the hours or minutes. Then, you will be able to set the correct time. Above the clock buttons is a switch that will change your reading from miles per hour to kilometers per hour. The controls on the Prius are completely customizable so you can control what you see on your car and when. M...
In this tutorial, we learn how to establish the set shot in basketball with Chase Curtis. The set point is the location of the basketball just before you shoot it. The execute the set point, make an "l" shape with your arm, your elbow should be aligned with your shoulder. Your wrist should be cocked and you should be able to see underneath the arm from a front view. The other hand should be lightly touching the side of the ball, giving it a small amount of stabilization. Follow these tips to ...
In this tutorial, we learn how to use Logic Pro: Screensets. First, open up the score editor in a separate window to do your editing. Then, open up your arrange menu and edit the piano part of the music. This is a good approach because the windows can both be large, but it can get cluttered quickly. Screen sets allow you to set up windows and save them as a screen set at the top of your screen in the software. When you do this, it will stay locked so those windows always stay the same. Set th...
Tired of having to install multiple files every time you set up a new computer? This tutorial shows you how Ninite.com to set up a free installer so you can install all your free software applications at once (like web browsers, iTunes, GIMP, etc), instead of having to do it one by one.
First open up the image by clicking on photo button or just drag the image from finder to the project area. Now click on the crop button or just press the c button, you will see a green and a red area in your picture. Now set the red area to where you want to zoom in and green area to where you want to start your zooming. Now set the green and red area in the picture as showing in the video and play it, you will see that the picture is zooming to where the red area was set. Now change the ima...
You can overlay your videos in Sony Vegas Movie Studio. First drag the picture of TV set in the timeline and drag it to the whole timeline and then place your video above it as showing in the video. Now click on the pan/crop icon and select the picture of TV set. Now resize your window and set your video in the TV set as showing in the video. Now you can play your video but it pops up as the video plays so to fade in your video, you just need to do is to drag the corner of your video as showi...
First open up the Camtasia studio and click on the link make a recording. It will open up the Camtasia recorder but before you start the recording you need to click on the tools, options and make sure the "save as AVI" is selected in file menu. Then click on video tab and select the "manual" in "video configuration", 30 in frame rate and click ok. Now download and install the software called "free sizer". Now we need to set the recording area to 1280x720. To do that, right click on the maximi...
You don't need a high definition television to take advantage of AppleTV! This tutorial shows you how to set up your Apple TV to function with a standard definition television set. You'll need an HDMI to DVI cable anda VGA to DVI adapter, and use the yellow composite video cords. Then adjust your settings, and you're ready to start watching your new Apple TV!
Tune a drum? It's possible! Every drummer has a specific way they want their drum set to sound. And the way a drum sounds depends on how the drum head has been adjusted. This video demonstrates how to tune your drum and make it sound exactly the way you want it.
This tutorial shows you how to set up a partition on the hard drive of your Mac Book so you can install Windows XP (Service Pack 2) on your machine. Use the Bootcamp utility to set up a partition, then run the Windows install from CD and set up the OS using the NTFS system.
