Multiple Ranges Search Results

How To: Choose which driving mode to use in the 2010 Prius

In this tutorial, we learn how to choose which driving mode to use in the 2010 Prius. The Prius offers four drive modes: normal, eco, power, and ev mode. To activate the mode, press the appropriate button the center console and the light will appear in the center console. Now, you can press it again to deactivate it if you no longer want it on. The Prius has a driving range of 1/2 mile and can operate at 25 mph using light throttle. If the battery needs charging or the speed exceeds 25 mph th...

How To: Adjust the spring tension on a Tremolo

In this video, we learn how to adjust the spring tension on a Tremolo. First, find the strings in the back that are parallel to the body of the guitar. Then, unlock the nut and set the fine tuners so you have maximum range of adjustment. Start to twist the tuners at the bottom of the guitar until the tension on the strings is enough for you to play correctly. Then, go to the back of the guitar and adjust the crimp screws that are along it. When finished with tightening your guitar, test it ou...

How To: Play "...September Ends" by Green Day on guitar

In this video, we learn how to play "...September Ends" by Green Day on guitar. Start off by placing your ring finger on the fifth fret of the D string, using the very tip of the finger. Place the first finger on the third fret of the B string. When you have these placed, you will start the intro and continue to play. As you move along the song, the chords will stay around the same range but you will need to change the pattern to go slower or faster. When you get to the chorus, change the fin...

How To: Roast turkey with a modern twist

In this tutorial, we learn how to roast a turkey with a modern twist. Use spices and herbs on your turkey and prepare it before you cook it!. First, make sure you find a fresh and free range turkey, these tend to taste the best and are the best for you. You can also use roasted garlic with other spices as a dry rub on your turkey before you place it into the oven. While it is cooking, make sure you apply more spices while it's cooking so there will be delicious spices throughout the turkey wh...

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 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: 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: 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: 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: Use the area type tool in Illustrator

If you want to be serious about using Adobe Illustrator, then learning how to use type is an essential part of your skill set. Type can help you with a wide range of assignments, from designing logos to image building and much more. There are a number of settings and functions when using Type, so it's important to know all of the options that are available to you. This video tutorial will teach you how to use the area type tool in Illustrator.

Beat Mirror's Edge Chapter 1: Flight Part 1/2

This is a video walkthrough for Chapter 1: Flight (PT. 1/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.

Beat Mirror's Edge Chapter 2: Jackknife Part 1/2

This is a video walkthrough for Chapter 2: Jackknife (PT. 1/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.

Beat Mirror's Edge Chapter 2: Jacknife Part 2

This is a video walkthrough for Chapter 2: Jacknife (PT. 2/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.

How To: Do calisthenics neck exercises

Do a light workout to tone your neck muscles. Learn exercises and stretches for your workout routine in this fitness video. Take action: use these drills before work outs, roll neck slowly to warm up muscles, follow full range of motion, and hold head in place while contracting. Tom Clifford, the instructor in this how-to video, has a degree in physical education, fitness and health from Eastern Michigan University, where he ran track and cross-country. Tom has worked as a personal trainer fo...