Affordable Option Search Results

How To: Allow only Monday dates in a cell in Microsoft Excel

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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.

How To: Count with four criteria in Microsoft Excel

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 596th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 criteria including an all criteria option.

How To: Open a stubborn jar

Want a quick meal, but the jar won't open? Here are some tips: try slamming it on your kitchen counter-top upside down, but not with enough pressure to break the jar. Another option is running hot water over the lid of the jar, to loosen it up. You can wear rubber gloves to give yourself a better grip, as well. This should solve any hurdles in the way of last-minute dinner preparations.

How To: Create and manage text in Final Cut Pro

For this Final Cut Studio video tutorial, Zach King will teach you how to create and manage text in Final Cut Pro. To create and manage text, just go to the Video Generators Tab in the Viewer window, go to Text, and choose your favorite option, or just the plain old Text. Check out the rest of the process in Final Cut. Let the Final Cut King show you how!

How To: Open format timeline in Final Cut Express

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.

How To: Use creative mode in Minecraft 1.8 to build a world

So you've just installed Minecraft 1.8 on your computer, and you're trying to figure out how to use the cooler options of creative mode. Where do you start? This guide will show you how to destroy blocks, create buildings with blocks, manage your inventory, obtain unlimited blocks, and use fly in creative mode while playing Minecraft 1.8.

How To: Manage and improve battery life on a Motorola Droid Bionic

The battery manager is a tool in the settings of the Droid Bionic Android smartphone. With it, you can create profiles that help you increase the battery life on your Droid Bionic with presets such as "Maximum battery saver", "Nighttime saver", and "Performance mode." Pick the option that best suits you so that you can take advantage of that 4G Verizon Wireless connection.

How To: Enable God mode in Windows Vista 32-bit and 7

In this video tutorial, viewers learn how to enable hidden God Mode in Windows Vista 32 bit and 7. This option does not work on Windows Vista 64 bit. Begin by right-clicking on the desktop. Then go to New and select Folder. Now name the folder to a desired name and paste this code behind it: .{ED7BA470-8E54-465E-825C-99712043E01C}. Users will now have a full list of control options for their computer system. This video will benefit those viewers who use Windows 7 and Vista, and would like to ...

How To: Remove pop up screen when Avira Antivirus updates

In this tutorial, we learn how to remove pop up screens when Avira Antivirus updates. First, locate the installation folder for Avira, this should be in your computer programs. After this, locate the file "avnotify.exe". Next, right click this and go to the preferences option. Now, go to security, then edit, then click on the system option. Click "deny" on all the boxes in the bottom section, then save these. Now, the next time your Avira updates, you will not get a pop up box that tells you ...

How To: Recover music from an iPod without software on a PC

In this video tutorial, viewers learn how to copy music and videos from an iPod to a computer. Begin by opening iTunes. Do not plug in your iPod device. Then click on Edit and select Preferences. This will make iTunes blind to the iPod. Now connect your iPod and open the drive folder. Click on Tools and select Folder Options. Now check the option "Show hidden files, folders and drives" and click OK. Then open the "iPod_Control" folder and open the "Music" folder. Now copy all the files into i...

How To: Draw the I-Mac icon using Flash CS3

The iMac may not the sexy new little darling of the Apple lineup that it was when it came out in the 90's, but it is still a very effective computing option for those that want Apple features without spending Apple money. This video will teach you how to draw the iconic iMac desktop icon using Flash CS3.

How To: Use multiple camera angles when shooting a movie

Spice up your next movie project with new and interesting camera angles. In this tutorial, learn all about the different options for aiming your camera that you can use to convey new moods or effects. These instructions are easy to follow and are great for first time filmmakers. So, follow along, grab your camera and start shooting!

How To: Watch TV online & save money by ditching your cable

If you have a high-speed Internet connection, your cable subscription might be redundant. This consumer's guide from the folks at CNET TV presents an overview of the various options available to you — all of which will save you money over cable in the long run. For specifics, and to start seeing whether you too would benefit by dropping your cable television subscription, give this guide a look.

How To: Use an Android phone to play music in your car

There are various ways to connect your Android phone to play music in your vehicle. You may be feeling a little left out with all of the devices available for connecting iPods and iPhones, but have no fear! There are plenty of available and easy to use options for your Droid as well. Follow along and start jammin'!