Comprehensive Range Search Results

How To: Create formulas with workbook references in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.

How To: Sight in a bow

Ike, from Ike's Outdoors.com gives basic information on Sighting a Bow. He explains a few things he does before he even goes out and shoots. He explains how to line up the site with your arrow whether you are left handed or right handed and then gives pointers on "following the arrow" with the site to get the best results. He recommends shooting at a closer range and with 2-3 arrows before making any adjustments in case of error on your part, and adjusting the site accordingly before moving b...

How To: Use the IF function with letter grades in Excel

This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...

How To: Measure for a tuxedo vest

If you need to wear a tuxedo vest, measuring is something that does not have to be spot-on. It will be adjustable at the neck and waist area. Most vests are offered on a small, medium, large, and extra large range. The chest and overarm measurement that's taken for your jacket might effect the girth or size of the vest, but this shouldn't be much of a problem since its adjustable. Whether or not its a full-back may also effect the fit. Children's sizes are measured on the same basis and can b...

How To: Widen your shoulders & upper back with exercises

In this video from fatlosslifestyle we learn how to widen your shoulders and upper back with a few exercises. This is a workout you do twice a week. First is a dumbbell overhead press. Bring dumbbells up to starting position, turn palms in to face a bit. Keep dumbbells above shoulder lift up. Don't let the dumbbells touch though when you bring them above your head. Repeat this action. Find a weight where the last 3 are difficult in the 12-14 range. The next exercise you need a flat bench. Thi...

How To: Select the right thread count

