Latest Trending Tech & Gadgets Lifestyle Apple Android

Hot Software Posts

iOS 18 Tips, Tricks, How-Tos, News

How To: Use data forms in Microsoft Excel 2003 or 2007

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 a data form in both Excel 2003 and 2007 as well as how to add a button to Excel's Quick Access toolbar.

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: Create a rough sketch effect in Adobe Photoshop

Have a photo that's not sketchy enough for your taste? Are you maybe just a big fan of Norwegian new wave band, A-ha? Whatever the case, this free Photoshop video tutorial will walk you through how to apply the effect to your own images in Adobe's popular image editing program. Take a look.

How To: Change columns from letters to numbers in Excel 2007

Teach Excel demonstrates how to change the columns from letters to numbers in Excel 2007. The first step is to click on the Office button in the top left part of the window. Next, you click on Excel Options and click on the Formulas tab. There should be a heading labeled "Working with Formulas." The checkbox for R1C1 reference style should be unchecked by default. Check that box and click OK. This changes the column headers from letters to numbers. In order to change back to letters, simply g...

How To: Install Auto-tune in your Audacity audio program

Audacity is a very effective program when it comes to audio and top of that it is free. Download Audacity from its home page, get the newest version because only that one will work with what we need to do. Install it when done with the downloading. Now the first step to installing auto-tune is getting the Audacity VST enabler, you need to need place this right or it will not work, it needs to go into the plug-ins folder in the Audacity installation folder. Now you need to get auto-tune evo fr...

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: Get the T-Pain effect in FL Studio 8

In this how-to video, you will learn how to get the T-Pain effect with Fruity Loops Studio 8. First, open the program. Insert the sound by clicking on the sampler and opening a recording. Next, click the arrow and select assign a mixer track. Select GSnap for the T-Pain effect. Change the settings, which will allow you to get this particular effect. You can also choose the Autotune effect to get this sound as well. Select this effect and set the effect up. You can save the settings with a pre...

How To: Make a CD cover in Photoshop

This video is about how to make a CD cover. First, open up the image that you have. Then, you need an action script. Click on the action's palette and pick which CD cover you want to do. Then you click step one which will run a template for you to set everything up and place your graphic in. The next thing to do is to slide the graphic image on to the template through the select tool. Then, click free transform found on the edit toolbar and just double click the image. The next step is to edi...

How To: Generate random numbers (integers) in Excel

1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...

How To: Extract records that meet certain criteria in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...

How To: Use the IF function with letter grades in Excel

This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use 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: Create a Matrix background effect in Photoshop

First thing to do is to create a new pic image called matrix. The next thing you want to do is to change the width and the height of your picture, as well as the resolution. Pick any background color you want, take the paint bucket tool and fill the background. To get the matrix code, go to Filter, Texture, and then finally Grain. You want to set the intensity to 90, contrast to 50, and grain type should be vertical. To get the grain to be green, you press Ctrl+U, press colorize and drag the ...

How To: Design a car license plate in Photoshop

In this video you will learn how to design how to create a license plate in Adobe Photoshop. To do that that just follow these instructions: Create a new file with 1000x1000 px. Then create a new layer, pick a white color and make a rectangle with the rounded rectangle tool. Use the Rectangular Tool to create a new rectangle on a new layer like in the video. Now color the rectangle and merge the layers. Add the effects for the layers and make a new layer to create the stars for the license pl...

How To: Calculate total savings in Excel

This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches functions that can be used in the Excel sheet, plus useful tweaks and formulas.

How To: Apply the 'Tom Goes to the Mayor' style to an image

This is an animation style which takes real pictures and outlines it to make you look almost cartoon-like. To start with you want to take a picture and get a cut out of the subject with the background transparent. Then get yourself a nice color for the outline and go to filter, sketch, and photocopy. This will look roughly like a colored outline of the subject but then you want to add some more touches by adding detail (usually around 3) and darkness (around 35 is nice).

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: Create Halloween text in GIMP

This video shows the viewers how to create a simple but well done Halloween text in GIMP. Starting from a simple white background you will end up creating a creepy text perfect to use every year on the 31st of October . The video is actually a easy to learn walk through , showing your each and every step you need to make . Advance users but also beginners can benefit from this short clip . At the end of the video you will surely create the type of text you usually see only in horror movies su...

How To: Create trubine blades with the carve tool in Houdini

This video tutorial provides information on how the curve tool in Houdini can be used to create turbine blades. This tutorial shows how compositing can be used in software program to manipulate an image or shape. The tutorial begins with a simple square shape, which can then be carved into a turbine following a series of steps and commands. For artists new to using the carve tool in Houdini, follow the steps in this video tutorial.

How To: Link to a URL in Flash

