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: 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: Hide scroll bars, sheet tabs & charts in Excel
This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook.
How To: Remove body fat or stretch marks in GIMP
In this video, we learn how to remove body fat or stretch marks in GIMP. First, go to filters, then distort, then warp. When you are in this window, you will be able to see all the different distortions that you can do. To help you remove the fat, use the "move" tool and a proper sized brush. Now, press on the stomach and slowly press down on it until you see the part of the body start to become smaller. Don't do it too quickly, or the picture will look fake. When finished, save your new pict...
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: 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: 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: 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: Reveal nipples with the Photoshop x-ray effect
Well, here it is. Hornballs unite!
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: Add a shake, quake or jitter effect using Sony Vegas
This screencast shows you how to add a shake effect to your video in Sony Vegas. It is also known as Quake, Jitter, tremor etc. It can have an interesting impact on your productions.
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: Create a dynamic weekly chart in Microsoft 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.
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: 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: 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: Identify the first occurrence of a value in a column 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.
How To: Get auto tune (t-pain effect) in Audacity using gsnap
In this video tutorial, learn how to get auto tune, or the t-pain vocal effect, in Audacity using gsnap. To get the GSNAP (GSnap/Grymmjack skin), go here.
How To: Create a bond discount or premium amortization table in Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 52nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create a bond discount or premium amortization table.
How To: Fix common Excel spreadsheet problems & errors
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.
How To: Create a simple line chart in Excel 2007
Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the line option. Select the two dimensional line graph option from the given choices. Move the chart to a new sheet. Label the new sheet in the appropriate field and click the OK button. Your line chart will now be created usi...
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: Increment numbers in formulas 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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.
How To: Calculate APR, EAR & period rates in Microsoft Excel 2010
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate) and Period Rate.
How To: Make a scary voice effect on Adobe Audition
In this video we learn how to make a scary voice effect on Adobe Audition. First, record an audio that you made and open up Adobe Audition. From here, open up any other audio that you want to hear for the beat. Then, go to "generate" and then "silence. Put this to 1.5 seconds, then go to the end of your sound and do the same thing. This will make a good effect when you are editing and adding in echo. First, reverse the audio by going to "effects" and then "reverse". This will make it a lot ea...
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: Change lip color & shade in Photoshop
Forget to put on lipstick before a photo? Or perhaps you want to spice up an old photo of someone you love. Well their is a way, as 4YouTutorial demonstrates step by step using Photoshop CS4. First upload a photo or image into Photoshop. Next access your Photoshop layers and delete the default locked layer. After, activate the zoom tool and zoom in on the photo where the lips are located. Next choose the quick selection tool (make sure it's on plus) and drag it over her lips. This process can...
How To: Avoid double-counting duplicates within a list 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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.
How To: Use volume envelopes in Sony Vegas Movie Studio
In this video tutorial, viewers learn how to use volume envelopes in Sony Vegas Movie Studio. Begin by importing the audio track into the time line. Then right-click on the audio control panel, go to Insert/Remove Envelope and select Volume. This will place a purple line through the audio track. Users are able to control the volume by moving the line up or down to increase or decrease the volume. Users are also able to select certain points by creating starting and ending points in the audio ...
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: Rip audio from a YouTube video & remix it in Audacity
In this video tutorial, viewers learn how to download and edit any You Tube video. Users will need to download the DVD Soft Video You Tube to MP3 Converter and Audacity software. Begin by opening the DVD Soft program. Then go to the You Tube website and find a video with the audio that you would like. Now copy the video's URL and paste it into the DVD Soft program. Click Download & Convert and wait for it to finish downloading. Now open the MP3 file in Audacity to edit it. This video will ben...
How To: Create a line chart in Microsoft Excel 2011
Want to generate a line chart in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started creating and using line charts to visualize data in your own MS Excel '11 projects, watch the video.
How To: Model a Leaf in Maya
Start with a Polygon Plane Start by creating a Polygon Plane with 4 width and 5 height sections.
How To: Generate MIDI notes from drum transients in Pro Tools
Learn how to use the Beat Detective tool to convert drum transients into MIDI notes 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 using this useful drum replacement trick yourself, watch this free video guide.
How To: Use the Twixtor effect in Sony Vegas
Twixtor is a great plugin for Sony Vegas that allows you to create incredible looking slow motion. This visual effect will add drama to your video and make it truly awe-inspiring. Watch and learn how to make the most of Twixtor in Sony Vegas.
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: Count Mondays between 2 dates 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.
Next Page
Prev Page