Hot Software Posts

How To: Fix Unmatched Song Errors and Duplicate Playlists in iTunes Match

Apple's iTunes Match service is a great feature for people who have large libraries or want to sync their music across a lot of different devices. It lets you store any song in your library that exists in the iTunes Store on the cloud, even songs you imported from CDs, and even improves the quality of some of them. But, like any new service, it's not without its problems, and the fact that it costs $25 a year makes those problems seem even worse. Among the issues that users reported, unmatche...

How To: Create a savings plan that will yield $1,000,000 at retirement in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PMT function to contrive a savings plan that will yield $1,000,000 at the time of retirement.

How To: Use a non-iPod MP3 player with a Mac and iTunes

In this video tutorial, we learn how to use non-Apple, non-iPod MP3 players in conjunction with iTunes. It's easy. So easy, in fact, that this home-computing how-to from the folks at CNET can present a complete overview of the process in just over two minutes. For more information, including a complete demonstration detailed, step-by-step instructions, take a look.

How To: Copy and paste vector graphics in Adobe Photoshop CS5

In this video tutorial, we learn how to copy and paste vector graphics (from Illustrator or elsewhere) within Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.

How To: Use the Ken Burns Effect in iMovie 09

First open up the image by clicking on photo button or just drag the image from finder to the project area. Now click on the crop button or just press the c button, you will see a green and a red area in your picture. Now set the red area to where you want to zoom in and green area to where you want to start your zooming. Now set the green and red area in the picture as showing in the video and play it, you will see that the picture is zooming to where the red area was set. Now change the ima...

How To: Create a navigation bar in Illustrator

First thing you need to do this is to select rectangle tool and make a shape and select the gradient fill and change the angle of gradient to 90 degree. Now color and resize it as showing in the video. Now type your navigation texts like blog, contact, gallery etc. Now size your text for your rectangle shape. Now set the texts in the bar and resize your bar.

How To: Create and use multiple calendars in Microsoft Outlook 2010

In this clip, you'll learn how to create and work with multiple calendars when using Outlook 2010. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating and juggling separate calendars yourself, watch this free video guide.

How To: Add yearly totals from monthly data in MS Excel 2010

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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.

How To: Return and get a refund for a song or App in iTunes

One of the best (for Apple) and most dangerous (for you) features of the iTunes media distribution system is that it allows you to buy things with a click of the mouse that are delivered to you instantly. The potential for making rushed buying decisions that you'll regret later is massive. Fortunately, and not many people know this, you can actually return content that you've purchased from Apple to them for a refund! This video will show you the process for returning and getting refunds for ...

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

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: Model a 3D human head using 3D Studio MAX

An image of a human head can consist of a single penstroke or a thousand polygons. The head model that you will be learning to create in this three-video series leans very much towards the latter. The videos will teach you how to create a 3D model of the human head using 3D Studio MAX from a photo. It assumes some knowledge of 3DS MAX, but not too much, so don't be scared! Watch this baby and start modeling!

How To: Summarize budget data via PivotTable in MS Excel 2010

Learn how to create a summary of your budget data. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started summarizing your own budget data, watch this free video guide.

How To: Model a human hand in Blender 3D

This Blender 2.5 video tutorial offers a demonstration and overview of clean hand topology. The tutorial includes tips on how to structure your mesh, including clean topology, mesh flow and edgeloop density. 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 info...

How To: Get started creating simple 3D models in Blender 2.5

Before you can work in Blender, you'll have to learn how to work with it. Fortunately, this guide will show you everything you'll need to know to get started creating your own models within 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 the folks at CG Cookie. For more information, ...

How To: Render an infinite ground plane in Blender

This clip goes through process of setting up a infinite ground plane with shadows to better display your models within Blender. The tip also looks at a couple of tweaks while using Ambient Occlusion to adjust the shadows. 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....

How To: Use the Adjustment Brush in Photoshop Lightroom 3

Meet the Adobe Photoshop Lightroom 3 Adjustment Brush! Whether you're new to Adobe's popular photo application or a digital photography professional just looking to better acquaint yourself with Photoshop Lightroom 3, you're sure to be well served by this free video software tutorial. For more information, as well as to get started using Lightroom 3 yourself, take a look!

How To: Make a detailed nose model in 3D Studio Max

The nose is the most prominent feature of the face, and cannot be obscured by sunglasses or hats like the eyes and hair. This two-part video will show you how to add detail to the nose of a 3D model of a human head using 3D Studio Max. You have to have a face already for this to really matter, but if you are up to the task of modeling a basic face in 3D, this video will help you make it look a lot better.

How To: Creating data-entry forms in Microsoft Access 2010

Learn how to create data-entry forms when working in Microsoft Access 2010. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using data-entry forms in your own Access projects, watch this free video guide.

How To: Tune a kick drum in FL Studio 9

In this clip, learn how to tune your kick drum using FL Studio 9 on your computer. You will learn how to tune your kicks and make them sound better when played melodically. So, check out this tutorial and try it out on your own version of Studio to start making beautiful music. Rock on!

How To: Use the Hypershade Window in Autodesk Maya 2011

Learn how to use the newely revised Hypershade Window in Maya 2011. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Maya 2011 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the Hypershade Window in your own Maya 2011 projects, watch this free video guide.

How To: Use Excel's SUMIF, RANK & IF functions

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 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...

How To: Create a savings plan with Excel's FV & PMT functions

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll see a lifetime savings plan using the FV and PMT functions and other formulas. See how to calculate how much you will have at retirement from a basic savings plan. Then see ...

How To: Create random basic math problems in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 71st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create random math problems for your kids with the CHOOSE, RANDBETWEEN, DOLLAR and TEXT functions. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Automatically color alternating rows in Excel

This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the shading, the whole purpose is defeated.

How To: Find, replace & sort in MS Excel

In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.

How To: Randomly generate whole numbers 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 17th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the RANDBETWEEN function to randomly generate whole numbers as well as how to randomly assign numbers to employees.

How To: Make an Excel gradebook that removes the lowest score

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 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.

How To: Make a shrinking data validation list 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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.

How To: Create a personal budget based on past data 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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.

How To: Make an invoice from an external product list 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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.