Hot Software How-Tos

How To: Change Excel options directly in the Registry

This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and...

How To: Remove objects from photos using paint.net

In this video from solvingtime we learn how to remove objects from photos using Paint. To get this program go to to install it. He uses the clone stamp tool to remove things. First he zooms in on the object he wants to remove using the magnifying glass. Then click the stamp which will switch to the clone stamp tool. Use the bracket keys near the letter P on the keyboard to adjust brush size. Then while holding the control key click once on an area near the object you wa...

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: 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: 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: 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: Extract part of a table from a larger table in Excel

New to 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 Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Photoshop car rims onto a car

JdudeTutorials shows how to Photoshop the rims of a photo of a car, either for previewing different options for your vehicle or just for fun. Open the photo of the car (preferably shot from the side) in Adobe Photoshop. Open the desired rim photo. On the rim, use the lasso or magnetic lasso tool to select the rim from the background. Then copy the selected area and paste it into the car photo. Select the layer with the rim, select "free transform" and resize the image to fit the car's rim siz...

How To: Sort data in single columns & whole tables in Excel

To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...

How To: Save a file in Microsoft Word .docx and .doc format

In this video tutorial, viewers learn how to save in .doc file format in Microsoft Word 2007. When saving a file, click on File and select Save As. In Format, change it to Word 97-2004 Document(.doc) and check Append file extension. To set .doc as the default format, go to Word and select Preferences. Under Output and Sharing, click on Save and change the format to .doc in Save word file as. This video will benefit those viewers who want to learn how to save files in .doc format so that it ca...

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: Use Raw Therapee with GIMP

In this video, we learn how to use Raw Therapee with Gimp. First, you need to go online to Raw Therapee, then download and install Raw Therapee. Once you have this, open it up and familiarize yourself with the layout of the software and where the different tools are at. Next, change your preferences and pick your settings throughout the different folders. Next, find GIMP through the program folders as your installation directory. Now, it will export your images to GIMP automatically. This way...

How To: Find & replace all instances of a word/number 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 160th installment in their series of digital spreadsheet magic tricks, you'll learn how to find all the occurrences of a word, number, format or formula and then change or replace all of them! See how to use the Find and Replace feature in Excel with this free video tutorial.

How To: Create realistic smoke and dust particles in Maya

The key to being able to animate realistic smoke or dust is being able to master the particle texture rate technique in Maya. Once you have gotten this down, you can create any sort of particle effect, such as sand or bubbles in addition to smoke and dust. This three part tutorial series goes in depth into the subtleties of Maya, showing you how to get the most out of working with particles to lend an extra layer of realism to your project.

How To: Make a histogram chart in Excel

In this tutorial, we learn how to make a histogram chart in Excel. To create a vertical histogram, you will enter in data to the chart. Then, highlight all of the data and go to "insert", "chart", then choose a regular column chart. Grab a regular 2D column and then make sure your values are correct. Then, right click and go to "chart options", then take the legend off. Now, make these columns all touch each other by right clicking over the columns and formatting them. Go to "options" then ch...

How To: Create a spotlight lighting effect in Sony Vegas Pro

See how to create a simple spotlight effect in Sony Vegas Pro. (NB: This effect can NOT be done in Movie Studio or Platinum.) Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Construct confidence intervals with TINV 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 83rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) in NOT known using the TINV function.

How To: Use channels to select hair in Photoshop

In this video tutorial on Adobe Photoshop CS3, we will cover using channels to cleanly cut out complex hair selections of both brunette and blonde hair on a studio style background and an outdoor scene. You will learn a lot about how to select things in Photoshop using the techniques displayed in this video, which will aid you in selecting many different things, not just hair.

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: 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: 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: 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: Create glass material in 3ds Max

Dave shows you how to produce a glass three different ways in 3ds Max in the video tutorial. Put two panels away, then concentrating on sensor one press m on the keyboard to bring up the materials editor. On the material editor go to the first sphere, choosing a slight blue color, bring up the specter level, bring up the glossy level, click on two sided and bring down the last two to about four. Look to see it is fairly transparent, in a test window. This is glass one, put on hide. Go to glas...

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

Prev Page