Multiple Ranges Search Results

How To: Apply a shape shifting technique to your solos one the guitar with Dave Hill

Soloing is something that every guitar player should learn. Being able to solo on command is crucial to being a great professional musician period! If you know all five of your patterns and are still just playing in the box patterns without much movement, then this video will help break you out of your cage! Dave Hill, a teacher at Musician's Institute, goes into great detail showing you how to use a technique called "Shape Shifting" by moving your lines through each of the patterns on the ne...

How To: Use the ISA M327 grenade launcher in Killzone 2

Killzone 2 is the latest iteration of one of the Playstation 3's only reputable exclusive series. It's a great shooter, and has many guns that are well-balanced and each offer distinct advantages. If you want to master the game, you'd better know how to use each one properly. This video will teach you everything you need to know about the ISA M327 grenade launcher, a rapid-fire close-range highly-explosive weapon great for clearing an area.

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: 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: Get bigger biceps by lifting weights

How do you get bigger biceps, the age-old quest for bigger guns. Well, first things first, more is not better. Hefting around 50-pound dumbbells as opposed to 20-pound dumbbells is not necessarily going to build you bigger biceps because what's probably happening, you're probably not using full range of motion, you're jerking a lot, you're not focusing on that muscle alone. Practice lifting weights to get bigger biceps. Learn how to increase arm strength and size in the biceps with weightlift...

How To: Display a user or computer name by the time in the Windows taskbar

There could be multiple reasons why you would want to input a name in the Windows taskbar on your PC, like when dealing with a network of computers, to help identify workstations, or simply for a customized personal feel. With this tutorial, you'll see how easy it is to put your user name or computer name (or any other name) down in the taskbar, right besides the time in the bottom right.

How To: Wear a ghillie suit

In this video tutorial, viewers learn how to wear a gillie suit. Start out by wearing the suit and looking at yourself in front of a mirror. Take a friend with you to the field and have them take multiple pictures of you at various scenes. Have them make notes about what's good and bad about your efforts in the suit. Place some vegetation around the head and shoulder area and position yourself to be unseen. This video will benefit those viewers who enjoy hunting, and would like to learn how t...

How To: Clean your longboard and skateboard bearings

This is a video tutorial describing how to clean your skateboard or longboard bearings. The first step is to put your skateboard or longboard into its stand and take off all four of its wheels. Then put your wheels back on the board and then off the board multiple times. This will help clean all of the debris off of the bearings. You should repeat this process at every wheel. Then take all of the bearings off of your skateboard and clean the grime off of them will and old t-shirt and then thr...

How To: Do an easy cheat on Dead Frontier: Outbreak (09/20/09)

In this video tutorial, viewers learn how to cheat on the flash game Dead Frontier Outbreak. Dead Frontier Outbreak is a new promotional game released on multiple game sites by AdminPwn. It is a text-based zombie adventure game, complete with voice acting. It was created mainly to promote Dead Frontier among gamers who may not have heard of it. To perform this cheat, users simply right-click and select "forward until it reaches the end of the game." Users only need to do this three times. Thi...

How To: Do walkover backbends for stretching

This video instructs on how to do a walkover back bend for stretching. A production brought to you by "Fit For A Feast". The instructors first tell you to lay on your back and turn your palms backwards to be placed on the ground afar from your head. The next step involved equal pressure being used on your legs and arms to create an inverse arch using your back. The stretch is then sustained and released multiple times to complete the task.

How To: Style wavy hair without any heat

Tired of all the damage heat does to your hair ? Well follow along and learn how to get wavy hair without using any heat. Make sure hair is wet. Brush back into a really tight ponytail. Put multiple hair ties in your ponytail, so that your hair will stay straight. Make sure each hair tie is spaced about an inch apart, but make sure it stays super tight. Spritz your hair with hairspray. Sleep with this in overnight. If its too poofy, try doing pigtails instead. There you have it, a simple way ...

How To: Find a common denominator to add fractions

In this video the tutor shows how to add fractions. Fractions are numbers in the form a/b, where a and b are normal numbers. He shows that to add two fraction we need their denominators to be same. If they are not same we need to take their least common multiple and change the fractions so that they have equal denominators. Now the numerators of these fractions can be directly added and the resultant fraction contains this numerator along with the original common denominator. Now this fractio...

How To: Win a two-on-one fight

The three gentlemen in the video show the viewer what it takes to win a 2 vs. 1 fight. They show multiple angles and scenarios for how the fight could pan out, and give advice accordingly. The "good guy" as he is called, informs the viewer on many ways to take out assailants and how to do so in a non-lethal fashion. He goes on to talk about more violent ways of taking out fighters, and to only use such methods in extreme situations.

How To: iOS 13 Makes Bulk-Deleting Emails in Apple Mail Easier & Faster on Your iPhone

One of my biggest gripes with the Mail app on iOS is that it makes it super hard to select multiple emails quickly in a search. For instance, if you want to delete all emails from one sender, it could take a seriously long time to do it the usual way. A bug in iOS 12 and older helped make the process faster, but it's no longer around in iOS 13, but Apple did include a faster way to select multiple emails.