Access Off Market Search Results

How To: Use Microsoft Excel 2007 as a complete beginner

If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:

How To: Prepare and eat a dragonfruit

Jaqueesha demonstrates how to prepare and eat a dragonfruit. To prepare the dragonfruit you will need a knife, plate and paper towel. Preparing a dragonfruit involves simply peeling it and cutting it into pieces. First, cut off the stem which is not edible. Then, peel off the outer purple part off of the fruit can stain the skin so be sure to wash your hands after you work with the fruit. Dragonfruit has the texture of a mango. Slice the dragonfruit in half lengthwise. Then, cut each dragonfr...

How To: Grow pineapples at home

This video shows how to grow pineapples at home. First, take a pineapple and slice off the top. Next, cut off all the meat from the top of the plant. Then start to peel all the bottom layer of leaves off the plant. Once the plant is well pruned, place it in water for about 2 weeks. You'll see new roots grow in the water. Once there is a healthy root growth structure the plants are ready to be transplanted. Then you'll put the plants into a pot. The transplanting part of the process will be fo...

How To: Get flawless looking legs

This is how to get flawless legs. The first thing you want to do is start off with some products from h2o, its body scrub, it lathers and expoliates, you can use it as a body wash. Another one is another h2o brand with sea salt, that is much more expoliating. Also use ocean salt, by lush, along with buffee, also from lush. Lastly Clarins toning body polisher. Get the water running, wet your leg down, start with the h2o more abraccive salts. Get it and rub it on your leg, if you have sensitive...

How To: Cut pineapples

This video shows you how to cut your own pineapple, which is the fifth most consumed fruit in the United States. The easiest way to tell if a pineapple is fresh is by pulling out the center leaf. If the leaf comes out easily, then you know that it is good to serve. You will need a cutting board, a sharp knife, a peeler, and a pineapple. Before you serve a pineapple, it should be refrigerated for thirty minutes upside down. This way, all the sugar that has rested at the bottom of the pineapple...

How To: Set-up Outlook Express with Gmail

In this how to video, you will learn how to set up Outlook Express for Gmail. This is useful if you want to use the program to access your email. First, log in to your Gmail account and go to settings. Next, go to Forwarding and Pop and select Enable Pop for all Mail. Save this and then go to Forwarding and Pop. From here, select Outlook Express. Click Run the Auto-configuration Tool. From here, you must save a file and open it. Once it is open, type in your account information. Press configu...

How To: Open a locked zippered luggage bag

In this how to video, you will learn how to open a locked zippered luggage bag. This is very useful if you plan a trip and forget the key to the lock of your luggage bag. All you need is a normal pen. Remove the lid of the pen. Apply pressure in between the zipper. Once you get through, slide the pen all the way around to open the luggage. This will open the luggage and you will have access to the entire inside. Once you are done, you can close it back with the pen or the zipper. It will be u...

How To: Configure Microsoft Outlook 2003 w/ an exchange server

This how to video shows you how to configure Microsoft Outlook 2003 to access an exchange server. This is useful if you want to use the program with an exchange server and do not know how. First, open up Microsoft Outlook 2003 on your computer. On startup, click next and yes. Select Microsoft Exchange server and click next. Uncheck use cached exchange mode and enter the server name. Enter your user name in the correct form and click check name. It will not be filled in. Click next and then se...

How To: Grow pineapple by planting the top

In this video, our author, ofenjen, shows us how to slice and plant a pineapple. First, find a pineapple: please don't get one too green or too yellow as they aren't ripe properly. Twist off the top of the pineapple with your dominant hand.

How To: Change your computer name in System Properties (PC)

On your Windows computer you can change the name of your computer. After changing your name, when you turn off your computer you can make it display some thing else instead of the default "turn off computer" text. Do do this right click the My Computer icon on your desktop. Select properties from the menu. This brings up the System Properties window of your computer. Go to the Computer Name tab and in the description box insert a new name to your computer. Save the changes and exit the window...

How To: Use shapes & stamps in Photoshop CS3

The shape stamp tool in Photoshop is similar to using old fashioned clip art. Shapes are extremely easy to access and you will get the hang of them quickly. These shapes can be used to enhance your existing photos or to create graphics like banners and icons. In this tutorial, you will learn exactly how to access and use the shape stamp tool in Photoshop CS3. You will no doubt have this down pat in no time and will soon be on your way to using stamps - just one of Photoshop's many helpful tools.

How To: Jumpstart a dead battery

If your car has a dead battery, jumper cables can be used to connect to a car with a good battery to start your engine. Begin by positioning the two cars side-by-side, turn off the engines, and lift the hoods to access the batteries. First, attach the red cables to the positive terminals of each battery beginning with the dead battery. These terminals are usually marked with a plus sign or in red. Next, attach the black cable to the negative terminal of the good battery. The negative terminal...

How To: Change the accessibility options in Windows 7

