Hot Software How-Tos

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: Make 303 acid using TS404

In this tutorial we learn how to make 303 acid using TS404. First, move the distortions around all the away around. After this, you will have a techno kind of beat. From here, you will change the oscillator one and two knobs all the way to the left. Once you have fine tuned these, play your audio to see how it sounds. Keep the filter in LP24 and move the resonance all the way to the right. LFO and Wave should be changed to the triangle pattern. Move the amount to the opposite. When finished, ...

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: 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: 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: Randomly generate 1s, 0s & blanks with Excel's CHOOSE

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 392nd installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly generate 1, 0 and blank values with the CHOOSE, RAND, RANDBETWEEN and INT functions.

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: Do matrix multiplication and inverse in MS Excel

This is a video about the multiplication, determination, and inverse of matrix using excel. First we have to take two matrix in excel. If you take two 3x3 matrices and multiply it then you will get a 3x3 matrix as a result. First we have to select 3x3 cells in the excel and give then a formula of =mmult(and then select the first matrix it will automatically takes the row and cell numbers, next select the second matrix). Then it will give the answer. Next if you want to find the determinant of...

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 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: Create dynamic sub tables 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. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

How To: Reverse video and audio in Sony Vegas

In this video tutorial, viewers learn how to reverse video direction in Sony Vegas Movie Studio. This task is very easy, fast and simple to do. Begin by importing the video clip(s) and/or audio into the time line. Then right-click on the clip and select Reverse. To reverse the audio, right-click on the track and select Reverse. To undo the video or track, right-click it and select Reverse once again. This video will benefit those viewers who enjoy editing and creating videos, and would like t...

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: Group duplicates & extract unique records 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.

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: 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: Add movement to your still images in Final Cut Pro

In this how-to video, you will learn how to add movement to still images using Final Cut Pro. Click on the view mode button in the canvas window. Set the mode to Image and Wire Frame. Move the canvas play head to the clip you would like to affect, and select the time line. To control the scale, grab the corner to shrink or enlarge. Reposition the clip by clicking on the image and dragging it around. To rotate the clip, move the mouse over the edge and click and drag it to spin it. Select the ...

How To: Calculate vacation days with TODAY, YEAR & IF 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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.

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: Check your voicemail in Microsoft Outlook

In this how to video, you will learn how to check your voice mail in Microsoft Office Outlook. Your exchange administrator must enable unified messaging for these messages to appear. First, open the program to set up your voice mail options. Go to options and click the voice mail tab. Your phone number should appear in the correct form. Click call to check your voice mail. Enter your number and click x and okay. Now you are ready to listen to your voice mail messages on your computer. From Ou...

How To: Make a bootable CD using Nero

This video uses Nero Burning ROM. First you must open Nero. Then choose Burning ROM. Scroll down to the CD-ROM(BOOT) icon. Click it. From there you choose you ISO image. To do this just browse and navigate to the correct directory where your ISO image is stored. From there be sure to set the emulations to No Emulations and change your available sectors to 4. Next change to the ISO tab. Be sure that it is set to run ISO+Juliet and that the max characters are set for Level 1. Next choose the La...

How To: Use a MODE IF function 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 145.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to a formula that will calculate the mode when you have more than 1 criterion.

How To: Use the opacity feature in Final Cut Pro

Plangere Culture Lab demonstrates how to use the opacity feature in Final Cut Pro. The opacity feature is a beneficial tool to use when working with layers. Opacity is an attribute which relates to how much you can see through a clip. To layer clips, create a new video track on the timeline. Make sure that the source tab is in the right position. The track on the top of the stack is the dominant track and will be shown. Select the volume and opacity overlay button. Click on the line over the ...

How To: Use the dynamic RAM preview feature in Sony Vegas

One of the most common problems with any video editing software is the preview lag- a result of high quality video slamming your CPU. There is a great fix in Sony's Vegas editing software to allow previews to run full-frame with a slight tweak called the dynamic RAM preview feature. This is especially useful if you don't have a brand new computer with maxed-out RAM and video card. Double-click the clip (or drag for a series of clips) that you would like to preview and select which quality you...

How To: Smooth and straighten lines in Adobe Flash

First select the pencil tool then click on pencil mode which is located at the bottom of the toolbar, select straighten and draw a line as in the video. Now you can see that the line is automatically adjusted, it will make the round and straight shape in the line depending on how you drew it. Now delete your shapes and select the smooth in pencil mode and draw a line as in the video. Now you can see that the line is automatically smoothed. And finally select the ink in pencil mode and draw a ...

How To: Find the sample size for confidence intervals 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 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate sample size (n) for confidence intervals.

How To: Return the address of the 1st non-blank cell 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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.

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...

Prev Page