In this video, we learn how to make your own charcoal. First, you want to make a stack of wood you have laying around, anything you have from scraps. Now, push the wood into a small empty pant can until you cannot fit anymore. Then, place the top onto the can so no oxygen gets into the can. After this, load the cans into a large barrel that has large air holes in it, then wait for the wood to turn into charcoal! This is a process that does take a long time and when finished, the can is going ...
In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...
In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one where you want to display the parts, go to the data validation window and enter the data. For this select the cell and then press 'Alt + D + L' to bring up the data validation box. Here you click on 'settings' and selec...
In this tutorial, we learn how to set up the calendar in MS Project 2007. First, open up your calendar and then click on the "work week" tab. Now, set your working times into the slots for each different day. Make sure you set your start and end times correctly. Now, go to options and change the default start and end times so they match your working calendar. When finished, save this and then start to enter your task information to each different slot. When you enter this, the start and finis...
If you live in an older home with windows that are aged, it's a smart idea to make sure they're sealed correctly. Doing so can not only result in a loss of energy in your home, but prevent cool or warm air from entering your home. It's a great and easy way to save on costs.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.
In this how-to video, you will learn how to change the password to your hotmail e-mail account. This will be useful if someone knows your password or it is not unique enough to be safe. First, go to your web browser and log in to your hotmail account. Once you are in, go to the options bar and click more options. Next, go to view and edit your personal information. Click on change next to your password. Enter your old password and then enter your new password twice. Click save to change the p...
This video is a demonstration of how to make environmentally-friendly homemade laundry detergent. This recipe uses soap flakes, soda crystals, and borax substitute. You may also add oxy-action bleach if you like. Put half the back of soda crystals (500g) into a container, or more if you have hard water. Add a 500g pack of borax substitute and 2 tablespoons of soap flakes. If you like, add 2 tablespoons of oxygen bleach. Put the lid on the container and shake it up. This laundry detergent must...
The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...
This video tutorial from MatthewNeer presents how to check your site's or blog's Google indexing.Type in Google word Site, press Space and then enter your site's or blog's URL address.Then press Enter or click Search button.Newly opened Google page will show all the pages from your site or blog which are already indexed in Google search engine.From search Results to the right you can see how many pages from your site are already indexed.According to the results you can reoptimize those pages ...
This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu...
How to pick the right RAM for your computer
This video will show you how to use the map function on your iPhone. Follow these steps to use the map function on your iPhone: From the Home screen, tap 'maps' to open the Map window. Use your finger to navigate and scroll around the map. Pinch your fingers apart and you will zoom in to the location, pinch your fingers together and you will zoom out. You can use your GPS to track where you are by tapping the Tracking icon. If you wish to search for a location, simply tap on the Search field ...
This is a tutorial on how to compost at home with a composting bin. First, you have to select an area for composting ensuring a location with plenty of sun and a water supply. You will need to divide your bin into two sections, one for the finished compost, the other for creating compost. Line the container with vegetables, tea grounds, or even newspapers. Do not compost meat, bones, fat, grease, dairy products, or pet waste. The most important ingredients for compost are moisture and oxygen....
Check out this video tutorial to see how you can make a paper role playing game. This is a fun little fantasy game that you can download and print on your computer, then cut out, assemble, and play! It is called "Enter the Labyrinth and Rescue the Princess".
Abdominal breathing is a technique you can use to reduce stress. This type of breathing allows for your body to receive oxygen in the areas that are too tense. Get advice on reducing and managing stress in this stress management how-to video.
The aim of CPR is to preserve life by maintaining an adequate supply of oxygen to the heart and brain. Effective CPR prolongs a person's chance of survival until either a defibrillator arrives and can be used to shock the heart back into its normal rhythm or advanced professional life support is available. This how-to video shows you how to use a portable CPR Ezy when someone you know is suffering from a heart attack. This medical device helps you perform CPR on a victim in a constant rhythm.
WHERE TO USE THIS CODE: Most videos DO NOT have "View in Higher Quality" links below them like this video does. So by using this code, you'll be able to watch ANYTHING in higher quality! TRY IT! : )
Deep down inside, Android is really just a fork of Linux, the popular open source desktop OS. You can see traces of its roots everywhere, and this lineage still holds a certain appeal with many Android fans. If you're in that boat, you'll love the newest notes app we just found.
While my desktop is usually neat and organized, it quickly fills up with screenshots each and every day. Usually, I end up putting them in a folder or just trash them, but why not make the entire process of taking and organizing screenshots easier by changing their default save location? With the help of Terminal, I'm going to show you how to change the default save location of screenshots to anywhere you want in Mac OS X.
You can easily lock any folder on your Windows computer with a simple Notepad hack. By creating a batch file, you can hide a folder and require a password be entered before it becomes visible and accessible. This is a great tool for locking sensitive information, like pictures, financial statements, and a lot more.
Gmail is a free, advertising-supported email service provided by Google. Users may access Gmail as secure webmail, as well as via POP3 or IMAP4 protocols. Gmail initially started as an invitation-only beta release on April 1, 2004 and it became available to the general public on February 7, 2007, though still in beta status at that time. The service was upgraded from beta status on July 7, 2009, along with the rest of the Google Apps suite.
In this video, I will show you how to perform the color-changing, blue bottle experiment with common household products.
If you want to enter the police station armory in Detroit while playing Deus Ex: Human Revolution, you either need to have enough credits to afford it, or you need a high hacking skill. This video from Game Front will allow you to skip both of those requirements by giving you the password to the armory so you can take all the weapons you want.
Electronic waste is becoming more and more of a problem for the industrialized world, especially since most electronics are full of precious and rare-earth metals that should be recycled. Even gold! Enter this video. It will show you how you can use chemistry to strip the gold from your old computer and other electronic parts and, well, have more gold! Who doesn't want gold?
Tinder is difficult to come by in the best of conditions, but in a damp wilderness survival situation finding it can be downright impossible. Enter this video. It will teach you how to make solid fuel fire starters out of cotton balls and candle wax, which you can use to start a fire even in wet conditions.
Oil is vital to maintaining the health of your engine, but if it's leaving the areas of the car where it's needed it can cause major damage. Watch this video to learn how to diagnose whether a misfire is being caused by a cracked cylinder head or leaking head gasket allowing oil to enter your coolant and spark plugs.
Those damn Romulus followers and their shrines! Finding all of the shrines in Assassin's Creed Brotherhood is difficult but rewarding. If you're having trouble, watch this video to learn how to find and enter the Palazzo Laterno shrine and get the One-Man Wrecking Crew achievement / trophy.
Most combinations locks like the one you have / had on your locker need to be turned right, left, then right again to enter the combination and open the lock. Or so you thought! Watch this video to learn how you can unlock a lock with turns in the opposite direction by using a different combination.
In this tutorial, we learn how to apply for California food stamps. First, to go the website: California Food Stamps. After you are on this site, you will see a pop up where you can enter in your name and e-mail, as well as more information about food stamps in California. After you enter in your information, you will receive an e-mail with two links on it. One will be for the application and the other will be to find an office near you. Print out the application and fill it out entirely, fol...
In this tutorial, we learn how to block a website using a Linksys Router. First, go to your web browser and type in "192.168.1.1" into the address bar. After this, you will need to enter in your username and password to the pop up window. From here, go to the tab that says "access restrictions" and look for where it says "policy name". Type in 'blocked website' to the bar and then click 'enable'. From here, go down to the bottom of the page and enter in the URL of the website you want to bloc...
In this tutorial, we learn how to configure Outlook 2007 to work with Gmail. First, go to the start menu and then open up Outlook. From here, go to tools and then options. After this, go to the mail setup tab and then click e-mail accounts. Then, click on "new" and then next. Enter in your information in the blank boxes on the screen. Then, enter in your e-mail address and make sure the server is not checked on this screen. From here, you will continue to go through the wizard until it's comp...
In this video, we earn how to make a call on the Samsung Galaxy I7500. From the home screen, tap on the dialer screen, then tap on the dialer tab. From here, enter in the phone number you want to call. Then, press the dial key after the number has been entered. To end the call, press the menu key and then press the end call button. If you wish to call a contact, tap the dialer key and then tap on contacts on the top menu. Tap on your contact that you want to call, then tap on call mobile to c...
In this tutorial, we learn how to text message from the Palm Pre. First, tap the launcher icon. After this, find and tap on the messaging icon. From here, tap on the new message icon and then enter in the name or the number for the person you want to text. After this, tap on the bottom where you will enter in the message. Write out the text for the message, then when you are finished, tap on the send button. This is all you have to do to send a message from the Palm Pre, it just takes seconds...
In this tutorial, we learn how to file for unemployment in Michigan. In the state of Michigan, you can now file online or on the phone without standing in line. First, you will need to make sure you have all of your personal information and information from your previous job. Once you have all of this information, enter it into the phone or the internet when you are asked for the information. When you are finished entering in the information, you will be finished. The state will contact you i...
In this video, we learn how to partition a hard drive in Windows Vista or Windows 7. First, go to your computer and right click on your hard drive. Then, go to the management in the compute rand find disk management. From here, you will see your backup, factory image, and everything else on your computer. From here, right click on the computer and click "shrink volume" It will then pop up a new window where you will enter in the amount of space you want to shrink in MC. Once you enter this, c...
In this tutorial, we learn how to use MMS on T-mobile or ATT iPhone using 3.1 or lower. First, you need to make sure you have iTunes down and it's not running on your computer at all. After this, go to the start menu, then click on the run. Next, type in "command" and hit enter. Then, type or copy and paste "C:/Program Files/iTunes/iTunes.exe/setPreflnt carrier-testin 1" into the command console that comes up. Then, hit enter and reboot your iPhone. When this reboots, go to the settings menu,...
In this tutorial, we learn how to start using Twitter. First, you will want to log onto Twitter and click on the "sign up now" button. Enter in your information and then start your account. Now you can start to follow people and have them follow you as well. Enter in your status update in 140 characters or less. You can start to make friends and learn what the new trending topics are around the internet! Be careful to stay away from the spam accounts and change your background along with your...
In this tutorial, we learn how to perform a master hand reset on your Blackberry Pearl. First you will need to go to the options menu on your phone, then click on security options. Next, you will go to general settings, and then hit the Blackberry menu button and click on "wipe handheld". A prompt will show up and tell you to enter in a confirmation word, then enter that and your phone will now start to go through the process of wiping out all information. When this is finished, your phone wi...
This video tutorial is in the Computers & Programming category where you will learn how to set up an FTP connection using Firezilla. Open up your filezilla program. On the top left, click on the file menu button, and select 'site manager'. In the window that opens up, select 'new folder' and give it a name. Now create a site to store in this new folder. Click on 'new site' and name it. Now on the right hand side, enter the host and the port. The default port is 21. Under server type, select F...