Hot Software Posts

How To: Insert and format a text box in Microsoft Word for Mac 2011

Interested to learn how to insert and format text boxes in Word for Mac 2011? This video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using text boxes in your own Mac 2011 projects, watch the video.

How To: Whiten teeth in the Gimp image editor

In this tutorial, we learn how to whiten teeth in the Gimp image editor. First, open up GIMP and zoom in on the teeth of your image. From here, create a new layer named "white", making sure it's transparent. Now, make sure the white tab is on the top and go to "mode" then "saturation". Select the brush named "circle fuzzy 19". Put the scale around 1.5 or 1.6 and then draw on the teeth, which will make them white! Do this for all of the teeth, then when you save you can use this as your image ...

How To: Create Scarface-style poster art effect in Photoshop

In this video tutorial, you'll learn how to use Photoshop to generate Scarface-style poster art. 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 instructions, watch this free video guide.

How To: Create a full underwater scene in 3D Studio Max 2010

Interested in making the next Finding Nemo? Learn how to model and render a complete underwater scene using 3ds Max 2010 with this video guide. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the application, you're sure to be well served by this video tutorial. Specifically, this clip discusses each of the following topics:

How To: Created animated .gif files in Adobe Photoshop CS2

This two-part video tutorial will show you how to create animated .gif files in Adobe Photoshop CS2. You can still use these directions in versions of Adobe Photoshop, with slight variations. Follow along with these easy steps, and you'll be making animated .gif files in no time at all! For more Photoshop videos, search on WonderHowTo! Created animated .gif files in Adobe Photoshop CS2 - Part 1 of 2.

How To: Measure the spread of a data set with Excel's AVEDEV

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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function and learn how to measure whether a mean represents its data points fairly.

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: Create a table for the VLOOKUP function in Excel

In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Excel Table feature and Table Formula Nomenclature for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup tabl...

How To: Produce a 3D house/building model using Maya

Autodesk Maya, affectionately known as just Maya to its users, is a 3D computer graphics software that makes it easy to create impressive, realistic models of real-life - or imagined - objects. Super useful for graphic designers, film makers and web designers, the program is one that you should study if you're looking to go into one of the fields above.

How To: How to Clone (Duplicate) Yourself Using iMovie 11or 09 (no downloads) Green Sc

Are you an iMovie user looking to double down on yourself? Well, if so, watch this video and see how to clone yourself, quickly and easily. I mean, who wouldn't want to make two of themselves? It could be so helpful for so many situations! Though cloning may be far in the future, we can still clone ourselves in Videos. Apple's new iMovies, have changed from being small easy video processors to a more complex higher quality Video editing software. This video will use the Green Screen Function ...

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: Create a Post-it note in Photoshop

Now, instead of leaving Post-It notes on a monitor screen, you can create virtual Post-It notes in Adobe Photoshop! This is a quick tutorial for the intermediate to advanced user of Photoshop, showing you how to create a square, yellow graphic that looks strikingly like the Post-It notes you can find at office supply stores! Add to your website, incorporate in PowerPoint presentations, or use wherever you see a need for a virtual sticky note!

How To: Stop iMovie from automatically zooming photos

Fix the automatic zooming feature in iMovie with the techniques presented in this tutorial. When pictures and photographs are imported into iMovie for Mac, there is an automatic zoom applied to all the images. This tutorial from TheHowToMac shows how to stop this feature, as well as fine-tuning the Cropping, Ken Burns & Rotation settings.

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.

How To: Create and use Xrefs when working in MAXON Cinema 4D

This tutorial looks at streamlining your C4D workflow, organizing your assets and working with groups. Xrefs can be incredibly useful and as well as helping you to stay organized can also hugely reduce hard drive space used. 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, and to get started using this tr...

How To: Make use of the 3D environment in Apple Motion 3

This clip covers the basics of creating and working with 3D models within Apple Motion 3, discussing a number of useful keyboard shortcuts. Whether you're new to the Apple's popular motion graphics editor/compositing application or are a seasoned digital video professional simply wishing to get better acquainted with Motion 4, you're sure to find value in this tutorial. For more information, and to get started using this trick yourself, take a look.

How To: Create and use band-pass filters in Blender

In this clip, you'll see how to construct a pass filter, commonly called a high-gain or band-pass filter. To do this, you'll use the HSV channels to identify what to do, the RGB curve to make an inversion mask, or negative, so that the image is added to itself, thus evening out the contrast and making a very flat image. This image can then be tiled and used as a seamless texture. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just inter...

How To: Import an object from one scene to another in Maya 7

Learn how to import objects from one scene into another in Maya 7 or later. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with application and its workflow, you're sure to be well served by this video tutorial. For more information, including detailed instructions, watch this free video guide.

How To: Create a credit sequence within Apple iMovie

Learn different ways to create iMovie credits sequences using the titles feature. You can do more than just scrolling credits by stringing along sets of single-name titles or using images. This home-computing how-to from the folks at MacMost will get you off and running. For detailed instructions, and to get started making your own titles sequences within iMove, take a look!

How To: Pitch correct with Antares Auto-Tune in Pro Tools 8

Learn how to use the Antares Pitch correction plug-in when working in Pro Tools 8. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started tuning your own vocal tracks in Pro Tools 8, watch this free video guide.

How To: Work with math equations in Microsoft Excel 2010

Learn how to store, use and manipulate equations in MS Excel 2010. 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 2010, you're sure to be well served by this video tutorial. For more information, and to get started using mathematical equations and formulas in your own 2010 worksheets, watch this free video guide.

How To: Navigate worksheets in Microsoft Excel 2007

Learn how to get get around worksheets 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 navigating Excel 2007 worksheets yourself, watch this free video guide.

How To: Create the "Twilight" text effect in Photoshop

Want to know how to create Twilight-style text using Adobe Photoshop? This lesson will show you how. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from TutVids. For more information, including step-by-step instructions on how to recreate Twilight's cover text, watch this graphic designer's guide.

How To: Use business card examples in Microsoft Word: Mac 2008

Need to make a homemade business card for you new company. Maybe you're about to take freelancing to the next level, a more professional level. Well, Word 2008 for Mac allows you to make your very own, personal business cards, and they give you tons of pre-formatted templates to choose from. You just have to supply the ink and paper. The Microsoft Office for Mac team shows you just how to find and use business card templates in this how-to video.

How To: Calculate bonuses based on years worked 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.

How To: Count Mondays between 2 dates 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.

How To: Create an X-Y scatter diagram chart in Microsoft 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 39th installment in his "Excel Statistics" series of free video lessons, you'll learn about variability (or dispersion or spread). Create an X-Y Scatter Diagram chart showing data points and the mean.

How To: Group duplicates & extract unique records 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.

How To: Make an Excel dynamic named range across multiple rows

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...