Married Filing Search Results

How To: Use iPhoto Smart Albums

In this video, we learn how to use iPhoto Smart Albums. These are useful for organizing your photos to see what you have. First, create a smart album on the file menu, then name it and go through the drop down menus to choose how you want to categorize your pictures. Choose the type of camera model you used, then you can see what photos you have that are taken with the type of camera that you used. This is very easy if you have a lot of photos and want to go through them easily. It also separ...

How To: Create a super-quick carbon fiber effect in Adobe After Effects

After Effects makes it easy to create wonderful designs and great looking material, and this tutorial makes it even easier! Watch and learn how to create a really quick carbon fiber (or carbon fibre for all you British folks) effect using After Effects. Carbon fiber is a great-looking material, and you can used the standard toolkit in After Effects to create an instant carbon fibre texture in seconds. Great for your next extreme sports car and high-tech driver video intro title sequence! Get ...

How To: Average the last three values for an entity 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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

How To: Ignore hidden rows with MS Excel's AGGREGATE function

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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.

How To: Ignore nested subtotals with AGGREGATE 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.

How To: Use the left-hand column options in Gmail

In this tutorial, we learn how to use the left handed column options in Gmail. First, log into your Gmail account, then click on your different emails. Open an e-mail by clicking on it, then click reply to respond to it. You can also save this, and it will save to your account. If you want to delete a message, simply select it and click on the delete button. It will now be moved to your trash, where you can keep it, or you can delete that, which will remove it forever. If you want to write an...

How To: Change filenames in bulk on a Mac running OS X

Want to rename a group of files on your Mac computer without going through them one at a time? Rename them en masse with a free application! This clip will show you how it's done. It's simple! So simple, in fact, that this home-computing how-to can present a complete, step-by-step overview of the process in just under two minutes. For more information, including complete, step-by-step instructions, take a look.

How To: Convert an ebook file to ePub format in Mac OS X

If you use iBooks on your iPad or iPhone, you can only read books in EPUB format. If you have books in text or PDF format you may want to convert them to EPUB so you can read them in iBooks. You can do this with Calibre, a free open-source e-book library application. It's easy! So easy, in fact, that this home-computing how-to from MacMost can present a full overview of the process in about five minutes. For more information, including detailed, step-by-step instructions, watch this Apple lov...

How To: Convert text to spoken word with the OS X Automator

Learn how to use Automator to convert selected text, or text from a file, to audio. You can listen to the result on your Mac, iPod or iPhone while on-the-go. It's easy! So easy, in fact, that this home-computing how-to from MacMost can present a full overview of the feature in exactly four minutes. For more information, including detailed, step-by-step instructions, watch this Apple lover's guide.

How To: Create a simple scrolling LED display in After Effects

This simple After Effects tutorial from Laurence Grayson will show you how to use CC Ball Action effect in AE to create a realistic scrolling LED signboard effect, like the ones you see at conference centers and football stadiums. Then end result can be altered to suit your project, and corner-pinned into a scene. There are no plug-ins required, and this method uses the standard toolset in CS3, CS4, and CS5.

How To: Use AGBX360 to stealth patch your XBox 360 games

You can hack you XBox 360 as perfectly as you please, but if you don't burn the games that you want to play on it properly than it will all be for naught. This video will teach you an important part of the process, using AGBX360 and S360X to stealth patch your .iso game files and make sure that they are SSv2. Taking these steps will ensure that the games you are burning are ready to be played on XBox 360's and ensure greater enjoyment of you XBox hacking experience.

How To: Save and swap OS X icons

In this video tutorial, viewers learn how to save and swap icons on a Mac OS X computer. Begin by selecting the application that you want to get the icon from, and copy it. Then open preview, go to the File menu and click on "Create new clipboard". Users are also able to apply the icons on other applications or drives. After you have copied the desired icon, select the application with the icon that you want to replace, press the Command and I buttons, select the icon and paste the copied ico...

How To: Connect to your home Mac with Back to My Mac

Mobile Me will allow you to access your home Mac computer from another computer, using Back To My Mac. In order to use this, you will have to sign up for a Mobile Me account. You will have to sign up, using both computers or all of the computers that you hope to connect. Sign up under System Preferences. Turn on Sharing: both screen and file sharing.

How To: Create layer comps in Adobe Photoshop CS4 and CS5

Layer comps let you assemble multiple image variations or even independent pieces of artwork inside a single Adobe Photoshop file. The Layer Comps palette gives you the freedom to explore. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instr...

How To: Mod Fallout 3 for the XBox 360 without using Modio

Fallout 3 is one of the most popular and biggest (content-wise) games on the XBox 360, and has thus become a popular target for hackers to mod. This video will show you how to mod your Fallout 3 saved game from the XBox 360 version using some FREE software. This does not include Modio, the popular for-money save game editor that many hackers use. Here are the files:

How To: Use the Media Browser Panel in Adobe Premiere Pro

This clip explains how the Adobe Premiere Pro CS4 Media Browser panel can save you time and keep your projects tidy. Also learn about Equalize Volume within Soundbooth to make volume matching files easy. Whether you're new to Adobe's popular non-linear editor (NLE) software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detaile...

How To: Create shine effects in After Effects without a plugin

