Hot Software Posts

How To: Retrieve the name of a lowest-bidding vendor 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 283rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, MATCH and MIN functions to retrieve vendors name when they have made the low bid.

How To: Bass Boost Songs with Audacity

Here's a short and to the point tutorial teaching how to Bass Boost your songs with Audacity. To download Audacity for FREE you can go to the official Audacity website. You may want to Bass Boost your songs for many reasons, so here's a tutorial on how to do just that with the popular, Free, and easy to use software called Audacity.

How To: Create a simple typewriter effect in Sony Vegas Pro

In this quick Vegas-user's guide, you'll learn how to create a typewriter effect. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a lens flare in Illustrator

Ever wondered about the flare hitting your eyes from reflective surfaces (vehicle mirrors)? Let's create one. Open Adobe Illustrator with an image and embed it. Take the flare tool from tool palette. Draw the first shape and then second shape. To change settings, go to flare options. You can change the brightness, opacity and diameter of the flare which will add life to the image(open sky). This will help bring out some cool effects as well as realism to the image.

How To: Edit and split clips in Sony Vegas

Sony Vegas is a cool new video editing program. In this tutorial, you will learn some simple editing techniques in Sony Vegas. You will learn to detach the sound from your movie clip, as well as how to split your movie to remove any unwanted footage. You will learn how to merge both clips and use the fade in and fade out tool to create a smooth transition.

How To: Use Style Builder in Google SketchUp

Style Builder is a companion application to Google SketchUp 6 Pro that allows you to create, mix, and modify your own unique style that you can use and share in SketchUp. Take a look at this instructional video and learn how to use this new software. This tutorial covers loading and mixing strokes, creating custom strokes, and how to finish the style in Google SketchUp.

How To: Create a 3D model of a Porsche 911 GT3 RS in Blender 2.5

This nine-part series presents an exhaustive overview of how to create a realistic 3D model of a Porsche 911 GT3 RS in Blender 2.5. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look. Create a 3D model of a Porsche 911 GT3 RS in Blender 2.5 - Part 1...

How To: Import images with transparency into After Effects

In this software tutorial you will learn how to manipulate images in Photoshop to remove the background and then bring that transparent background image into After Effects without loosing the transparency. The Photoshop section covers the use of the Magnetic Lasso tool and Quick Mask to remove a background. With the image adjusted, you will learn how to import your new image into After Effects with preserved transparency.

How To: Password protect queries 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 how to force a password to be entered in order to run a query.

How To: Add yearly totals from monthly data 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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.

How To: Rip a copy-protected DVD with Handbrake

The procedure involves downloading a program called "hand brake". Hand brake is free to download. You can find it by searching for "hand brake" on Google. The direct website is Handbrake. You have to install this program on your computer. You must also download a program called DVD43. That program can be found the same way as hand brake, by using Google. DVD43 is also a free program to download. You use the DVD43 program to by pass copy protection on a DVD. You can use hand brake to change th...

How To: Speed up Excel calculations with helper columns

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to count unique records with a formula with a helper column to speed up calculations.

How To: Split tracks in FL Studio

NFX shows how to split tracks into WAV files using FL Studio. You would do this to send your song to a professional mixing engineer or maybe to collaborate with a non-FL user. Split tracks can be used in Protools, Audition, etc., but are demonstrated here in Fruity Loops.

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: Create simple animation loops in Adobe Flash Professional CS5

Has looping got you thrown for a loop? See how it's done with this clip. Whether you're new to Adobe's popular Flash-development platform or a seasoned web developer 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, and to get started making your own Flash-based twinkling starscapes, watch this video guide.

How To: Create a list of hyperlinks 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.

How To: Use SUMIFS and COUNTIFS in Microsoft Excel 2007

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn about the SUMIFS function and how it blows SUMPRODUCT away when it comes to calculation speed.

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: Generate random numbers (with decimals) in Excel

This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...

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: Make your own passport size photo

This video instructs the watcher on how to create a passport-sized photo in Photoshop. First, open Photoshop and choose the image that you want using the "Browse" option. Then go to "image", from there "select image size" and select the image size you want (e.g. 35 mm by 43 mm). Next, under "File", go to "select new" and select the size of the paper you use in your printer. Select image and move it to the new file. Copy it as many times as you want in that file. Save, then print. Watch this v...

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: Calculate Commission Based on Varying Rates 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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

How To: Display trend arrows in a Microsoft Excel spreadsheet

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 and Mr. Excel, the 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.

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: Change the pitch & formant of your voice with Audacity

Want to disguise your voice? With Audacity, it's a simple process. And this clip will show you precisely what to do. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.

How To: Calculate incentive rates by formula in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business 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 39th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate (piecework/comission) incentive rates by Excel formula.