Software: Page 82

This how to video shows you how to do a live trace in Adobe Illustrator. First, open the image you want to use. From here, zoom out. Go to the corner of the image and hold shift and drag to shrink it. Zoom back in and then click the arrow beside Live Trace. Go to tracing options and click okay. Check ignore white so that you will not get a box. Click trace and then select expand. Click out of the image and click control y on your keyboard to show the outline of your file. If you did...

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 390th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of words and numbers quickly with two different formulas as well a a mouse trick that will allow you to paste special values.

In this how to video, you will learn how make car rims bigger using Photoshop. First, open the image in the program. Choose the elliptical marquee tool and select the rim. Next, right click the selection and click layer via copy. Now you should have the cut out rim in a new layer. Drag layer 1 bigger by holding shift. Replace it and then click on the accept button. Erase the part of the rim that is on the body of the car with the eraser tool. Have layer 1 selected and merge it down. Do...

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 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OFFSET function and defined names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.

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 582nd installment in their series of digital spreadsheet magic tricks, you'll learn how to understand and fix the nine most common formula errors in Microsoft Excel. Specifically, you'll learn how to interpret and resolve #######, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Cell Reference, and #NULL! errors.

This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new...

In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.

This video shows us the method to transfer files between iTunes libraries in iTunes 9. First step involves downloading iTunes 9 from apple.com. Go to the 'Edit' tab and 'Preferences'. Go to the 'Sharing' tab and select the 'Share selected playlists'. Select the playlists you want to share and click 'OK'. Now go to 'Advanced' and select 'Turn on home sharing'. Make sure that both are under the same account. Type in the password and you will see an icon in the shape of a home in the left side....

This video tells us the method to use the WORKDAY & WORKDAY.INTL functions in Excel. These functions are used to find a workday after a finite number of workdays in the future. WORKDAY uses Saturday and Sunday as off days. Its syntax is WORKDAY(start date, days, [holidays]). 'days' refers to the number of days in the future and holidays is the list of holidays written below each other in the same column. If Saturday and Sundays are not your off days, use WORKDAY.INTL. Its syntax is...

This video tutorial from computerticket shows how to use Daemon tools and Img Burn applications.

In this how to video, you will learn how to set up Outlook Express for Gmail. This is useful if you want to use the program to access your email. First, log in to your Gmail account and go to settings. Next, go to Forwarding and Pop and select Enable Pop for all Mail. Save this and then go to Forwarding and Pop. From here, select Outlook Express. Click Run the Auto-configuration Tool. From here, you must save a file and open it. Once it is open, type in your account information. Press...

In this Software video tutorial you will learn how to make animated GIFs with Adobe Fireworks CS4/CS3. It is easier than Photoshop and Flash. You can create a picture or you can drag and drop a picture. To drag and drop a picture, find out the dimensions of the picture. In the example, it is 420 x 420. Now open fireworks, open a new document and set the height and width to 420 pixels and click OK. Now drag the picture and drop it in to the blank canvas. On the top bar go to window > states....

Robert demonstrates how to use Photoshop to give yourself a tan. First, you need to upload your picture(s) into Photoshop. Then pick one to work on. Next, you will need to copy the background to save the original image. On the right side drag the background label to the new layer icon (you can just hit control J). You will then need to select a paintbrush tool. Go up to the tool bar and click on the paintbrush settings to set the hardness at 80%. The master diameter will be adjusted as...

This video shows us a tool that can be used to split and merge pdf files without having to buy any software.

This how to video shows you how to create wallpaper for your computer desktop. Open Photoshop and create a new file. Change the dimensions to the size of your desktop. Click okay and go to edit and fill. Choose color and select black. Click okay to fill the screen with black. Duplicate the layer. Once this is done, go to filter, render, and lens flare. Make sure the lens flare is in the center. Edit the settings to your liking. Click okay to add the effect on to the image. Go to...

In this how to video, you will learn how to layer videos in Final Cut Pro. First, open Final Cut Pro. Get your original clip and then put the clip that you want in the clip and drag it in over the top in the time line. Change it to image and wire frame. Grab the corner of the image and drag it down to the size you want. You can also move it around. Next, go to sequence and render it. Once that is done, change the selection back to image. Once you play the file, both clips will be...

This video demonstrates how to set up a password for Microsoft Outlook. Begin by opening up Microsoft Outlook. Next, go to "GO" and scroll down the "Folder List." Click on this. Then right click on "Personal Folder" and then on "Properties." Next, you will need to click "Advanced" then "Change Password." You will then type your old password. This is your default password for your email. Next type in your new password. You will need type it in twice, so make sure you type it in...

In this how to video, you will learn how to whiten teeth in Photoshop. First, open an image that you want to edit in Photoshop. Zoom in to the teeth as much as you can. Next, go to the brush tool and set the diameter to 21. Hold shift and q to put you into quick mask mode. Now paint over the teeth with your brush. Whatever is red will be your selection. Once you are done painting the teeth, select press shift and q again. Go to select and choose inverse. Next, go to image and...

In this how to video, you will learn how to convert an AVI file to a DVD with Xilisoft. First, you will need to download the Xilisoft AVI to DVD Converter. Next, click the add video files icon on the left and select the AVI file that you want to convert. Select it and click open. Next, change the destination so that it is saved as an ISO file. Enter the new name of the file and click save. Click start burn on the right side. Now your AVI will be converted to DVD format. Once it is...

This video teaches us to make a photo black and white with coloured parts in Photoshop. This procedure consists of many steps. In the first step, we choose the magnetic lasso tool from the application. This is followed by the second step. In the second step, we draw the contours of the places we want to stay colored in the photo. Press the 'Shift' key to keep the contours selected while drawing contours across multiple places in the image. After drawing the contours, go to step three. Right...