Hot Software How-Tos

How To: Create a login form using MS Access 2007

If you want to password restrict some of your data, or just want to know who is doing what in Microsoft Access 2007, you will want to set up a login form for MS Access 2007. This is an easy procedure, and you can create one yourself with just a basic understanding of the structure for MS Access. Watch this video, and Uncle Gizmo will show you how to do a login form and several other forms for MS Access.

How To: Edit or delete a title or effect in iMovie HD

How do you edit or delete a title, transition or effect within iMovie HD without actually damaging your videos? During this short clip from the iMovie HD Troubleshooting Guide we will explain how iMovie HD handles titles, transitions and effects so that you can always revert back to your original clip settings.

How To: Create a cool blend text effect in Illustrator

In this tutorial, we learn how to create a cool blend text effect in Illustrator. First, open up Illustrator and draw a path, then change the color to black. After this, click on the line and type in your desired text. Increase the font size to 36 points, then select the red color. After this, copy your path and select the duplicate button. Now, move the duplicated path and change the background color to yellow. Now, scale the path and resize, then place on to of the red path. When finished, ...

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: Get started with Acrobat 3D Toolkit

The application Acrobat 3D comes with an associated utility called Acrobat 3D Toolkit, which allows the 3D content in the PDF file to be enhanced by editing lighting, adding textures and materials, and creating animations. In this video tutorial you will learn to set up the Acrobat 3D Toolkit environment for technical illustration. Learn about the shortcuts and quick keys to quicken your workflow!

How To: Find & count the longest or shortest word 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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to find and count the longest and shortest words/strings with the MAX, MIN and LEN functions in an array formula.

How To: Set up and use input areas in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business 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 2nd installment in his "Beauty of Excel" series of free video lessons, you'll learn how to set up the input/assumption area for formulas so that subsequent formulas, functions and charts update beautifully. Learn how to build Excel spread...

How To: Create a line chart with time as its x-axis 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 284th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a line chart from years and percentage change. See how Excel makes the chart wrong, but then see how to fix it.

How To: Create a wood photo frame in Photoshop

In this video tutorial by photoshopuniverse you learn how to create a wood photo frame in Photoshop for your photos. Take the photo that you want to add a frame to, open it in Photoshop. Open the layers palette and double click to convert to a regular layer and increase the canvas size of the image to the required thickness of the frame. Create a new layer and fill in with the wooden pattern. Apply a mask and reveal the photo as shown. Apply the desired effects bevel and emboss to get the woo...

How To: Highlight your mouse pointer in Camtasia 7

If you're into screencasting, then you know all about Camtasia. But there might be a few things you're not well-versed in, like the mouse pointer. That little arrow could be constantly eluding you in Camtasia, but you can fix that! This video will show you how to highlight the mouse pointer for better visual representation.

How To: Conditionally format an Excel column-row intersection

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 296th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a row, a column and the intersection of the two with three different colors.

How To: Create songs using loops on Garageband

Elliott Berring shows us how to create songs in GarageBand using Loops. First, launch GarageBand and create a new music project. Keep the default tempo, time signature, and key. Click on the Show Loops browser, indicated by the Eye icon in the bottom left of the window. In this example, he starts with a drum beat by choosing All Drums, then Rock/Blues. Find a beat you like, then drag it into the timeline. Position your cursor over the top right hand corner of the blue bar of the beat you just...

How To: Use Photoshop to create six pack abs

Who has time to go to the gym any more? Not to mention the money. And then there's all that heavy lifting if you do get there. Why not just fire up Photoshop and turn that 96 lb weakling into a gym monkey beefcake? This Photoshop editing technique for giving a similar look dodging and burning only a lot quicker. This is a technique was developed by Photoshop Guru Calvin Hollywood. This tutorial will show you how it's done. In no time at all you'll be faking out people with your touched up pho...

How To: Import an MP3 file into an Audacity project

In this clip, you'll learn how to import an MP3 file into an Audacity project. Whether you're new to the Audacity DAW (digital audio workstation) or are simply looking to pick up a few new and useful tips and tricks, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Record HD widescreen in Camtasia

First open up the Camtasia studio and click on the link make a recording. It will open up the Camtasia recorder but before you start the recording you need to click on the tools, options and make sure the "save as AVI" is selected in file menu. Then click on video tab and select the "manual" in "video configuration", 30 in frame rate and click ok. Now download and install the software called "free sizer". Now we need to set the recording area to 1280x720. To do that, right click on the maximi...

How To: Create and use grouping points in Houdini 10

This tutorial presents a guide on how to use grouping points and primitives in Houdini. Whether you're new to Side Effects Software's popular 3D production program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look. Create and use grouping points in Houdini 10.

How To: Calculate subtotals in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 18th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to calculate (and sum) subtotals in Excel. See how to do subtotaling with the SUM function.

How To: Create fast formulas for huge Excel spreadsheets

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.

How To: Calculate future value for a sinking fund in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business 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 48th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions FV and PMT to make a future value calculation for a sinking fund.

How To: Design lower thirds in Adobe Photoshop

This is a two part video tutorial. Be sure to click on Chapters 2 as well to get the full tutorial. Taking a look at the popular technique of designing lower thirds and the process it takes to design these using Photoshop. Photoshop is the perfect solution for this task with the ability to mix text, texture, graphics and logos to create compelling titles for your show or video.

How To: Use Backtrack security software

A basic tutorial from InfinityExists.com on using Backtrack - the Linux-based security software package. This tutorial covers: Where to get Backtrack 2, How to burn an .ISO file, How to boot Backtrack 2, How to login, and start the GUI interface. It also illustrates basic Linux commands, and how to set up your Network Interfaces.

How To: Create a TV screen look in Final Cut Pro

In this three part tutorial, Ben Scott shows you how to create a TV screen look, with effects, motion properties and key framing. Part two goes over adding motion paths, window layouts and the Quickview tool. Part three covers more on keyframes with opacity and noise. The final effect isn't that great looking but the techniques and processes you'll learn are well worth it. Create a TV screen look in Final Cut Pro - Part 1 of 3.

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