Delectable 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: 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: Understand & Use IPv4 to Navigate a Network

You may not know it, but the IPv4 address of your computer contains tons of useful information about whatever Wi-Fi network you're on. By knowing what your IPv4 address and subnet mask are telling you, you can easily scan the whole network range, locate the router, and discover other devices on the same network.

News: Amazon Prime Members Can Preorder the Nokia 6 Today for $50 Discount

While it might be a little past its prime now, the running gag about Nokia phones never breaking was one of the internet's favorite jokes. "If you buy one," they would say, "you'll never need another phone again." I think if those users could see into the future, they'd change their tune, as the Nokia 6 is now available to preorder — and I'm guessing it would give any of Nokia's old bricks a run for their money.

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