Hot Software Posts

How To: Rearrange parts of a text string 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 190th installment in their series of digital spreadsheet magic tricks, you'll learn how to rearrange three parts in a text string (e.g., last, first, middle name) using the RIGHT, FIND, LEN, & LEFT functions in one formula.

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Convert TRUE & FALSE values to 1 & 0 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 314th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for converting TRUE and FALSE values to 1 and 0 (zeroes).

How To: Chart cross-sectional and time series data in MS 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 11th installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with, and create charts for, cross-sectional and time-series data.

How To: Change your voice pitch in Audacity

Watch this video tutorial to see how to change your voice pitch in Audacity. Audacity is a digital audio editor application and is free. If you ever wanted to know how to mess with people's voices or song voices, this will help you transform those pitches into whatever you desire.

How To: Easily get autotune in Garageband

User tomreviewer shows us how to get autotune in GarageBand. Open GarageBand and create a new project. Make sure the Key is set to C. Delete the default track by clicking on Track, then Delete Track. Start a new track by clicking on Track, then New Track. Select Real Instrument Track when prompted and click Create. In the sidebar that opens click on Vocals, then Male Basic. Any of the Vocals, however, can be used. Press the Record button and record your voice. Click on the Scissors icon in th...

How To: Save your project in Pinnacle Studio

This tutorial explains how to save your work in Pinnacle Studio. The first step is to go to "File". Next is saving projects by using the drop down menu from the top left corner of the program. When you save your project it does not mean that all the video files will be saved. In fact, all the original files have to be stored in the exact same place so this will work. To save your new project you have to go to movie and make and output format like Vdix or VCL.

How To: Create a Super 8mm effect in After Effects

Using Curious Turtle's Film Wash Color Effects in After Effects create a Super 8 look to your film. In this tutorial, you will learn how to build up a color grade using several layers, then using expressions and After Effects own filters to finish the look. To learn more about the Film Wash, visit www.curiousturtle.com

How To: Use the Microsoft Excel Data Analysis add-in

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 43rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the Excel Data Analysis add-in descriptive statistics tool.

How To: Use boolean operations in Inkscape

In this software tutorial you will learn how to use boolean operations in Inkscape to combine or remove two shapes. Boolean operations are an important part of modeling in 2D or 3D and give you a way to make fast and accurate shapes. So watch and learn how to work with booleans in Inkscape.

How To: Record streaming audio from the Internet with Audacity

In this video from PCRescueRepair we learn how to record streaming audio from any website using audacity. To get audacity just go to google, type in audacity, click on the link for audacity, and download audacity to install this on your computer. Also you need the LAME mp3 encoder which is on the audacity website. Now he takes you through the steps to do this task. Go into audacity and from the drop down change to stereo mix from microphone. On output adjust to max. and on input adjust the vo...

How To: Sound older by changing your voice's pitch in Audacity

Wish there were a way to change the pitch of your voice to sound a little bit older than you actually are? With Audacity, there is. See how it's done with this clip. 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: 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: Selectively lighten or darken an image in Photoshop

This technique uses layers, blending modes, and brushes to achieve selective lightening & darkening of an image. Whether you're new to Adobe's popular graphics editor or a seasoned design professional looking to get better acquainted with the industry-standard app, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.

How To: Work with skew and histograms 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 23rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with skew in histograms for quantitative Data. Learn how to skew left (negative) and skew right (positive) with ...

How To: Set your essay to MLA format in MS Word 2007

In order to apply MLA format in MS Word 2007, you will need to change the lines and spacings. Press Control + A. This will highlight all of your typing. Then, click on No Spacing. Scroll to Times New Roman, in the font style drop down menu. Change the font size to 12. Change the line spacing to 2.0. You will need to re-center anything that was centered before. Your headers and footers will still be in the default font style. So, you will need to change them as well. Double click on the header...

How To: Pitch correct with Antares Auto-Tune in Pro Tools 8

Learn how to use the Antares Pitch correction plug-in when working in Pro Tools 8. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started tuning your own vocal tracks in Pro Tools 8, watch this free video guide.

How To: Use parallel compression in Reason 5 and Record 1.5

Learn how to apply parallel or New York-style compression to a track or finished mix within Propellerhead's Reason 5 or Record 1.5. This official video guide from James Bernard of Propellerhead will teach you everything you'll need to know. Whether you're new to Propellerhead's virtual music studio application, Reason, or their newer DAW app, Record, you're sure to find much to take away from this brief video software tutorial.

How To: Create animated flames in Photoshop

In this tutorial, learn how to make an animated fire flame effect in Photoshop. Step by step instructions are gone over on how to create this perfect addition to any animation or presentation. Create fire flames in Photoshop with help from this tutorial. Create animated flames in Photoshop.

How To: Create a meteor crash landing in After Effects

Check out this instructional video that demonstrates how to create a meteor crash landing effect using After Effects software. Using a skylight is an easy solution to soften shadows, but for faster rendering try using an array of point lights in a dome pattern above your scene with shadows on. Create ground destruction in 3D Max using particle flow. Watch this After Effects tutorial to learn how to create a meteor crash landing effect for your film! Create a meteor crash landing in After Effe...

How To: Export a video made in Final Cut Express to YouTube

Stuart shows you how to try to keep your higher quality video settings when uploading your tutorials and videos to YouTube. This tutorial is for people working in Final Cut Pro or Express to create movies, then do some final touches in Quicktime Pro. So check it out and see some methods to keep good video quality when uploading videos to YouTube that were made in Final Cut.

How To: Adjust the volume of a track in an Audacity project

In this clip, you'll learn how to adjust the volume of a track in an Audacity project. Whether you're new to the Audacity DAW (digital audio workstation) or are simply looking to pick up a few new and useful tips and tricks, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Render in Adobe After Effects CS4 or CS5

Learn how to render projects in Adobe After Effects CS4 or CS5. This guide also covers the use of background renderer, creation of output modules and render settings templates, memory, multi-processing and disk-cache preferences, as well as showing a basic preset for rendering FLVs and Quicktime H.264 out of After Effects. The tutorial is aimed at users at a basic to intermediate level. Whether you're new to Adobe's popular vector editor or a seasoned graphic arts professional just looking to...

How To: Adjust audio effects in Premiere Pro CS3

Working with sounds in Premiere Pro is just as important as working with video. This video will show you how to use some basic techniques to adjust your sound effects in Premiere Pro CS3, including how to use audio filters and create a simple echo effect on some dialogue. Not very advanced, but if you're new to this powerful editing software this video is a good place to get started.