Latest Trending Tech & Gadgets Lifestyle Apple Android

Hot Software How-Tos

iOS 18 Tips, Tricks, How-Tos, News

How To: Use the Advanced Filter tool to extract data in Excel

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 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:

How To: Match text substrings with an array formula 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 321st installment in their series of digital spreadsheet magic tricks, you'll learn how to match text substrings with an array formula that uses the AND, ISNUMBER and SEARCH functions.

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: 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: 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: Force text to flow around an object in QuarkXPress

Do you want to include an image in your Quark document? In this QuarkXPress video tutorial you will learn to use runaround for formatting. Learn how to add a custom padding shape, and format text around an image. Make sure to hit "play tutorial" in the top left corner of the video to start the video. There is no sound, so you'll need to watch the pop-up directions. Force text to flow around an object in QuarkXPress.

How To: Generate random numbers (with decimals) in Excel

This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...

How To: Create a Tangent Line with Excel

Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.

How To: Hide scroll bars, sheet tabs & charts in Excel

This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook.

How To: Generate realistic clouds with the GIMP image editor

In need of a sunny, blue sky? Generate one in GIMP! Whether you're new to the GNU Image Manipulation Program, GNU's popular free graphics editor, or a seasoned designer just looking to pick up a few new tips and tricks, you're certain to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started making realistic clouds in GIMP yourself, take a look.

How To: Update inventory records by formula 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 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).

How To: Remove Vocals from a Song in Pro Tools

If you need to remove vocals from a song in Pro Tools first you need to open Pro Tools and load the song. First, you need to split this track so go to Track and click split to mono. Now, mute this first track. Next, you want to remove the stereo by panning each the bottom to 0. Now, flip the phase by going to the bottom clicking EQ plugin. Now the vocal is pretty much gone.

How To: Retrieve the name of a lowest-bidding vendor 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 283rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, MATCH and MIN functions to retrieve vendors name when they have made the low bid.

How To: Create glass material in 3ds Max

Dave shows you how to produce a glass three different ways in 3ds Max in the video tutorial. Put two panels away, then concentrating on sensor one press m on the keyboard to bring up the materials editor. On the material editor go to the first sphere, choosing a slight blue color, bring up the specter level, bring up the glossy level, click on two sided and bring down the last two to about four. Look to see it is fairly transparent, in a test window. This is glass one, put on hide. Go to glas...

How To: Change an object's color in Photoshop using magic wand

Use the "Magic Wand" tool to select the color you wish to change. The next step is to open the replace color box. Go to Image > Adjustments > Replace Color. After the Replace Color box is open, you may have to select the color that you want to change in the image. Sometimes, it will automatically select the color you're changing, but sometimes you will have to use the Eyedropper Tool and click a hue of the color you wish to change. After the color is selected in the "Replace Color" box, you c...

How To: Make a scroll bar in Dreamweaver

Down, down, down! Yep, what you want is lower on the page and you want to get there faster. SO, why not scroll baby scroll! Ever wanted your website to have a scroll bar? Well, now you can by watch the following video. This how-to will show you how to use Dreamweaver to insert a scroll bar to allow for easy navigation for your or your client's website. It's not too hard, so follow the bouncing ball and learn what to do.

How To: Create perspective text with a drop shadow in Adobe Photoshop

Even people who are new to using Photoshop will be able to understand this simple tutorial. Take a piece of text (a single word, a heading or even a whole line) and then apply a series of effects to the text to give a perspective look. Then apply the drop shadow effect for a little greater depth. This is a great look for a logo or any piece of text you want to draw attention to!

How To: Calculate stock value based on the value of future dividend cash flow 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, the 61st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock based on the present value of a future dividend cash flow.

How To: Simulate the texture of canvas in Adobe Photoshop CS5

In this tutorial, you'll learn how to create a realistic canvas texture within Adobe Photoshop CS5. 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 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: Soften skin, control color & tones in Photoshop CS4

Learn about skin softening techniques and the controlling of color and tones when working in Adobe Photoshop! Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started managing skin tones in Photoshop yourself, watch this designer's guide!

How To: Use autotune on Garageband

Yes, you can use GarageBand's Auto Tune to sound like T Pain and Kanya West. To start with, in GarageBand, click the plus sign in the bottom left hand corner to create a new track. A window will pop up, Real Instrument Track should be selected by default. Click the Create button. In the Track Info window check to make sure your Monitor is set to On. In the bottom left hand corner, click on the button with the scissors in the middle of the sound wave. This is the Edit Track button. Click on Ad...

How To: Mount an ISO with Daemon Tools in Ubuntu

Askabouttech shows how to mount an ISO with Daemon tools using Ubuntu. Right click on Daemon Tools in the tool bar and select "virtual CD rom". This will bring up a side window in which you will click "device". This will open another side window where you will click "mount image". This will open a new window. Make sure you're looking in desktop and open the Ubuntu ISO file. This should open up a new window where you have the option of running it or viewing the files. When you're finished, fol...

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.