In this Excel basic video the instructor shows how to setup a spreadsheet and use cell references. Cell references are used in Excel to refer to other cells in a formula. When a formula contains data based on the cell reference the formula auto generates the result each time the value in the cell changes as the formula contains only the reference to the cell and not the actual data present in it. In this video the tutor goes on and shows how to write a few basic formulas using cell references...
In this video, viewers learn how to install and setup JDownloader on Ubuntu Linux Downloader is open source download manager. It simplifies downloading files from One-Click-Hosters like Rapidshare.com or Megaupload.com - not only for users with a premium account but also for users who don't pay. It offers downloading in multiple parallel streams, captcha recognition, automatically file extraction and much more. Of course, JDownloader is absolutely free of charge. This video will benefit those...
This video demonstrates the technique to setup a Yahoo email on an iPod Touch. You start going into settings and then clicking account. On the next screen you will click "Other" and then click on "Pop". At this point you enter your name and email address that you use for your Yahoo email account. Incoming server or host name is "pop.mail.yahoo.com", next is the username (which is your yahoo email address without the @yahoo). You will then enter your password and the out going smtp server whic...
In this tutorial the author shows how to use a proxy at your school and get on the blocked site like MySpace etc. Now he points to the Dot.tk website and how to access it from Google.com. Now if you want to access any website you just need to copy the link and paste it into the pointed field in the Dot.tk website and now you can choose a new domain name for the website. Now you can choose the free domain option in the next page where the new website is setup. Now he shows how to go through th...
Do you want to know how to make an installer using Visual Studio 2008? In this 9 minute video, the viewers will be taught the process of how to do so. All the viewer requires is a computer and the software. Some of the knowledge in this video is quite advance and require prior computer knowledge. However, the process itself is easy and if the viewer follows each step correctly, they should have no problem creating a setup file using Visual Studio 2008. However, prior computer knowledge is sti...
This simple video tutorial explains how to use Airport Utility to configure your Airport Extreme so you can access your Apple computer remotely for file and screen sharing. It explains how to setup DHCP IP reservations and port forwarding using Manual Setup option of the Airport Utility. Considering that the tutorial becomes a little bit technical during the second part, this tutorial is aimed at users who already have at least some knowledge and/or experience setting up a network. Absolute b...
This is Brian Brushwood with Scam School. The trick is called 'In the bank'. This week we've got another puzzle with a setup that sounds absolutely impossible.
One important part of nursing is knowing how to use and set up a Baxter IV infusion pump. Follow along with this Baxter setup demonstration to learn how to carry out this procedure with a real patient. Keep watching and learn how to do a piggyback IV setup also. Watch, learn, and practice setting up Baxter IV infusion pumps during the nursing lab. Note that the Baxter infusion pump doesn't have a cassette to prime.
This instructional photography video shows how to setup large white infinity backgrounds in the photo studio. The key components to this setup is include this six foot octobox softbox light, which requires quite a bit of power; a framed aluminum reflector; the background itself is vinyl floor painted white; and a black baffle to shield the camera from lens flare. Set up professional looking shoots and take great portraits with this tutorial.
This video teaches how to change Windows 7 accessibility options. Choose Start, Control panel. This opens the Control Panel window. Choose Ease of Access in the control panel window. This opens Ease of Access window. Inside the Ease of Access window, there are various links that allows you to set various accessibility options in windows 7. You can use these settings for options like "Optimizing Visual Display", "Replace sounds with visual cues" and you also have settings to choose how the way...
Learn how to set up an Epson printer wirelessly when you bring your new printer home you will want to start by installing the software that came with the new printer. You can set up your printer to work without wires and it will print from all over the house. There are 3 ways to set up the printer including the Epson way, with cables, and WPS. To determine is you need to use WPS, which is more complex, check your router to see if it has a sticker on it that says Wi-Fi Protected Setup. If that...
An awesome GoPro setup for diving with sharks.
This video demonstrates how to setup a printer on a Macbook Pro.Open the document you wish to open. Go the File menu on the top bar menu and select Print. On the Print dialogue box, you will notice that no printer is selected. Click on the drop down menu to select Add A Printer. Click on the IP found on top of the window. Change the protocol to IPP or Internet Printing Protocol. On the address bar, type in the address of your printer then click on Add. Once done, you can now print your docume...
Own3D.tv is an online service that allows you to stream many different games and content from your computer game so that others can see you play. It is commonly used with PC games such as League of Legends and Starcraft 2. If you want to configure XSplit Broadcaster to stream to Own3D.tv, watch this guide on how to setup XSplit to stream to your channel.
The equipment only does about half the work when it comes to making your shot really stand out - the other half is setting up your shot just so. This is a quick video that gives you some good tips for making your shot look amazing, no matter what you're filming with.
If you're a Mac user, you know the keys to the castle are literally knowing how to use the shortcuts and hot-keys. But, what if you don't like the predefined OS X setup? Well, simple answer, change them. This is a quick guide to remapping any keyboard shortcut in any application running in Mac OS X.
If the servo wires in your RC car are broken or need to be a different size for the setup you're working with, this video will help you out. It will show you how to repair damaged servo wires or, if you aren't happy with the size, swap them out for longer or shorter wires.
If you can do an inside around the world and a crossover, you're probably good enough at freestyle soccer to learn the Air Jester. This trick invovles a lot of side movement after the inside around world setup, and is pretty sweet.
In this clip, you'll learn how to speed up your Cinema 4D workflow by using MoGrapht tracers. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
In this C4D video tutorial, learn how to do simple camera animation, texturing, material setup. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
Appending nodes allows you to reuse node trees from previous files. This can be a huge time saver, particularly when working with complex setups. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!
Not 100% familiar with all the awesome features that make facebook a great storytelling medium? Check out this instructive how-to video from the cast.
Starboard made this video in order to make an intro to windsurf. It's a windsurf academy video that goes over the start to windsurfing. It covers basic techniques like equipment setup, tacking, gybing and getting up.
This video shows how to setup and use your DynaSpy wireless video surveillance camera.
No one likes having their food messed with. That makes it all the more fun to do so right? This video will show you some fun pranks that you can pull to mess with the food of your friends and neighbors. They include making surprise disgusting layer dip and ordering unusual combinations of items at the grocery store, but are all freakin' hilarious and require relatively little setup or risk.
Final Cut Express makes it easy to convert or capture your videotapes into digital video files. All you need to do is set the desired capture format and destination for your clips. The Final Cut Express menu also provides an Easy Setup function.
Final Cut Express provides easy setup options for a variety of video formats, but if you're not sure what format you're working with, Final Cut Express can automatically set the sequence to match the size and frame rate of your clips. When adding the first clip to a new sequence, the program will ask if the sequence should be changed to match the new clip. You don't have to work with all the same format, either, thanks to Final Cut Express' powerful open format timeline.
Learn how to create a preset for printing panoramas in Lightroom. Along the way you’ll pick up some tips about good features to use for this in the Print module as well as tweaking the Page Setup options to get the right sized print.
This tutorial shows how to setup the character order in which you want to fight in Arcade mode in Mugen - the custom PC game engine.
The Motorola Droid Bionic has support for both corporate email and personal email accounts. If you want to setup either, take a look at this guide from Motorola on how to sign into your email on the Android smartphone so that you can start reading and sending new messages using Verizon Wireless's 4G network connection.
The raging debate in the electronic music world between digital and hardware music production is virulent and unnecessary when the best setup is clearly a mix of the two. In this video you'll learn how to get your computer and your DJ hardware together by using the Ableton Live external effect plugin to control sounds from your gear using the computer. It's the best of both worlds!
Lighting a movie can be dramatically expensive and complex, but for the DIY filmmaker on a budget this can be a major handicap. In this video you'll learn how to create a serviceable lighting setup for your filming using only $25 worth of shop lights and 200w bulbs.
In this video, we learn how to create a song in Studio One. First, click on "create a new song" on the start page. Now, click on the empty template, and click on the continue button. After this, click song, then song setup. Click on the audio IO setup, then you will see a new window with input channels. Add in cross points and channels to the window and then test it out. Before you exit, click on the make default button, then click ok. After this, you will be able to start creating a new song...
Are you lucky enough to have gotten your hands on an HTC EVO - the world's first ever 4G cell phone? If you have, then check out this helpful tutorial. In this video you will not only get an introduction to your new smartphone but also a step by step walk through of how to set it up and start using it. So, follow along and start taking advantage of all the cool features of the EVO.
In this tutorial, learn how to install and set up emulators on your HTC EVO 4G so that you can play cool, old-school games on your phone. With these emuators you will be able to play your all-time favorites like Super Nintendo and Sega Genesis games on your mobile phone. So, check it out and get started reliving your childhood in the palm of your hand!
You never know when disaster will happen. You could be going about your business one minute and the next - the power blows out. There are many reasons why a black out can be devastating and if you have small children or run a business that needs to stay lit, check out this video. In it, you will learn how to safely setup and operate a generator to keep your power going through thick and thin.
Looking for an easy way to work with footage from a two-camera setup within Final Cut Pro? Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to learn how to take advantage of Final Cut Pro 7's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to sync multi-cam footage.
If you want to mod your new Duncan yo-yo, don't fret, help is here. See how to silicon recess your Duncan brand yo-yo.
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 357th installment in their series of digital spreadsheet magic tricks, you'll learn how to pull data from individual sheets to a single master sheet given improper data setup.
Have need for a giant stencil (and use Microsoft's popular MS Paint software)? Then you've need for this free video tutorial, which explains how to change the page setup settings in Microsoft Paint to print multiple-page stencils. For more information, including a step-by-step walkthrough of the process, watch this how-to.
