This how to video shows you how to use drop down lists in Microsoft Excel. This will be useful for stores and avoiding people ordering items that are not available. First, type the items in a column. Select them and then click in the name box. Type the name of the list. Note that it must be one word. Now, go back to the order sheet. Select the cell where you want the list to be placed. Go to data and select validation. On the settings tab, choose list and type in = and list name. You can pres...
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...
Sandra Lee shows viewers how to make a No-Bake Love Cake in this video. You will need the following ingredients:
Steps to Configure Your Modem/Router are: 1. Open Network connection and click properties
This video tutorial shows how to open a port for torrent downloading on your computer. Click Start menu, type cmd command in Search area. In cmd window type ipconfig and press Enter. Remember or write down your IP adress. Type exit and press Enter to close cmd window.
This is a how-to –video on using hydra 5.4 to crack FTP passwords. This video is intended for educational purpose only. It reveals the basics of hacking a FTP server using dictionary search technique. Here are the steps involved.
Open up dreamveiwer and click HTML on creat new. If the new page opens then go to design view and then go to insert and then layout object and then diff tag in that then click ok for that. There we have to create a scrollbar content. Then we have to right click there and go to css styles and then go to new. There go for selector type and click class and then name it as you want. Here he just named it as scrolldivstyle then go to go define in and take this document only and then click. Next yo...
1. Type in WWW.sendthisfile.com in the web toolbar and press enter 2. Click on Register found on the top right side
In this how to video, you will learn how to speed up your Azureus Vuze program. First, open up Azureus Vuze. Next, go to advanced, option, and click preferences. Select preferences and change the port to a number between 49152 to 65535. Once it is changed, go to transfer and make sure that these are set to zero. Once that is done, open your web browser and type in your default gateway. To find this out, go to system preferences, network, and router. Next, enter your user name and password to ...
First of all you have to open the 'notepad'. Now you have to type in "<html>" in first line. Write "<head> in second line. Write "<title>this website contains text wrapped around images</title>". In the fourth line you have to type '<body bgcolor="#999999">'. This shall add a light orange color. Now find out the name of the image. Here the name of the file is 'image.png'. Then in the next line you have to type in "<img src="image.png">this text should hopefully wrap around the outside of the ...
HighQuality Tutorials demonstrates how to change your iPod Touch alpine default password. Changing the default password is useful when using your iPod Touch in a public setting to make it less vulnerable to hacking. To change the default password, first open up your internet connection and search for Putty. Download the Putty program. Open and run the Putty program. Your host name will be your IP address for your iPod Touch. Select port 22 and SSH and open up the program. Log in as root and c...
This video gives you tips on how to keep your dog cooler in the summer heat. Their natural body temperature in the summer is 102 degrees already. Dogs are unable to sweat. Their only mechanisms for cooling themselves naturally are their mouths and the pads of their feet.
Ken Alston shows how to germinate Japanese maple tree seeds. The most important thing is to always buy fresh seeds. Seeds that are bought on eBay or other unreliable sellers are dry and lifeless and the chances of germination are not very good. The video shows the huge difference between the dry seeds and the fresh seeds. On the fresh seeds you can see that the roots are already out and in some cases the leaves are out, so from this point the rest is easy. Have little seed pots ready, make sm...
Shaun will teach us how to create a 3D video game compatible with MAC or PC with no prior programming knowledge. First download Alice, a 3D World program that can be turned into a video game. Open Alice, click on "add objects", click on "more controls" and select your choice of aspect ratio such wide screen. Now you can import your own 3D models that Shaun will show you at the end of the tutorial or choose from a wide selection that comes with Alice. In addition, if you click on "home," "web ...
Ready to rock and roll? You don't have to listen to music through those teeny tiny computer speakers anymore! Check out this cool tutorial, and learn how to connect stereo speakers to your laptop or PC and get the most out of your music.
So you bought a PC and now you want a Mac... You don't necessarily have to shell out the couple thousand bucks it takes to buy a new Mac. In this tutorial, learn how to make your Windows 7 operating system look & feel like a Mac OSX operating system. To complete this tutorial, follow these steps:
This tutorial demonstrates how to make very cheap Christmas tree decoration using feathers and Christmas silver balls. Here a violet and pint feathers are used. The best way to buy feathers is to buy feather bows in which feathers will be fixed together using some wire or string. Now an inch long section of feather is cut from two different bows of violet and pink and the ends are glued. It is left to dry for a few seconds. Some copper wire and the silver ball are taken. Connect the wire to t...
This unusual clip shows you how to make spiced milk tea. The recipe is included in Gourmet Magazine. Massala Chai can be bought in coffee shops around the US. First, use cardamom pods - they need crushing to get the seeds out, although you can buy them without the pod to save time. The other spices are cinnamon, pepper corns and fennel seeds. Everything is ground together and while doing this, you simmer two cups of milk, sugar, salt, ground ginger and the spice mixture. Whisk them all togeth...
The idea is to buy a few items from IKEA and use them to make a back garden BBQ smoker. The concept is also know as IKEA hacking and the principles are simple, re-engineer IKEA products to make a entirely different item. This video will take you step by step through the buying, preparing and constructing of your very own BBQ smoker. All plans for construction can be found on their Website and a big thanks to ford for lending garden fork a car for the summer.
This video shows how to change the advanced settings to make Firefox faster on Mac and PC.
If you've received the "hal.dll is missing or corrupt" error message from your Windows machine, then you're in luck! This video will show you how to correct that problem with the Recovery Console tool that comes with the Windows 2000 and XP CDs.
In this video Dionne shows how phone calls can be made by PC. There are a number of softwares available in the internet for making phone calls, but the best and the cheapest is Skype. Skype is easy to download and install in your computer. Then you can enter the contacts and their phone numbers. After that you have to buy Skype credits so as to start making calls anywhere in the world. Calling from Skype is so cheap that if you buy a credit of 10 pounds, it will last many days no matter where...
This video shows us how to describe the situations that are opposite of the future perfect tense. Here it is shown how to describe the situations that did or did not happen in the past using would, have and past participle. He gives us 3 very good examples that are describing such situations. In these examples he describes a situation which happened in the past which is actually a negative and uses a fact that is described in the present tense to give the reason why that situation ended in a ...
Learn to cook like a professional chef from the comfort of your own home with this fun and entertaining video on creating individual meringue shells. Don't throw away your money by buying store bought finished products and create this tasty treat at home. Beat together all your ingredients as outlined in the step by step video, pop them in the oven, top with your favorite fruit and whipped or lemon cream and you're ready to eat. You're friends will think you spent hours on these delicious des...
Stay stylish on your trip to Poland & buy a new hat! How are you to buy one in Poland, you ask? With the right words. In this video, learn how to say the word "hat" in Polish.
Not sure how to balance a chemical equation? According to the rules of chemistry, matter must be conserved in chemical reactions. When you balance a chemical equation, you account for all of the matter in the reaction.
Looking to buy a home? Why leave your current digs? Using technology has made it easier than ever before to find the home of your dreams. Learn how to buy a home online with help from this how-to video.
Learn how to make an easy drink that can be supplemented as a workout drink with this tutorial! 1. Buy some carbonated water from any convenience store,such as seltzer water or make your own from carbonated water capsules.
Corinne Trang, author of Noodles Every Day, explains that contrary to popular belief, fish sauce doesn't last forever. As soon as you open the bottle, the air gets to it and it starts fermenting again.
Need to cut back on the sodium? Limiting your daily salt intake can help prevent major diseases. Here's how to cut the sodium out from your diet.
Looking to make a special scrapbook? You've got the "scraps"—now you need the book. Before you rush out and buy the first flashy binder that grabs your eye, put a little thought into what you really need.
Not sure what to be next Halloween? A princess is a classic choice. Whether you’re making a costume for your little girl, or want to feel like royalty yourself, a princess costume is always in style.
Give someone his or her own personal ticker tape parade with this easy prank. You Will Need
A better body image in six steps, and dieting isn't one of them. This video will show you how to build a better body image.
Why buy a boring old lamp when you can make a unique one yourself? Learn how to build a lamp yourself, at home with this how to video.
Biotin is a water soluble B-complex vitamin important for synthesizing fatty and amino acids and maintaining blood sugar. It's important for the synthesis of fatty acids and amino acids. Try these tips for buying biotin enriched foods in this diet and health how-to video.
You just bought a laptop, but how to do you protect it? Buy a laptop case! No wait... make your own laptop case out of household items. Watch this how-to video from Gianny L and learn how to make a simple laptop or notebook case out of old pants or jeans and a piece of plastic.
Homemade yogurt is so simple to make that you’ll wonder why you haven’t made it before. Watch this how-to video and try this recipe. You will agree that Indian style homemade yogurt has a delicious flavor that is very different from store bought ones, not to mention how much cheaper it is to make versus buying.
There has been an update with the NES emulator, so you have to put the ROMs in the /var/mobile/Media/ROMs/NES folder, and not the /var/root/Media/ROMs/NES folder.
First buy a cheap rc buggy, then a cheap wireless camera and receiver off ebay. Then buy a usb TV box and plug it into your laptop. Connect receiver to tv box. Tape camera to car. Switch everything on and drive! My other camera has packed up and I can't see anything through the viewfinder or screen. That's why the filming is so bad.