Cells Earning Search Results

How To: Make phone calls from the Samsung Galaxy Tab

The new Samsung Galaxy Tab isn't a cell phone, but that doesn't stop you from making phone calls! With this Android tablet, it's a breeze to make phone calls. Just hit the PHONE icon on the homescreen and dial your number. Press CALL and wait for the connection. You can MUTE the mic, use a HEADSET or MINIMIZE the dial pad. See how!

How To: Turn a tube sock into a cheap iPod or phone holder

If you want to save some money on an iPod holder, you might want to watch this video tutorial. You will learn how to make a cool iPod holder out of a sock. It's very easy to do and more importantly... it will save you money. You can even use that dirty, raunchy, gym sock to protect your iPhone or other cell phone too! Really though, make sure you wash your socks before making this iPod protector. You may not be protecting the ingenious mp3 player is you don't.

How To: Make sodium bromate & potassium meta-periodate

This video tutorial is in the Education category which will show you how to make sodium bromate and potassium meta-periodate. This experiment uses toxic chemicals and releases harmful gases. First you have to make a saturated sodium bromide. To this solution then add a small amount of potassium dichromate. The solution now becomes concentrated. Then make the circuit as shown in the video. You need a 3 - 5 ohm resistor in order to reduce the current. Then let the cell run for around 6 hours. S...

How To: Calculate weekly gross pay from time values in Microsoft Excel 2010

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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Create a glitzy title sequence in Adobe After Effects CS3, CS4 or CS5

In this clip, you'll learn how to use layer styles, blending modes and cell pattern effect to create a fun, glamorous pre-roll sequence in Adobe After Effects CS3, CS4 or CS5. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step inst...

How To: Use magnets to stick things to the roof of someone's car for a prank

The prank is one of the most cherished traditional forms of expression around the world, from Japan to the Middle East to the good ol' US of A. Without them, how would people settle their disputes with one another while having a good laugh at the same time? Every time a new phenomenon enters our lives, new pranks emerge that can be performed with it. We at Wonderhowto love pranks as much as anybody, and to that end we've scoured the internet for videos demonstrating the proper setup and execu...

How To: Wear a wrist watch

This video tutorial belongs to the Beauty & Style category which is going to show you how to wear a wrist watch. These days not many people wear watches. They find out time with their cell phones. If you want to improve your image, wearing a watch will help. If you are going for a job interview or on a date, you should wear a watch. Because watches co-relate to responsibility and hence project a better picture of yourself. A solid stainless steel watch is universal and matches with formal as ...

How To: Calculate and add running percentages in Excel

In this tutorial, we learn how to calculate and add running percentages in Excel. First, write out your value and percentage into the different columns. Next, write the formula in the cell where you want the answer to appear. To have the answer appear, highlight the box and drag it down, then the answers will start to appear in each of the different columns for the different equations. This is an extremely simple way to calculate these percentages without having to do any math! As long as you...

How To: Use templates in Dreamweaver

In this tutorial, we learn how to use templates in Dreamweaver. First, go under "create new" and click on "hdml". Start with a table that has three rows and one column at 100% width. Click in the middle one and split the cell into two columns. Now, click "insert", "template objects", then "editable region". Type text into this box, then it will show up on your page. Whenever you open a file, this will be the part you can edit, while you won't be able to change anything else. Now go to "file" ...

How To: Do a yoga resting crocodile pose

In order to do the resting crocodile pose, you will need to lie on your stomach. Separate your legs. Space your legs greater than hip distance apart. Your toes should be pointed. Cross your arms. Your arms and chest should form a triangle with the floor as the base. Rest your head on your hands and breathe deeply. As you inhale this will work your lower abdominal muscles, while it sends more oxygen to the cells of your body. This pose is a recommended pose for anyone who is rehabbing muscle o...

How To: Stay awake at work using yoga exercises

To use yoga exercises to wake up and stay awake at work, begin by doing breathing stretches: i.e. cow to cat stretches. Inhale, expanding your chest out for the cow stretch, and exhale concaving your chest into the cat stretch. Next, do side stretches from left to right. Repeat these. Next, add 4 punches: left jab, right jab, undercut, and undercut. Extend your arms fully. Repeat all of the steps together.

How To: Use a Clarisonic Mia brush for beginners

Hordes of women live and die by their Clarisonic brushes, which they claim speeds up their cell turnover rate and decreases hyperpigmentation as well as old acne scars, creating fresh, youthful skin. But Clarionic newcomers may find this vibrating brush to be a little intimidating.

How To: Convert mp4 to mp3

In this video, learn how to access a computer program online that will allow you to convert your MP4 files to basic MP3's. This is great if you would like to download items via iTunes but do not want to play them on an Apple product. For example, if you use a Zune, non-Apple MP3 player, cell phone or any other device to listen to music, you will need to have these files saved as MP3's. Follow along and learn exactly how to do this.

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: Set a photo as caller ID

Are you a major networker with a cell phone full of digits? Are you horrible at remembering names and often times look at incoming calls with a look of confusion? There's a way to remember them from this day forward. Once you get a number, snap a picture of them and set it up as their caller ID. When calling, their photo will appear giving you a hint who it is! In this video courtesy of Best Buy Mobile, learn how to set a photo as caller ID.