This video teaches how to change Windows 7 accessibility options. Choose Start, Control panel. This opens the Control Panel window. Choose Ease of Access in the control panel window. This opens Ease of Access window. Inside the Ease of Access window, there are various links that allows you to set various accessibility options in windows 7. You can use these settings for options like "Optimizing Visual Display", "Replace sounds with visual cues" and you also have settings to choose how the way...

How To: Make traditional turnip greens

This video is showing how to make a great southern dish. In a large saucepan fry some bacon. After the bacon has had some time to cook add some salt and three cups of water. Chop the roots off three turnips and save the leaves on top. Peel the outer skin off each one of the turnips. Dice the roots and put them into the pot. Set on simmer with a medium heat. Tear apart the leaves and remove the thick core on each leaf with your hands and rinse the field dirt off. Chop the greens and steam them...

How To: Configure a router for Wifi

Llewyn demonstrates how to configure your router for Wifi. Access the router by opening up your internet browser and typing in your router's IP address. That will bring up the router configuration page. Now, click on the wireless tab. You can set the wireless network mode to accommodate your computers. As a precaution, set the mode to mixed for greater flexibility. Set your wireless SSD broadcast to enable which will enable your wireless card to actually see the webpage and the internet. You ...

How To: Make a four-leaf clover pendant for St.Patrick's Day

In this how-to video, you will learn how to make a four leaf clover pendant. Start off with contact paper and place it on a smooth flat surface, such as a large plate. Trace a four leaf clover shape onto the paper using a pencil or pen. Fill the entire shape in with glue. Once it dries, you can color the pendant with a green marker. Finally, you can peel off the contact paper. The four leaf clover shape will come right off with it. Viewing this video will show you the fastest and easiest way ...

How To: Perform an aerial twist in free run

In this how-to video, you will learn how to perform an aerial twist. An aerial twist is a technique used in free running. First, identify which foot you are going to take off with. All you have to do is do an aerial with a 180 degree twist. As you go down, jump off with the take off leg and make sure the other leg goes up in the air with a lot of force. The right hand should go underneath to generate torque for the twist. You should land facing backwards. Make sure to have patience while prac...

How To: Fix sticky keys on a PC

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...

How To: Get the scratches off your CDs the easy way

This video shows you how to clean a CD or DVD easily.First of all, you need toothpaste. Apply a thin layer of paste to the whole surface of the disk and spread it evenly. Let it dry for about 5 minutes. After the 5 minutes have past, clean the whole disk at a sink, and make sure you get all the paste off. Wipe off the disk with a towel, but be careful not to make any scratches while doing so. You could try wiping from the middle of the disk to the exterior. The disk must be dry before using i...

How To: Put an iPhone or iPod Touch into DFU Recovery Mode

Here's how to enter recovery mode on your iPhone or iPod touch the easy way. No need to press the sleep button and the home button at the same time for x amount of seconds, just turn your device off, if the device is frozen and can't be turned off normally just hold the above buttons until it turns off, now press and hold the home button and plug the device in. Do not let go of the home button until you see a screen in which the connector cable is displayed and there is an arrow pointing from...

How To: Do switch heelflips on a skateboard

In this how-to video, you will learn how to do a switch heel flip with a skateboard. This trick is similar to a switch kick flip, except using your heel. This trick is considered easier than a normal heel flip. First, your front foot's toes should be hanging off with the back leg on the back pocket corner of the tail. Now, pop the board and flick the heel out. Try and kick it forward and slightly off to the side. Once it flips, catch the board with your feet. This trick does not take too long...

How To: Dismantle a Blackberry Bold 9700

In this how-to video, you will learn how to take apart a Blackberry 9700 Bold. First, set the Blackberry on a sturdy and flat surface. Next, pry off the bottom front plate with a non-metal tool. Remove the battery and place it aside. Next, unscrew the front plate with a screw driver. Be sure not to lose these screws. Now, carefully pry the front bezel off. The keyboard pad will come off as well. Now, remove the screws around the area where the screen is. Once this is done, you can easily remo...

How To: Perform a webster frontflip

In this how-to video, you will learn how to do a Webster front flip. This will be useful if you are trying to get better at Parkour free running. It is one footed front somersault. Make sure you do a big jump with your take off leg. The take off leg is the front leg. The back leg will use a lot of force, as it gives it gives you your initial rotation. Kick that leg behind you as you lift off with the other foot. Tuck in as you start your rotation. Land on the leg that you kicked back with. Yo...

How To: Pop an ollie on a snowboard for beginners

Sierra Snowboard demonstrates how to pop an ollie on a snowboard. An ollie is a basic but mandatory trick when riding a snowboard. When popping up on a snowboard do not jump off of your toes. If you jump off of your toes it is not considered an ollie. Make sure that you also do not jump off of your heels. First, keep your body square and balanced so that you are parallel with the board. Be sure to bend at the knees and not at the waist. Quickly shift your weight to the back foot. Load up the ...

How To: Restring a fishing pole

