Hot Software How-Tos

How To: Rearrange parts of a text string 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 190th installment in their series of digital spreadsheet magic tricks, you'll learn how to rearrange three parts in a text string (e.g., last, first, middle name) using the RIGHT, FIND, LEN, & LEFT functions in one formula.

How To: Count words separated by commas 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 289th installment in their series of digital spreadsheet magic tricks, you'll learn how to count words separated by commas using the LEN & SUBSTITUTE functions in a formula.

How To: Solve pan and crop problem in Sony Vegas Movie Studio

This video is all about pan and crop in Sony Vegas Movie Studio. There are two video clips and the top clip is to be put into the other clip as in this case. First of all select the pan and crop button and the pan and crop window appears on the screen. From the window that appears, select the zoom option and then change the zoom so that more of the screen can be seen. Make sure that the preview window is shown in the side. It is useful to change the size of the event pan and crop. Sometimes t...

How To: Find confidence intervals without the sigma in 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 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...

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: 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: Create a sudoku puzzle in Excel with 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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.

How To: Remove stains, dirt and discoloration in Photoshop

Want to touch up an old printed photograph? 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 the folks at Britec Computer Systems. This video offers a step-by-step guide on how to get rid of unwanted stains, dirt and discoloration using Adobe Photoshop.

How To: Make an animated GIF in Windows Movie Maker

SchizoFilms brings the viewers instructions on how to make an animated GIF in Windows Movie Maker. First open up Movie Maker. You will need to import pictures. To do this, click the button on the top left of the screen that reads 'Import Media'. Find your files here and import them into Movie Maker. Now, you will want to order the pictures in the sequence you want them to show up in. To do this simply drag and arrange them. Now, you can make adjustments for how long you want each to run by dr...

How To: Make an image strip using FastStone Image Viewer

In this tutorial, we learn how to make an image strip using FastStone Image Viewer. First, open up the images that you want to have inside the strip. Then, open up Fastone Image viewer and find the location of the images. From here, go to "create", then "image strip builder". This will bring up the builder window where you can add in the images you want to see on the strip. When finished, click on the "create" button. Now, the strip will come up on your computer in a new image and you will be...

How To: Summarize survey results with a pivot table 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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize survey results with a pivot table (PivotTable) or a formula. See how to create a Pivot Table in Excel 2003 or 2007.

How To: Change a person's sex in an image editing program

Want to change someone's sex in Adobe Photoshop—making a boy look like a girl or a girl a boy? This clip will get you started. 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: Set up pagination in Adobe InDesign

Get your numbering straight with Adobe's InDesign and this helpful tutorial, showing you what you need to know. It's essential when creating a project for yourself or a client, to get your numbering right the first time. There is no second chance. So, check out the steps and see how to turn this sometimes tricky task into a much easier one. InDesign offers a lot of options, and if you're going to master all it's tricks, watch this how-to to learn one of the most simple and essential tricks.

How To: Generate a dynamic list from a table in MS 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 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...

How To: Create an old faded newspaper effect in Photoshop

The video is about how an old stalled photographic image with faded backgrounds to a normal image. A nice clean digital image is taken and is mixed with a texture of a paper and produces a final composite image of all effects combined. The procedure is not that difficult but it needs to be followed in a proper order. First the paper texture is taken as a base and then the clean digital image is dragged onto this texture. The blending mode is adjusted from normal to multiplied blending mode, w...

How To: Create a water shader in Maya

In this tutorial you will learn how to create a pretty decent looking water shader in Maya without many nodes. Water materials are a great and fast way to get around creating real 3D water effects so watch this Maya tutorial and create your own water shader.

How To: Show file names in the Sony Vegas timeline

Use this simple tip to automatically show file names of all elements in your project's timeline. 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: Randomly generate 1s, 0s & blanks with Excel's CHOOSE

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 392nd installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly generate 1, 0 and blank values with the CHOOSE, RAND, RANDBETWEEN and INT functions.

How To: Add movement to your still images in Final Cut Pro

In this how-to video, you will learn how to add movement to still images using Final Cut Pro. Click on the view mode button in the canvas window. Set the mode to Image and Wire Frame. Move the canvas play head to the clip you would like to affect, and select the time line. To control the scale, grab the corner to shrink or enlarge. Reposition the clip by clicking on the image and dragging it around. To rotate the clip, move the mouse over the edge and click and drag it to spin it. Select the ...

How To: Use the opacity feature in Final Cut Pro

Plangere Culture Lab demonstrates how to use the opacity feature in Final Cut Pro. The opacity feature is a beneficial tool to use when working with layers. Opacity is an attribute which relates to how much you can see through a clip. To layer clips, create a new video track on the timeline. Make sure that the source tab is in the right position. The track on the top of the stack is the dominant track and will be shown. Select the volume and opacity overlay button. Click on the line over the ...

How To: Give someone a shave in GIMP

In this Software video you will see how to give someone a shave in GIMP. Learn spot removal, skin smoothening and a makeover or removing a 1 day beard. This is done using the Clone and the Healing tool. To use the Clone tool, select the tool from the right hand panel. Then to select the source skin color, you have to hold ctrl key down and click. Now when you apply it to the area you will get the same shade of the source color. So, you will need to select an area very close to the spot you ar...

How To: Draw realistic eyelashes in Photoshop

This video demonstrates how to draw eyelashes using Adobe Photoshop and a graphics tablet. You need three tools to draw eyelashes: Soft Round Brush, Smudge Tool, and Eraser. Create a new layer. On the upper eyelid, draw each eyelash with Soft Round Brush (color: black, width 17px, opacity 100%). Use Smudge Tool (width 45 and straight 25%) on the eyelashes to straighten them. Use Eraser (width 65 and opacity 100%) if necessary. Create a new layer and use the same tools for the bottom of the ey...

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Make swooshes & swirls in Illustrator

The first thing to do is open a new document with Adobe Illustrator. Inside the document, make a box, width 200 pt, height 20 pt. Click the bottom right corner with your mouse and hit delete. Then hold down the top right with shift, and tap the down arrow once. Then, click bottom left point, hold shift, join the objects by half. Go to brushes pallet and create a new brush. Click the spiral tool. Use the up and down with the mouse to select range you would like. Select the art brush, and click...

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: Make a pulse or pulsating wave effect in After Effects

Making really attractive titles for your films is just one of the way that you can dramatically improve them using After Effects. This video will help you make them by showing you how to create a pulse or pulsating wave effect from whence your titles can emerge. They look great, and will make your movie (especially horror or sci-fi movie) look much more professional right from the beginning.

How To: Fill in missing column values with Excel's IF 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 605th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function to fill in column with missing values then use Paste Special Values to create the final column with correct values. Also see three methods for Paste Special Values.

How To: Use Live Trace in Illustrator CS2

Live Trace is the hot new automated tracing capability of Adobe Illustrator CS2. In this Podcast Terry White will show you how to take a logo that was created in Photoshop CS2 and trace it using Live Trace. Because Live Traces are “Live" we’ll be able to tweak the settings to get better results.

How To: Use the Clone Stamp and Blur tools in Photoshop to remove straps and tanlines

So you have a great photo of a girl in a bikini, but you want to get rid of some of the straps and tan lines in the picture. Fortunately, Adobe Photoshop has the tools you need to accomplish this! The video below is a tutorial that shows you how to use the Clone Stamp and Blur tools to get rid of things like tan lines, bra straps and bikini strings. Some familiarity with Photoshop is recommended before trying this.

How To: Increment numbers in formulas 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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.

How To: Extract records with 2 criteria with Excel's AGGREGATE

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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...