Altered Range Search Results

How To: Make a Petal Pillow

Do you ever get overwhelmed with how many beautiful things are out there? Do you want to be able to alter your home's aesthetic with your mood or the season? A great solution for this is making your own pillows. In this tutorial sewing and fashion video, you can learn how to make petal pillows in a lush, feminine fabric. These marvelous pillows will make your apartment or couch look amazing.

How To: Make an Excel dynamic named range across multiple rows

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...

How To: Find range and interquartile range in Microsoft Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 40th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate range & interquartile range for variability using the MAX, MIN, QUARTILE functions.

How To: Use a formula to find the area of a parallelogram

This video shows us how to use a formula to find the area of a parallelogram. The formula for finding the area of parallelogram is the same as finding the area of rectangle or a square which is equal to length time’s breadth. But the parallelogram looks a bit different and the parallelogram is basically a rectangle but it is not at right angles. If you draw two altitudes then it is a rectangle with two triangles and if you cut one of the triangles and paste it next to another triangle then we...

How To: Use spell Florida water

Krazyboytx shows viewers how they can use spell Florida water. You can use Florida Water to cleanse your alter and for your candles. First, you will need a camfur block. Use one of the four pieces of the camphor block and put this piece into a zip-lock bag. Crush this camphor block up into the zip lock bag to get small crystal pieces. Fill up your bowl as much as you can with one block. Next, pour in some of your Florida water up to about it covering the stones. Put this on your alter until i...

How To: Stop procrastinating by altering your daily routine

This video shows us how to stop procrastinating by altering your normal routine. One way – to start with – is to understand why you procrastinate at all. Some people think that what they do is going to be judged on who they are. Some people think that they have to do everything perfectly. One of the most important things that you can do is make a schedule and then stick to it. Also you can practice the ‘good enough’ principle – realizing that you don't have to do it perfectly and that you are...

How To: Use the rattlesnake knot, square braid and other paracord braiding techniques

Paracord braiding is a popular technique used to make lanyards and ties for survival gear. There are many different techniques a braider can use - the most common are the rattlesnake knot and the square braid. This video shows you the nuances of both techniques, a few variations, and how you can decide when to use one or the other. You can also alter the appearance and tensile strength of your paracord braid by changing how tight you make your knots.

How To: Sort files into folders using Automator on Mac OS X

With OS X, you can use Automator to automate several functions. This nifty little how-to by macmost shows you how to sort files into sub-folders using Automator. You can use Automator to alter what happens when a file is added to a folder. In this example, new files added to a folder are then sorted into subfolders according to their type. You can add multiple actions to a folder and then determine which order they are used.

How To: Create Lea Michele's 2010 Emmys makeup look

Lea Michele, who plays perfectionist and super-talented singer Rachel Berry on "Glee," is quite unlike her school girl outfit-loving television alter ego. In fact, on the red carpet she's a big fan of sultry, sirenish makeup looks with winged liner, red lips, and big, voluminous hair.

How To: Customize your Safari toolbar

In order to customize your Safari tool bar, you can alter your buttons. All you have to do is click on "view" and "customize tool bar". Select a button that you like from the 2 rows in display. Then, click on the button you would like to add to your tool bar and drag it to your tool bar. You can use buttons as shortcuts to go back and forward, with the back and forth arrows and to take you to your favorite sites, with "top sites".

How To: Create a simple scrolling LED display in After Effects

This simple After Effects tutorial from Laurence Grayson will show you how to use CC Ball Action effect in AE to create a realistic scrolling LED signboard effect, like the ones you see at conference centers and football stadiums. Then end result can be altered to suit your project, and corner-pinned into a scene. There are no plug-ins required, and this method uses the standard toolset in CS3, CS4, and CS5.

How To: Make easy crepes from scratch with Jenny Jones

In this clip, learn how to make homemade easy crepes at home. Jenny Jones will show you exactly how to make these delicious flatbreads that can be eaten with anything from chocolate and fruit to meat and veggies. Jenny will also show you how to alter the ingredients to make them healthier by choosing the right oils and whole wheat flours. It's as easy as 1, 2, 3.. what will you put in your crepes? Enjoy!

How To: Resize and alter your window on a Mac

The window on a Mac computer can be confusing if you are used to using a Windows computer. You will learn how to resize your window by clicking and dragging the lower right side corner. Clicking on the green button will not completely maximize the window it will only make it as wide and tall as you need so there are no scroll bars. You will learn many more basics on a standard window so that you can navigate like a pro.

How To: Perform a digital nose job in Photoshop

This Photoshop tutorial on performing a nose job using Photoshop contains detailed instructions on the use of Photoshop tools to, depending on taste, enhance the appearance of an individual. The person narrating the tutorial specifies the necessity of subtlety with the modification of the picture in order to remove any appearance of modification. The way described is essentially to select the general nose area, feather the selection by an optional amount, and set it in a separate layer. Then ...

