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