Shine effects are one of the cooler and more popular effects that you can add to a title in After Effects. Many people use Trapcode's Shine plugin to accomplish this quickly and easily. But that costs extra money! This two-part video will show you how to create shine effects in After Effects without having to download any additional plugins. If you already shelled out the dough for After Effects, we know you don't want to spend any more, so watch this video!

How To: Leave color in black and white scenes in After Effects

If you've seen the 2005 film Sin City, you most likely remember how most of the film was black and white, but some objects were rendered in livid color. This video will teach you how to create the same effect yourself using After Effects! The creator of this two-part video works with a photo of a fetching young woman and her red blouse, which retains it's color as he turns the rest of the image black and white.

How To: Create Star Wars style titles using Premiere Pro

The scrolling, synopsis-giving titles of the sci-fi epic Star Wars might be the most famous set of titles in the history of cinema. All most people need to see is deep space and yellow letters to immediately think of Star Wars. This video will teach you how to make similar titles for your own films using Adobe Premiere Pro. This is MUCH easier than what the Star Wars staff did to make the original titles, so fire up your computer and make your own!

How To: Bring back the "show desktop" button in Windows

In this video tutorial, viewers learn how to add the "Show Desktop" button in Windows 7. This task is very fast, easy and simple to do. Users will need to download the freeware from this site: German freeware. Once downloaded, users will then need to extract the file and pin it into the task-bar. Users may also use the keyboard shortcut by pressing the Windows button and M. This video will benefit those viewers who use a Windows 7 computer, and would like to learn how to have a Show Desktop b...

How To: Recover a lost file in Blender 2.5's autosave feature

With this quick Blender 2.5 video tip, you'll see how to stave off frustration in the case of a crash or lost work by using Blender's autosave feature to recover your work. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step ins...

How To: Use Blender 2.5's external drag and drop feature

In this quick Blender 2.5 video tip, you'll see how to use the new external drag and drop functionality recently added to Blender. This feature enables you to drag and drop images and videos from your operating systems file browser into Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from...

How To: Make a PSP Pandora's Battery and MMS with PSPtool

Hacking the PSP is a complicated process, and there has been some demand for a software tool that would make the process easier. This video has that solution. It explains how to use a program called PSPtool to create the magic memory stick and Pandora's battery much more easily than you could otherwise. Follow these instructions and play those homebrews!

How To: Create an animated comedy title sequence in Cinema 4D

This Cinema 4D tutorial offers a lesson in creating a very fast and easy comedy title sequence using MoGraph, MoGraph Spline Effector and a bit of compositing in After Effects. 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 free video software tutorial. For more information, including detailed, step-by-step instructions, watch this 3D modeler's guide.

How To: Secure or find your Android smartphone if you lose it

If you've spent a ton of money on your newest smartphone, you will want to make sure it's secure. In this tutorial from the experts at PCWorld, learn exactly how to activate safety mechanisms on your Android. With these options you can set a complicated passcode (so that anyone who does find your phone won't be able to access your files) and you can also set up a locator. By using the location app, you can text your phone from anywhere else and set off a search alarm so you will be able to fi...

How To: View details of file inside zip folders in Mac OS X

Ever wish there were a way to get a peak at what's inside a zip archive without having to unpack it? Well, with Mac OS X and Quick Look, there is. And it's easy! So easy, in fact, that this home-computing how-to from Tekzilla can present a complete overview of the process in just over two minutes. For specifics, and to get started previewing the contents of zip archives without expanding them, give this guide a look.

How To: Import, manage & export 16:9 footage in Final Cut Pro

In this video tutorial, viewers learn how to import, manage and export 16:9 footage in Adobe Final Cut Pro. Begin by opening the Log and Capture.Then configure the Logging, Clip Settings and Control Settings. For the Control Settings, set the Device Control as Fire Wire NTSC and the Capture/Input as DV NTSC 48 kHz Anamorphic. Then scroll through the sequence setting of the footage and check Anamorphic. To export, click on File and select Export. Click in Options set the the size to Compressor...

How To: Change the default PDF program on your Mac

In this tutorial, Luke shows you how to change your default PDF reader on your Mac computer. There are various programs that can be used to read PDFs and you don't have to decide on only one. Your Mac is probably pre-programmed to open up the "Preview" application when you click on a PDF file, but if you'd prefer to use something else, such as Adobe Acrobat Reader, there is an easy way to change your default. Check out this tutorial, and set it up in just a few minutes.

How To: Disable iPhoto's auto open when you connect a camera

By default, iPhoto will open as soon as your Mac detects a digital camera or iPhone. In this tutorial, learn how to change your iPhoto settings so that it does not automatically open. The auto open is a good feature, but can be annoying, especially if you are just using your computer to charge your device and do not need to import any files. iPhoto's auto-open can disrupt other activities you may be involved in on your computer. In this video, Luke will take you step by step through the proce...

How To: Fix the battery length problem on a jailbroken iPod

This video demonstrates how to fix the batter length problem on a jailbroken iPod. First, make sure that you have a Wi-Fi connection so you could download the necessary files. Turn your iPod Touch on and locate the Installer icon. Wait until the installer program loads. Then, on the bottom portion of the screen, select the icon Install. In the Packages section, scroll all the way down to letter S and look for Services. Select it and install it. After the installation completes, go back to hom...