How To: Correct white balance in Photoshop

This informative video tells you how to use the variations panel in Adobe Photoshop to correct color issues in your photo. Too much yellow in your picture? Learn how to use the variations setting to instantly fix this with the corresponding opposite color. With simple clicks and easy preview-able pictures, you can correct color over-exposures with a click of the mouse. First go to the Images drop down and select the variations option. The original photo on the top can be clicked to revert you...

How To: Create a ghost effect in Photoshop

To manipulate photos and turn someone in a photo into a ghost, there are several filters that can be used in Photoshop. This video takes us through the steps of how to take an ordinary picture and turn the subject into a supernatural being using the motion blur technique and the diffuse glow filters among others to alter an image. The best types of pictures to use are ones where the background is relatively dark. By following these simple steps in Photoshop, you can turn anyone in an ordinary...

How To: Remove red eye with the channel mixer in Photoshop

If you or someone you know has light eyes, then you are no stranger to red eye sneaking into your photos. Red eye is an annoying addition to most photos taken with a flash camera. Luckily, if you have Photoshop, this is easy to fix. With this tutorial, learn how to use the Channel Mixer tool in Photoshop to edit your prints, and make it look like the red eye never existed. None will be the wiser when you display these altered photos. Using the channel mixer is an all time classic red eye remo...

How To: Master the use of vanishing point filter in Photoshop

Photoshop can be a confusing program, especially with all the different settings and effects you can tinker with. Learn to master the vanishing point filter in this fun, easy to follow tutorial with the Pixel Perfect team. Clean up your pictures and smooth over any unwanted imperfections as he takes you how to make them "vanish" with the program. Alter the perspective of an image and add it on to another and change that cloudy day into a snowy background. Each step is carefully explained with...

How To: Fold an origami orchid

Learn how to make an origami "orchid" by slightly altering an origami iris / lily flower. This origami video shows how to make what I call an orchid flower... really it's something I made by mistake when first learning to make an origami lily / iris. You'll need to start from the frog base.

How To: Do the dance for Miley Cyrus' "Can't be Tamed"

In her music video for "Can't Be Tamed," Miley Cyrus pushes the bar past anything her pop star alter ego Hannah Montana would have ever dared to do. With feathery lashes, heavy cat eyes sparkling with aqua shadow, wings, and a $5,000 corset that leaves little to the imagination, Cyrus very officially separated herself from her Disney past.

How To: Solve word problems involving domain and range

See how to find the domain and range of a function implied by a word problem with this free video math lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutor...

How To: Modify a Nerf Longshot CS-6 gun

Nerf guns are a great way to battle without inflicting serious injury. This video tutorial shows you how to modify a Nerf Longshot CS-6 by adding an angel breech and altering the clip to accept stefan bullets. This instructional also shows how to add gun spring reinforcements to insure the weapon operates well under the increased force. Finally, you'll learn how to integrate the front gun and link the trigger to the main Longshot spring mechanism for added fire power.

How To: Blur out a face in your video using Wax 2.0

Watch this video and learn how to protect your identity on the internet. This clip will help you learn how to blur out your face and alter your voice when posting videos on the web, where your identity is an important secret. Stay anonymous while portraying your opinions. This software can also be used to avoid release issues with strangers in the backgrounds of your videos. Preventing passers by from having there picture posted with your opinions opening you up for legal action. This can als...

How To: Beef up your bass sounds in Reason 4.0

If the bass sounds in a song need to be amplified, learn how to beef up the bass using Reason 4.0 with this video tutorial. Nick from PrimeLoops shows how this process can be done first by creating a copy of the bass patch that can be altered with a filter and reverb. This new sound can then be mixed back into the original bass sound. Nick shows step by step what to do in Reason 4.0 to create the desired effect.

How To: Create super saturated color images in Photoshop

This Adobe Photoshop CS3 tutorial teaches you how perform slight photo retouching to supersaturate a photo without the distortion and bleeding. This adds a slight but noticeable saturated look of a photo which enhances the color quality. First the graphic artist adjusts the saturation. Then he creates a version copy using the lab mode versus the RGB mode. He then adjusts the contrast of the Lab mode image. Once you return the photo back to the RGB mode, you can continue altering the photo.

How To: Blend color in images in Photoshop

Simon Plant of ProPhotoInsights.com shows how to use Photoshop to blend colors in images. He uses a photo of his son standing in front of Stonehenge to take us through each layer of the photo to alter the levels of hues, saturation, and opacity. The key to blending colors is a matter of playing with different hues and saturation levels in Photoshop to get the subject in the foreground to match the background. Follow Plant's thorough tutorial to find out how to get professional looking photos ...