Bigger Range Search Results

How To: Perform a lower extremity exam on a patient

In this medical video, learn the process of examining the lower extremity of the body. See demonstrations of how you inspect the lower extremity, how you palpate and then perform passive range of motion of the hip, knee and ankle. John D. Gazewood, MD, MSPH, will also teach doctors special maneuvers to help examine a knee injury. With any type of musculoskeletal exam, you're looking for things like deformity, swelling, and changes in coloration.

How To: Generate random numbers not divisible by 3 in 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 261st installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random numbers within a certain range and with certain supplementary criteria (e.g., values that are not divisible by three) via the use of large array formulas.

How To: Sing an easy high note

Aspiring singers can learn how to sing high notes with vocal coach Robert Burnley. When you attain an extended range, your vocal chords will stay in place and then your chords will thin, shorten, or dampen allowing you to reach higher notes. This is what occurs physically when you are reaching higher notes. The key is to have the mentality that you are allowing your vocal chords to get thinner or shorter to reach those higher notes. Part of the struggle is not having the right mindset that yo...

How To: Create swirling rainbows in Illustrator CS3

This is all about vector, swirling rainbows. Have you ever seen those looping, swooshing, swirling rainbow graphics used in all kinds of graphics ranging from logos, and sketches, to grungy and retro illustrations? Well, you are going to create one of them in Illustrator. Watch this Illustrator video tutorial to create vectored rainbows. Also, learn how to export it to a program, such as Photoshop, as a smart object, to utilize it as a smart object so we can both retain vector scalability whi...

How To: Automatically color alternating rows in Excel

This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the shading, the whole purpose is defeated.

How To: Create collapsible and expandable cell ranges in Excel

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...

How To: Combine images to create HDR photos in Photoshop

Yanick's Photo School demonstrates how to use Photoshop to make HDR images in Photoshop CS3. This tutorial first explains that HDR means "High Dynamic Range" which is a process to get details from a photo from both the highlights and shadows of a particular scene. The first thing that is necessary is to take multiple views of the same image with different exposures. To start off, you will take three exposures: one that is two stops down, one that is normal exposure, and one that is two stops ...

How To: Cross process your photos in Photoshop

Cross processing is a Photoshop version of slide processing. The result would be you get all these weird color shifts. For reasons best known to people who run the fashion magazines, this look became very popular in the 1990s. Start by adding in a curves layer. Add a new adjustment layer for curves. If you've never used curves before it is recommended that you take a curves tutorial first as for this effect we will need to adjust individual color channels. It is not difficult but if you don't...

How To: Select different items in Finder in Mac OS

In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...

How To: Survive in Minecraft

Minecraft is a game that snuck up on the gaming community and set a wild fire bigger than the ones in California! Even though it's not even done and still in Alpha phase, reviewers are already reviewing it, and people are jumping on board. The game itself is based around a basic concept: survive, craft, build, conquer. You play the only man in the world who starts with nothing, during the day, it's safe and you can mine and harvest material, but at night, creatures come out, including Zombies...

How To: Avoid Injury While Exercising

When exercising at a high intensity, you know to expect some level of pain. That can make it difficult to identify when your body gives you a warning sign of injury. If you pay close attention, however, you can tell the good hurt from the bad. I talked to Dr. Brian Parr again, professor at the Dept. of Exercise and Sports Science at the University of South Carolina Aiken, who explained which symptoms of exercise are normal and which are bad:

News: Everything You Need to Know About the New Samsung Galaxy S5

The Samsung Galaxy S5 was just officially announced at Mobile World Congress. The new flagship device will be available worldwide beginning April 11, 2014, including all major U.S. and international carriers. With over 200 million Galaxy devices sold to date, the S5 doesn't stray too far from the trend, at least not aesthetically. We've still got a high-grade plastic shell with perforated back covers, and four color choices at launch. Our highlights of the release event are as follows.

News: Treat Yourself (Or Someone Else) to Steampunk Sex for the Holidays

A Steampunk's Guide to Sex was the subject of a recent successful Kickstarter campaign, and I now hold the finished book in my hands. As such, I can say (mostly) unreservedly that you should buy this book. Allow me to tell you why, before I get into the nitty-gritty about the book itself. Sex is something of an odd topic in America because it's perfectly legal, and yet taboo. Unlike things that are illegal and not taboo, like drug use, murder, theft, etc. What this means is that children can ...

How To: Enhance your breasts

In this video from TheCurrentCustom she teaches how to enhance your breasts. First she says you need to measure your breasts to figure out the right kind of bra for you. Take the measuring tape below your bust, and wrap around back, and then measure right above your bust. Round down to the nearest even number if you get an odd number. Then measure your bust size by wrapping the tape measure around the largest part of your bust, typically where your nipples are. Then subtract the bust size fro...

How To: Turn Vista into Windows 7 for free

This video demonstrates how to turn Windows Vista to Windows 7 for free. Make sure that you are running your PC on a Windows Vista OS. First, unlock your taskbar by right-clicking on it and unchecking the option. The space where your smaller application icons are located can now be made wider. Re-lock your taskbar once done. You can also right click and select View>Large Icons to make the icons look bigger. You can also download a free application at RocketDock which will make your Vista task...

How To: Make tea (or coffee) and toast with fondant

To start making your tea and toast, roll about a section of white fondant about four inches by six about 1/8th inch thick. Now take a one inch circle cutter and cut out one circle. Now taking a half inch circle cutter, make an impression in the center of the first circle being careful not to go all the way through. Now you have your saucer for your toast. Next, take a one inch square cutter and cut that out of the fondant as well. Cut it in half diagonally and poke tiny little holes with a to...

How To: Lower your blood pressure naturally with Suzy Cohen

Suzy Cohen tells us in this video how to lower our blood pressure naturally. Believe it or not, the urinary tract is connected with our blood pressure. A dietary supplement called "Asparagus extract" is recommended. Asparagus in vegetable form is delicious when served with a little butter or feta cheese. When you take it as a supplement, you get a bigger dose. It is a wonderful diuretic, which means it makes you pee a lot. You should take it in the morning, so that you do not find yourself ru...

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.