1. The following Steps shows how to open a URL in a Web Browser, using a Button Click from a Flash Application. 2. Open a new Flash Application and place a Rectangle Shape from Tools and inside place a Text Box and Enter a Text named "URL". 3. Then convert it to Symbol by Right Click->Convert to Symbol and selecting type as Button. 4. Goto Button Properties and Name the button instance as "btnurl" 5. Then in the Action Screen Create a OnRelease() Event function for Button "btnurl" 6. use a me...

How To: Create a studio background in Photoshop

This video by photoshopuniverse shows you how to make any photo seem as it was taken in a studio. Take the working photo and add a new layer over it and fill it in black as shown. Add a newer layer over that and add the filter> render> clouds effect. Increase the opacity of the cloud layer and merge it with the black layer as shown. Add the splatter effect and the sprayed stoke effect as shown onto the merged layer and add a hue and saturation adjustment layer and colorize it as desired. Go t...

How To: Create a cell phone icon in Photoshop

Learn how to create a cell phone icon in Photoshop with this video tutorial. Draw a rectangle of radius 30 pixels by holding shift key. Right click on the toolbar and select Stroke button. It will open Layer Style dialog box. Set stroke color and set size to 2 pixels. Select Stop Color set little light red color and click on OK. Now, check on Inner Color option change size to 4 and Capacity value to about 60%. Now select Ellipse tool which will draw a ellipse and cover half of rectangle. Sele...

How To: Use getURL in Actionscript in Flash

1. This video shows how to use getURL in Flash ActionScript. 2. Create a new flash application and draw a circle with blue color using tools. 3. Place a text box over the circle and enter the text inside the text box. 4. Then make that circle and text box a button object using the "convert to symbol" menu. 5. Then open the action script window. 6. Create a variable named "url" with string value named Wen Arene. 7. Then create UrlRequest object. 8. Then add a button click event listener for th...

How To: Use the sparkline function in Microsoft Excel 2010

There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...

How To: Draw realistic graffiti on a wall in GIMP

This tutorial describes how to create a realistic graffiti effect in a program called GIMP. You must first make sure that you have the font "writers original" installed on your computer. If not, you must download it to create this graffiti effect. Simply open a brick background on GIMP and put whatever text you want to have. Enhance the text by creating multiple layers and create a multi-dimensional image by creating contrast among those layers. Lowering brightness opposite layers and changin...

How To: Add watermarks to your PDF documents in Acrobat 9 Pro

Do you have PDF documents that you want to make sure people know belongs to you? Don't want people to use your PDF documents without permission? Well, this video will teach you exactly how to add watermarks to your documents using Acrobat 9 Pro. The watermarks will stay on the documents, so that who ever uses it will know who the document belongs to. This is very useful in protecting your content from being used without your permission or credit. This is a short 3 minute video, the steps are ...

How To: Use INDIRECT, TEXT, and SUBSTITUTE in Excel

ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.

How To: Make a catalogue picture for IMVU

IMVU is a 3D avatar chat, instant messenger, and dress up game. Get help with all of your IMVU avatar needs with these IMVU tips and tricks! Watch this video tutorial to learn how to make a catalogue picture for IMVU. This will show you all about making your catalogue picture using such programs as Paint and Photoshop.

How To: Convert VHS tapes to DVD with Roxio Easy VHS to DVD

This easy-to-follow video tutorial walks you through steps of converting old VHS tapes to DVD. Roxio Easy VHS to DVD is a combination of software and hardware that allows you to easily and quickly digitize old analog recordings. You simply attach the included hardware to a free USB 2.0 port on your computer, then capture from virtually any analog video or audio source.

How To: Use the color range command in Adobe Photoshop

Some free tricks on how to use the color range command in Photoshop. Many people use the old method of utilizing the magic wand tool for selecting areas of color, the color range selection tool has more flexibility and control. Richard walks you through using this tool and shows some new features added in Photoshop CS4.

How To: Create a simple folder in Adobe Photoshop

Need a little help with your new Adobe Photoshop graphics editing program? Working with Photoshop can be a bit tough if you don't know what you're doing, so instead of getting out the books, check out this 'no nonsense' video tutorial to learn how to create a simple folder in Adobe Photoshop. Photo manipulating and editing is always tricky, so just watch to see how to create a simple folder, for beginners.

How To: Create a spotlight effect in Final Cut Pro

For this Final Cut Studio video tutorial, Zach King will teach you how to create a spotlight effect in Final Cut Pro. To create a spotlight effect, just drag your photo of choice into the timeline, set and in and out point, go to video generators, and use the slug. Then press the red overwrite button. Next, select the clip, go to the Effects tab, go to Video Filters, Matte, and then Mask Shape. Check out the rest of the process in Final Cut. Let the Final Cut King show you how!