Ultimate List Search Results

How To: Find & extract duplicate records from a data set

This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...

How To: Read a balance sheet in accounting

In this Business & Money video tutorial you will learn how to read a balance sheet in accounting. Yu can learn to read it quickly and easily as to where the company’s came from, where it went and where it is now. There are four main financial statements; balance sheets, income statements, cash flow statements and statements of shareholder equity. In the balance sheet, under assets are listed things that the company owns that have value. Liabilities are amounts of money company owes to other...

How To: Use Google Maps with the Blackberry Storm 9500

In this how-to video, you will learn how to install and use Google Maps on your Blackberry Storm 9500. First, go to the main menu of the device and go to applications. Now, find Google Maps on this list. Click on it and press Install. Now it will connect to the internet. Scroll to the bottom and click agree and then download on the next page. Once it has finished installing, click ok or run. Now, close the browser and go to applications. Select google maps in order to use it. It will load and...

How To: Read and understand a nutrition label

This video shows how to read, understand and interpret the "Nutrition Facts" on food labels. First he explains the fats. Unsaturated fats are good for you, but saturated and trans fats are unhealthy. Cholesterol can be lowered by unsaturated fats and raised by saturated fats. Sodium is salt, and can make you bloated if you have too much or don't drink enough water. Carbohydrates are broken down into fiber and sugars. Fiber is good for digestion, and it's good to keep the amount of sugar low. ...

How To: Download free mp3's to your PSP

In this tutorial, Zain will explain how to download free mp3's from your PSP to your PSP. All you need is a wireless connection, and a PSP. First, go to your internet browser. You can enter on Kohit for downloading free music. There you have search box where you can write the title of the song you want. Type it there and then click 'go'. A song list will appear on the web page. Click on the song you want to download. Now click on 'Download now'. Go to options and click on 'Save Link Target'. ...

How To: Stop procrastinating by altering your daily routine

This video shows us how to stop procrastinating by altering your normal routine. One way – to start with – is to understand why you procrastinate at all. Some people think that what they do is going to be judged on who they are. Some people think that they have to do everything perfectly. One of the most important things that you can do is make a schedule and then stick to it. Also you can practice the ‘good enough’ principle – realizing that you don't have to do it perfectly and that you are...

How To: Create dynamic menus with JavaScript

1. The following steps describes how to Create dynamic menus with html and Javascript. 2. Open the html file in Illustrator. 3. Enter the Menu.js file with <Script> Tag. 4. Create a Bulleted List of the Menus and Its Sub Menus inside a DIV Tag. 5. For Each UI List Create a Mouse over and mouse out Event for Header Menus. 6. For Mouse over Event call a Function named set Menu with MenuSubOne id as parameters 7. For Mouse out Event call a Function named named clearMenu with MenuSubOne id as par...

How To: Have an eye-catching online dating profile

Make a great online dating profile with this tutorial! Having a good profile is very important because when it comes to catching someone's eye and getting them to contact you. You have maybe a few seconds so your profile has to stand out, be interesting, and personable. Photos are also very important. You need 3-5 nice solo photos to put on your profile. Photos will help a person decide if they are interested in you. Posting good head and shoulder and full body photos is important. Do not use...

How To: Convert YouTube music videos to mp3

Looking to change your YouTube Favorites to an mp3 to carry them with you everywhere? In this video, learn how to do so with the help of a download from dvdvideosoft.com, and this tutorial. Instructions for are listed below as listed by videomaker, vakama380:

How To: Install software on Linux

Finding Linux hard to handle after using Windows? Well this should help, here is how to install software on Linux. Start off by clicking on application launcher. Here go into applications, then into 'system' where you should find software management. In this program go straight into the settings and then edit software sources. Under 'downloadable from internet' make sure every option has a check against it. Now press the software management tab on the side. Now this is where you can get which...

How To: Perfect the elevator job pitch

They say you have to be in the right place at the right time... how about an elevator? If you happen to run into your ideal employer or business partner, in an elevator – or anywhere else for that matter – you'll have about 30 seconds or less to wow them. Here's how to do it.

How To: CC in a Physical Business Letter

CC, which stands for "carbon copy", is a familiar phrase in email, but can also be used in business letters and legal documents. This can be especially useful for letters you want to spend up a company or organizational chain, letting each recipient know exactly who else received the same document.

How To: Sell a screenplay

Attention aspiring screenwriters! In this tutorial, learn how to sell that script. You may have written the next Hollywood blockbuster – but unless you can finance the film yourself, you’ll need to sell the screenplay to a producer who can make it come to life.

How To: Set up your Gmail account in Mozilla Thunderbird

In this video from MegaByteTV we learn how to set up a Gmail account in Mozilla Thunderbird. First go to your browser and download Thunderbird from the Internet. Once downloaded, go to the Thunderbird application. Go to New and Account. Click on Gmail and enter your name and email address. Click Next and check off download messages now and click Finish. Your messages should now appear there. The first time you do this, all of your messages will look new but you can change that. If you'd like ...

How To: Bypass the iPhone 4 passcode lock screen to make phone calls (iOS 4.1)

Want to make a phone call on an iPhone 4 running Apple's iOS 4.1, but don't know its passcode? Not a problem. In this clip, we learn a simple trick that will allow you to bypass the lock screen entirely and permit you to view the phone's contact list and place phone calls to any number you like. This glitch has been fixed with iOS 4.2, so treasure this hack while it still lasts! This will let you unlock someones password on an ipod or iphone touch.

How To: Create a free website from scratch

You can create a free website using HTML. HTML is hyper text mark up language. Create a folder "my webpage" with all of the images and information for the webpage. Use notepad to write the HTML for the website. Notepad plus is the best which can be found on Sourceforge. Open the browser and the notepad and begin to construct. These codes will help in the creation of the page: <html> opens instructions </html> closes instructions. These are called tags. One opens the commands or instructions a...

How To: Get an achievement and avatar awards on Monday Night Combat

If you're looking for a great game, but at a low price check out the Xbox Live Arcade section for a great list of games. One of the more popular and talked about games is Monday Night Combat. It's a third person shooter game that features different classes like Team Fortress 2. It's a fun addicting game that is sure to attract many gamers.

How To: Set custom sound volume for different applications

In this video tutorial, viewers learn how to set custom sound volume for different applications in a Windows 7 computer. This task is very easy, fast and simple to do. Begin by simply clicking on the speaker icon in the system tray and select Mixer. There users will have access to the master audio mix on the left and each application listed individually, with their own volume bar. Just adjust each volume bar of the applications to your liking. This video will benefit those viewers who use a W...

How To: Go back and correct a mistake while texting with Swype

We all make mistakes and in this tutorial, learn what to do if you decide to go back and change a word after you've already typed it. Fixing a word with Swype - the fastest way of text messaging - is super easy and won't slow you down at all. So, if you've typed that rambling, soul baring text message at 3 am and want to go back and change a few choice words save yourself with this feature.

How To: "Hop" in Swype for harder to recognize words

There are some words that Swype has trouble with. While Swype will still be able to recognize these words, it will make you choose from a list of options. For example, you will run into this problem with the words "put" "pit" and "pot" because on a QWERTY keypad the letters "TYUIOP" are all in a line. In these situations, you may want to "hop" so that your texting stays up to super speeds. Check out this clip for an explanation of "hopping" from the makers of Swype and keep on texting!