See how to use themes to set color, font and effects settings for a Microsoft Excel 2007 workbook. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular 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.
Learn how to use set key frames (or keyframes) working in Nuke 5. Whether you're new to the Foundry's popular node-based compositing application or a seasoned post-production professional just looking to better acquaint yourself with Nuke 5's new features, you're sure to be well served by this video tutorial. For more information, including a detailed overview, watch this free video guide.
There are nearly as many ways to set up a hammock in the bush as there are to skin a cat, to use the old cliche. This video demonstrates one simple way to set up a hammock in the bush. As the presenter explains, this simplicity is a blessing when you are out in the bush and need something to sleep in as quickly as possible. If you don't have a tent and there are trees around, hammocks are the superior choice for your survival and comfort because spiders and other pests that live on the ground...
Set your Android smartphone's ringer volume while leaving other volume settings untouched. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to adjust the ringer volume on your Android smartphone.
Performing close-up card trick magic in a business environment can be one of the most lucrative envrionements in which to do so. This trick, called Let's Do Lunch, is perfect for just such a setting as it integrates the business cards that your audience are sure to have in abundance. It requires no set-up and only minimal sleight of hand, but produces a great effect. This tutorial video will have ou performing it in no time.
Fancify your slideshows with Apple Aperture 3. Whether you're new to digital photography or merely unfamiliar with Apple's Aperture 3, you're sure to benefit from this free video software tutorial from Lynda, which presents a thorough, step-by-step overview on how to set up complex slideshows within Aperture 3.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.
Want to give your new Android enable mobile device a personal touch? Well, your phone comes preloaded with wallpapers that you can use, and you just have to find the right one that fits your personality. Adding the wallpaper to your phone is easy. Go to gallery, flip through the stock wallpapers, and select the one you want by clicking "select" — Best Buy has answers. The Best Buy Mobile team explains how simple it is to set the wallpaper on an Android cell phone.
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 536th installment in their series of digital spreadsheet magic tricks, you'll learn how to list all modes in a given multimodal data set using Excel 2010's MODE.MULT function.
Want to set up a custom email account for a domain hosted by GoDaddy? It's simple. So simple, in fact, that this free video guide can present a complete overview of the email address creation process in just over three and a half minutes' time. For complete instructions, and to start using your own custom email addresses, watch this helpful how-to.
In this video tutorial, viewers learn how to use the Filter Key features on a Windows 7 computer. Begin by opening Control Panel and select Ease of Access. Under the Ease of Access Center, click on Change how your keyboard works and click on Set up Filter Keys, at the bottom of the window. Now check the box beside Turn on Filter Keys. Users are provided with several options for he Filter Keys such as: turn off the Filter key wen Shift is held or 8 seconds, display a warning message when turni...
In this how to video, you will learn how to set up a tone arm on a record player. First, you will notice the counter weight at the other end of the tone arm. Remove this first. Set the dial set to zero and have the lever pushed forward. Slide it on and lift the arm off of its rest. Play around with it until the arm floats. The next thing to do is to balance the cartridge. Many cartridges have different weight requirements. If you do not have the weight set up behind the arm, you cannot use di...
This HelpVids.com tutorial shows the basic options for setting an alarm on an iPhone. To begin, open the "clock" app. There are four sub-menus in the the "clock" app. Choose the "alarm" sub-menu. To create a new alarm, touch the "+" in the upper right corner of the screen. A new screen appears and the user has different options. A repeat time for the alarm can be chosen. The user can choose the sound that plays when the alarm goes off. The "snooze" option can be toggled on or off, and the ala...
For all you future RC fans out there, if you're having trouble setting the Nitro engine gear mesh up on your RC vehicle, do we have the video for you. This tutorial will give you about 8 whole minutes of how to properly set up this easy task. Although it says it is for Nitro, it can be used with others as well. Enjoy!
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 188th installment in their series of digital spreadsheet magic tricks, you'll learn how to set up headers and footers across multiple sheets.
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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.
HP TouchSmart is a powerful PC with innovative features. Using the HP TouchSmart Recipe box you can set up the blue tooth headset. The recipe box provides an easy way to work with you recipes using voice commands. You can set up your blue tooth head set to use the voice command feature of the recipe box. This gives the freedom to walk around your kitchen while cooking. The microphones embedded in the TouchSmart can also be used for this purpose but the blue tooth head set gives a better voice...
Create drums sounds using Reason's Thor synthesizerYou can use the Thor synthesizer to make a kick, snare, hat and clap sound.Kick:Use the analog oscillator with triple wave form octave3. Set the source to mod envelope 45 destination oscillator 1.Use a very short attack to K and release time. You get the short effect of pitch. Try different oscillator types to get different textures.Snare: Use the same basic patch that we created for the kick. We will keep it as the basis for most patches for...
The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the 3 default sheets. This video puts the macro in a module. The procedure starts with typing sub and a name which can be easily recalled. The rules for naming the macro are also covered briefly. After the macro code is writ...
Ubuntu and Windows may have trouble syncing time because when they are dual booted, they both assume that your hardware clock is set to a different time setting. Ubuntu assumes that your clock is set to UTC and Windows assumes that your clock is set to local time. Answers Launchpad has solutions to fix the syncing issues. To correct the issue, configure Ubuntu to be set to local time. Launch your terminal window and click on the description box. In the code string change the UTC default value...
Network mapping lets PC users organize multiple computers into a system that provides informational data access. This video tutorial shows how to set file sharing permissions and assign users designated privileges within a network. Establishing a network provides functionality within a workplace and facilitates virtual communication among users.
In this video the instructor shows how to set parental controls for a user ID account in Windows 7. To do this go to the 'Start Menu' and go to 'Control Panel'. In the Control Panel window select the 'User accounts and Family Safety' link. There is an option called 'Set up parental controls for any user'. Select that link and it opens a window where it asks you to Choose a user and set up parental controls. There you are presented with some user accounts that are currently active on that syst...
This is a video from HelpVids.com that discusses how to set and adjust tab stops and indents in Microsoft Word 2007. The video starts off with a Word 2007 document open on the screen. First the presenter shows how to show and hide the rulers. This is accomplished by clicking on a small icon above the vertical scroll bar. Tab Stops are only applied to text that has been selected and not the entire document (unless you select the entire document). The sliders on the ruler control the amount of ...
If you are looking for a healthy and flavor packed meal to change up a boring lunch routine then your in luck. This video will show you how to make a pita hummus pocket. You can make your hummus from scratch.
In this video by Click Here Photography, learn about using f-stops, or apertures and how they work. The aperture is the hole or opening within the camera that allows light in. When using your aperture setting it is important to remember that the amount of light traveling through a lens alone will not only give you a great photograph, but a combination of the following three components, which are:
Lifestyle expert Hal Owen teaches us the correct way to set a table place setting. 1. Place the "charger" plate in the middle of the place setting. This is the plate on which you will place all of the other plates. 2. Place your "dinner plate" in the middle of the "charger". 3. Place your "soup plate" in the middle of the "dinner plate". 4. Place your fork on the left of the plate and your dinner knife and spoon on the right, with the soup spoon on the outside. 5. Place your dessert fork and ...
If you ever wondered how to create a buy now button for your website this video shows how to do it using Photoshop. To do this open Photoshop and start with a new file. First draw a rectangle which will be now modified into the buy now button. Set the radius of the rectangle to forty pixels. Fill it with gray color. Duplicate the layer. Open the layer options of the duplicated layer and set the stroke position option to inside. Set its weight to 6 pixels and set its colors to light gray. Now ...
This video shows you how to set up an active speaker system with a built-in amp. Move the gain up and have it halfway up on the mixer. The actual volume control should be set to 0 prior to moving the gain up and down. Mess around with the gain, and slowly bring the gain up until you are slowly tapping into the ampere. You can mess with the gain until it sounds right. This will increase the bass on our mixer.
This is an amazing magic trick that can only be done with a new deck of cards. Watch the video to learn.
In this video, learn how to set-up a Canon EOS 7D camera for slow motion. Learn about the settings you need to use to prepare to shoot in one of the high speed modes. To see more of the videos on this subject, check out the parts below, especially on processing the slow motion film.
An interesting feature of Windows 7 is the ability to run Windows XP in a virtual machine in order to use applications that don't currently work with Windows 7. This is different than using other virtual machine options because in the final version of Windows 7, several versions will ship with this for free as opposed to other options such as purchasing VMWare and an XP license.
This video tutorial from Melrose Jewelers shows you how to set a Rolex Day-Date President wristwatch. Setting the Rolex Day-Date can be done with just a few simple steps. You will see how to set the day, the date, and time... just watch.
This covers using no-ip.com to set a dynamic domain name after you set up your own server. This makes the IP dynamic rather than static. It updates the domain name with your IP address so you don't have to. This is an informationleak.net video from Halla.
Regular backups of your important files are something that should be a top priority, though because of the complexity of most backup systems, regular backups are often overlooked until it is too late. In this video tutorial, you'll learn how to set up automated backups in the Microsoft Windows Vista operating system. Get started backing up your files with this helpful guide.
Check out this instructional climbing video that demonstrates how to set up the ascent system for crevasse self rescue. Hooking up the prussik is the subject of this video and stops at the second ascender required for upward mobility. Watch all the crevasse self rescue series and you may get the hang of this. It is best to practice this somewhere dry and safe before the real thing happens. When you are in the hole things get tougher.
The Prada cell phone (LG KE850) is a unique, sophisticated and elegant mobile phone with the first complete advanced touch interface.
Illah Nourbakhsh of Carnegie Mellon's Robotics Institute teaches you how to set up and use your Gigapan robotic system. Watch all four videos to see the process from start to finish. Learn how to use the Gigapan robotic system by watching this video tutorial.
If you're new to the Mac OS X operating system, one of the first things you might like to do is set up an email client. In this how-to, Gary Rosenzweig looks at how to set up the Apple Mail application to receive and send email from a standard ISP email account.
Before scratching on a given turntable, you'll need to set it up properly to ensure that you will not damage either your records or your hardware. This basic DJ tutorial demonstrates one method (among many) for adjusting up a turntable for scratching.
This video is a tutorial for setting up Native Instruments' Traktor Scratch system. While the setup can seem a bit confusing, with this video's help, you will be able to setup and use your system easily. You should practice setting this system up repeatedly, especially if you intend to use it in live performance, so that setup is quick, and troubleshooting is straight forward rather than a sweaty, nervous mess!