Options Search Results

How To: Create Better Panoramas in Photoshop CS4's Photomerge

In the new Photoshop CS4, there are some minor improvements to the Photomerge function, including the new collage option. Jay Kinghorn goes over the different ways of bringing your images into photomerge, the layout options, and some quick tips for creating better quality panoramas in Photoshop CS4. The following how-to video walks you through the entire process.

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: Download WinRAR and unpack audio media files

When the amount of memory on your computer sucks, you either have two options: Buy more RAM, or make use of the storage space you've got by compressing your files. One program that will become your new BFF should you choose to do the latter is WinRAR. WinRAR is a compression and packaging software that makes it way easier to store large files on your computer.

How To: Use the groove function in Ableton Live 8

In this tutorial, we learn how to use the groove function in Ableton Live 8. A group settings consists on points along the timeline where hits sit. If you have something with no groove applied, it will sound robotic. By adding a groove, you will shuffle around the midi from the hard quantized parts. This will add more human element to the audio. There is a button on the left with two lines that show the library with options you can use. You can also apply this to other clips, scroll through t...

How To: Make smart contact sheets with Photoshop

In this photography tutorial, you learn how to create a contact sheet using Photoshop for your digital photography prints. In order to create this contact sheet, you can open Photoshop, go to File, find the subfolder called "Automate" and then choose to create a contact sheet. If your version of Photoshop does not appear to have this setting, your version of Photoshop should have come with a secondary disk which has this feature. You can also find the file from Adobe if you do not have the go...

How To: Ignore hidden rows with MS Excel's AGGREGATE function

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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.

How To: Ignore nested subtotals with AGGREGATE in MS 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.

How To: Ignore filtered values making calculations in MS 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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.

How To: Use the AGGREGATE function in Microsoft Excel 2010

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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...

How To: Watch TV on your iPhone with Joost

In this tutorial, we learn how to watch TV on your iPhone with Joost. First, you will need to download this application to your phone. After you do this, click the icon that is on your phone. Once you are on this, you will be directed to a page with different options. Click on popular to see what the most watched shows are, then click browse to find different shows to your liking. You can also click on search if you are looking for something in particular. There are thousands of different sho...

How To: Use the zoom feature in Mac OS X Leopard

In this tutorial, we learn how to use the zoom feature in Mac OS X Leopard. First, go to system preferences, then universal access. Find the zoom category, then turn it on of off. You will also see the keys that you can press which will make it appear. If you go to the options menu, you will be able to maximize or minimize the zoom. Test this out by zooming in on a page and holding the control key along with the tracking ball on your mouse. When you do this, everything will become far more zo...

How To: Use a calendar for future projects in MS Project 2007

In this tutorial, we learn how to use a calendar for future projects in MS Project 2007. First, go to the "tools" menu, then down to organizer. Choose the calendar tab and then change what the calendars are available in. Choose ABC Limited, then click on "copy". Now, click on "close" and open up a new project. From here, go to "project" then "project information", and you will be able to change to the other calendar. Remember to change the default under the options so you have the correct tim...

How To: Create a group for your college class on Facebook

In this tutorial, we learn how to set up a group on Facebook. First, log into your Facebook, then click on "groups", then click "create a new group". Now, give your group a name, description, news, email address, and contact information. When finished, click on "create group". Now you will be able to customized your group by adding images. Once you do this, you can add a website and change your different options. Allow only instructors to upload photos, because students may decide to upload i...

How To: Make a healthy chicken wrap for your kid's lunchbox

With obesity now a confirmed epidemic in the United States, we should be putting more emphasis than ever on how we feed our children and what they consume at school. While many educational instititions sell salads and healthier options like apples and carrot sticks, these foods often don't catch your kids' attention when they're placed side-by-side with cheeseburgers and calzones.

How To: Use Flickr photos in your screensaver

In this video tutorial, viewers learn how to use Flickr photos in their screen-saver. This task can only be done on the Windows computer. Users will need to download the program from the website provided in the video. Once downloaded and installed, there is an option in the Screen Saver Settings. Users are able to take photos from specific users or groups, or can search through tags and contacts. Further options include selecting the size of the photo and delay between switching the photos. U...

How To: Use the navigation tools in Adobe Photoshop CS4 or CS5

Photoshop lets you modify your view of an image using a variety of tools, commands, and options. But you don't need a single one of them. Learn a few navigational shortcuts and you'll be working at maximum efficiency in no time. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information...

How To: Reset and purge in Adobe Photoshop CS4 or CS5

Deke gets things started with a pair of options that can clean out Photoshops plumbing when things get clogged up: Reset and purge. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Make a frozen lemon soufflé, the perfect summer treat

In this clip, learn how to make an absolutely delicious dessert for summer: frozen lemon souffle. This dessert is refreshing for a hot day by the pool and adds a wonderful zing to the end of any meal. Follow along with this tutorial from the TLC Discovery Channel Cake Crew and get started. You will also get a ton of options for garnishing the souffle like a professional chef. Enjoy!

How To: Use Spotlight to find files in Mac OS X

In this video tutorial, viewers learn how to use Spotlight to find files in Mac OS X. To activate Spotlight, click on the blue magnifying glass icon in the top right corner. Then type in the term to search. Spotlight will display all the documents and files that match your search. If you click on Show All, you will have more options in Spotlight. In the Spotlight Preferences, users are able to select the categories for Spotlight to search in or not search in. This video will benefit those vie...

How To: Secure or find your Android smartphone if you lose it

If you've spent a ton of money on your newest smartphone, you will want to make sure it's secure. In this tutorial from the experts at PCWorld, learn exactly how to activate safety mechanisms on your Android. With these options you can set a complicated passcode (so that anyone who does find your phone won't be able to access your files) and you can also set up a locator. By using the location app, you can text your phone from anywhere else and set off a search alarm so you will be able to fi...

How To: Import, manage & export 16:9 footage in Final Cut Pro

In this video tutorial, viewers learn how to import, manage and export 16:9 footage in Adobe Final Cut Pro. Begin by opening the Log and Capture.Then configure the Logging, Clip Settings and Control Settings. For the Control Settings, set the Device Control as Fire Wire NTSC and the Capture/Input as DV NTSC 48 kHz Anamorphic. Then scroll through the sequence setting of the footage and check Anamorphic. To export, click on File and select Export. Click in Options set the the size to Compressor...

How To: Use the Home Sharing feature in iTunes 9

Engadget shows iTunes users how to make use of Home Sharing in iTunes 9 in this video. Using screenshots and video tutorials on-screen, Engadget shows the full interface of iTunes 9 to show you exactly where to start. Through several examples you can see how the transfers work and what viewing options and filters you can use to make the sharing feature quick and easy, including automatic transfers of your iTunes purchases or apps, so it's not just for your music library. Even though it's impo...

How To: Format an external hard drive for Mac OS X

The World Wide Geek demonstrates how to format an external hard drive for Mac OS X. External hard drives are usually formatted for windows. To change the format, you will need to use the disk utility option. Access the disk utility by going to finder and clicking on applications. Next, click on the utilities folder. Then, click on the disk utility option to open it. You can also search for disk utility in spotlight. Select your external hard drive in the options to the left of the disk utilit...