Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
In this video tutorial, viewers learn how to create a photo-montage using Adobe Photoshop. Begin by inserting the images into the program. Then double-click on the montage image to unlock it and select the eraser tool to remove the background. Once the background is removed, select the move tool and move the montage image to the background. To modify the dimensions, go to Edit and select Free Transformation. Hold the Shift key to maintain the proportions. This video will benefit those viewers...
Ina Garten, the Barefoot Contessa, shows how to make her chocolate ganache cupcakes. Put the butter and sugar into the mixer and mix until light and fluffy. Add the eggs one at a time, mixing after each. Next comes the “secret ingredient”, a can of chocolate syrup, then some vanilla, and finally the flour. Mix it well but don’t overbeat or the cake will be tough. Fill the muffin pans using an ice cream scoop, and bake at 325 for 25 to 30 minutes.
This video tutorial from Michael Espinosa shows how to install and use File Zilla Ftp client on Windows XP operating system.
In this video tutorial, viewers learn how to use the blend tool in Adobe Illustrator. The blend tool will allow users to create objects between two strokes or filled objects. When you double-click on the blend tool, there will be 3 options to select from. Select the spacing and press OK. The three spacing options are: Smooth Color, Specify Steps and Specified Distance. Users are also able to select the amount strokes between the two objects. Now select the points of the two objects and it wil...
In this Software video tutorial you will learn how to link tasks in Microsoft Project 2007. There are four ways to link a task. Finish to start is the default, then you have start to start, finish to finish and start to finish. Here you will see how to link up two tasks and what is the dependency between them. There are various methods of creating dependency between two tasks. One method is to select the two tasks and click on the ‚Äòlink tasks‚Äô button on the tool bar or you can go to the ‚...
In this how to video, you will learn how to install fonts on to a computer running Windows. First, go to the start menu and go to control panel. From here, double click on fonts. Next, select install new font. From here, browse your folders to the folder you have saved your downloaded fonts. Once it is selected, press okay to add the font to your current list of fonts. You can check if the font can be used by opening up Photoshop. Create a new file and then press the text icon. From here, you...
In this video tutorial, viewers learn different ways to wear a Pashmina scarf with a bridesmaid dress. The first way is to wear it on the shoulders for those who are uncomfortable with strapless dresses or are cold. The second way is to simply wear it around your arms. The third way is to put on the shoulders and tie it at the back. The fourth way is put it around your neck and wrap it. If it's cold, you can wrap the end in a knot. The fifth way is to double the scarf then tie it around your ...
To open the Windows Task Manager the long way
This how to video will show you how to jail break the iPod Touch or iPhone to the 3.0 firmware with Redsn0w. First, download Redsn0w and the firmware. Open the file and double click the program. Click browse and navigate to the firmware. Open it and let it load. Once this is done, press next. Let the data load and then make sure Cydia is clicked. Click next and then turn off your device and plug it in. Click next and then hold the power button for 3 seconds. Without releasing the button, hold...
In order to make a Cuttlebug Smoosh Card, you will need the following materials: card stock (at least 3 different prints or colors), a ruler, distress tool, double sided tape or glue, distress ink, watermark stamp pad, decorative accessories, and scissors.
How to tie a Eight Figure Knot.
Dirt Design Graphics will show your how to draw a firey hotrod flames. Flames are like a series of water drops. There are many different types of flames you can draw. You can see the difference in the more angular tribal flames which you get by adding a kind of hook at the end. You can do some long seaweed like flame, intertwining flames, double flames, and realistic fire flames all by changing up that same basic pattern. There easy and will make anything look like it’s going really fast so f...
In this video we learn how to make your iPhone vibrate your notifications longer. For this you need an SSH program like cyberduck. You also need plist edit pro. Once you have SSH in your phone, go to system, library, private frameworks, celestial framework, then find vibration patterns. Double click that. Download it to the desktop. Open it. Open up the plist file. Go to default, look at total duration, click into that to change the time of the vibrate duration. Change the On Duration too. No...
This video talks about protected mode for internet explorer 7 and Windows Vista. The person tells you that protected mode helps protect your computer from types of spyware. It is not the best solution and they tell you one should not rely on this alone. By default protected mode is on. You want to make sure it hasn't accidentally been disabled. To check your settings, double click on the area on the bottom of the screen that says protected mode. The security tab will pop open. Look to see if ...
This is a great instructional video on how to measure a quilt for binding. This video teaches you about binding. First you have to get your quilt and tape measure. You need to know the size of your quilt. You have to be careful while measuring a quilt. You can measure the breadth with your measuring tape first. Then you can measure the breath as well accurately. You can take measurements down the center of the quilt. In some cases you can measure from one side, the center and the other side. ...
In this video tutorial, viewers learn how to copy music from am iPod device to a computer. Users will need to download the program, Copy Trans Suite. The download link for this program is located in the video description. Once downloaded, double-click on the file and follow the instructions to install the program. Once installed, open the program and select Copy Trans. Now connect your iPod device into your computer. Users can manual select the songs or select them all at once and then click ...
In this video tutorial, viewers learn how to zoom in like a Mac on a Windows computer. Users will be using the program, Q Zoom. Begin by downloading the program from the link provided in the video description. Once downloaded, double-click on the file and follow the instructions to install it. Open the program and configure the settings. Users are able to set the maximum and minimum of zooming in and out. Users can also set mouse zoom and shortcut keys for zooming. This video will benefit tho...
The first thing to do to install tune-up utilities on Windows 7 is to, go to Google and search tune up utilities. Then you scroll down to CNET download website and click download now. After you clicked it hit save file and wait for it to load. After you finished downloading it in that box right click it and choose open containing folder. Then drag the file to your desktop and right click on the folder and go all the way down to properties. Once you are on to it go to compatibilities and check...
In this video tutorial, viewers learn how to bypass web-sense filter using the software, Hopster. This program allows users to bypass firewall, bypass proxy and HTTP tunnel. To download this program, go to Google and search for the program. Click on the first result and select download. Once the file is downloaded, double-click on it and follow the instructions to install the program. This program runs silently and invisibly so that the administrator won't be able to detect it. This video wil...
How to make artistic emails using Mac.First open up email then click on new message, then on top right hand corner we can see ‘Show stationary’ button. Click it to see the templates made by apple. He selects the template of vacation to make up an email about his trip to Sydney. Then the template of vacation to Europe appears with photos. He clicks on the photo browser and opens his trip to Sydney folder by double clicking and dragging the required photo to set the photo for the photo in the t...
In this video tutorial, viewers learn how to work out basic percentages. The key is to always find 10% of the number first. To find 10%, divide the number by 10. It's very simple because you simply move one decimal to the left. Once you have found the 10%, you can simply find the next 10% by doubling the number. The other thing you can do is find 5% of the number by dividing the 10% number in half. This video will benefit those viewers who have trouble with find percentage or forgot how to an...
In this video tutorial, viewers learn how to do Bret Hart's sharpshooter wrestling move. Begin by giving the opponent a toe kick and a double leg take down. Now grab the soles of the feet and put your left leg in between the opponent's legs. Take the opponent's right leg and cross it front first. Then take the other leg and cross it over. Take your left arm and wrap it around the left foot. Now turn counter-clockwise and hold the opponent's knee. This video will benefit those viewers who are ...
In this video, we learn how to send an email using Outlook Express. First, click "create mail" in the Outlook program. In the "to" section, fill out the email address of the person you want to email to. You can also access your address book and choose recipients from that folder, double click them and make sure they show up in the recipient folder. After this, click "ok". In your subject line, fill in which subject the email is about. After you are done with this, move to the main body of thi...
In this video tutorial, viewers learn how to unzip a zipped file using the 7-Zip extraction tool. Begin by going to the website and click on the Download link. Wait for the screen to load and click on Save File. Once downloaded, double-click on the file and follow the instructions to install it. Now simply right-click the zipped file. Go to 7-Zip and select either Extract files or Extract Here. The files will be extracted into a new folder that contains all the content...
In this video tutorial, viewers learn how to turn off the stick keys on a Windows computer. Begin by clicking on the Start menu and select Control Panel. Double-click on the Accessibility Options and go to the Keyboard tab. Under Sticky Keys, click on Settings and uncheck the box that says "Use Shortcut". Then click OK. Users can also turn off the sticky keys by pressing the Shift button 5 times and click Yes to confirm. This process is very simply, fast and easy to do. This video will benefi...
This is a clear video showing how to easily draw a 3D letter 'B'. First of all you start by just writing the letter 'B' normally; and then you double outline all of the lines you have drawn, both inside and outside of the letter. Color it in with a block color for a 2-dimensional letter. Then its time to make it 3D! In the middle you just add lines parallel to the 2D letter, and also around the top and left sides of the shape; color this in with a darker color, and voila! You should now have ...
This video from TechFusionVids presents how to install Microsoft Office 2008 on Macbook Pro.All installation process takes about 5 minutes. Insert Microsoft Office 2008 installation disk, double click on the installer icon when Office installation window opens.Click Continue two times, agree to software license agreement, type your name and name of your computer, click Continue again.Window opens saying you should close all running applications before starting further installation.Once it's d...
In this video tutorial, viewers learn how to burn ISO-format disc images to a DVD from Windows. Users will need to download the program, DVD Decrypter. Download it from this link: DVD Exact Copy/] and double-click the file to install it. Users will also need a blank DVD disc. Open the program, go to ISO and select Write. Now click on the folder icon to locate your ISO file. Now click on the disc image and wait for the decryption to finish. This video will benefit those viewers who have downlo...
You should use the file Winrar to unzip your file, it's the easiest. You're going to open up an internet browser and go to: Zybomen. Click on download, then click on Winrar. Click on the one that says 32bit, unless you've got a 64bit system which is the second one. Click run, then wait for it to download. Close your internet browser. Click install, go through the process. Right click on the file you would like to unzip, and then click on extract to and then the file name. Double click on the ...
Olivia will be showing you a few different styles you can wear your Pashmina scarf. One way you can wear it is by just grabbing one corner and throw it around your neck it may be a bit longer but you wont end up with a big bunch of tassels on one end. Another way you can wear it is to simply loop it around your neck, it makes it a bit shorter if that's what you're comfortable with. Then another way you can wear it is by doubling it then sort of knotting it around your neck, but don't not it t...
Quincy shows how to jump rope like a professional or for competitions. 1. Make sure that the rope is the proper length. The rope should meet your armpits. He teaches that you'll start with the basic jump. 2. To initiate the jump, move the rope in a circular motion, make sure that it passes your head. 3. To do continuous jumps keep moving the rope in circular motions. 4. To do a double ended jump, the rope goes under your body two times and you move the rope faster.He also teaches advanced jum...
This video tutorial from hottyqingwa shows how to add audio files into PowerPoint projects.In this tutorial was used Power Point 2007 Professional edition.To start, create a folder with a random name. Then drag your audio file and power point project into this folder.Open PowerPoint project, click Insert from top menu, then select Sound-Sound from file. Double click audio file in your folder.Dialogue box will appear asking if you want the sound to start automatically or when clicked.After, cl...
In this how-to video, you will learn how to change a .doc file into a .PDF file. Open the document in Microsoft Office. Go to file and select print. Change the printing device to the CutePDF Writer. Click okay and save the file as whatever name you want. Once this is done, navigate to the location where you have saved the new .PDF file. Open the new .PDF file by double clicking it. You cannot change any of the text in this new file. By viewing this video, you will learn how to quickly convert...
In this video we are about to see how to plant a garlic in your garden. First of all we should decide on the type of garlic to be planted where and write it down or else we will lose track of it. Garlic always like an area of full sun and a composite mixture of soil. She has double dig the ground and added organic mixtures to get the soil nice and lose and also for it to be fertile. Remove the garlic cloves one by one using your fingers or knives (a better way). Then always garlic is planted ...
In this video tutorial, viewers learn how to make a slow motion video on a camcorder in Sony Vegas. In a film camera, this is called "overcranking". On your camcorder, set your rec format to PH 720.60 P. Then open your clip in Sony Vegas and set up a time line. Then make a region around the entire clip and select Render As. Go to Custom and change the frame rate to 59. 940 (Double NTSC). Now save it. This video ill benefit those viewers who produce videos and would like to learn how to make t...
In this video Dave Andrews from Help Vids will show you how to clean up your hard drive in Windows XP. A way to do that is to delete the icons from the desktop that you don't use regularly. The files that you have just deleted are located in the Recycle Bin. To permanently delete them, right-click the Recycle Bin and click "Empty the Recycle Bin" or double-click the Recycle Bin and delete them from there. Now the files are gone and your desktop is much cleaner. You can repeat this method with...
In order to use Picasa's face recognition feature double click on an image that you would like to edit. It will automatically identify each person. Then label the first person that it identifies. Then hit the enter key, and click on the new person button then click on the okay button. Now go back to your library and on the left hand side of your library you should see the label that you made for your first photo. Click on that label and Picasa will automatically find all of the photos that th...
To figure out a tip without a calculator, first remove the pennies amount in the bill. For example, if your bill is $23.76 becomes $23.70. To figure out a 10% tip, move the decimal point one place to the left. So, 23.70 becomes 2.370 or $2.37. Bump up that number to $2.30 or $2.40 or $2.50 cents, depending on your preference. Since 20% equals two times 10%, double the figure you computed for 10%. So, $2.30 becomes $4.60, or $2.40 becomes $4.80 or $2.50 becomes $5.00. Using this method, you wo...
Learn how to make a fly fishing leader by following this tutorial. First, the easiest way is to purchase a tapered leader, obviously. However, sometimes as you are fishing this will break and you may not have a backup leader. Your only option in that scenario is to make a new one from your broken leader. Take approximately 18 to 24 inches of the 3X wire and double knot it to the but section that is broken. Then use another wire material to attach for the fly section. To decide what type of ma...
