Choices Range Search Results

How To: Make cheap DIY blowgun darts out of paper

The blowgun may not be the most en-vogue weapon in the 21st century, but they are still very cool and surprising effective for shooting things with darts at long range. One of their problems is that good dart are hard to come by and expensive when you do find them. This video will show you a way to get around that problem: making your own darts out of paper! All you need is paper (and maybe a little superglue would help) and you can make your very own darts that will pierce object almost as w...

How To: Zoom in and out on a Mac

In this video tutorial, viewers learn how to zoom in and out on a Mac computer. To access the zooming tool, begin by clicking on the Apple menu and select System Preferences. Under System, select Universal Access and check On under Zoom. In Options, users are able to set specific settings such as the maximum and minimum range of zoom. The keyboard shortcut for zooming in is: Option, Command and =. The keyboard shortcut for zooming out is: Option, Command and -. This video will benefit those v...

How To: Create a dynamic frequency table & chart 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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....

How To: Do a yoga flow into a handstand with Tara Stiles

Despite common misconception, yoga is extremely intensive and a challenge for core stability and muscle stability, especially when you encounter poses like handstands. Not easily done by even the most experienced yoga experts, handstands are a true test of your yoga prowess and ability to say "ohm" with two feet up in the air, arms aching and trembling.

How To: Scan and crop images in Adobe Photoshop

Want to digitally restore an old family photograph in Adobe Photoshop? Before you can remove noise and dust, you'll need to scan and crop it. Maximize dynamic range with Photoshop's levels and curves tool. 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 scan and crop images using Ph...

How To: Restore an old photograph in Adobe Photoshop

Want to restore an old photograph? With Adobe Photoshop, the process is easy. Maximize dynamic range with Photoshop's levels and curves tool. 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 repair damaged photos using Photoshop's clone and band-aid tools.

How To: Decorate a credit card holder with duct tape

Most of the duct-tape aficionados out there who are watching this video are probably familiar with duct tapes incredible versatility as a material for making backpacks, tuxedos, and other accessories and clothing items. What many don't realize, however, is the extent of the decorative options made possible by the wide range of colors that duct tape is available in. This video teaches you how to make very cool designs out of colored duct tape and use them to decorate a credit card holder. This...

How To: Look up a picture 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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.

How To: Create horizontal subtotals for a 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 and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.

How To: Build and use array formulas in Microsoft 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Make raw Cantonese style chow mein

Jess Knox from "In the Raw" makes Raw Cantonese-Style Chow Mein. Start by spiralizing (or julienning) butternut squash and making a marinade of 2 tsp tamari (or soy sauce), 1 tbs almond butter, 1/3c water, and 1/2 clove garlic. Combine and put onto dehydrator tray in nest-shaped bunches at 110-125 degrees for 3 hours or until a little crispy.

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: Use the Nerf Gun Long Shot

In this how to video, you will learn how to use the Nerf Gun Long Shot. First, you will need to know about the magazine. These can hold 8 shots and are spring loaded. Do not load 8 shots, as it will jam. Instead, load 6 shots to prevent this. The shots can be used in other guns, but the Long Shot magazine can only use this shots. The holes in the shots make a whistling sound. If you get shot, you will feel it regardless of distance. The gun has a trigger, a mount, a quick grab design, a hidde...

How To: Make St. Louis style BBQ ribs

Babbabooey begins his master piece by introducing the ingredients that are required to make St.Louis style BBQ ribs. He starts with two packages of ribs that contain 6 ribs in each package. He then goes on to describe the special BBQ sauce he uses, and includes the ingredients used to make that sauce. Utensils are needed such as a machete, and two types of probe thermometers. After chopping an onion he mixes it with the BBQ sauce and pours the mixture into a small bread tin.

How To: Validate data & look up values 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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.

How To: Use Excel's VLOOKUP with dates to retrieve the season

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 353rd installment in their series of digital spreadsheet magic tricks, you'll learn how to make date calculations with Excel's VLOOKUP formula (e.g., finding approximate matches and returning a season for a date within a given range).

How To: Count dates within a given month 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 220th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month for a given range of dates.

How To: Automatically create pivot tables in Excel 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 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.

How To: Find the last row or column used in an Excel data set

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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.

How To: Do construction paper weaving with your kids

