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: 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: 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: 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: Flip a Clip in Final Cut Pro X 10.1.2
This is a great how to for all users in Final Cut Pro X 10.1.2 Video: .
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: Resize images and video in Sony Vegas
In this video tutorial, viewers learn how to re-size an image or video in Sony Vegas. Begin by opening the image or video that you want to re-size in Sony Vegas and drag it into the time line. Then click on Event/Pan Crop on the right side of the clip in the time line. Now re-size/rotate the video/image by dragging in and out. Finish by simply closing the window. This video will benefit those viewers who create videos using Sony Vegas and would like to learn how to make their video image smal...
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: 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: 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: Compare two lists and extract the new values in Excel
Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks.
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?!
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 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: 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: Conditionally format at every change in value in 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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
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: Change the pitch & formant of your voice with Audacity
Want to disguise your voice? With Audacity, it's a simple process. And this clip will show you precisely what to do. 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: Compress Mp4 videos in Sony Vegas Pro
If you are facing any problem to compress videos in Sony Vegas like not in very good quality or big in size etc. then you have to take these steps to get rid of it.
How To: Create masks w/ find edges & auto-trace After Effects
In this video tutorial, CreativeCOW contributing editor, Nelson Fernandes demonstrates a method to obtain a quick and dirty mask using the find edges effect combined with the auto-trace feature.
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: Remove JPEG artifacts in Photoshop
Photoshopuniverse shows how to remove JPEG Artifacts in photoshop. It's simple. Sometimes it happens that, you get the best picture which is related with your work, but unfortunately its low quality or small. If you zoom in a small picture it will pixilated. You will see some blocks. Luckily there is a way to remove it from photoshop. Go to- filter, then noise, then reduce noise. There will be an options of removing JPEG artifact. Check that. After watching the video you can remove JPEG artif...
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: Make a pulse or pulsating wave effect in After Effects
Making really attractive titles for your films is just one of the way that you can dramatically improve them using After Effects. This video will help you make them by showing you how to create a pulse or pulsating wave effect from whence your titles can emerge. They look great, and will make your movie (especially horror or sci-fi movie) look much more professional right from the beginning.
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: Remove Vocals from a Song Using GarageBand
Do you think that Avril Lavigne has nothing on you when it comes to belting it out on the mic? Then you probably prefer karaoke versions of songs to the real ones so you can hone your vocal chops to your favorite tunes.
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: Enahce the appearance of breasts in Photoshop
Add cleavage or a cup size to a portrait using the software program Adobe Photoshop. For most of this process, you will be using your liquify tool. This tutorial shows the exact technique you can use to enhance chest size.
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: Gradually increase tempo, volume, and pitch on a song in GarageBand
This video will show you how to manipulate the master track of a song in GarageBand to gradually increase tempo, volume, and pitch. Learn how to speed a song up, or slow a song down. Follow the instructions of this tutorial and you'll make beautiful music.
How To: Extract records that meet certain criteria in 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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
How To: Mount an ISO with Daemon Tools in Ubuntu
Askabouttech shows how to mount an ISO with Daemon tools using Ubuntu. Right click on Daemon Tools in the tool bar and select "virtual CD rom". This will bring up a side window in which you will click "device". This will open another side window where you will click "mount image". This will open a new window. Make sure you're looking in desktop and open the Ubuntu ISO file. This should open up a new window where you have the option of running it or viewing the files. When you're finished, fol...
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: Set up pagination in Adobe InDesign
Get your numbering straight with Adobe's InDesign and this helpful tutorial, showing you what you need to know. It's essential when creating a project for yourself or a client, to get your numbering right the first time. There is no second chance. So, check out the steps and see how to turn this sometimes tricky task into a much easier one. InDesign offers a lot of options, and if you're going to master all it's tricks, watch this how-to to learn one of the most simple and essential tricks.
How To: Use Daemon Tools Lite to run .iso files
In this how to video, you will learn how to use Daemon Tools Lite. First, download Daemon Tools Lite and install the program. Next, download an ISO file from the internet. Once that is done, mount it on to Daemon Tools. To do that, open the program and then right click on it. Select Virtual Drive and set the number of drives to one. Next, select mount image and find and open your ISO. Once that is done, you are ready to use that file as if it were an actual CD inside an actual optical drive. ...
How To: Count words separated by commas 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 289th installment in their series of digital spreadsheet magic tricks, you'll learn how to count words separated by commas using the LEN & SUBSTITUTE functions in a formula.
How To: Utilize and manipulate sound dynamics on your songs in GarageBand
It's called the AUDynamicProcessor, and it's very helpful when it comes to mastering your songs in GarageBand. In this video tutorial, you'll learn how to utilize and manipulate the sound dynamics of your songs in GarageBand using the AUDynamicProcessor filter, which effects the high and low ends of audio.
How To: Blur out a person's face in Final Cut Pro 7
In this clip, you'll learn how to blur out a person's identity with matte tracking in Final Cut Pro or Express. Whether you're new to Apple's Final Cut Pro non-linear video 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: Automatically insert symbols 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 391st installment in their series of digital spreadsheet magic tricks, you'll learn how to use custom number formatting to insert symbols automatically.
Next Page
Prev Page