Hot Software Posts


How To: Model a full cartoon character in Blender 3D
Writer, Director and Producer Johnathan Williamson shows you how to model a simple cartoon character in Blender 3D from start to finish. This is just a simple character but demonstrates the principles of character modeling in Blender 3D. Once you know these basics you can move on to your own complex creations. It will help if you know your way around the Blender 3D interface.

How To: Create a stem & leaf chart with Excel's REPT & COUNTIF
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 28th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data stem & leaf charts using the REPT and COUNTIF functions.

How To: Animate a bouncing ball in Maya
The bouncing ball animation is a classic beginning point for animating in every 3D software package. This tutorial shows you how to do it in Maya. Part two will concentrate on keyframes. Part three will turn the bouncing ball into a character set. Part four will cover using the Trax editor when animating.

How To: Conditionally format odd & even numbers 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 370th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to even and odd numbers using a TRUE/FALSE formula with the MOD function.

How To: Calculate excess over a hurdle in Microsoft 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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!

How To: Generate a dynamic list from a table in MS 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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...

How To: Create an offset stroke around a subject in Photoshop
Dave demonstrates how to create an offset stroke around your subject by defining a pattern, making a quick selection, and using the minimum filter to expand the area around the subject. Create an offset stroke around a subject in Photoshop.

How To: Use GIMP to add a fake lip piercing to a photo
GIMP is the free alternative to Photoshop, and many of the things that you can do in Photoshop, you can also do in this open source software. Want to see how you'd look with a lip piercing, or want to touch up a photo and add one where there isn't? This tutorial shows you how to add a fake lip piercing to nearly any photo. It's not that difficult - as long as you're familiar with the basics of GIMP, you'll be able to make this work for you!

How To: Animate a swinging chain in the Blender 3D modeling software
This tutorial can work for anything you want to make swing, but it focuses on how you can make a chain swing back and forth when using the Blender 3D animation software. It also explains some of the artist concepts behind the process of animation.

How To: Get rid of edge seams in Adobe After Effects
Interested in getting rid of edge seams within Adobe After Effects? This video guide will show you how it's done. Whether you're new to Adobe's popular compositing editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.

How To: Use an OFFSET as a dynamic range in an Excel VLOOKUP
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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.

How To: Create a glass bar in Photoshop
This video will show you have to make a glass bar in Photoshop. Adobe Photoshop is a great program for manipulating photo and adding interesting effects to your pictures. The glass bar is distinctive because of it’s colored shading.

How To: Use Aperture and iPhoto together
Aperture 2 and iPhoto '08 are designed to work together so you can bring your iPhoto images into your Aperture library to work on them. Conversely, you can use images from your Aperture library to create iPhoto cards, calendars, and projects.

How To: Add a guestbook feature to your website using Flash
Allow visitors to your website to leave comments and feedback on your website with Flash and Action Script 3. This tutorial walks you through the process, also using PHP and MySQL, to create your guestbook and then add it to your website.

How To: Speed up Firefox with "Tweak Network" add-on
Firefox is one of the most customizable web browsers available. In this browser, you are able to install multiple add-ons and toolbars, all of which do something different for the performance level of your program.

How To: Reverse first & last names by formula 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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.

How To: Simulate a photo tear in Photoshop
In this video we learn how to make it seem like your photo is torn in half using Adobe Photoshop. The first step is to decide how you would like to have your photo "torn" up. The second step is to select the lasso tool and draw the tear line through the photo. The third step is to select the rest of the image you want to keep. The fourth step is to go into Quick Mask mode and select Filter, Brush Strokes, then Splatter. This creates the jagged edge torn effect. Finally select a smoothness bet...

How To: Transform a photo into a puzzle in Photoshop
This video from photoshopuniverse shows us how to make your picture look like it's a puzzle by using Photoshop! First you want to open up the layers palette and duplicate the layer. Now add a new layer and bring it down to the middle and fill it in with black. Now to get the puzzle into place, go to Filter---Show Menu Items---Texture---Texturizer. Click the arrow to load texture. Load in puzzle texture. Now you can set the scaling to however many puzzle pieces you want. He put it at 75% and t...

How To: Create a glossy sphere in Photoshop
In this Photoshop tutorial the instructor shows how to create a glossy sphere. Now to get started open the tool and select the oval tool. Using the oval tool create a sphere shape. Draw holding the shift key button and set it to green color. Now similarly draw ellipse and give it white color. Create a few more ellipses this way. Now go to filers and then glowers and then Gaussian glower. Now go to shape free and select gradient and set the gradient. Now you can apply color changes to it and g...

