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: 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: 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 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: 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: Do bank reconciliation in Microsoft 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 37th installment in his "Excel Business Math" series of free video lessons, you'll learn how to do bank reconciliation when accounting in Microsoft Excel.
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 confidence intervals for proportions 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 86th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.
How To: Draw 10 different types of anime eyes in GIMP
In this video, we learn how to draw 10 different types of anime eyes in GIMP. For the girls eye, draw the outlining of the eyes and then the eyebrows. Then, color the whole eye black and give it color. Then, burn the shadows and add in white to the top. Color the face around it and then add in the facial features. For the guys eyes, give them the color in the eyes first and then add the lighter color and the white to make it shiny. If you are going for a mean look, darken the eyes and make th...
How To: See Through Clothes with Gimp 2.6
If you can't seem to find any photos of naked people on the internet, don't fret, this how to will show you how to "see through" clothing using some simple techniques with Gimp 2.6 photo editor. Gimp is like Adobe Photoshop without the heavy price tag. Tight, white clothing works best for this trick, so keep that in mind. Watch the video and get one step closer to seeing someone naked. Right on your own computer! See through clothes with Gimp 2.6.
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: Enter formulas in Excel with a macro
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
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: Make a voice sound deeper or higher in Audacity
Want to sound a little bit older? As if you've just inhaled helium? With Audacity, it's easy to manipulate or even entirely disguise a human voice. And this clip will show you just how it's done. 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: 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: 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: Use D functions (DSUM, DAVERAGE, DMAX) in MS Excel
video tutorial from ExcelIsFun, the 64th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to Excel's D (i.e., database) functions such as DSUM, DAVERAGE, and DMAX.
How To: Make a song acapella using Audacity
Highly produced and vocoder-heavy songs are the musical signs of our time, but there's nothing that beats the raw power of an a capella tune. If you want to make a song you recently recorded (or a song you like) a capella, then watch this tutorial.
How To: Enlarge your boobs for free in Photoshop
Have you always wanted larger breasts but just don't have the money? This tutorial won't help you fix your real boobs but it CAN make your boobs look bigger in your portraits. Check out how it's done using Photoshop.
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: Calculate proportions and percentages in Excel
This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To make a formula for a percentage, you need to first make a formula to calculate the total sum of objects you are going to use. To do that, use the sum formula. Now, divide the current object's value with the previously generated sum formula, which gives you the frequency. When you multiply this by 1...
How To: Create a checkbook-balancing formula 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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.
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: Export your song from Garageband to iTunes
After you've created a song you're happy with, you'll probably want to use it with your other projects, including iPhoto, iDVD, and iWeb projects, or just listen to it on your iPod. You can easily export your song from Garageband to your iTunes library.
How To: Combine 3 Videos Seamlessly in After Effects
Get past the intro and then you will get to the actual tutorial. This blending technique was used in the short film Tin Trio. This effect allows you to combine multiple videos shot with a locked off camera.
How To: Solve for rate of change in Microsoft 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 29th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve for rate, amount of change and rate of change.
How To: Create the iPod commercial effect in After Effects
Apple's iconic silhouette people-dancing-against-colored-background iPod commercials may not rule the airwaves anymore, but they still look really cool. This video will show you how to recreate the effect of these commercials in After Effects using greenscreens. Now all you have to do is learn how to dance and you can film your own little iPod commercial!
How To: Create tables with XML in Adobe InDesign CS5
In this clip, you'll learn how to create XML tables with InDesign CS5. Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by free video software tutorial. For more information, take a look.
How To: Combine keyframe animation with DOPs in Houdini 10
This four-part tutorial series presents a look at how to combine traditional keyframe animation with DOPs simulation. This first part contains an overview of how DOPs differs from SOPs and how to examine DOPs data using the Details View. It then looks at the RBDKeyFrameActive node as a method for combining keyframe and simulation animation. Whether you're new to Side Effects Software's popular 3D production program or a seasoned graphic artist just interested in better acquainting yourself wi...
How To: Zoom in and out in Photoshop CS4
Being able to zoom in and out of an image in Photoshop can save you precious time and can be more effective. If you don't know how to do so, it can be challenging. There are various ways to do so and this video tutorial is going to show you them. So find out how to zoom in and out and move your image in the workspace in Photoshop CS4. Sit back, take notes, and enjoy!
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: Clear data & cell contents in Excel using a macro
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
How To: Reveal nipples with the Photoshop x-ray effect
Well, here it is. Hornballs unite!
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: 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: 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 twinkling star effect in Adobe After Effects
This is a great background for Christmas plays, holiday pageants or any other video you want to add a little twinkle! You can add a twinkling star quite easily in Adobe After Effects, and this tutorial shows you exactly how!
How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
You know that moment when you finally figure out something, but you figured it out years after you really needed it? Don't you freaking hate that?!
Next Page
Prev Page