Appealing Option Search Results

How To: Fix broken AVI files with DivFix++ on Ubuntu Linux

Broken AVI video files are your worst nightmare. Nobody wants to watch a video and find out it's corrupted and not working anymore. But there could be a solution on Linux. This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to fix broken AVI files with DivFix++ on Ubuntu Linux.

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: Turn dates off in Blogger blog posts

Sometimes when making a blog post you'll want to post it without any date whatsoever. To do this is easy, and this short how-to from How to Mac, makes it easy as pie. This is a tutorial on how to turn off dates on your blogger blog posts. If you want to change the blog post dating system click on the formatting tab and change the first setting. To completely turn the dates off make sure you de select both the first and third option in the edit blog post window.

How To: Make a clear cheat sheet for a test

In this video we learn how to make a clear cheat sheet for a test. If you're in a time crunch and need to ace a test, this is a great option to cheat. First, you will print out what you need to know on a piece of white paper. From here, take some clear packing tape and tape it over the information on the paper. After this, dip the paper into water and cut it out into sections. Next, you will peel the paper back from the tape and you will be able to see the print on the tape! Use this with a t...

How To: Adjust the front seat and heater in the 2010 Toyota Prius

In this tutorial, we learn how to adjust the front seat and heater in the 2010 Prius. First, you will need to adjust your seats by lifting the lever in the front of the seat. Move up and down until it's comfortable. On the side of the seat is a lever which will move the seat up and down. The other lever behind that will move the seat back up and down until it's in the right place. There is also a button on the side that will change the lumbar support for your back. There is also an option ava...

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: Create cutscenes with the Dragon Age: Origins toolset

When Bioware anounced the Dragon Age: Origins toolset, they mentioned a lot about being able to recreate your own battles and create your own cut scenes! Well, after opening the toolset you will notice that there is an option to making cutscenes! But if it's a little overwhelming for you, let this video be your savior! In this video you will learn how to make a complete cut scene from start to finish.

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: Create summary tasks in MS Project 2007

In this tutorial, we learn how to create summary tasks in MS Project 2007. First, put a task into your project and use the fill option to create more tasks. Fill in the duration and start time of your tasks as well. Now, write the subject at the top and then highlight the tasks that have to do with them, and click an arrow to indent all of these tasks. You can have up to nine levels of indenting and tasks, but this can make your project look far too complicated. When finished, save your proje...

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: Begin using a USB flash drive

In this tutorial, we learn how to use a USB flash drive. First, go to "my computer" through your desktop. Next, you will see a device that says "flash drive", which is in drive "d". When you unplug your USB device, the drive will disappear. When you plug it back in, a new window will appear asking what you want to do with drive "d". Now, go to your documents folder and if you want to copy one of these files, right click and choose the copy option. After this, you will be able to paste your fi...

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: Draw a room with stairways using complex levels

Have you ever secretly pined away for a career in interior design, even though you're currently stuck in law school because, well, your parents forced you and gave you no other option? Because law school can be a bit rigid in terms of what you learn (pretty much it's just facts and figures and learning sound logic), it's important to indulge your creative side ever once in a while.

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: Access all Windows 7 settings at once

In this video tutorial, viewers learn how to access every Windows 7 setting at once. Users will need to download the Windows 7 in a Box program provided in the video. Once downloaded, simply click on one of the functions (Functions, Folders, Internet Settings, Programs, Tools and Settings) on top of the window and select the option that you wish to use. This program will organize all the Windows 7 settings into an easy to comprehend layout. This video will benefit those viewers who use a Wind...

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...