Hot Software Posts
How To: Make a fancy border in GIMP
Learn how to make a fancy border in GIMP with this GIMP tricks video tutorial. This border can be used to frame images for YouTube videos or other things. Take your image, and go to Image and Canvas Size. The size should be made larger to allow room for your border and then click Center. On Layers, select All Layers. Then, click Resize. This allows you to make room for your Layer. On the far left side, right click on your layer and select Alpha to Selection. Go to Select, To Path, Select, and...
How To: Give someone a shave in GIMP
In this Software video you will see how to give someone a shave in GIMP. Learn spot removal, skin smoothening and a makeover or removing a 1 day beard. This is done using the Clone and the Healing tool. To use the Clone tool, select the tool from the right hand panel. Then to select the source skin color, you have to hold ctrl key down and click. Now when you apply it to the area you will get the same shade of the source color. So, you will need to select an area very close to the spot you ar...
How To: Create an interest-only loan schedule in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an interest-only loan schedule in Excel.
How To: Use the blur, smear & sharpen tools in SketchBook Pro
Learn how to use the blur, smear and sharpen tools in Autodesk SketchBook Pro 2010. Whether you're new to Autodesk's popular raster graphics editor or a seasoned graphic artist merely looking to better acquaint yourself with SketchBook Pro 2010, you're sure to be well served by this free video software lesson from the folks at Lynda. For more information, take a look.
How To: Hack MD5 passwords with Cain and Abel
Whatever your reasons for doing it, if you are trying to hack passwords, it helps to have the right software for getting the job done. With the Cain and Abel program, you will be well on your way to hacking even the toughest personal passwords.
How To: Use the Gradient Mesh Tool in Adobe Illustrator for Vector Portraits
Illustrator's gradient mesh tool is a powerful one for vector artists... if you know how to use it. This tool can help create beautiful and vivid mesh-based vector portraits, as long as your skills are up to par. If not, try out some of the beginner tutorials on WonderHowTo for using the mesh gradient tool in Adobe Illustrator, then move onto mastery...
How To: Embed a video in a slide in Microsoft PowerPoint Mac 2011
Want to know how to add a video to a slide in a PowerPoint for Mac 2011 document? This video will show you how it's done. Whether you're new to Microsoft's popular word digital slideshow application, new to MS PowerPoint 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For detailed, step-by-step instructions, watch the video.
How To: Round off date and time calculations in Microsoft Excel 2010
Learn how to round dates and times to a given interval in MS Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
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: Create custom charts with Microsoft Publisher
Learn how to better organize and convey your data to colleagues- create your own professional-looking charts in Microsoft Publisher.
How To: Conditionally format a bar chart 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 566th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF functions and a bar chart to create a conditionally formatted chart for students scores that exceed a given hurdle.
How To: Zoom and pan in Photoshop CS4
Using GPU processing, Photoshop CS4 does things like never before. Colin Smith shows you the new viewing options available in Photoshop CS4. Smoothly zoom, pan and move around your image with complete freedom. Discover how to use the Flick-Pan and pixel grid tools in Photoshop CS4 as well. If you think you know all there is to know about zoom and pan in Photoshop CS4, think again and watch this tutorial.
How To: Calculate monthly retirement income in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.
How To: Make Any Song Instrumental Using the Audacity Program
This will work for nearly any song. Upload your chosen piece (simpler pieces work better), and then follow along with the procedure so you can remove the entire vocal track and end up with a song that's purely and completely instrumental.
How To: Make a YouTube subscribe button in Photoshop
This video shows how to make a YouTube Subscribe button with Photoshop. First go to File>New, or ctrl + N. Make the size 960x150. Set the resolution to whatever you like. In this case we set it to 300. Go to the Rectangle Tool, and go to the Rounded Rectangle Tool. Make a Subscribe button that appears to be about the right size. For the background, use the color #fedd33. Now select the text tool. Make the font size 10, font Calibri Bold. Change the color to a dark brown (#703d00). In order to...
How To: Count words separated by commas 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 289th installment in their series of digital spreadsheet magic tricks, you'll learn how to count words separated by commas using the LEN & SUBSTITUTE functions in a formula.
How To: Use a 2D bitmap image as a background in Cinema 4D
In this C4D-user's guide, you'll learn how to apply a 2D bitmap file as a background in Cinema 4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
How To: Straighten your photos using Photoshop CS4
In this how-to video, you will learn how to straighten crooked photos in Photoshop. First, open the photo you want to straighten in Photoshop. Next, use the ruler tool under the eye dropper tool. Select it and zoom in to an area. Find a crooked line to straighten, such as a building rooftop or ground line of some sort. Click, hold, and drag. Next, zoom out. Go to image, image rotation, and arbitrary. Click okay and your image will be adjusted. Go to the crop tool and crop out the spaces. Hit ...
How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
How To: Get last price in an Excel column based on criteria
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
How To: Draw vector clouds in CorelDRAW X4
In this video, we learn how to draw vector clouds in CorelDraw X4. First, open the program and make a circle using "ctrl+shift". Make these circles touching and overlapping each other on the top of the page. After this, select all and then weld it. Next, press "ctrl+k" to break the curves apart, then erase the parts inside of the clouds. When this is done, select all, then copy and paste for additional clouds. Trim the bottom to make the clouds sit on a mountain or straight edge, then you are...
How To: Render video in 1080p HD with Camtasia Studio
This clip presents a general overview of how to render and export clips to 1080 progressive high-definition video within Camtasia Studio. It's easy! So easy, that this video tutorial can present a complete, step-by-step overview of the process in about four and a half minutes. For more information, including detailed, step-by-step instructions, watch this video guide.
How To: Randomly select an employee name from an Excel sheet
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 169th installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly select an employee from a list using the INDEX and RAND and INT functions (also RANDBETWEEN).
How To: Use the Auto-Align Layers command in Adobe Photoshop CS5
In this video tutorial, we learn how to use the Auto-Align Layers command in Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
How To: Base one drop down list on another in Microsoft Excel
Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
How To: Fix an overexposed sky in an image using Photoshop
Depending on lighting conditions, you may need to overexpose the background to get a good shot of your subject. See how you can use Photoshop to bring the overexposed backgrounds back to life. This trick will work if you took a photo of the object and the sky, or if you just have another image of a background you want to use.
How To: Render Wireframe in Maya Software Render
This is a very essential tutorial for Modelers to present their showreel. In this tutorial we are going to learn how to render a wire frame of a model. Wireframe render in Maya is bit tricky but easy also, just you have to know right button to press. This tutorial will cover the output in Autodesk Maya Software renderer. Later we will discuss through Mental Ray render engine. Hope you will enjoy.
How To: Tell if you are logged in as an Admin or User in Windows 7
Admin accounts are given special privileges to change the system (like installing programs) that user accounts are not. This tutorial shows you a quick way to check using Windows 7's calendar, and also how to go through the Control Panel to find out if you're an Admin or general User on your computer.
How To: Do a grass silhouette effect in GIMP
In this video, we learn how to do a grass silhouette effect in GIMP. First, draw a black mound and then close off your selection. After this, turn the path into a selection and fill it in with a black color. Next, select your smudge tool and use a small circle brush. Set the rate up to 95, depending on the length of grass you want. Now, use your mouse to push up on the mound and you will see wispy pieces of grass form where you are moving your mouse. Cross them over and cover as much of the a...
How To: Calculate a trimmed mean 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 36th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate a trimmed mean, which is used when there are extreme values in the data set that might skew the mean.
How To: Use Excel's AVERAGE functions with zeroes and blanks
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 92nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how the AVERAGE function sees zeroes and uses them in calculating an average but does not see blanks.
How To: Rip music from MySpace using Audacity audio program
MySpace is an excellent resource for up and coming musicians. If you just can't do without that hot new jam, then it's time to rip your favorite song using Audacity media player. This video tutorial demonstrates the process of ripping MySpace songs in a few easy to follow steps:
How To: Use calculated queries in Microsoft Office Access 2007
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 using calculated field to work out the tax payable on an item, then adjusting item value. For more, and to get started using calculated queries yourself, watch this MS Access how-to.
How To: Draw shapes in Google SketchUp
New to Google SketchUp? Take a look at this instructional video and learn how to draw shapes in Google Sketchup. There are four fundamental rules to drawing edges.
How To: Convert a Word doc to a form template on InfoPath
Many businesses rely on standardized forms for gathering information, and often those forms are created in Microsoft Office Word. But Word isn't really intended for creating, maintaining, and filling out forms — that's what Microsoft Office InfoPath is for! Take a look at this instructional video and learn how to convert a Word coument to a form template.
How To: Remove shadows from photos in Adobe Photoshop
Sometimes shadows might be a nuisance to your photos, causing unwarranted distraction to them. In this video tutorial you will learn to remove a shadow from a photo using Adobe Photoshop. Learn to use the lasso tool and sample tools to do the job. Remove shadows from photos in Adobe Photoshop.
How To: See Through Clothes with Gimp 2.6
If you can't seem to find any photos of naked people on the internet, don't fret, this how to will show you how to "see through" clothing using some simple techniques with Gimp 2.6 photo editor. Gimp is like Adobe Photoshop without the heavy price tag. Tight, white clothing works best for this trick, so keep that in mind. Watch the video and get one step closer to seeing someone naked. Right on your own computer! See through clothes with Gimp 2.6.
How To: Change a person's sex in an image editing program
Want to change someone's sex in Adobe Photoshop—making a boy look like a girl or a girl a boy? This clip will get you started. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
How To: Turn a male voice to female voice with Audacity
If you're a user of digital editing software Audacity, you already know you can do a ton of cool things. One of the cooler things you can do is changing a guy's voice to sound like a woman's. This is done with pitch control, or autotune, and will like you modify the voice by a number of octaves. I this video, rock band 30 seconds to Mars is made to sound like Avril Lavigne. Check it out! Of course, this can also be done with your own voice too!
How To: Get auto tune (t-pain effect) in Audacity using gsnap
In this video tutorial, learn how to get auto tune, or the t-pain vocal effect, in Audacity using gsnap. To get the GSNAP (GSnap/Grymmjack skin), go here.