Hot Software How-Tos
How To: Find a P-Value with Excel
So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis.
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: 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: 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: Use x-ray techniques in Photoshop to show naked skin through clothing (NSFW)
Do those new naked body scanners have you freaked out at the airports? As far as the TSA is concerned, those x-ray machines are here to stay, but you might as well take comfort in knowing that airport security guards aren't the only ones looking at your private parts. Practically anyone with a computer can manage to see through your clothes, and it's all thanks to a little program called Photoshop. Thanks, Adobe.
How To: Create a pass-fail grade formula 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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pass-fail grading formula using the IF and AND and VLOOKUP functions.
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: Create an Excel inventory template with running totals
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 Skin Tone in Photoshop
With Adobe Photoshop on your computer, it's super easy to change or adjust the skin tone of somebody in a digital photo. The process uses some basic selection and color adjustment tools, and it's a fun way to make a friend's face nauseously green or lessen the effects of overly strong, sometimes even orange, makeup.
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: 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: Use conditional formatting for a student grading report in Microsoft Excel
If you're looking for a way to create a student report, Microsoft Excel makes it easy to create a wonderful spreadsheet with tons of information. This video shows an example of a student report being created, which has three simple items in the columns of the sheet, which are the names of the students, the marks obtained and the grades.
How To: Update inventory records by formula in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).
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: Create an Excel spreadsheet to calculate your GPA
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
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: Reveal nipples with the Photoshop x-ray effect
Well, here it is. Hornballs unite!
How To: Cross tabulate categorical data 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 16th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using a pivot table (PivotTable).
How To: Change the language to English in After Effects
Have you got a copy of After Effects installed with the language set to another language? Check out this helpful video to learn how to set the language English, whatever the current language is. Maybe your film is in French, but that doesn't mean your visual effects software has to be.
How To: Make a chrome material in 3ds Max
Make a photo-realistic chrome material in 3D Studio Max.
How To: Import Flash into the PDF file format
One of the advantages of using the Adobe family of creative products is that its many programs can be combined easily to create cool digital multimedia projects. This video tutorial teaches you how to integrate .swf files from Flash into .pdf files in Adobe Acrobat Pro 9. Including Flash in pdf files makes it easier for people who don't have the appropriate Flash players on their desktop to view the great images that you've made in Flash.
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: Auto-tune your vocals in Audacity for free
T-Pain, Cher, heck, most of the new artists these days use auto-tune, some over use it. With technology it isn't so much of a question of, "do we need to do it?" and more of "why aren't we doing it!?" Well, if you're looking for an easy way to add auto-tune to your vocal tracks, or your voice in recordings, and are looking to spend the fantastic price of FREE then check out this video! You will learn what programs you will need to download (Audacity, Audacity VST, ect.) and then how to set yo...
How To: Create a Tangent Line with Excel
Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.
How To: Remove Vocals from a Song in Ableton Live
In this how-to video, you will learn how to remove the vocals on songs using Ableton. First, open the tracks you want to remove the vocals from. Go to utility and select the preset difference. Drag it to the audio track. This will remove vocals.
How To: Create Karaoke Tracks by Removing Vocals in Audacity
Audacity is a music editing software that allows you to do a bunch of cool stuff like removing vocals from a track, edit your own track, delete clips, add clips, etc. It's great for those interested in mixing or making their own music or creating karaoke versions of their favorite songs.
How To: Graph the probability density function in an Excel file
One of Microsoft Excel's capabilities is to allow you to graph Normal Distribution, or the probability density function, for your busines. This is a quick and easy tracking feature you can learn in just a few minutes.
How To: Summarize survey results with a pivot table 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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize survey results with a pivot table (PivotTable) or a formula. See how to create a Pivot Table in Excel 2003 or 2007.
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: Change an object's color in Photoshop using magic wand
Use the "Magic Wand" tool to select the color you wish to change. The next step is to open the replace color box. Go to Image > Adjustments > Replace Color. After the Replace Color box is open, you may have to select the color that you want to change in the image. Sometimes, it will automatically select the color you're changing, but sometimes you will have to use the Eyedropper Tool and click a hue of the color you wish to change. After the color is selected in the "Replace Color" box, you c...
How To: Use the Antares Auto-Tune Evo VST in Audacity 1.3 Beta
This video explains how to make your voice sound like T-Pain using Audacity 1.3 (Beta), the VST Bridge for Audacity, and Auto-Tune Evo. 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: Create a relative frequency distribution 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 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...
How To: Insert joints in a joint chain in Maya
If you are working on characters or rigs, you are definitely working with joints. This video shows you how to insert a join in a joint chain if you need more or happened to miss one.
How To: Draw a car in MS Paint
Microsoft Paint has the capability to allow you to draw an awesome realistic car. This video will show the line and filling tools that someone uses to make a sporty car. You can make whatever alterations and adjustments to create your own unique dream car. Draw in wheels of the car first. Unless you plan to draw a perfect side view of a car, you need to use perspective. Using the circle shape tool, draw two circles for wheels. One circle should be slightly lower on your screen, and that circl...
How To: Download & install free brush patterns from Brusheezy
This clip offers instruction on how to find, download and install free brushes for Adobe Photoshop. 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: Restore black and white photo in Photoshop
In this video tutorial you will learn to perform black and white photo restoration using Photoshop. A quick trick is to use the curves tool to add contrast. Another way is to use sharpen tool to enhance the detail of your photos. Restore black and white photo in Photoshop.
How To: Adjust pitch and transform a voice in Soundtrack Pro
If you are doing podcasting, very often you might have to use your own voice. The good news is that there are ways to touch up your voice even if you don't like it. In this video tutorial Adam Hay will show you how to adjust pitch and transform your voice into a much different sounding one using the stock effects in Apple Soundtrack Pro. Adjust pitch and transform a voice in Soundtrack Pro.
How To: Create an eyecatching intro for your film or video using Adobe After Effects
Start with Adobe After Effects. Decide what you want your intro to look like. Then follow along with this tutorial, which shows you how to use the various tools in After Effects to create a short yet effective intro clip.
How To: Send emails with a PHP web form using Dreamweaver
Learn how to build a an Email Handling PHP script in Dreamweaver that sends info from your web form to your email.
Next Page
Prev Page