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...
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...
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 ...
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.
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.
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.
This video from ESPN walks you through the different draft modes available for picking a fantasy football team using the ESPN fantasy football site. The different draft modes available are:
You don't need to pay a stylist or even get a friend to help you with this hairstyle! It's easy, elegant and looks good with nearly any type of long hair. Here's how to create an elegant bow updo for your next formal event!
New to shooting video with a DSLR? In this video tutorial from renowned DSLR cinematographer Philip Bloom and the staff of Vimeo, we receive some tips on how to work with different lenses when using a DSLR like the a Canon 7D, T2i (550D) or 5D Mark II.
Add text and titles with Windows Live Movie Maker. There are three options for adding text in Movie Maker. This tutorial provides an overview for each type: title (which goes before the selected clip), caption (which is superimposed over the selected clip) and credits (which goes after the selected clip).
This is perfect for someone who wants to keep their hands warm but still work with their hands (such as typing, sewing or crafting). Start with medium weight worsted yarn and a size I crochet hook to make these fun wrist warmers.
Need a smooth, polished, and glossy surfaced piece of acrylic for your next project? Then check out this video for a handy guide on how to sand, cut, and polish Perspex, a type of acrylic, for a high-gloss finish. Perspex is thick and difficult to work with, but this video will give you tips for a professional look.
Got a cake or cupcake-obsessed friend? Then she'll simply swoon over this "You Take the Cake" birthday card. The greeting card depicts a triple layered cake crowned with frosting.
Just because when you bought your jeans it said that it was just one type of jean - bootcut or skinny - doesn't mean you can't wear it in different ways by either rolling them up or by slashing in holes to make them look worn.
If you want to create the type of makeup look where the makeup IS the costume for Halloween, then look no further than this video. You'll be guided step by step through creating a facial prosthetic from latex. This prosthetic can be shaped any way you want to form rotting flesh for a zombie costume, scars and wounds, even bullet holes.
You can make jewelry out of chainmail! It will be bulky, unless you use incredibly tiny rings. This tutorial shows you how to make the box chain out of many small metal rings, which you can expand to a necklace, bracelet key chain or any other type of jewelry you can think of.
There are lots of key parts to creating beautiful makeup, but if you had to ask us for the most important step we'd without a doubt say foundation. Good skin looks good no matter what other type of makeup you decide to you put on, whether it's smoky eyes or red lips. That's because beautiful, flawless skin acts as a smooth, pretty base.
Sandpaper is one of the essential tools of woodworking and carpentry, and there are many types with different applications. This video is for woodworking beginners and will teach you a lot of the basics about sanding so that you can give your pieces the finish they deserve.
You don't have to know what kathal pulav means (jack fruit pulao, or jack fruit plus rice pilaf) to enjoy its mildly sweet and rich flavor. Jack fruit is a supersized fruit (the largest tree-borne fruit in the world, in fact ) comes from a Southeast Asian tree that grows in tropical regions.
Google's Goggles mobile app was a big hit on the Android market, and now they've given iPhone users the chance to enjoy the awesomeness of Google Goggles. This iPhone app only works on the Apple iPhone 4 or iPhone 3GS, and it's available in the App Store for download. Simply type in "Google" or "Google Mobile App" and you'll find the app with the Google Goggles feature built in.
Have you seen odd, square codes on some specific merchandise? These are called QR codes, or quick-response codes, and they are a type of bar code which your smartphone can read and then take you to a particular website, give you coupons or even a business card. Here's how you can get the most out of QR codes.
This is an Alicia Keys makeup look, inspired by some pictures of her wearing some gorgeous green eyeshadow. This look works great for any skin tones, but works especially well with skin types that are dark or tan. It's also a good makeup look that transitions well from summer to fall. Follow along to see how to apply this green smokey eyes and bright lips look.
Halo: Reach has gotten a completely revamped version of the Forge where you can truly let your imagination run wild! If you miss the old Invasion game types and want to make your own, this video will show you how! In this video you will learn how to create objectives, set up spawn points and many other options to create the perfect Invasion game for you and your friends!
If you're a Penelope Cruz fan, then this makeup tutorial is a must-see! You'll learn how to recreate her makeup look seen in these pictures. The makeup she dons is very classy, but also wearable for any woman, no matter the skin type or color. Her seductive eyes draw in all the attention, as well as her defined, neutral pouty lips.
Tutting is one of the most versatile types of popping, and has become popular in the rave community because it's emphasis on hand and finger moves translates well to light shows. This video is a basic tutting tutorial for ravers to get acquainted with the theory of tutting and some basic moves to get started.
Tutting is a popular type of popping focused on 90 degree hand movements inspired by depictions of King Tut. This video will show you how to do one very cool tutting combo step-by-step, giving you another piece that you can use to build your tutting routines and kill the dancefloor
Google is always moving one step closer to pretty much controlling everything in the world, in a good way ofcourse! The latest feature added is Google Instant Search, so for anything that you're searching all you have to do is start typing in the search term and Google will immediately begin giving you results on the fly. In this video you will get a quick hands on demo on how to use the new feature.
One of the newest and most effective types of dry powder asmtha inhalers is called a Diskus. They can be confusing to use for those used to a more traditional inhaler. This video will show you how to use a Diskus to treat your Asmtha symptoms and make sure your device stays clean and effective for a long time.
One of the most annoying of the many annoying types of errors on Windows computers is when you computer won't recognize parts that have always been a part of it, like the drives or keyboard. If your computer has stopped recognizing your CD or DVD disc drive, watch this video. As long as the drive is still connected, the steps in this video should allow you to fix the problem and continue using your drive.
Warm summer nights call for equally warm and savory stews that harness the flavor of the fresh vegetables that are in season. So before we head into fall, try out this delicious recipe for a sausage, potato, and zucchino stew.
Other than a perfectly crispy, flaky crust, a top-notch pastry should possess a most wonderous filling. The best pastry chefs know this, and the more types of fillings you offer, the more customers you satisfy.