Hot Software Posts
How To: Arrange email messages by date or sender in Microsoft Outlook 2007
Sort your emails by either date or sender within MS Outlook 2007. This clip will teach you how. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
How To: Unclothe people in Photoshop
Have you ever wanted to prank your friends by showing pictures of them naked? By learning these easy graphics editing techniques in Photoshop, you can quickly make people shirtless or nude in fake photos.
How To: Disable quick fill handle & drag-drop Excel features
In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...
How To: Calculate probability in an Excel pivot table
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 55th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate probabilities with a pivot table (PivotTable). Specifically, you'll learn how to find joint, marginal and conditional probabilities.
How To: Layer video clips in Final Cut Pro
In this how to video, you will learn how to layer videos in Final Cut Pro. First, open Final Cut Pro. Get your original clip and then put the clip that you want in the clip and drag it in over the top in the time line. Change it to image and wire frame. Grab the corner of the image and drag it down to the size you want. You can also move it around. Next, go to sequence and render it. Once that is done, change the selection back to image. Once you play the file, both clips will be playing. If ...
How To: Create collapsible and expandable cell ranges in Excel
This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
How To: Round to the nearest 1/10th of an hour 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 379th installment in their series of digital spreadsheet magic tricks, you'll learn how to round hours worked to the 1/10th of an hour using ROUND and MROUND functions.
How To: Find the average time between orders in an Excel sheet
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 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.
How To: Save a file in Microsoft Word .docx and .doc format
In this video tutorial, viewers learn how to save in .doc file format in Microsoft Word 2007. When saving a file, click on File and select Save As. In Format, change it to Word 97-2004 Document(.doc) and check Append file extension. To set .doc as the default format, go to Word and select Preferences. Under Output and Sharing, click on Save and change the format to .doc in Save word file as. This video will benefit those viewers who want to learn how to save files in .doc format so that it ca...
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: Use the x-ray effect on GIMP
In this little video tutorial, kaje01 demonstrates both the basic edit and advanced techniques for applying the "x-ray" effect using GIMP. Now, what is there to x-ray? Hmm...
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: Change the color of an object in After Effects
This video shows you how to change the color of an object in After Effects.
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: 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 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: Make your own music mixes on your computer for free
There are many music programs beyond Audacity which you can download for free, and which will allow you to mix and edit your own music. This tutorial shows you where to get these programs, like ROC, Myna, FreeSound and FlashKit, and how to use them for your own projects.
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: Rotate & revolve cameras in Maya
In this tutorial, we learn how to rotate and revolve cameras in Maya. First, go to create primitives on the menu at the top. Next, create a camera and pull it out onto the circle. Now, click the camera and then the circle, then hit the 'p' key on the keyboard. Now, you can rotate your circle around and it will rotate on the y axis. To set this, click on 50, then type in 360 on the 'y axis' space. After this, hit 's' an you will have a key frame. You can change the settings as you prefer, then...
How To: Use the ProType Titler tool in Sony Vegas Pro
This tutorial explains some of the ins and outs of using the ProType Titler in Sony Vegas. 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: Transition between tracks in Apple GarageBand
Looking for a guide on how to transition or fade between two different tracks or audio regions within Apple GarageBand? This clip will show you precisely how it's done. Fortunately, it's quite easy. So easy, in fact, that this free video software tutorial can present a complete walkthrough in just over three minutes. For details, and to get strated creating your own smooth transitions in GarageBand, take a look.
How To: Extract an object from its background in Photoshop
Want to separate a foreground object from its background? Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from Connor Tuts. For more information, including step-by-step instructions on how to get started extracting elements from pictures in Photoshop yourself, watch this graphic designer's guide.
How To: Create digital drapes in Adobe Photoshop
In the mood for a little digital decadence? Learn how to create virtual drapes using Adobe Photoshop. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to generate fabric-like textures in Photoshop.
How To: Copy & paste a list of all names in an Excel workbook
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12.66th installment in his series of Excel name tricks, you'll learn how to paste a list of all names in the workbook, both the name and the formula that defines the name.
How To: Work with nominal, ordinal & interval scale in 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 10th installment in his "Excel Statistics" series of free video lessons, you'll learn how about data sets and the nominal, ordinal, interval and ration scales/levels of measurement and see two Pivot Tables that...
How To: Count whole and half workdays 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 535th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKDAYS, NETWORKDAYS.INTL, WEEKDAY, ROW, INDIRECT and SUMPRODUCT functions to count weekdays including half (1/2) workdays.
How To: Randomly select names without repeats 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 302nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX & MRAND functions to randomly select names without repeats.
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: Automatically Hide the Ribbon Menu System in Excel
Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specific workbook in which the macro is implemented. Some helpful shortcuts are Ctrl+F1 which partially hides the ribbon, Alt+F11, which opens the Visual Basic screen, and Alt+F8, which opens the macros list. First, hit Alt+F11 to open the Visual Basic screen. Then double-click "This Workbook" on the le...
How To: Create a paper scroll in Photoshop
In this video tutorial by Tasktutorial, learn how to make a paper scroll in Photoahop. Select the rounded rectangle tool and draw a shape similar to the shape shown. Open layer options. Go to gradient. Select the indicated gradient and delete the marker shown. Adjust the other markers as indicated and use the control+g shortcut to duplicate the layer. Position the shape as shown and using the pen tool draw the paper outline by clicking and holding to obtain the required shape. move the paper ...
How To: Get auto-tune (T-Pain effect) in Audacity on a PC
In this video tutorial, learn how to get auto-tune into Audacity. This video shows you how to receive a ten day free trial. The success rate of this video is questionable, so if you have trouble: Go into edit/preferences/effects, and make sure all three VST settings are checked. Also make sure that "rescan" is checked. Restart Audacity, and it should work. This video is demonstrated on a PC, and should work for Vista users.
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: Create a pseudo 3D image from a photo in Inkscape
In this software tutorial you will learn how to turn a regular photo into a 3D looking image or make the photo pop out in a pseudo-3-dimensional way using Inkscape. This is a clever way to use Inkscape to play with photos and could be used for graphic design or scrapebooking type applications.
How To: Create a face where you want it in SketchUp
Sometimes SketchUp won't create a face where you want it. This troubleshooting video that accompanies Chapter 16 of the book "Google SketchUp for Dummies" will help you solve the problem and get on with your modeling!
How To: Score a Full Version of Microsoft Office for Only $10
When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, and dinner. Something that I wish I would've known about during college is Microsoft's HUP (Home Use Program). With HUP, any employee or student of an organization that has a Microsoft volume license is eligible to purc...
How To: Convert CSO files to ISO very easily
This video will show you exactly how to use PSP ISO compressor to convert CSO image files to ISO image files so that they will play better on a PSP. This will allow you to download either ISO or CSO files and still run the ISO files on your PSP.
How To: Isolate one color with Adobe Photoshop
This how to will teach you how to single out one color with Adobe's Photoshop CS5. This technique will work with other versions of PS as well. With this trick, you'll be able to create some fantastic effects, make colors pop, or simply highlight something you want to show off. It's not hard to do, and a useful things to know if you're planning on putting your Photoshop skills to use in a professional manner. Now you can remove all but one color in Photoshop.
How To: Make your photos look like they were taken with a great camera
If you take a lot of photos with your smartphone or cheap digital camera, you can see the difference compared to results from a pro camera. So, if you want to get a professional camera look without dropping the money, check out this video to learn how to enhance your pics. This trick works with Photoshop, or any photo editing software that has a selection tool, a gradient tool and a gaussian blur filter.
How To: Install a streamlined version of Apple iTunes on a Microsoft Windows PC
Want to install Apple iTunes 10 on your Microsoft Windows desktop or laptop PC without installing all of the attendant bloatware? Let this clip be your guide. For complete instructions, and a complete demonstration of how to make a lean install of iTunes, take a look.
How To: Add or remove colons from a list of times in Microsoft 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 721st installment in their series of digital spreadsheet magic tricks, you'll learn how to to go from a time of 0655 to 06:55 AM with the TEXT function.