In this video tutorial, viewers learn how to restring a fishing pole. Begin by twisting off the drag cap and take off the spool. Take your fishing line and run it down the rode holes. Flip your bail up and tie a quick knot. Put it on the spool and reel it in. Hold the rope with some tension and reel it in slowly. If you reel it in too fast, the line will easily get tangled and you will have to remove or cut off the line. This video will benefit those viewers who are interested in fishing and ...

How To: Disable Windows Vista's user account control

In Windows Vista start off by going into the control panel in the start menu. In here go into "user accounts and family safety". Inside go into "user accounts". A screen will appear where you can make changes to your user account. Here there should be an option to turn user account control on or off. Click on this will bring up another window where if you uncheck the solitary checkbox you will have succeeded in turning User Account Control off. After doing so click ok and then press restart n...

How To: Create an automator workflow to upload to Flickr

Learn how to create an automator workload that will upload pictures to your Flickr account in this video tutorial. Simply Google "automator Flickr." Upload it to Flickr to allow access to your Flickr account. This means you will have to sign into Flickr and allow for the application to have access to your account. Every time you use the application, you will have to give the photo a title as well as tags. You will then save the photo as an application with whatever title you want. Anytime you...

How To: Jump off high places & roll for parkour

Learn how to jump off high places and roll without hurting yourself in simple steps. 1. First when you jump off, you have to land by placing one of your legs to the front and the other a bit back. 2. Now you have to bend your legs after placing them correctly when you land. 3. Now place your right elbow on the ground and roll over with its support without hurting your shoulders. 4. Practice the roll first on the ground, then try to jump and roll from a very low height. 5. Move on to higher pl...

How To: Cut corn off the cob for meal preparation

Here, Foodie tips instructs how to cut corn off the cob! First, get your corn on the cob. You will want to place the corn firmly, standing up straight, on your cutting board. Take your knife or cutting tool, place it on the edge and top of the cob and ride it down softly. You'll want to softly and slowly drag the knife down the cob so the corn does not pop everywhere. Hold the corn firmly to help the cob be stable. You can also lay a towel down to further stabilize the cob. Continue doing thi...

How To: Take apart an Xbox 360 Elite without special tools

neversummer224 teaches you how to take apart an XBox 360 Elite without any special tools. This will void your warranty, so be careful once you start this process. You need a TORX 10 screwdriver, which is also called a star bit, and a very small flathead screwdriver. First off, remove the hard drive on top. Take off the faceplate by pulling on it. You can know also remove the top piece of plastic. Use your small screwdriver on the side and back of the XBox 360 to remove the side of the console...

How To: "Grab" flash files from websites

In this video tutorial, viewers learn how to grab flash files (.swf) from websites. Begin by going to the website and locates the flash file that you want. Right-click on the page and select "View Page Source". Go to the Media tab and copy the URL that ends with .swf. Paste it into your address bar and go to the site. Click on File and select Save Page As. Choose the location, name the file and select Save. The file will download and you will be able to access it whenever you want. This video...

How To: Hide hard drive icons in Windows with NoDrives Manager

Video demonstrates tutorial of how to hide the logical drive icons in Windows. In the demonstration there is two partitions C and D and also there is a DVD drive, DVD Rom and DVD Writer. Here drives C, D and F from My computer is going to be hidden with help of utility called “No Drives Manager”. If you don’t want your young ones to access some of your important data you can hide it. It will just be hidden. This means if go to the address bar and types the name of the drive you can go to that...

How To: Replace the windshield washer pump in a Saturn car

This video demonstrates how to replace the windshield washer pump in a Saturn S series car. Remove the reservoir by unscrewing the bolt and lift the reservoir and slide it back to take it off the mount. Disconnect the electrical connector by squeezing the clips and pull the connector off. Next remove the hose, making sure to cover the opening with the winger to prevent loss of fluid from the reservoir. Drain the fluid from the reservoir as shown. Get the pump off the reservoir by tapping the ...

How To: Line a square cake tin

This video shows the detailed procedure to line a cake tin. Firstly, the demonstrator cuts off a square paper just smaller than the base of the tin. Then she measures off a length of paper for covering the sides. She folds it in half lengthwise twice. After careful folding and cutting off small triangular portions at the folds, she then skillfully places it to cover the sides completely. The last step in the procedure is to place the square paper for the base. She thus lines the cake tin full...

How To: Core apples quickly

There is a very easy method to use that is much faster than coring the apples. You can use it to speed the process of preparing apples up so that they are available to you to make your favorite recipe whether it be an apple cake, an apple pie, or some other apple recipe. You will start by peeling your apples with a peeler. Then take a knife and cut the sides of the apple off basically squaring it off. Then take the side pieces that you cut off and slice them into smaller slices. Before long y...

How To: Peel a mango

Mangoes are not easy to peel. This technique shows how to preserve them in the freezer. Mangoes start off green and become purple and then finally orange. When they are brilliant colored, it's time to pick them or buy them. They have a clear almost sticky juice when they're ready. The central stone is flat and round. It's quite hard to remove. Use a thin flexible life to follow the contour of the mango. Lie it down on one of its flat sides. Then peel it in small sections, holding it still wit...