How To: Create a RG warp reflection with Adobe After Effects
In this video tutorial, Creative Cow Contributing Editor Eran Stern will demonstrate building a reflection using After Effects built-in filters. He will also explore the RG Reflection plug-in.

How To: Rewire Reason 3.0 with Sonar 6
Learn how to Rewire Reason 3.0 with Sonar 6. Part 1 of 3 - How to Rewire Reason 3.0 with Sonar 6.

How To: Use photoshop to miniaturize a photo
Turn something BIG, small! miniaturize it! Using photoshop, make a photo seem as though it is a miniature scale model.

How To: Miniaturize things in Photoshop
Turn something BIG, small! This video goes over how you can use Photoshop to minaturize things.

How To: Create a microscopic view effect using Photoshop
Using the blend modes in the brush tool, you will learn how to make an image that looks like you're looking through a microscope. We're not sure what you can do with this, but it's still pretty cool. Create a microscopic view effect using Photoshop.

How To: Use x-ray techniques in Photoshop to show naked skin through clothing (NSFW)
Do those new naked body scanners have you freaked out at the airports? As far as the TSA is concerned, those x-ray machines are here to stay, but you might as well take comfort in knowing that airport security guards aren't the only ones looking at your private parts. Practically anyone with a computer can manage to see through your clothes, and it's all thanks to a little program called Photoshop. Thanks, Adobe.

How To: Flip a Clip in Final Cut Pro X 10.1.2
This is a great how to for all users in Final Cut Pro X 10.1.2 Video: .

How To: Create a percentage frequency table in Microsoft Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 4th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a frequency table and percentage frequency table using a Pivot Table (PivotTable).

How To: Resize images and video in Sony Vegas
In this video tutorial, viewers learn how to re-size an image or video in Sony Vegas. Begin by opening the image or video that you want to re-size in Sony Vegas and drag it into the time line. Then click on Event/Pan Crop on the right side of the clip in the time line. Now re-size/rotate the video/image by dragging in and out. Finish by simply closing the window. This video will benefit those viewers who create videos using Sony Vegas and would like to learn how to make their video image smal...

How To: Remove Vocals from a Song in Ableton Live
In this how-to video, you will learn how to remove the vocals on songs using Ableton. First, open the tracks you want to remove the vocals from. Go to utility and select the preset difference. Drag it to the audio track. This will remove vocals.

How To: Make a moving curtain animation within After Effects
Check out this tutorial of how to create moving curtains in After Effects. You create a set of curtains that opens up to reveal footage placed behind it. You can render the clip out with an alpha channel and always have a curtains clip ready to reveal some footage. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well ...

How To: Create a multiuser login system in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a multi-user login form to password protect different areas of your database.

How To: Conditionally format at every change in value in 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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.

How To: Resize an image in MS Paint without losing resolution
In this video, we learn how to resize an image in MS Paint without losing resolution. First, you will go to the file menu and then open. From here, open up the photo you want to resize. After this, go the 'image' section on the toolbar and then click 'stretch and skew'. From here, change the vertical and horizontal stretches until you have the size of picture that you want! Continue to play with it until it's right and then save this over again. This should only take a few minutes and will ke...

How To: Make a freeze frame in Sony Vegas
How to Make Anything demonstrates how to make a freeze frame in Sony Vegas. You can go to the preview window and click on save snapshot to file. The program will then create a jpeg which you can lay into your video to create a freeze frame. You can also use Vegas' velocity envelopes to create a freeze frame. First, zoom into your video in the timeline so that you see each individual frame. Make sure that quantize to frames is toggled in the options menu. Then, hit S to split the video. Right ...

How To: Extract part of a table from a larger table 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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Reverse video and audio in Sony Vegas
In this video tutorial, viewers learn how to reverse video direction in Sony Vegas Movie Studio. This task is very easy, fast and simple to do. Begin by importing the video clip(s) and/or audio into the time line. Then right-click on the clip and select Reverse. To reverse the audio, right-click on the track and select Reverse. To undo the video or track, right-click it and select Reverse once again. This video will benefit those viewers who enjoy editing and creating videos, and would like t...

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: Remove spaces from numbers in Excel with the SUBSTITUTE 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 715th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a number with spaces, remove spaces and convert text to number using the SUBSTITUE function and plus zero.

How To: Capture video in Adobe Premiere
Don Schechter explains how to capture your footage from your camera to your computer and log it for easy access later on. You can use Adobe Premiere to capture your movie, but you can not forget to put your tape in your camera.

How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
You know that moment when you finally figure out something, but you figured it out years after you really needed it? Don't you freaking hate that?!