This link shows a talk with Chase Voelker from fusion who gave detailed information about how to select the right sheet for our bed. He describes about the selection of sheets based on the thread count, tensile strength and fabric hand etc. He had described about these concepts and had illustrated some approved brands of bed sheets. Suphima supreme luxury, Beech etc. are the example of branded sheets. Depending on how we like to sleep we can select sheets of different thread count (400 to 500...

How To: Stretch, shift & reflect the graph of a square root

Professor ElvisZap teaches you how to stretch shift and reflect the graph of a square root. A square root function is the opposite of a squared function. You start with y=square root of (x-1) it becomes 0<=x-1. then 1 <=x. You use the graph and solve it as you would for any function using small values first, then you have y=square root of x - 1, the domain 0<=x. This shifted the graph down 1 unit. 0=square root of x - 1, 1=square root of x, 1=x. Then the range is [-1 + infinity). Continue in ...

How To: Create a dynamic table for VLOOKUP function in Excel

You can use the vlookup function in MS Excel to create a dynamic table in your document. Creating a new dynamic table and a new dynamic lookup area enaables you to add new data or new columns to the lookup table. You can also create dynamic named ranges by using offset, vlookup table and the match table. This function is very useful to businesses working on Excel. This video will show you to create a dynamic table for vlookup in Excel.

How To: Create a table for the VLOOKUP function in Excel

In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Excel Table feature and Table Formula Nomenclature for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup tabl...

How To: Draw a simple flower

This tutorial video shows how to draw a simple flower. The tools used are only a dark colored pencil and a sheet of paper. A recurring technique used by the presenter in this video is to draw the petals first and then add finishing touches to the petals using small strokes.

How To: Interpret a graph

YouTube user NotesCollegeAlgebra teaches you how to interpret a graph. You will learn how to read it and extract information. You go to the graph to see that f(-4)=-2. f(1.5)=2, so it's positive. You then have the question: For what x-values is f(x)<0? You go to the graph and see that you come up with (-5,3). The x-int is (3,0) (4,0). The y-int is (0,4). The domain is (-5,4) and the range is (-4,4). You then have the question: how often does y=7/5 intercept the graph? The answer is 4 times. T...

How To: Sing scales

The Erick Dillard Vocal Clinic gives you vocal lessons in this video. Using a variety of scales, this tutorial will give you a range of different notes that will strengthen your vocals, and enhance your singing. You will start with the more simple exercises, and gradually build up to the more difficult exercises. Accuracy and training your ear is explained. This is a nice tutorial to help you with your singing skills, and it beats having to pay for singing lessons.

How To: Draw with charcoal pencils

Art enthusiast Bob Davies demonstrates how to use charcoal pencils in your drawings. Bob explains that charcoal pencils are useful when you simply want to experiment with a new idea without getting too detailed. What makes charcoal useful is that a wide range of shades, tones, and textures can be produced simply by smudging it with your finger! Bob goes on to show how to draw a quick, simple, yet surprisingly realistic tree using charcoal! This video is a great introduction to an easy, yet ve...

How To: Get six pack abs through bench crunches

Six pack abs are possible, if you put in the time and work. This instructional video demonstrates simple exercises you can do to sculpt your abs. Rememeber, abs don't just happen over night, but stick to it. Llittle can compare with the satisfaction of looking down at your own washboard stomach.

How To: Repair coolant level sensors

Where is the coolant level sensor and how to fix or replace it on a Mercury Sable?? The coolant sensor is located in the coolant reservoir bottle. It cannot be serviced, you can only replace the reservoir. However, if just the sensor is bad, you can also try unplugging the sensor at the coolant reservoir bottle. Unscrew the two screws holding the reservoir bottle in place. With the bottle loose, tilt the bottle slightly toward you until you see wiring coming out of the reservoir bottle, that ...

How To: Grow naturally taller through exercise

Almost everyone wants to be a little bit taller. By following the simple stretches and exercises outlined in this video we learn that it's possible to gain that inch or two simply through straightening your spine and posture, and through overall muscle health. Listing a dozen mostly yoga related positions, ranging from the Cobra position to the Yawn stretch to the Downhill, along with supplying health diagrams for each and every one, this video shows you how to get the most out of your body's...

How To: Boil an egg for soft or hard boiled eggs

This video shows you how to boil different type of eggs, from soft eggs to hard boiled eggs. The first thing you have to do is put water in a pot and turn on the gas range. When the water starts boiling, add one or more eggs. Let the water boiling for 4 minutes if you want soft-boiled eggs. Soft-boiled eggs are good for kids and babies. Break the egg with a spoon and hole the contents of it. If you want medium-boiled eggs, leave the water boiling for 6-8 minutes. Then repeat the process menti...

How To: Stretch your ear gauge using the tape method

Want to wear some awesome ear plugs and be the most unique person walk down the street? Then you're going to have to stretch out your ear holes - and we mean REALLY stretch them out. Since ear plugs come in sizes ranging from the super tiny to even 2 inches in diameter, you'll have to stretch your ear to whatever diameter you prefer.

How To: Tie a winter scarf with stylist Amy Salinger

In this video Amy Salinger 'stylist extraordinaire' shows us how to our winter scarves. Amy knows what she's doing and works with a model in the video. There are several different options in the video and the ties range from complicated to very simple. She says the simpler of the ties will work when you're in a hurry but don't have a lot of time to fuss but there are also funkier options. One option also shows how to tie the scarf with a pin or broach.

How To: Build & stain concrete countertops

Paul Ryan of the DIY Network shows how to make concrete countertops for the kitchen. Concrete is now available in a wide range of colors and textures. First build forms out of 3/4-inch melamine (a waterproof smooth material for easy casting), according to the blueprints. Use caulk to fill the seams and create a rounded corner to the concrete. Clean the form with rubbing alcohol. Mix the concrete according to the instructions, then fill the form with the concrete. Rub a power sander on the edg...

How To: Use HDRI lighting in modo

Devolped by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however,...

How To: Do body weight squats and jump rope for strength

Combination body weight squats and jump rope drills is a great way to warm up for strength and power training. Learn how to perform combo body weight squats with jump rope drills properly from Michael Rosengart, a professional fitness trainer in Santa Monica, California, in this workout tutorial. When performing body weight squats and jump rope for strength you should use full range of motion in legs, alternate to jumping rope and squats. With this how to video you can incorporate body weight...

How To: Build garden benches

A place to sit and relax can add greatly to the enjoyment of your backyard, garden or flower beds. A garden bench is one answer and also a fun workshop project. Garden benches, as seen by the examples here, can range from classic designs requiring a fair amount of materials and woodworking expertise to simple slab benches that require little effort, can be built from scrounged materials and add a “rustic” appeal to yards. In this DIY video tutorial, you'll find step-by-step instructions for b...

How To: Tile a wall

Installing wall tile is basically the same procedure as installing floor tile. And it offers the same advantages: flexibility of design; a wide range of colors, materials and patterns; and if installed correctly, years of durability. Ceramic or porcelain tile makes an attractive backsplash behind sinks and stoves, or encasing a bathroom or shower. It's a strong and easy-to-clean material that offers great decorative advantages for areas exposed to water, while resisting moisture intrusion and...

How To: Become more flexible with yoga

Flexibility is generally defined as the range of motion of the joints. It is the ability to bend and stretch easily without too much effort. Flexibility depends upon various factors like the state of the joints, muscles, length and looseness of muscles, shape of bones, age etc. Some medical conditions like arthritis can affect flexibility.

How To: Do the backbend yoga pose

Backbends shouldn't really be called "backbends", but instead "full body bends" because they involved so much more than just your back. All on its own, your spine has a pretty impressive range of motion, but in order to do a deep backbend, all the muscles and connective tissues that support your spine need to be long and limber. Everyone I know who has an impressive backbend swears by the reclining hero or supta vajrasana posture. Be safe, but if possible, hold this one for a long time.

How To: Take photographs with reflections

This videos will explain how to experiment with ITC and receive images from spirit using water, mirrors, and light. These photography techniques will allow for a great range of experimentation in pictures. Watch this video photography tutorial and learn how to take pictures with reflections, using waters, mirrors, and light.

How To: Create charts in Excel 2007

Check out this tutorial and learn how to create chars in Excel 2007. In Office Excel 2007, you just select data in your worksheet, choose a chart type that best suits your purpose, and click. Want to try a different chart type? Just click again and select a new chart type from a huge range of possibilities. Then work with the new Chart Tools to customize the design, layout, and formatting of your chart. You can see how various options would look just by pointing at them.

How To: Grow Japanese ferns

If you've ever tried to plant in the shady part of your garden, you've probably run across ferns. There are literally hundreds of them to choose from with a wide range of plant form, size and always with a beautiful delicate texture. One of my all time favorites is the Japanese Painted Fern. If you'll take a little closer look, you can see how this plant got its name. This plant looks as though it has been meticulously hand painted. This subtle variegation helps the Japanese fern to stand out...

How To: Use camera stabilization equipment

In this episode, we dive into the expensive, or, at the least, tedious realm of camera stabilization equipment. This ranges from the all-powerful, all-knowing fluid tripod head, to the much used and often abused dolly. We don't own and operate an actual Steadicam or a jib or a crane, but hey, we'll mention them, too.

How To: Install a stage 1 speaker package in a BMW X5

This video series goes over installing a stage 1 speaker package in a '00-'06 BMW X5 (E53). This consists of front and rear speakers (all 10 drivers in the car), rear mid base and rear mid range. Video one starts with the rear door panel removal, two covers front door panel removal - midbass and tweeter installation, three covers installing the rear door panels and the last video covers midrange installation.