In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sort will allow you to be very specific in the way you want your data sorted. You can add or remove a filter with the same drop down menu, in order to be even more precise.
In this video, we learn how to make homemade Kefir Ginger Ale. First, you will need a 2 qt jar of filtered water and add in 1/4 c of honey into it. Mix this together until it's combined and the water is a yellow color. Now add in milk kefir grains that have been soaked in ginger. Next you will add ginger and tumrick that have been chopped up and add into the jar. Also add a squirt of lemon and lime, as well as a piece of coral calcium. Place the top back onto the jar and let it sit for at lea...
Wayne with Vodafone Help Centre demonstrates how to use the application center on a Blackberry Storm 2 phone. First tap on the Blackberry key to bring up the main menu. Then choose the application center option. Click yes to update the application list. Choose app world and install it on your phone by downloading it. Then, click run and accept the software agreement. You now have access to the Blackberry app world. You can search for the applications that you want and filter the results by pa...
In this video tutorial, viewers learn how to make a real flame text in Adobe Photoshop. Begin by opening a flame image in the program and select the text tool. Type in the text and position it over the flame. Now go to Select and click on Load Selection. Once the selection is created, delete the letter. Then select the marquee tool. Right-click above the selection and select Feather. Now create a new sheet and fill it in black. Using the move tool, drag the selection to the new sheet. Go to F...
In this video, we learn how to created a chilled look on a photo using PhotoShop. First open up PhotoShop and open up the picture you want to change. First, duplicate the layer on the photo. Then press "control" then "u" and make the picture blue. Now, click "filter" then "blur" and add a small amount of blur to the photo. Now you can click on "overlay" and you can see the photo change. If you want to make it look more blue, duplicate the layer again and you will see more of a chill factor on...
Clicks are made on "Image",then "Adjustments", followed by "Brightness/Contrast" ; contrast is set to 30 and brightness is set to 60 to add more light to the picture. "Adjustment", "Variations" are clicked in that order and both yellow and red are increased. "Filter", "Render", "Lightening Effects" are chosen in that order and a new window appears; within which the style is set to "Soft Omni". The brightness is decreased ;similar to the way it was increased, and contrast is increased to 60. T...
Robert with Roberts Productions demonstrates how to give your photos depth of field with Photoshop. You can create this effect by having a clear foreground and a gradually blurry background. First, duplicate the background layer. Then, go to filter and select Gaussian blur. Set it to a believable radius like 12 pixels. Create a mask by clicking on the mask icon. Then, make sure the foreground is set to black while the background is set to white. Next, go to the gradient tool and make sure tha...
Before you make that extended camping trek out into the wilderness, there are a few things any self-respecting camper should know how to do. And one of those things is how to safely feed oneself. With this free video guide, you'll learn how to practice food safety when roughing it in the wild.
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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).
Layers are very important component of Photoshop. Without knowing how to use the layers correctly, one can not utilize the maximum what Photoshop offers to designers and digital artists. For a beginner, this video provides a good basic knowledge about Photoshop layers. Layers enable you to arrange different parts of a picture and manipulate them without effecting the content of other layers. Layers are added by using layers panel. Each layer is named accordingly. We can change the order of la...
This video shows you how to make a survival kit: i.e. which things to gather together to make a survival kit. This one fits in the palm of your hand. For this kit, you will need the following: a small cloth bag. It can be used to filter sediment out of water. It can also be used to make a patch in clothing.
How to Use COD4 Cracked Servers.
In this video from sethd85 we learn how to brew coffee with a French press. For this you need coffee beans, a French press, something boil water in, and water (filtered preferred), and a coffee grinder. First boil water. Now use 2 tablespoons of coffee beans and grind them up in a grinder. You want the coffee to be very coarse. Now pour in the ground coffee into the French Press. You want a bit of a gap between the plunger and the coffee grounds. Once the water is boiled, pour the water into ...
In this Software video tutorial you will learn how to apply the Film Look effect in Final Cut Pro. This is an advanced technique. This essentially takes a video and makes it look like a film. Select the video clip that you want to work with. Then select the ‘color corrector 3 way’ filter. This is under the ‘Effects’ tab. The key to any color correction is to crush the blacks. So, decrease the blacks with the slider. Then increase the whites as films have higher white level. Depending on the s...
In this how-to video, you will learn how to crop an image using Adobe Photoshop CS4. First, open Photoshop and open the image you want to crop. Next, press filter and select the edge hollow tool. Carefully draw around the image you want to crop. Once this is done, click on the fill tool and left click in the middle of the image. Now, press preview to see if you missed any spots. You can clean these spots up by pressing the clean up tool. This will allow you to erase these particular spots. On...
Drip irrigation systems in your garden are centered around a long length of pressure compensating drip tubing. The tubing will also need a pressure regulator and a "Y filter" to keep it clear of impurities. When laying the tubing down in your garden, be sure to keep the kinks out of the line. When choosing an emitter for your irrigation system, keep in mind the needs of your particular garden, and choose either a single emitter or one of various multi-emitters. Depending on the size of your g...
In this tutorial, Yanik Chauvin teaches us how to create an old-style looking photo starting from a grayish, underexposed one, using the software "Lightroom". He starts by creating a virtual copy of it, and then he adds a Camera Calibration preset named Camera Landscape and increases the exposure. After that, he crops the image removing the blank parts of the photo, and adjusts Contrast, Blacks and Clarity to strength the image borders.
This Software video tutorial shows how to convert color images to black and white in Aperture. Scott Bourne presents this video. Open up ‘aperture’ program and select a color photo that you want to convert to black and white. Now move from the ‘projects’ page to the ‘adjustments’ page by clicking on it. Then click on the ‘+’ sign and select ‘Monochrome Mixer’. When you do this, the picture instantly turns to black and white. It’s as simple and easy as that. For editing the picture further, on...
In this video tutorial Yanik Chauvin of Yanik's Photo School shares a discovery he made while using the software Lightroom. This quite simple technique of adding hints of color to black and white photos can make them striking. By adding a color screen on top of your photo, using either the adjustment brush or a gradient filter, you can create a lovely conversation piece for your home that will confound your visitors. "Is this photo black and white or sepia or ... what?" He also shows a trick ...
In this video tutorial, viewers learn how to make a metallic wallpaper with a stripped paint effect. GIMP (GNU Image Manipulation Program) is a free software raster graphics editor. This video is very descriptive and clearly explains all the procedures. It provides step-by-step instructions and a visual demonstration for viewers to easily understand and follow along. This video teaches viewers how to use the weave filter and RGB noise, layer modes like abstract, burn and saturation. This vide...
First thing to do is to create a new pic image called matrix. The next thing you want to do is to change the width and the height of your picture, as well as the resolution. Pick any background color you want, take the paint bucket tool and fill the background. To get the matrix code, go to Filter, Texture, and then finally Grain. You want to set the intensity to 90, contrast to 50, and grain type should be vertical. To get the grain to be green, you press Ctrl+U, press colorize and drag the ...
In this Software video tutorial you will learn how to have fun with the’ liquefy’ tool in Photoshop. The video is by Yanik Chauvin. Open Photoshop, select a picture that you want to have fun with, go to ‘filter’ and click open the ‘liquefy’ tool. This video is looking at 3 tools under liquefy. They are Forward Wrap Tool, Pucker Tool and Bloat Tool. These tools can be modified by the brush options on the right hand side. The Pucker Tool reduces the size of a feature on the image. The Bloat Too...
This video shows a user how to create a panoramic picture using Photoshop. In this video the details like how to merge a photo and other options which are very useful to a learner are shown clearly. This video is very practical for keen user as different things like the layouts and merging a photo are explained in detail. In this video a user can find different filters that are used in creating this panoramic picture. One will find it very easy and one with artistic heart will definitely appr...
Adding motion to graphics using Photoshop can create an exciting and dynamic effects. Select a picture you want to add motion to. First, duplicate the background layer. Then under Filters, select blur, and then select Motion Blur. Then you set the angle of the Motion Blur. You can select any direction and also set the intensity of the blur by setting the distance setting. Then you will need select the eraser tool and select under Options select the brush. Chose a soft edge brush and erase ove...
This video was made to help users with disabilities use Windows XP more efficiently in their lives. Starting with entering the control panel the and clicking on the accessibility options the user will have an array of options to help customize their settings to their needs. The demonstrator showed that sticky keys are for those who have a difficult time holding down buttons at once for functions. The filter key eliminates double strokes for certain keys so you would need to hold down a key to...
This is an animation style which takes real pictures and outlines it to make you look almost cartoon-like. To start with you want to take a picture and get a cut out of the subject with the background transparent. Then get yourself a nice color for the outline and go to filter, sketch, and photocopy. This will look roughly like a colored outline of the subject but then you want to add some more touches by adding detail (usually around 3) and darkness (around 35 is nice).
Hulldo teaches you how to create indented text in GIMP. First, create a new document of any size. Then use the text tool to write some words. Next, select that text and go to Script fu-layer effects-inner shadow. Once you've done this, duplicate the layer. You will now want to filter-blur-Gaussian blur. Apply that to your second layer. Now you can either merge the layers or leave them as they are. You can also play with the text settings, if you want a larger shadow, a bolder text and so on. ...
In this video tutorial, viewers learn how to make a dryer machine produce heat to dry clothes. Sometimes the dryer machine doesn't produce enough heat to dry clothes. To begin, users should clean the filter if it's full of dust. Check the discharge tube and make sure it is clean and doesn't have anything inside. Users should also open the back of the dryer machine and clean up all the excess dust located in the machine. The build up of dust clocks up the passage way and prevents the machine f...
The tutorial teaches the audience an alternative way to make jerky without the fire. The ingredients needed include soy sauce, garlic powder, brown sugar, white sugar, black pepper, ground ginger, onion powder, oriental five spice, cayenne pepper and kosher salt. Meat is put into a metal bowl with the mentioned ingredient and after a period of time, the meat is tossed around in the metal bowl so all the meat will have a chance to soak in the solution. After soaking off the solution from the m...
This video is about how to make a business card design in GIMP. First of all, download some GIMP labels plug-in. Create a business card of required size by entering dimensions going to on “Toolbox”, then Xtns, then Misc, then Labels, then Rect Label. Now create image and text on business cards. The image should compliment it without overwhelming the text. Now add borders and accents. Select “Image”, then “Filters”, then “Combine”, then “Make Label Page” and insert the image. Check your contac...
Mark Duncan teaches the secrets of cooking a garlic shrimp pasta dinner in simple steps. First boil some water in a soup pot, add some salt, then the spaghetti and allow it to cook. Meanwhile heat some olive oil in a pan, add chopped garlic, red pepper flakes and cook. Now add the chicken broth, allow it to boil, then add the shrimp and cook for 5 minutes. Filter the pasta when its cooked, add it to the pan and add the chopped parsley to it. Now add some butter, mix them well and transfer it ...
Watch this video to learn how to make a little planet effect in Photoshop. Go to Image>Image Size and resize the picture making the width and height equal . Don't forget to unmark the "Constrain Proportions" option. Now that you have a squared photo go to Image>Rotate Canvas>180. Go to Filter>Distort>Polar Coordinates and select the option "Rectangular to Polar". Now rotate as you want to and remove any failures.After you select the picture, make sure the sides are alike and that the horizont...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck.
In this video, Gary from MacMost demonstrates how to use GarageBand to edit audio. He creates an empty GarageBand project,and then imports an audio file by dragging it in. He demonstrates how to move to any point within the audio file and view the waveform. To edit out a part, he moves the marker to the place he wants to split it,and then chooses "Split" from the Edit menu. He can also delete the section from the audio region editor. He shows how to select an area by dragging over it, and the...
In this tutorial CreativeIceDesigns shows you how to make really cool electricity text effect by using Photoshop. To do this you need to open Photoshop and create new document. Layer will be black. Go to Type tool and type the word which you want to give effect. Now duplicate the layer and hide one. After that go to filter, stylize and wind option. Give this effect from all side. Change the color and unhide the text layer. After watching this you will be also able to make electricity text eff...
This video describes how to make a whiskey sour cocktail. First take the following ingredients Bourbon Whiskey, Lemon Juice, Gomme Syrup, Cocktail Glass, Strainer, and Shaker. Now take Cocktail glass with full of "Ice cubes", and stir it well and using "strainer" filter the water out and pour the "Lemon Juice" of 1 1/2 oz(ounce),and add 3/4 oz of "Gomme syrup" and then now pour 1 1/2 oz of Bourbon Whiskey into Cocktail glass added with ice cubes. After added all the ingredients take the "Shak...
In this Adobe Flash CS3 Professional video the instructor shows how to work with text. This video shows how to work with text in flash and various other tips. First open your flash and create the text. Now format the text using the formatting option and by setting the proper font, color etc. Now convert your text fields to symbols by right clicking them and choosing the required option. You can also mask them to create animated text. Use different layers in your video, one for actions and the...
Reason 4.0 enables you to make all kinds of edits and create effects for the audio you record and edit with the program. One of these effects is to create a "sweep" in your track. You can achieve this effect by using a noise oscillator. There are many options for noise oscillators. The one used in this example is the low bypass filter version, which produces the richest noise available. This video will show you how to add a "sweep" effect in Reason 4.0 by using a noise oscillator.
This is a very interesting instructional video on how to make an onion relish. This is a very good food. Take white or red onion. Now peel off the outer layers of the onion. Now cut the onion into small pieces. You can cut the onion with a straight knife to get uniform sized pieces. Now put them into the boiling water in a pan. Now you have to filter the water. Now you can add salt, vinegar and sugar. You can keep this in the fridge for a few hours. Then you can add a few raw leaves and now t...
British record producer David Spoon explains how he uses the computer program Propellerhead Reason 4 to create rhythm and bass tracks in his home music studio. He explains that by just messing around with the controls within the program, you can create a lot of interesting sounds and effects. Sometimes the best sounds are discovered by accident. He uses Filter 2 to create interesting effects that he describes as "acid-y" or "nasty", having to do with the resonance of the bass sound. He also a...
