Hot Software How-Tos

How To: Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.

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: Change the tempo in GarageBand (speed up or slow down songs)

Anyone with a Mac knows the power of GarageBand, but not all iLife users know the ways to slow or speed up their songs in GarageBand. This video will show you exactly how to change the tempo of your song creations, which is actually a really simple thing to do.

How To: Draw eyes in MS Paint

In this tutorial, we learn how to draw eyes in MS Paint. Start out by drawing the outline for the eye using a thin marker. After this, draw on a thicker line at the top of the eye and then draw on the crease of the eye above this. Now, draw in the details of the middle of the eye and start to shade in around the crease of the eye and the middle of the eye. From here, draw in the eyelashes on the top and the bottom of the eye, making them longer if they are for a woman. When finished, save thi...

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: Get the CD Product Key or Serial Off of Any CD

This will allow you to find the CD product key or serial if you have lost it so you dont have to buy another CD.

How To: Create a 3D extruded world map in MAXON Cinema 4D

This tutorial presents a lesson on how to create a 3D extruded world in MAXON C4D. 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: Clean up a scanned drawing with the GIMP image editor

In this how to video, you will learn how to clean up scanned drawings using Gimp. You will need a scanner, drawing, and Gimp installed to do this. First, open the scanned drawing in Gimp. Next, select Select by Color. Click on an area that should be white and hit ctrl + x. Next, go to filters and select soft glow under the artistic sub menu. Play around with the settings to lighten the image and darken the important lines. Click okay once you are finished. Next, go to the artistic sub menu an...

How To: Convert a Photo into a Line Art Drawing in Photoshop

If you're not much of a drawer, you can still get the look of a detailed drawing simply by taking a picture and using Photoshop's tools and filters to transform it into something that looks drawn by hand.

How To: Reduce the Level of the Vocals in a Song with Audacity

In this video tutorial, viewers learn how to remove the vocals from a song using the program, Audacity. Begin by opening Audacity and import the song into the program. On the left side of the track, click on the downward arrow and select Split Stereo Track.

How To: Use KDE konsole bookmarks

In this tutorial, we learn how to use KDE konsole bookmarks. You can add a bookmark, then go to the home directory and then you will be able to go back to where you previously were. To do this, save the bookmark of the entry that you are in. Do this by clicking the bookmark tab, then add bookmark. After this, go back to the home entry and then click on your bookmarks tab again. Once you click this, you will see your new bookmark on the bottom, when you click that it will bring you back to you...

How To: Save Your Word Document as PDF with One Click (Using a Macro)

In this article, we're going to create an additional button in our Word toolbar which creates a PDF file of our loaded file with one simple click. We are going to use the function to create Macros, which are little 'programs' in

How To: Create a bond discount or premium amortization table in 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 52nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create a bond discount or premium amortization table.

How To: Edit videos in Audacity

Audacity is a great (free) audio editor for recording, slicing, and mixing audio. Learn how to use this software with this detailed step-by-step guide on how to edit videos in Audacity. Be sure to check out other Audacity tutorials on WonderHowTo to find the answers to all your questions!

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: Create a dynamic weekly chart 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.

How To: Remove Vocals from Songs Using Audacity

Need to remove the vocals from a song? Audacity just might be the answer. It's one of the few free audio editing programs out there with many, many features, making it simple to create a track for karaoke or simply to listen to an instrumental version.

How To: Use Magic Bullet Looks for color correction in After Effects

This is your video guide to the Magic Bullet Looks plugin in for Adobe After Effects. If you are looking for a color correction tool, check out this video to see what Magic Bullet Looks has to offer. Learn how to use this color correction tool.

How To: Make someone look fat with Photoshop

Well, usually people are looking to go from fat to thin, but sometimes it's fun to see what a person would look like if they were on a full Twinkie diet. Well, this tutorial shows how to use the liquify tool in Adobe Photoshop to add weight to someone to make them look pudgey, overyweight, fat or even downright obese. The tool is easy to use and the video shows clearly how to turn that beach babe into a Jenny Craig "before" photo! Check it out and YOU can make people look fat in photos.

How To: Calculate bonuses based on years worked 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.

How To: Create handwriting in After Effects

In this Adobe After Effects tutorial, the instructor shows how to generate a hand writing effect. First, open Adobe After Effects. To do this effect, you need to use the Pen tool, which is a very good feature. Go to File menu, select new then create a new project. Go to composition and select a new composition. Right click and fit it to 100%. Go to the text tool and select a box on the composition and write something that you want. Apply a desired color and font to it. Select the text box, go...

How To: Open, close & save documents in MS Word 2007

In this beginners video, the instructor shows how to use Word 2007 by opening, closing, and saving documents. When you open the Microsoft Word software with out any documents, the window looks gray indicating the same. There is an office button present in the top left corner of the window through which you can access various options. Click on it, and select the open button which brings up the open dialog box. Now, you can browse through your computer and select any Word document to be opened....

