Altered Range Search Results

How To: Do ultrawide pushups for a big chest

In this tutorial, we learn how to do ultra wide pushups for a big chest. A basic pushup can be way too easy if you are an experienced body builder, but you can do different variations to strengthen your body further. First, get down on the ground and place your arms much wider outside of your body than they normally would be. This will make you push harder up while your hands are pushing outward. This will make you work hard and squeeze at the same time, and your range of motion will be limit...

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Sum values after a deadline in Microsoft Excel 2010

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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

How To: Film skateboarding

In this video, we learn how to film skateboarding. First, get a camera that fits your price range and you will be ready to start filming. Next, use a long lens so you capture the best shots of people on their boards and in motion. Next, make sure you capture the lines that the skateboarder is skating on. Use different angles to get the best shot possible. You want to get close to the action, so you will need a fish eye lens. Use your skateboard to follow the skater around. Using these simple ...

How To: Make budget summary tables that add by month 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 642nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budget summary table that adds by month and payee. See the benefits and drawbacks of the SUMIFS & EOMONTH functions method or the PivotTable method. Also learn about the Excel Table feature for adding dynamic ranges.

How To: Perform a general shoulder exam on a patient

In this video lesson for doctors, you will learn how to do a shoulder examination. First, you'll get a review of the procedures for evaluating any joint, and then jump into the basics of inspection of the shoulder, then learn palpation, and range of motion. This is a very general shoulder examination, meant to serve as a refresher course for those medical doctors or medical students who already know the exam procedure.

How To: Use Adobe Photoshop CS5's HDR features

With Adobe Photoshop CS5, it's easier than ever to work with HDR or high dynamic-range images. This video tutorial presents an overview of some of the bigger enhancements. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial. For more information, and to get started taking advantage of Photoshop...

How To: Do basic statistical analysis 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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:

How To: Become more flexible with exercise

In this how to video, you will learn how to become more flexible. This refers to the range of motion you can attain around a joint. This can be useful for keeping your body fit and becoming a better lover. You will also be less prone to injury. You will also get slimmer. The best time to do this is after a workout. Hold each movement for ten to fifteen seconds. Although you may feel a pull in the muscle, do not stretch to the point of pain. Yoga and Pilates is another away to increase flexibi...

How To: Use new features for photographers in Photoshop CS5

Whether you're new to Adobe Photoshop or a seasoned digital photographer after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. New Photoshop CS5 helps you achieve the visual and emotional effects you’re after with re-engineered features for reducing and adding grain, performing post-crop vignetting, and sharpening. CS5 reinvents HDR imaging with Exposure Merge, which makes it easy to preserve the fu...

How To: Draw a mountain landscape using charcoal techniques

Drawing is an excellent exercise for the brain that also lets your mind wander. This video tutorial demonstrates how to draw a serene mountain landscape using charcoal techniques. Begin with a simple sky and mountain range, then add trees and a beach. Pencilling in water will help to bring the trees to the foreground. Finally, add shadows and a waterfall to provide a sense of depth to the entire rendering.

How To: Change a person's hair color in Photoshop

Photoshopuniverse will show you how to change a person's hair color in PhotoShop. You can achieve this by using hue and saturation adjustment layers and set to colorize. Set the saturation to about 50%. Go back to the background layer and select the color range select parts of the hair color, select the parts of the hair you want to change and with the eye dropper click it. Once the selection is made invert the selection the color will change. You can now change the hue to make it what you want.

How To: Apply a Marlene Dietrich 1930s inspired makeup look

Fashion Face shows us how to create a 30's all over face look inspired by Marlene Dietrich. To create this look you will need full coverage foundation, concealer, a range of matte eyeshadow from taupe to brown, eyeshadow brushes, brow highlighter, mascara, liquid eyeliner, false eyelashes, pressed powder, beige contouring powder, powder and contouring brushes, highlighting powder, red lip liner and red lip cream or gloss. Specific brands are used and suggested, but you could create this look ...

How To: Practice a pump fake & pivot with Kobe Bryant

Learn how to do the Kobe Bryant pump fake & pivot! This is another Nike Signature Move from NBA Laker MVP Kobe Bryant. Get in triple threat position. Jab step, drive by, pump fake and then pivot. This is a mid-range game for when you have an aggressive defender. Show him the ball, step through for a drive. If the defender is close left pivot around in a pirouette. Take the shot or you've got the teammate.

How To: Practice running drills on a track

These are great running drills by Lauren Fleshman! They're useful for runners both sprinters, hurdlers and long distance runners. She talks about body position, range of motion, posture and gait. The karaoke drill is a sideways drill. The high knee drill is to recreate the perfect running position by using a knee lifting skip. It freezes your body frame in proper position and exploding with your back foot off of the ground.

How To: Extend and customize an ASP.Net server control

In this video tutorial, Chris Pels will show how to extend a standard ASP.NET server control and customize it for a specific purpose. Specialized controls provide an convenient way to implement standardized user interface elements for multiple web sites for individuals or teams of developers. In this example, see how to extend the DropDownList control to create a special purpose year selection control. Learn how to add properties for custom attributes that control the behavior of the range of...

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: 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).