Latest Trending Tech & Gadgets Lifestyle Apple Android

Hot Software How-Tos

iOS 18 Tips, Tricks, How-Tos, News

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: Make HD/1080p videos for YouTube in Camtasia

This video lesson will show you how to make HD/1080p videos for YouTube in Camtasia. The simplest way to make this is to record your video in 1920x1080 resolution and render it in that setting. That’s all that you need to do. But, if you have a smaller screen resolution and can’t get 1080p, you can use Camtasia Studio to convert it to 1080p. first add your media to the timeline and change the width to 1920 and the height to 1080 click OK and then close the box. In the preview, you will see th...

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: Install ISO game files with the use of Daemon Tools

In this video, the poster is teaching YouTube users how to use Daemon Tools mount games image files. That’s very useful to many people that cannot burn ISOS or any other image files into a blank media (CD, DVD). With the tips provided by this video, anyone can use Daemon Tools to mount the image in a virtual CD/DVD drive. Daemon Tools is a Freeware program and you can download it at many websites on the internet.

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 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: 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!

How To: Make boobs bigger in Photoshop

One of the most suggested topics on youtube for Photoshop is enhancing breast size. Sending an image to someone & need to alter it? Want your boobs to look bigger? Or do you just want to have some fun giving girls bigger boobs on Photoshop? This tutorial demonstrates how to increase breast size using Photoshop.

How To: Change your voice pitch in Audacity

Watch this video tutorial to see how to change your voice pitch in Audacity. Audacity is a digital audio editor application and is free. If you ever wanted to know how to mess with people's voices or song voices, this will help you transform those pitches into whatever you desire.

How To: Use Knoll Light Factory Pro After Effects plugin

This software tutorial shows you how to use the Knoll Light Factory Pro plug-in for After Effects. Knoll Light Factory Pro is the industry's favorite tool for creating lens flares, sunsets, photon torpedoes, stars and other effects. It offers a custom lens editor, auto tracking, alpha channel support, and pinpoint control over dozens of settings. If you haven't used the Knoll Light Factory Pro plug-in yet, watch this After Effects tutorial and get started.

How To: Create a multiuser login system in Microsoft Access

The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a multi-user login form to password protect different areas of your database.