How To: Build a 15-minute schedule in Microsoft Excel

Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.

How To: Create an array from a rasterized object in Photoshop

This image editing software tutorial shows you how to create an array from a rasterized object in Photoshop CS3. An array (in design terms, not programming terms) is an object that duplicates itself around a pivot point. So learn how to work with arrays to create designs in this Photoshop video.

How To: Smooth skin in Photoshop CS3

Think every model you see in a magazine has perfectly smooth skin? Sure, but don't worry, it's not natural! You can do the exact same thing in Photoshop with this tutorial. Watch and learn how to smooth skin by retouching portraits with blur tools in Photoshop CS3.

How To: Apply a Minus One Effect to Audio Tracks and Songs Using Audacity

Edit your audio using the invert effect in Audacity. Once you follow this tutorial on applying a minus one to your track, you'll be good to go! You can download Audacity for free by going to this website. Enjoy!

How To: Change the color of the background grid on FL Studio

If you are tired of looking at the same old background when using Fruity Loops, go ahead and make a change! This video will show you how you can change the background color on FL studio. Personalize your FL studio!

How To: Draw Sonic the Hedgehog using the tools in Adobe Illustrator 5

By following along with these tutorials, you can learn not only how to draw the popular Nintendo character Sonic the Hedgehog, you will also be able to master many of the basic and intermediate drawing tools available in Adobe Illustrator 5.

How To: Remove (detach) audio from video in iMovie

If you've imported some video footage into iMovie, but want to use the sound elsewhere, like in GarageBand, you're going to have to detach the audio from the video. This tutorial will show you how to remove the audio from an video clip in iMovie in Mac OS X. Detaching audio is very simple, so don't worry!

How To: Draw Sonic the Hedgehog in Photoshop

In this video, we learn how to draw Sonic the Hedgehog in Photoshop. First, draw a circle on the page and then draw the eyes onto him. After this, draw on his ears and then his hair around his head. After this, draw in the rest of his body and his feet. From here, use a darker paint brush to create the final outline of the character. Draw in the lines around Sonic to make him appear more realistic. Then, color him a dark blue color with red on his shoes. When finished, save this drawing and y...

How To: Store clips and projects on an external drive when using iMovie

Interested in keeping your iMovie projects on an external USB or FireWire hard drive? It's easy! So easy, in fact, that this home-computing how-to can present a fairly talky overview of the process in over five minutes. For more information, including detailed, step-by-step instructions, take a look!

How To: Remove audio, record voice over, unlock audio in Vegas

In this tutorial, we learn how to remove audio, record voice over, unlock audio in Vegas. First, load a video clip to the time line. Then, remove the audio by right clicking on the track and going to "group" and "remove from" Once you remove it, you can delete it and then add in new audio or a voice over. Just import media if you have an audio track you want to add into the time line. Drag and place it, just make sure it's not muted and play it. You can also record a voice over for the time l...

How To: Create a toggle button using Action Script 3 for your website

A toggle button can let visitors to your website hide or reveal content (such as a product description or explanation attached to an image). This tutorial shows you how to make your own content toggle buttons for your Flash-based website.

How To: Create A Nice Curtain In GIMP

Hello everyone, This is my first tutorial posted on WonderHowTo and as a starter I wanted to show you how to make a nice curtain in GIMP, the free Photoshop alternative. Even though GIMP does not have all the features of his expensive brother, you can still do some cool designs or photo manipulation.

How To: Warp Time with the Flex Time Tool in Logic Pro 9

Learn how to use the Flex Time tool to alter the speed and timing of your tracks without altering their pitch or introducing nasty artifacts. This clip presents an overview of how to use it. Whether you're new to computer recording, new to the Apple Logic DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this free video software tutorial.

How To: Do video overlay in Sony Vegas Movie Studio

You can overlay your videos in Sony Vegas Movie Studio. First drag the picture of TV set in the timeline and drag it to the whole timeline and then place your video above it as showing in the video. Now click on the pan/crop icon and select the picture of TV set. Now resize your window and set your video in the TV set as showing in the video. Now you can play your video but it pops up as the video plays so to fade in your video, you just need to do is to drag the corner of your video as showi...

How To: Change object colors via ActionScript in Flash 8

Change object colors via ActionScript in Flash 8

How To: Find 5 largest values with Excel's AGGREGATE 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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the five largest values for each a data set using the new AGGREGATE function.

How To: Show file names in the Sony Vegas timeline

Use this simple tip to automatically show file names of all elements in your project's timeline. 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: Reset and purge in Adobe Photoshop CS4 or CS5

Deke gets things started with a pair of options that can clean out Photoshops plumbing when things get clogged up: Reset and purge. 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.