How To: Count blanks in an dynamic range in Microsoft Excel

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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).

How To: Evaluate a random value against criteria in MS Excel

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

How To: Sort Excel data in custom order

This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...

How To: Sort data in single columns & whole tables in Excel

To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...

How To: Create an Excel table in Excel 2007

First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.

How To: Root your T-Mobile G1

Rooting a cell phone can give you so many different perks and advantages that you wouldn't normally have. But at the same time it can also cause damage to the phone itself that it may even cease to function properly causing any money that you spent, to go down the drain. This tutorial shows you how to root your T-Mobile G1. Be careful and good luck!

How To: Use the text-to-column tool in Microsoft Excel

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 192nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the middle name in quotes from a cell that has last, middle and first name using Excel's in-built text-to-column tool.

How To: Tell if your device is tethered or unlockable

In this video, the instructor shows us how to tell if a device (cell phone or other device) is tethered or un-lockable. Before you begin, you must download a tool called f0recast onto your laptop or desktop computer. After the application is downloaded, you must plug in your device to your computer (Windows only). Once you've done this, a window will show up from F0recast that will show you all of your phone's information. This includes if it's lockable, if it's tethered, the serial #, model ...

How To: Create a simple line chart in Excel 2007

Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the line option. Select the two dimensional line graph option from the given choices. Move the chart to a new sheet. Label the new sheet in the appropriate field and click the OK button. Your line chart will now be created usi...

How To: Use Bluetooth to connect your cell phone to your Mac

First open up system preferences, select Blue Tooth and click the plus at the bottom. Make sure that your phone has Blue Tooth on and wait for your phone to pop up. Click continue and enter the number 71057113 onto your phone in the space provided. Once your phone is connect to Blue Tooth, this space should be there. After clicking pair on your phone a Bluetooth set up assistant window should pop up. Click on the x, then click on the settings after selecting your phone. Even though it says no...

How To: Create formulas with workbook references in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.

How To: Save your wet cellphone

In this video tutorial, viewers learn how to save a wet cell phone. Begin by taking the battery and remove all electrical power. Now wrap the phone in a dry washcloth and cover it with aluminum foil. Then put it into an oven for 5 hours at a low temperature. It is recommended to heat it at about 125 degrees. Another method is to put the phone into a container filled with dry, uncooked rice and leave it for 1-2 days. This video will benefit those viewers who have accidentally dropped their pho...

How To: Not pay for texting on the iPhone or iPod Touch

This video shows you how to bypass expensive texting charges and use this free and easy way to text people without the need to download apps, go to websites, or jailbreak your device. Works on basically any cell phone. No need to ever pay $20.00 for unlimited texting with AT&T, watching this you'll be able to text for free whenever, and whoever.

How To: Use Skype on the Nokia N900 phone

This video shows you how to use Skype on a Nokia N900 cell phone. Skype can be activated from the Settings menu of the phone. You must scroll down to "VoIP and IM Accounts" and then select "Skype". After that, you must either log in to your Skype account or create a new one. If you don't have an account, then you must create one and you'll be able to sign in right away. Once you have logged in, you can create and edit contacts. Once that is done, you can use Skype to contact people. Skype set...

How To: Use the IF function with letter grades in Excel

This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...

How To: Create a text alert database using Google Forms

This video explains how to create a database text alert using Google Forms. In Google documents click on new, then form. After naming the form and typing in that standard text messaging rates apply, our presenter selects multiple choice yes or no options. Select it to be a required question so that the user can make sure they understand terms. You can choose to select any or all of the questions to be required. You can then type in various questions for the user to answer-our presenter wants ...

How To: Do long division with remainders

This video goes through the step by step process of doing long division with remainders. Multiple examples are used throughout the video to give the viewer a better idea of how to properly complete the difficult task. Perfect for anyone learning long division for the first time, or for anyone attempting to relearn long division after forgetting how to do the process (an all to common occurrence in a world with calculators on every cell phone).

How To: Make HD videos in Windows Movie Maker

Windows Movie Maker can be used to make HD movies. This step by step clip shows you how. The first step is to import your picture or video and make sure they're in your timeline. When you've finished editing, go to tools and options and choose the advanced tab. In video properties there's video format and aspect ratio. Select NTSC and 16:9. If you're using a cell phone or video camera, you'll be using 4:3 which is pretty small for YouTube and similar sites in order to get full screen. Save th...

How To: Convert music to ringtones through iTunes

In this video tutorial, viewers learn how to convert music to ringtones using iTunes. Begin by finding a song. Right-click and go to get info. Go to Options and change the time to any 40 second period (check both boxes). Covert it to AAC. Delete New Version, but keep file. Then close iTunes. Find AAC song file and drag it to the Desktop. Rename from .M4A to .M4R. Double-click and it will open in iTunes under ringtones tab. Sync just like you normally would. This video will benefit those viewe...

How To: Use Excel formulas & functions

In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if you pay attention during this presentation you'll pick up the skills quickly! Several ideas covered in this video are Formulas with cell references, how to find various Excel functions to use in formulas, and the Effect f...