In this Electronics video tutorial you will learn how to take a picture with your LG GW620. First you got to press and hold the camera key on the side of your phone. This will open up the camera options. If you tap the screen you will see the options icons on the side. The various icons are zoom, exposure, flash, macro and settings. On the right hand side you have the back, camera mode and the gallery icons. To take a photo, tap on the camera mode icon. The photo will be clicked and then a li...
Hip-hop dance is a great and modern dance to pick up on. It's something that can cause you to sweat and will definitely cause your heart rate to go up. There are many steps in hip-hop dance, but this tutorial is going to cover just one.
In this video tutorial, viewers learn how to create an event in Face-book. Begin by logging into your Face-book account and go to your profile page. Under your profile picture, select "Create Related Events" from the list of links. Now users are able to input all the information about the event, such as: event name, event type, start time, end time, location and etc.... When finished, click on Create Event. Then upload an image for the event configure the options and access of the event annou...
In this video tutorial, viewers learn how to perform the self working card trick. The magician begins by showing the spectator the deck of cards and is asked to randomly select a card. Then the magician places the card on top of the deck and cuts the deck. Then magician snaps his finger and finds one face up card in the deck. Depending on the number of the faced up card, the magician does through the deck with the card's value and finds the selected card. This video provides a visual demonstr...
Bad breath can be a first date killer, the difference between embracing your guy in a sumptuous first kiss and having him hold his nose closed in disgust as you open your mouth and immediately turn from princess to banshee.
This two-part video demonstrates the ancient Chinese book binding technique called stab binding. If you do a lot of calligraphy, you can use this technique to put all of your sheets together into a really attractive and traditional book. Make sure you line the pages up correctly!
"Baywatch" babe Pamela Anderson is famous for big, sultry smokey eyes and plush, nude lips. In this tutorial you'll learn how to achieve an utterly gorgeous purple-based smokey eye that's perfect for a night out club hopping with your posse. It's a beautiful makeup look that'll get you noticed even if, like Pamela Anderson, you live in a town full of A-listers.
Denham Resources illustrates some common mistakes that people make when answering a common and infamous job interview question: what is your biggest achievement? Rather than simply listing tips for answering the question, they use footage of a woman answering it poorly and highlight the mistakes that she makes as she goes along. He interview is deemed "the bad". In the follow-up video, deemed "the ugly," another video of an applicant illustrates just about the worst possible way to answer thi...
During a time when it's more important than ever to watch what you eat, more and more chefs are creating tasty dishes that are easy on the belt but full of flavor. Out of the many diets, one of the most popular is the Atkins diet. It mainly focuses on the amount of carbs you eat and how to limit them. So in this specific diet tutorial, you'll find out how to make Atkins low carb teriyaki stir fry. Ingredients are listed below, enjoy!
Out of all the sweets in the world, chocolate is one of the most delicious out there that also offers certain health benefits. Of course, those benefits go out the window when someone eats loads and loads of it and doesn't know the definition of self-control. Anyway, chocolate is one of those candies that goes perfect with many things. Raisins, strawberries, cherries, ice cream , crepes, and the list goes on and on. So if you're craving something dipped in chocolate this video may help you ou...
Getting super fast access to your stored contacts on your Android-enabled Motorola DROID mobile device is a easy as two buttons. Yes, 2! Best Buy has the answers. The Best Buy Mobile team explains how simple it is to access contacts quickly via a shortcut on the Motorola DROID mobile phone.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.
If you are ready to make your podcast more professional, have a look at this tutorial. In this video, you will learn how to take an ordinary, amateur podcast and use different programs to make it sound more polished. This will bring your podcast up to professional grade and make it more likely to get distributed by larger companies.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
This video demonstrates how to set up a password for Microsoft Outlook. Begin by opening up Microsoft Outlook. Next, go to "GO" and scroll down the "Folder List." Click on this. Then right click on "Personal Folder" and then on "Properties." Next, you will need to click "Advanced" then "Change Password." You will then type your old password. This is your default password for your email. Next type in your new password. You will need type it in twice, so make sure you type it in correctly in bo...
In this Computers & Programming video tutorial you will learn how to format/partition an external hard drive on a Mac. This is really very easy and simple to do and takes practically no time. Click on spotlight search and look for disk utility. That will bring up the list of hard drives. Click on the external hard drive and click ‘erase’. Then on ‘security options’ select ‘zero out data’ and click OK. This will remove everything from the hard drive. Your external hard drive is now...
First you have to open your internet browser and then go to Google.com. Then search for "outlook connector download". Go to the top hit it gives you go to the site. Scroll down to where you can download the outlook connector and pick the top one of the two there. Run the file and agree to the terms and conditions. Run the install and once it is finished installing open up Outlook. Click next and input your hotmail user name and password. Enter the name you want to appear on emails sent, click...
In this video tutorial, viewers learn how to automate tasks in a Mac OS X computer. This video will show viewers how to create a simple application, that when double-clicked, will open a new message that's already addressed to a specific person. Begin by clicking on the Macintosh HD and click on Applications. Open Automator. Users will be able to create a template for different work flows. Select Application and click Choose. On the left side of the window, there will be a list programs that ...
In this how to video, you will learn how to play Borderlands LAN online using Tunngle. You will need Borderlands and Tunngle in order to do this. First, open Tunngle and then log in to Borderlands. Go to LAN game and select your character. From here, join a game. You are now ready to play. If your friend is not showing up, press E to refresh the list and make sure the port 11155 is being forwarded by the host. To get the in game mic to work, you must go to online game and make sure you log in...
Wayne with Vodafone Help Centre demonstrates how to use the application center on a Blackberry Storm 2 phone. First tap on the Blackberry key to bring up the main menu. Then choose the application center option. Click yes to update the application list. Choose app world and install it on your phone by downloading it. Then, click run and accept the software agreement. You now have access to the Blackberry app world. You can search for the applications that you want and filter the results by pa...
In this video, Jake Allman from Butterscotch.com shows us how to use e-mail on a Blackberry. First, configure your e-mail account onto your Blackberry. You will need your login information as well as internet information to do this. Now, return to the main screen and click on "messages". Once you are in it, you can tap on your e-mail messages to read them and you can compose new ones to anyone or any Blackberry messenger. New e-mails can also be composed from the address book if you want to d...
In this how to video, you will learn how to keep your Windows operating system secure by look for and closing open ports. First, you will need to run the program called Net State. Once this is open, type in netstat -a. This will list main connections. Next, type in netstat -an. This will give you the numbers of ports that are open. Some may be used for file sharing and anti-virus programs. If you want it completely secured, you should only have one running. This video shows you how easy it is...
This silent video shows you how to install HP printer drivers for Windows XP. Start off by turning on the power on the printer. Do not connect the USB cable to the computer yet, it'll ask you at a later time. Now go to HP's support webpage by typing "www.hp.com/support" on your web browser and then choose the region and language you want the support for. Now click on the "download drivers and software" option and type in your printer's model number. Select the correct printer from the list an...
In this Software video tutorial you will learn how to version contacts between MS Outlook and Cosential. Download and install a simple application called ‘ethnosinstaller’. On the first run, Cosential will import all your contacts from Outlook. On the first run, login with your account details and then you can either create a new folder or use an existing folder. You can also download an existing task list or create a new one. Next step is to update your contacts. Click on ‘update’ on...
In this Computers & Programming video tutorial you will learn how to remove ntde1ect.com & autorun.inf virus & trojan files. Go to my documents > tools > folder options > view and unhide the files and click OK. Open up the task manager. Under properties, click on explorer and end that process. Then look for wscript.exe, select it and minimize the task manager. Now open up command prompt and type in ‘dir’ against C drive. This will not list the hidden files. So, you type in ‘attrib –r ...
This video shows us the method to find and install Windows PC drivers. Install the software from www.DirectDriverChecker.com. Click on 'Start Scan' to list the drivers you have and which ones need an update. Choose 'All Drivers' to see all drivers and 'Outdated Drivers' to see the outdated ones. Check the drivers and click 'Next' to update them. Use the 'Back Up' option to back up the drivers in case of a malfunction in the computer. Use the 'Restore' feature to restore the saved drivers whic...
This video tutorial from pctechbytes presents how to quickly set up Homegroups in Microsoft Windows 7.This feature allows to easily share files between computers with Windows 7 operating system.Press Start button, select My Computer option. In the newly opened window select Homegroup from the list to the left. Select View Homegroup Settings link.In this window you can choose what types of documents you want to share with other Windows 7 operating system users.You can share pictures, documents...
This video demonstrates a recipe for Hollandaise sauce, which is an egg based sauce similar to mayonnaise except that it's warm and made with butter. First he melts the butter in a sauce pan and lets it boil. He breaks some eggs into a tall glass and adds some vinegar. He pours the hot butter into the glass and uses a Bamix immersion blender to mix the ingredients, whipping it up until the mixture is thick and creamy in the glass. He then cooks a piece of salmon to go with the Hollandaise sau...
This tutorial will show you how to hide your MySpace comments using the custom MySpace profiles website. All you have to do is visit the website mentioned in the video, and copy a simple code in the codes section. The code that you will be looking for in the list is the 'Hide MySpace comments' code. The code is then pasted in to your MySpace profile under the 'About Me' section. If you follow the directions entirely in this tutorial, your MySpace profile comments will be disabled until you re...
In this video tutorial, viewers learn how write a resume in the table format. A table formatted resume is one of the most effective formats. It highlights metrics in a particular field that potential employers are looking for in a presentable quick overview. At the top of the table, provide your name, contact information and location. In the table, list your skill, experience, role and products from each of your previous jobs and experiences. This video will benefit those viewers who are sear...
This video is about how to install custom fonts on XP. The first thing to do is to open your browser and type "fonts" in the search bar. Several sites will appear and just simply click on any of the websites. Once you have found the site that suits you best, just start looking for fonts that you may like. And if you already have found a font, just simply press download then save it in your computer. Once you have saved it, other files need to be extracted so just simply extract it. After extr...
Have you ever wondered how to prepare a USB drive to flash an Xbox 360? Here is the how-to -video on how to create an USB drive for flashing your Xbox 360 benq drive. To make a bootable flash drive and to prepare it to flash XBox benq drive you have to download the “Xbox benq flashing files for USB” folder from the below mentioned link.http://www.MegaShare.com/1721713
In this video tutorial, viewers learn how to open a Microsoft Word 2007 file by double-clicking it on Ubuntu 9.10. Begin by right-clicking on the file and go to Properties. Click on the Open With tab and select Use a custom command. Now type in [playonlinux --run "Microsoft Office Word 2007" and click Add. Select the custom command from the list and close the window. This video will benefit those viewers who use a Linux computer, and would like to learn how to open Microsoft Word 2007 files b...
This video demonstrates the installation of the “Bleeding Cowboys” font. In the description of this video click on the link for ‘The font’ and download it. Go to the downloaded folder and extract the downloaded file. A new icon appears. Go to the start menu, select My computer and select drive C:, open folder Windows, open folder fonts. Copy and paste the extracted font file into this folder. A dialogue box appears for the installation. Click on install and you are ready to use this font. Clo...
