Repairs Universe demonstrates how to replace the LCD screen on the LG Xenon GR500 cell phone. First, remove the battery and the SIM card from the phone. Then, use a small phillips head screwdriver remove six screws from the back of the phone. Next, use a safe pry tool to release the clips by running it along side of the phone. Remove the back layer. Remove the two screws on the inside of the phone. Also remove the volume key, the hold button and the camera button. Slide the phone to the side ...
This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact sa...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 514th installment in their series of digital spreadsheet magic tricks, you'll learn three methods for conditionally formatting duplicate values:
Learn how to make your own cell phone signal enhancing device! You're reception will be awesome with a simple homemade coffee and cookie can antenna.
Tossing old computers and electronics in the trash is bad for the planet. Techno-Guru Lloyd gives a smarter alternative.
Another aspect of landscape design is framing pathways. This can be done a number of ways. Steel arbors, wood arbors and trellises or any combination of those, all add interest.
In photography, creating a double or multiple exposure photo involves combining two different images to make one single image. This technique has been used in film photography by exposing a piece of film twice to two different images. The second image becomes superimposed onto the first image, creating various effects that may mirror one another or seem ghostly.
Staying in tune with the digital age doesn't mean you have to sacrifice personal health. In fact, new technology only makes it easier to workout and keep track of your progress. On any Android mobile phone, there's an application called Cardio Trainer that could help you out significantly. But how? Best Buy has answers. The Best Buy Mobile team explains how simple it is to use the Cardio Trainer app your Android enabled cell phone.
MissChievous gives us a tip about skin care. She thinks that a really important process in having a healthy skin consists in exfoliating your face once in a while.Basically, by exfoliating you get rid of all the dead skin cells. In order to eliminate your dead skin cells you must use an exfoliator. MissChievous thinks that the best exfoliator for your skin is the generic, not coded aspirin. Take two tablets of aspirin, put them in the palm of your hand and add a few drops of water. Then just ...
If you have any Google applications, like Gmail or Google Calendar, that you want to sync to your new Android enabled mobile phone, it's a simple task to complete. There's nothing hard about it, but if you think you need help, Best Buy has answers. The Best Buy Mobile team explains how simple it is to sync Google apps with your Android cell phone.
This is a video about the multiplication, determination, and inverse of matrix using excel. First we have to take two matrix in excel. If you take two 3x3 matrices and multiply it then you will get a 3x3 matrix as a result. First we have to select 3x3 cells in the excel and give then a formula of =mmult(and then select the first matrix it will automatically takes the row and cell numbers, next select the second matrix). Then it will give the answer. Next if you want to find the determinant of...
This how to video shows you how to use drop down lists in Microsoft Excel. This will be useful for stores and avoiding people ordering items that are not available. First, type the items in a column. Select them and then click in the name box. Type the name of the list. Note that it must be one word. Now, go back to the order sheet. Select the cell where you want the list to be placed. Go to data and select validation. On the settings tab, choose list and type in = and list name. You can pres...
Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If the...
This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are put in it by selecting the appropriate cell. The median is made an absolute constant by pressing the F4 key. This is squared by using '^2'. This is multiplied to the frequency using '*'. The result is found for all the dat...
The verb "stop" in the English language can be used with a gerund and an infinitive. The word "stop" has different meanings depending on how it's used. Look at the sentence, "I stopped eating fast food." Stopped is used in the past tense and eating is a gerund, or a word that describes an activity and functions as a noun. Look at the sentence, "I stopped to eat some fast food." In that sentence, there is an infinitive. The first sentence means I no longer eat fast food. The second sentence me...
Learn how to create a cell phone icon in Photoshop with this video tutorial. Draw a rectangle of radius 30 pixels by holding shift key. Right click on the toolbar and select Stroke button. It will open Layer Style dialog box. Set stroke color and set size to 2 pixels. Select Stop Color set little light red color and click on OK. Now, check on Inner Color option change size to 4 and Capacity value to about 60%. Now select Ellipse tool which will draw a ellipse and cover half of rectangle. Sele...
Need to sort a ton of data in Excel? Why waste time cutting and copying cells? In this tutorial, learn how make Microsoft Excel automatically sort columns or rows alphabetically.
You may think you'll never be in an emergency situation, but you can never be too prepared! This video provides excellent tips on what to bring and do in an emergency situation.
Those old cell phone and laptop batteries staring you in the eye? Don’t worry, recycling them is easy.
Whether your plane made a crash landing or your ship got lost on a three-hour tour, now you're stranded on a remote island. Here's how to get help.
Watch this video tutorial to learn how to make your own all-natural face masks. Tired of spending a lot of money on facial products that don’t even work? Try on some masks made from items you already own—they’re all natural and good enough to eat!
Stop bemoaning your blotchy complexion and start evening it out instead, no matter your specific skin complaint.
A virus easily spread among trout and salmon could make it harder to keep your favorite fish on the menu.
People infected with HIV take many different types of pills every day to decrease the amount of virus in their body, live a longer and healthier life, and to help prevent them from infecting others. That could all be in the past as new clinical trials testing the safety and effectiveness of a new type of treatment — injections given every four or eight weeks — look to be equally effective at keeping the virus at bay.
A tiny louse is responsible for decimating the citrus industry. Diaphorina citri, the louse in question, better known as the Asian citrus psyllid, harbors and spreads the "Candidatus Liberibacter asiaticus" bacteria that causes citrus greening disease.
Frosty the Snowman is a fairy tale they say, but this microscopic snowman is very real and just broke the record for the world's smallest snowman. (Though, it's not Guinness-official yet.)
We're living through the technological revolution, and while devices like the iPhone 6 or Galaxy S5 have made life easier and more entertaining, it's possible that sometimes our smartphone usage can become uncomfortably excessive. In your own experience, think about how anxious and off you feel when you leave your phone at home—Cell Phone Separation Anxiety or Phantom Phone Vibrations shouldn't be a real thing that we deal with.
Update: August 1, 2014 Earlier today, President Obama signed into law the Unlocking Consumer Choice and Wireless Competition Act, making the act of unlocking your unsubsidized cell phone 100% legal.
Traveling often is super fun, but sitting through 13 hours on the flight from California to Bangkok is killer on your skin, especially since the airplane recycles air and therefore dries out your skin.
You only get one picture day per year while you're in school. It only takes a minute or so, but the results of that one shot stay with you for life in the form of your yearbook. So instead of being the one girl who got too lazy to put on makeup and then sneezed in your photo shoot, turn up your game a little this year and be the perfect model for your picture. Makeup done for photograph purposes requires a bit of extra effort.
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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...
Have you ever been in a situation when you needed to remember something real important, but you didn't have you didn't have your trusty cell phone or other electronic savior with you?
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 658th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells.
We all have our reasons for erasing personal data from a phone. Whether you just ended a bad relationship whose face you never want to see again (lots of text messages) or just want to restore your privacy on the cell phone, erasing may be your only option.
There's no need to lug a big, heavy camera around all day when you have a perfectly good one already sitting in your pocket. In this tutorial, learn how to set up your iPhone so that you can capture high quality landscape shots. If you find yourself staring at a beautiful sunset with no camera in sight, just reach for your phone and follow these easy tips to get a great snap. No one will even be able to tell you used a cell phone if you do it right, so give it a try tonight!
In this clip, learn all about the brand new cameras on your iPhone 4. The latest iPhone from Apple has made major improvements on the cameras from the older models. Not only do you now have a flash, but you also have TWO fully functioning cameras with great picture resolution for a cell phone. In addition to that, the iPhone 4's new camera has face recognition software, a zoom lens AND an autofocus. There are so many fun things you can do with these cameras from photography to video to two-wa...
Oh, we feel you, guys. You're at the bar and you spot across the room a woman who, in all her godlike perfection, is too perfect to be true. Your heart rate pulses, your pupils and, er, other things dilate, and you get the urge to go up to her and try to start something.
In this clip, learn how to make the right phone calls and press the right buttons to "trick" your phone company into giving you a free phone upgrade before you are due. You will also learn how to save money on you phone bill by using a few choice words on the telephone. This trick works for Sprint, Verizon, T-Mobile and AT&T, so not matter who your carrier is you will be golden. This clip is hosted by an ex-employee from a cell phone company, so it is full of insider tips.
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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a transactional record when the date is 90 days past due using the TODAY function and mixed cell references in a logical TRUE-FALSE formula.
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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.