Hot Software Posts

How To: Use the Auto Trace tool in Adobe Illustrator CS4 or CS5

Looking for a quick guide on how to use the Auto Trace tool when working in Adobe Illustrator CS4 or CS5? This clip will teach you what you need to know. Whether you're new to Adobe's popular vector 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: Soften skin, control color & tones in Photoshop CS4

Learn about skin softening techniques and the controlling of color and tones when working in Adobe Photoshop! Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started managing skin tones in Photoshop yourself, watch this designer's guide!

How To: Calculate probability in an Excel pivot table

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 55th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate probabilities with a pivot table (PivotTable). Specifically, you'll learn how to find joint, marginal and conditional probabilities.

How To: Create a 3D sphere & reflection in Illustrator

In this video tutorial, viewers learn how to create a 3D sphere and reflection in Adobe Illustrator. Begin by using the ellipse tool and create a circle. Select the black and white gradient, and drag the colors that you want into the gradient panel. Now hold the Alt key and draw a smaller circle inside. Fill it with white/transparent gradient. Select the sphere and go to Object/Group. Now go to Effect/Distort and Transform/Transform. Tick the Preview and Reflect Y, insert 1 copies box and sel...

How To: Make a gradebook based on percentage scores in Excel

New to 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 Excel tutorial from ExcelIsFun, the 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...

How To: Look dead in Photoshop

In this Photoshop tutorial the instructor shows how to do retouching to produce undead skin makeup. This video shows how to make a convincing, undead like, vampire skin make up. First open a image of the face which you want to make it look like undead face. Go to the channels panel and make a selection of just the face with the skin and exclude the rest of the head which includes the hair and other stuff. Now open a new adjustment layer and open the color balance tool. Fist select the mid ton...

How To: Create a modern bokeh effect in GIMP

In this video, we learn how to create a modern bokeh effect in GIMP. First, start a new image and then change it to the size that you want. From here, click on the paint can and then fill your box up with a color. Then, create a new layer and name it "bokeh background". Click on this layer and then use the paintbrush tool to paint a small brush with color onto it. Start to paint on small dots and you will see that there are small tiny star like dots that start to appear. Then, fade these out ...

How To: Make Someone Look Skinny with the Liquify Tool in Adobe Photoshop

Want to know how to remove a digital tag from a garment for (in this case) a pair of shoes? This clip will teach you what you need to know. 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: Create and use templates in Motion and Final Cut Pro

With this clip, you'll learn how to create templates for use in Final Cut Pro and Motion. These templates are editable in FCP. Whether you're new to the Apple's popular motion graphics editor/compositing application or are a seasoned digital video professional simply wishing to get better acquainted with Motion 4, you're sure to find value in this tutorial. For more information, and to get started creating your own custom templates, take a look.

How To: Sort using buttons in FileMaker Pro 11

See how to sort with button controls in FileMaker Pro 11. Whether you're new to FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, watch this handy FileMaker Pro user's guide.

How To: Make userbars for forums in Photoshop

Since the early introduction of the internet, forums have been a popular destination for people to share their opinions with other users. This particular video shows you how to make a userbar for forums using Adobe Photoshop. It's an easy way to show your pride about a particular topic of interest. One of the most common places is among video game forums. So sit back and enjoy!

How To: Multiply matrices with the MMULT function in MS Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Update inventory records by formula in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).

How To: Resize a custom image using Adobe Photoshop CS4

In this Software video tutorial you will learn how to resize a custom image using Adobe Photoshop CS4. Select your image. Click on ‘image’ tab and select ‘image size’ from the dropdown menu. In the ‘image size’ box you can change the height and width pixels. But, if you check the box ‘constrain proportions’, then when you change one pixel dimension, the other will automatically change. Similarly, for resizing drop shadows proportionately, check the ‘scale styles’ box. The ...

How To: Check your voicemail in Microsoft Outlook

In this how to video, you will learn how to check your voice mail in Microsoft Office Outlook. Your exchange administrator must enable unified messaging for these messages to appear. First, open the program to set up your voice mail options. Go to options and click the voice mail tab. Your phone number should appear in the correct form. Click call to check your voice mail. Enter your number and click x and okay. Now you are ready to listen to your voice mail messages on your computer. From Ou...

How To: Format decimals & fractions as inches 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 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a custom number format for inches that will allow you to type decimals or fractions and have it formatted as inches.

How To: Count values between a lower & upper bound 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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.

How To: Conditionally format dates & weekends 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY functions.

How To: Use high-quality video compression in iMovie HD

In this how-to video, you will learn how to compress iMovie files into QuickTime files to make them look really good on YouTube. First, open iMovie. Click Share and click Share again. Go to Expert Settings and click on Share. Click on Options and go to Settings. Change it to h264, current frames per second, and every. Restrict should be set at 5000. Optimize it for DVD and change encoding to best quality. Change the size to NTSC 720X486. Check de-interlace video and hit okay. Change the sound...

How To: Automatically Hide the Ribbon Menu System in Excel

Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specific workbook in which the macro is implemented. Some helpful shortcuts are Ctrl+F1 which partially hides the ribbon, Alt+F11, which opens the Visual Basic screen, and Alt+F8, which opens the macros list. First, hit Alt+F11 to open the Visual Basic screen. Then double-click "This Workbook" on the le...

How To: Calculate vacation days with TODAY, YEAR & IF in 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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.

How To: Create dynamic sub tables in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

How To: Reduce beard stubble in Photoshop

This video, produced by Photoshop Universe, teaches how to reduce beard stubble or 5 o'clock shadows from male pictures. We are shown how to use the dust and scratches filter, layer mask, as well as the advanced layer style command "blend if" on the underlying layer helps us to make this possible. The first step is to duplicate the layer and then select filter, noise, and dust and scratches. The second step is to apply some dust and scratches to the beard selection. Finally we blur the layer ...

How To: Protect PDFs with a password in Adobe Acrobat 9 Pro

In order to secure a PDF with a password when opened in Adobe Acrobat 9 Pro, press the secure button and go into password security settings. Here you can change on what versions of this software the file will run on, the next option asks which portion of the document is to be encrypted when a password is placed. Further below here is where you actually choose the password, this ensures that only people who know the password will be able to see the contents of the document. Below this is the d...

How To: Make boobs bigger in Photoshop

One of the most suggested topics on youtube for Photoshop is enhancing breast size. Sending an image to someone & need to alter it? Want your boobs to look bigger? Or do you just want to have some fun giving girls bigger boobs on Photoshop? This tutorial demonstrates how to increase breast size using Photoshop.

How To: Work with layers in Photoshop CS4

Adobe Photoshop CS4 is the industry-standard software for perfecting digital images and is ideal for professional photographers, serious amateur photographers, and graphic designers. In this Photoshop CS4 tutorial, you'll learn how to use CS4's new, streamlined layer management features. For (reasonably) comprehensive instructions on working with layers within Adobe Photoshop CS4, watch this how-to. Work with layers in Photoshop CS4.