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: Use D functions (DSUM, DAVERAGE, DMAX) in MS Excel
video tutorial from ExcelIsFun, the 64th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to Excel's D (i.e., database) functions such as DSUM, DAVERAGE, and DMAX.
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: Create an Excel spreadsheet to calculate your GPA
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
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: Use 3D Stroke in Adobe After Effects
After Effects is one of the best digital motion graphics software programs out there. Learn it. Now.
How To: Remove Vocals from a Song Using GarageBand
Do you think that Avril Lavigne has nothing on you when it comes to belting it out on the mic? Then you probably prefer karaoke versions of songs to the real ones so you can hone your vocal chops to your favorite tunes.
How To: Replicate the effect on the album cover for Drake'sThank Me Later
A fan of Drake's music, Thank Me Later or just like the way the album art was done? This tutorial shows you how to go step by step to create the same kind of effect using the free photo editing software GIMP.
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: Use sprites or animated .GIFs to recreate an old video game
Code a retro style video game using old school sprites or other animated .gifs. This tutorial shows you how you can take a small character and animate him to walk across the screen. Make your own homage to Mario or a nostalgia-fueled video game or animation!
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: Make abstract waves in After Effects with the Trapcode Form plug-in
Creating an abstract wave effect in After Effects will allow you to make graphics like those in the thumbnail, basically clouds of particles with that smokey / silky effect like they used in James Bond titles. This video will show you how to make this effect yourself in After Effects in two parts. Apply this technique to your titles and they should be much, much sexier.
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.
News: Hubba, Hubba. I Like My Ladies X-Rayed
The Eizo medical supply company has issued a 2010 calendar of X-ray pin-ups. First prize to the person who can bring these skeletons to life. We know it's possible to transform a person into an X-ray in Photoshop, but how about the reverse?
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: Rendering shadows using Vray render elements in 3d Max
Render shadows only in 3D Studio Max using vray. Once the tutorial is over you will also learn how to use the other options in the render elements, which uses similar methods. Skyrill Design brings us this tutorial
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.
How To: Transform chords into melodies in FL Studio
If you have a particular talent with melodies or chords but not both, this video shows two methods for crossing over to the other side when working in FL Studio! Learn how to create melodies from chords and chords from melodies to suit your creative needs in this FL Studio tutorial.
How To: Make a simple but effective bassline in FL Studio
Making an effective bassline is probably easier than you think. Check out this tutorial and see how easy it is to make a simple and good bassline for your music in Fruity Loops (FL Studio).
How To: Use Edison to chop samples in FL Studio 7
Edison is the new FL Studio 7 wave editor and it is light years beyond the old editor. In this tutorial NFX does some basic chopping and slice markers in Fruity Loops.
How To: Control video playback in Flash
This tutorial explains the different options for controlling video playback you can use in Flash 8. Control video playback in Flash.
How To: Add special effects to a video using iMovie
Adding special effects to your video can make it look more professional and entertaining. Learn how to add Apple iMovie effects to your clips with ease.