This is a project to keep your kids entertained. It is also a great way to practice hand eye coordination and motor skills. The materials that you are going to need are; construction paper and something to cut the paper with.Depending on the age of the child you can use 3 colors or more for older children and 2 colors for the younger children. Color choice is left up to what the child wants.To get started take a full size sheet of construction paper. Fold this paper in half length-wise. Take ...

How To: Make self-igniting spell incense

Krazyboytx shows viewers how to make self-igniting spell incense! First you need an incense burner and place your incense in this. You then light this mound and it will ignite itself. One should note that this soap is very thick but it will light. First, to make this incense you need to base which is just sawdust. Next, you can add mugwart in this, or whatever choice you would like to add. Next, you should add in some potassium nitrate or a common name for this is 'peter salt'. For a stronger...

How To: Make a GIF from video in Photoshop CS4

Learn how to make an animated GIF from a video clip using Adobe Photoshop CS4. You'll need to use an external editing program (like Sony Vegas) to create a small clip from your larger video beforehand. From Photoshop, go to "File" and select "Import" and then "Video Frames to Layers" from the pop-up menu and select your video clip. Choose "From Beginning to End" when prompted about range to import. The duration of the video clip will now be displayed in frames. By default, each frame is set t...

How To: Select speakers/mics & adjust sounds in Windows 7

In this video the instructor shows how to select speakers, microphones, and adjust system sounds in Windows 7. To do this, first go to the start menu and select the Control Panel. In the Control Panel select the Hardware and Sound link when the panel is in view by category mode. In the next page click on the Sound link. This opens up the Sound properties setting window. There are four tabs in that window like Playback, Recording, Sounds and Communications. In the Playback tab you will find th...

How To: Make your Sony Vegas video look like film

For various reasons — ranging from lens type to the frame rate to the storage medium —, footage shot with a camcorder doesn't really look anything like what one would see in a Hollywood film. However, with a little bit of work and a touch of post-production, you can make your consumera camera footage look a lot more like a commerically shot project.

How To: Make graffiti using Photoshop

Walagers helps us learn how to make graffiti in Photoshop. First, go to "Select" and click on "Color Range". Use the eye dropper tool to select the color of the background, then press delete. Next, press "alt" and double click on the background layer to convert it to a normal layer. Using the brush tool, select the type of brush you want and the brush's size. Brushes can be downloaded from Brusheezy.com. Use the eyedropper tool to select part of the graffiti. It is recommended to use the same...

How To: Create a stylish text in Photoshop

This video tutorial by tasktutorial shows you how to create stylish text in Photoshop. Launch Photoshop and select the type tool and choose myriad-pro font light. Create a text field and type in the text as indicated. Increase the font size and location as desired. Thereafter open the layer options, choose a gradient and create a new gradient by selecting the color as required. Apply a white color outer glow change the size, range and opacity. If you want to add more text create a new layer a...

How To: Pull of the perfect pre-shot routine in golf

In this video, Tom Leese, Director of Instruction at Angel Park Golf Club, gives pointers for your pre-shot routine in golf. Important in the transition from the practice range to real games, your pre-shot routine helps you get situated and ready to play real competitive golf. Tom explains, first, how to set your lines, taking a straight and purposeful line down course where you want your ball to go, and remaining fixed on it, as you approach your tee. Then, when positioned at your ball, he t...

How To: Improve your chipping game in golf

In this how-to video, you will learn how to prepare for a golf tournament by improving your chipping game. For a high shot, put the ball up in the stance with an open club face. Address the ball with the hands a little bit behind the ball. Through the shot, let the club continue to go while your hands are behind the ball. For a mid-range shot, take a middle stance with a lot less wrist hinge where you are almost right on top of it. For a low shot, place the ball back in your stand with your h...

How To: Draw multiple manga facial expressions

Koizu brings you another lesson in how to draw manga. He describes how he begins with the eyes as guidelines that are used as the base for each facial expression. This immediately begins to capture and illustrate the specific expression for which you are going. Multiple facial features are illustrated in the manga style of drawing and range anywhere from angry to happy and beyond. This video will definitely either teach you how to draw the facial expressions using simple features or help you ...

How To: Catch walleyes

Know what walleye eat. Walleye eat smaller fish, such as minnows or shad, so lures that imitate fish, such as spoons or thin-minnow crankbaits are good choices. Walleye also will eat nightcrawlers, insects and leeches, although artificial forms of these baits usually are not as productive.