This video tutorial is in the software category where Kerry Garrison will show you how to use vignettes with Adobe Photoshop Lightroom. By this you can remove the dark corners in a photo created by some zoom lenses. Select the photo, kick in the vignettes and fade out the corners focusing on the main subject matter. For this, select 'lens correction' on the right hand side and with the help of the sliders apply the vignettes. You have the choice of applying either a light or a dark vignette. ...
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
In this video, Jennifer DiDonato shows us how to make healthy tuna salad and veggie dip. To begin, drain a can of your favorite tuna and place it into a bowl. Then, add in 2 tbsp fat free cream cheese, 1 tbsp mustard, dash of dill weed, salt, pepper, and your choice of diced veggies, and mix everything together until well combined. A half cup of this only contains 145 calories and has tons of nutritional value to it. It has a lot of protein so it will fill you up easily, without having to eat...
Which frozen burgers are the best to serve for Dad? In this episode of Freezer Burns you will get the lowdown on all the brands of frozen patties. There's nothing tastier than a fresh burger, but frozen ones are often more convenient and last longer. In this video, compare three of the most popular brands so that you can make the tastiest, juiciest and healthiest choice for your papa. All three burgers are put through the Dad Test so you can be sure you pick the right one.
There are nearly as many ways to set up a hammock in the bush as there are to skin a cat, to use the old cliche. This video demonstrates one simple way to set up a hammock in the bush. As the presenter explains, this simplicity is a blessing when you are out in the bush and need something to sleep in as quickly as possible. If you don't have a tent and there are trees around, hammocks are the superior choice for your survival and comfort because spiders and other pests that live on the ground...
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
In this video tutorial, viewers learn how to transfer songs from an iPod device to a Windows or Mac computer. Begin by going to this link. Download Pod to Mac or Pod to PC, depending on your computer. Then install the program and open it. Plug your iPod device into your computer and select the song(s) that you would like to transfer. Users have the choice to transfer to the Desktop or directly into iTunes.
Making a personal jewelry organizer is easy. First, find a convenient place to put your jewelry organizer. The bathroom is a good choice because you can quickly grab your jewelry as you're getting dressed. Next, take a clothes hanger and hang it somewhere easy to reach. Then take a long, thin shawl and slip it on the hanger. Note that the shawl must be thin enough to easily pierce with small hooks. Next, fasten small hooks on the shawl. Finally, place your jewelry articles on the hooks. Congr...
In this video, we learn how to make pad thai and stir fry. First, take a hot skillet and add in vegetable or canola oil, shallots, garlic and shrimp. Fry this with beaten egg and add in rice noodles and cook for 2-3 minutes. The pan should be very hot, but do not burn the noodles or shrimp. Next, add in a fish sauce then finally add in your choice of vegetables. Cook this until you see the shrimp is pink all the way through and the vegetables are tender. You can add more seasoning as you wish...
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 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.
In this how-to video, you will learn how to make your own gak. All you need is borax, food coloring, and school glue. Take five tablespoons of water and mix one teaspoon of borax in a plastic container. Take one tablespoon of white glue and mix it with a tablespoon of water before adding it to a different plastic container. Add three or four drops of the food coloring of your choice. Now, mix it with a spoon and add two teaspoons of your borax solution to the new mix. Once that is done, mix i...
In this Computers & Programming video tutorial you will learn how to search for local yard sales online. Stacy, in this butterscotch tutorial, takes you through a site called Yard Sale Treasure Map. This site uses Craigslist for finding the yard sales and it places them on maps for you to find you way to them. First you type in your starting address, say, Cincinnati, OH. Then you adjust the search radius of the distance you want to drive and the day of your choice. Click ‘search’ and the map ...
Changing the color of your eyes is very quick using Photoshop and this handy video. After using the selection tool of your choice to outline the eye (this video uses the pen tool) with a little bit of feathering, just change the hue of the eye. The video shows how to do this by pressing control + h, however it can also be selected by choosing the image menu, then adjustments, then hue/saturation. This great effect can be used as shown on close up eyes or on smaller eyes further away. Both way...
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
This video demonstrates how to change a drive letter to a certain drive in your Windows 7 computer. On you Windows 7 computer, go to Start > Control Panel. In the Control Panel, select System and Security then open the Administrative Tools. Look for and open the Computer Management tool. On the left side pane of the Computer Management window, select Disk Management. Look for and right click on the drive you want the drive letter changed. Select 'Drive Letter and Paths...'. Click change and s...
How to pick the right RAM for your computer
1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...
To decorate a fall flower centerpiece for your home, create a table centerpiece. Get some dry flowers with attractive colors of your choice. Take a metallic pot for centerpiece. Place a Styrofoam ring in the bottom of pot or vase. Carefully insert stems of dried flowers into the foam. The interior design technique is to be perfect to fall, so that it looks natural. Make sure to have the tallest flower at the center of the pot. Work from the center outwards applying more flowers and stems. Mak...
Here's a great summertime treat that won't have you cheatng on your diet. This healthy alternative ice cream is low in fat, high in protien, low in carbs, and is still pretty good. This video will demonstrate exactly how to make high protien low fat, ice-cream.
In this video tutorial, viewers learn how to tie a scarf into a bow. Begin by finding a long rectangular scarf of your choice. Now slightly twist it up a bit. Then put it on the neck and wrap it around from the back once. Finish the procedure by tying the ends into a bow. To make a bow, create 2 loops and cross them over each other. This video is very simple, easy and fast to do. This video provides step-by-step instructions for viewers to easily understand and follow along. This video will b...
In this video tutorial, viewers will learn how to make a briolette charm drop necklace. The materials required to make the necklace include: a small piece of wire, briolette bead, charm of your choice, a jump ring (for the charm), chain necklace, round-nose pliers, long-nose pliers and cutters. Begin by putting the wire through the bead. Bend and cut the wire to shape a loop. Put the charm on the jump ring and attach it to the bead. Then add the bead to the chain and tighten the loop. This vi...
This video shows how to delete a user account on Windows 7. Go to the start menu, the control panel, then user accounts. Click add or remove user accounts. Select the account you want to remove. Choose the option to delete the selected account. Windows will ask if you want to delete everything on the account or keep the information on your desktop while still deleting the account. This will be your choice. The narrator chooses to delete the full account.
This is a fantastic video, which guides us how to adjust auto play setting in our laptops. It shows systematic moving snapshot demonstration of the auto settings procedure of Windows 7. The speaker tells us to go to the start menu and then click on the control panel. Inside the Control Panel click on the Hardware and sound menu, which will open a new window, and then click on the Auto Play option? The window that opens now gives us several options to choose when we insert different types of d...
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart Art object choices. In this example we first want to click on the Text Cycle icon. Once we do that click on OK and the rough drawing will be placed on your document. After that click on design and you can format the gra...
On YouTube-irDescent you find a simple way to make your own model of a gliding airplane. The instructor begins by giving some information on how birds inspired the inventing of airplanes. Some clips of flying birds are shown. She also explains all of the general parts of the airplane model and their purpose. After the short introduction, she talks you though making the airplane model from scratch. She begins by making the fuselage of the plane. Then she makes the wings which must be equal in ...
This video tells you how to save files in Microsoft Word using different file types. If you are trying to save a file as the old Microsoft Word 97-03, the process is easy. This video takes you through a visual tutorial on how to save files under different documents. If you click the circle in the upper left corner and scroll down to save as, it will give you several different options to save under. Then, you can choose which document you want to save it under, and save the file under a new na...
This video shows you how to change the background color and watermark in your Word 2007 document. Both settings are found on the Page Layout tab. The background color can be chosen from a wide palette. The most frequently used colors are immediately applied to the current page as a preview. You can also choose to add a fill effect, like a color gradient, by clicking the Fill Effects item in the Page Color list. The watermark feature allows you to add either a predefined notice, an image or a ...
This video teaches the secrets of creating an Electro pop makeup style in simple steps. First wet a dark blue eyeshadow powder and apply to your eyelids. Now apply a pink eyeshadow using 222 brush and apply it over the blue. Now use white color and highlight under your eyebrows. Apply a green color using a flat brush under your lower lash and apply a brighter green over it. Apply a white eyeliner to the inner corner and make a triangle shape at the outer corner. Now apply some eyeliner, lashe...
A few tips and tricks in cooking involving artichokes. A simple trick of the trade made to use while cooking at home or even if you are out preparing artichokes on the grill. One of few examples that artichokes are known for in cooking is first by steaming the artichokes for about 35 to 40 minutes, or until you could take a knife and if it easily penetrates without being tough your artichoke is ready. This video gives you a small demonstration on what you could do with your artichokes. You co...
He starts off performing the task that he then describes. It's one technique that is called a mirrored double click flare. This is done by moving the record forward a double click and then back a double click then forward a single click. The whole process is then done in reverse, starting with moving the record back a double click. On his DJ table he moves a cross fader to mirror his movement of the record. First start the technique slow without a beat to get the movement memorizes. Add a bea...
You will learn to create graphs in Illustrator. The best way to visualize data is a graph, and there are several different graph choices in this program. He chooses a column graph to show how he creates his graphs. Holding the left mouse button and dragging, he creates a rectangle which will be our graph. This brings up an input screen beside the rectangle for the graph; he puts information into the screen which shows up on the graph when he is finished.
This video demonstrates how to sew a Victorian skirt. First take a cotton cloth and cut a rectangle piece twice the size of your waist. The length would be depending on your choice of height you require. Hem the top and the bottom of the cloth. Then use elastic thread to create 12 rows of shirring. Each row can be 1/4th inch apart. This is for sure a tedious task but it will look beautiful. Then take a chiffon cloth and cut the same size as your skirt. Hem one side of it and on the other side...
This 5 minute video covers the basics of photographing architecture using Nikon equipment. It gives good basic explanation of basic lessons in architecture photography, including selecting a proper position and distance to either provide or avoid distortion as desired, selecting the proper lens, selecting the film speed for indoor photographs, and how this may affect your choice to use a triPod, and even how to use Nikon's software to correct or adjust photographs after they've been taken. If...
This video shows you how to make Pakistani style creamy pasta. You will need 1 slice of butter, 100 gm finely chopped chicken, 1/2 onion chopped, Cheese to taste- cheddar, Handful of sliced mushrooms (frozen), Pasta of choice- boiled,
Emily from Girlispoision takes us through crafting yarn falls, a new and interesting sort of hair accessory for girls and women of all ages. First, obviously, you need yarn. Second, you'll need a glue stick, for general construction. Third, you'll need a nice large flat surface on which to work. Spreading your yarn out into separate strands, all side by side, you then tie them around the middle, and apply your glue stick, to make sure it will be secure. After snipping it to the desired length...
This video shows the procedure to draw a face. The video shows various stages to draw a face. These include drawing an egg on the paper, dividing the egg into various parts by horizontal lines, drawing the nose and lips, drawing the eyes and ears. The video cleverly deals with issues relating to the evidence of not being a professional. The video shows the various choices that can be made by the artist in drawing the face like the pencils to use.
In this video, you will find out how to make a large recipe card file from Emerald City Elegance Paper Crafting. Anyone who loves to collect recipes knows how quickly you can fill up a little recipe box so make this file to keep all your treasured recipes together. You can easily make this divided file to hold four by six recipe cards. To create this file you will need a large piece of card stock, a printable template from the website, scissors, a scoring tool, adhesive, a ruler, and your cho...
This video is about how to learn how to calculate what key to play a piece of music in. The instructor tells you that you need to know two things: how to read music notes and how understand the Circle of Fifths. Putting together these two layers of knowledge you can figure out what possible keys the music can be in. You can normally narrow down your possibility to two choices. Normally, the key to choose correlates with the last note in the music.
