Hot Software Posts

How To: Use the noise removal tool in Camtasia Studio

In this video tutorial, viewers learn how to use the noise removal tool in Camtasia Studio. Begin by uploading the audio track into the time line. Then select and highlight the region that contains the noise. Now click on Edit and select Audio Enhancements. Under Background noise removal, users are able to select to automatically or manually remove the noise. Once selected, simply click on the Remove Noise button. Users also have the option to adjust the sensitivity. This video will benefit t...

How To: Use borders in MS Word 2007

To use borders in Microsoft Word 2007, you begin by clicking on the Page Layout tab. Next, click on Page Borders. This will open a window. Page borders will border the entire page. You are able to custom choose the width of the lines, the style of the border, or the color of the border. The color drop down menu will allow you to choose automatic colors or custom colors. You can also choose to remove one or more of the sides. You can decide which pages to add borders to, as well. There are als...

How To: Copy and move worksheets in Microsoft Excel 2007

Learn how to copy and move sheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started manipulating your own Excel 2007 worksheets, watch this free video guide.

How To: Record audio with the Camtasia recorder

Learn to record audio with the Camtasia recorder by watching this video tutorial. First, if you want to record audio click on the mic. It's easier than clicking on capture. Next, you'll find on the same menu a selection for custom or full screen modes. After you've made these selections you have cursor selections to choose from. Those options are listed under the effects tab. Are you a silent mouse or a squeaker? If you want your viewers to hear your clicks then under the same tab there is an...

How To: Extract a unique list from a huge data set 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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.

How To: Create nested unique lists in Excel via array formulas

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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.

How To: Create a modern bokeh effect in GIMP

In this video, we learn how to create a modern bokeh effect in GIMP. First, start a new image and then change it to the size that you want. From here, click on the paint can and then fill your box up with a color. Then, create a new layer and name it "bokeh background". Click on this layer and then use the paintbrush tool to paint a small brush with color onto it. Start to paint on small dots and you will see that there are small tiny star like dots that start to appear. Then, fade these out ...

How To: Remove the background from an image in Photoshop

First double click on the image in layer window then name it and click on OK. Now if you use magic tool on the image and delete the background, it will also delete some of the image part. So to fix it you need to find that kind of places of the image and use brush tool to fill up that space. Now you can delete the background by selecting it with magic tool.

How To: Put your MS Access databases on your website

To start off the process of publishing your access database online we first look at a sample MS ACCESS database with typical formats and a online searchable application where users can search by library name or city and get details of the library. There are 3 steps to publish the database. The first step is importing data which can be done through clicking on the file menu and then click on import data through a Microsoft Access Database. Now select the file you want to import through the bro...

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

How To: Crop an image in Adobe Photoshop CS2

In this how-to video, you will learn how to crop an image using Adobe Photoshop CS4. First, open Photoshop and open the image you want to crop. Next, press filter and select the edge hollow tool. Carefully draw around the image you want to crop. Once this is done, click on the fill tool and left click in the middle of the image. Now, press preview to see if you missed any spots. You can clean these spots up by pressing the clean up tool. This will allow you to erase these particular spots. On...

How To: Score a Full Version of Microsoft Office for Only $10

When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, and dinner. Something that I wish I would've known about during college is Microsoft's HUP (Home Use Program). With HUP, any employee or student of an organization that has a Microsoft volume license is eligible to purc...

How To: Use the Point Cache deformer in Cinema 4D

This clip discusses a technique for using the point cache tag and point cache deformer in Cinema4D. It will show you how to cache your objects deformation and then use this on many more duplicate objects without increasing the overall filesize in the same way that you would if you used duplicate cached tags. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this...

How To: Calculate sales using a compact array 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 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.

How To: Calculate percentage change 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 267th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate percentage change using a simple universal formula: (End Value)/Beg Value)/Beg Value = Percentage Change.

How To: Copy or back up a DVD disc on a PC with Nero Express

In this video tutorial, viewers learn how to copy or backup a DVD disc on a PC with Nero Express. Begin by opening the program and select Backup from the menu. Make sure that the disc is set to DVD and select Copy DVD. Now select the Source Drive, Destination Drive, Writing speed, Number of copies and the Image file. Click on Copy and wait for it to finish copying to the DVD. Now insert the disc into the disc drive and wait for it to finish burning. This video will benefit those viewers who n...

How To: Summarize data from multiple sheets 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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.

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: Apply accounting & percentage formatting in Excel

This is the fifth video in the Statistics in Excel. He gives the website address where content can be downloaded. He speaks about the different types of formatting like stylistic and number formatting. He talks about the different formats like accounting and percentage, and how to use both of them. Accounting format is nice because it lines up the decimals nicely. He shows how to apply the accounting format. The percentage format displays the value in as a percentage. He shows you how to appl...

How To: Mirror geometry in Zbrush

This software tutorial shows you how to mirror geometry when modeling in Zbrush. This is a more non-organic method of sculpting in Zbrush but it allows you to duplicate details on both sides of an object without having to redo the details. Learn how to mirror geometry in sections using masks, and how to make sure the seams line up and keep your scuply accurate in Zbrush.

How To: Use the shell modifier in 3ds Max

This 3D software tutorial was developed by Discreet (creators of 3ds Max) to show you how to use the shell modifier new to version 6 and up of 3D Studio Max. If you are a 3ds Max modeler, you should learn how to use this powerful tool. Great 3ds Max tutorial for anyone new to modeling in 3ds Max or needing to know how to use the shell modifier.

How To: Multi-replicate objects in Bryce 5

Are you creating an army of awe-inspiring monsters, and don't want to create one by one from scratch? In this Bryce 5 video tutorial you will learn how to multi-replicate objects. Learn how to duplicate many objects, and arrange them using the distribute menu. Make sure to hit "play tutorial" in the top left corner of the video to start the video. There is no sound, so you'll need to watch the pop-up directions. Multi-replicate objects in Bryce 5.

How To: Play Google Video files in Windows Media Player

This video demonstrates how to download Google Video movies onto your computer and play them using Windows Media Player. The video walks you through downloading the right software, downloading the video you want, modifying the movie, and playing in Media Player. This video is silent and goes fast, so you will have to watch a few times to understand what is happening.

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: Export iPhoto slideshows as video

You can export your iPhoto slideshow as a video. First select photos, you want to use in the slideshow. Now you need to click on + button in iPhoto which is located at the bottom of the iPhoto. Then click slideshow and make sure "Use selected items...." box is checked and then click create. It will create the slideshow on the left. You can change the settings of your slideshow by clicking the setting icon, located at the bottom. There you can change the settings of your slideshow like link th...