Leaving your Wi-Fi radio "on" allows your smartphone to auto-connect to trusted wireless networks in lieu of using cellular data, but it also consumes battery power while it's constantly network hunting.
Everyone loves using their cell phones for everything except actually making phone calls. Whether it's watching streaming video, listening to music or playing video games, it would seem that calling people is almost an afterthought to cell manufacturers in this day and age.
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 ...
In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizontal lines. Now go back to the data set, click on a cell and click ctrl+shift+L and that will add the auto filter. ctrl+shift+L is for Excel 07. For earlier versions, see the commands listed in the video. This is a toggle...
ShowMeAcademy.com shows how to sort data in Excel 2007. Excel has many options for sorting data according to any given column. To sort your data, right click on a cell in the column that you want to sort by. A menu comes up where you will see the “Sort” option. Hold your mouse over “Sort” and another menu comes up showing the different ways to sort. For example, if you select “Sort Smallest to Largest” it will take all the data and sort it from the row that has the lowest figure u...
Today's Tech shows you how to fix a cell phone or computer that has gotten wet or jammed. With a wet cell phone, you must act quickly or it may be permanently damaged. The first thing you should do after pulling it out of the water is to take the battery and SIM card out. Dry both of them off. If you drop it in a liquid that is not water, rinse them off quickly. If you have a vacuum cleaner handy, you can use it to suck the water off. You can also place the phone on top of your cable box. Wai...
Steer clear from empty flattery and malicious social engineering with these tips on how to avoid a player.
Thanks to modern "smart phones" and the internet, media by the people, for the people is finally a reality. Here's how to use your phone to be a mobile journalist.
This how-to video is about how to repair a leaky faucet. One of the most common problems with the faucet is the replacement of the rubber washer, which is located on the bottom of the valve unit. First, stop the water supply by turning off the stop valve at the bottom of the sink. Then, turn on the faucet until the water stops flowing. Next, remove the handle. To do this, we first need to remove the decorative cap using a screw driver or sharp pointed knife to expose the screw. Then, remove t...
The Inspire 4G is AT&T's hot new budget 4G handset, and it's a powerful little unit thanks to a fast processor and AT&T's new 4G LTE network. This video will show you how to root, unlock, and S-OFF your device so that you can do whatever you want with it. The second part of the video shows you how to fix the sound issue from the first part AND install DesireHD ROM games on the phone. All of the advantages of jailbreaking without the cool name. You will need this software.
The internet has created amazing new standards for how closely information can be followed. If you want a portable analog unit that will monitor one important piece of online info continuously and have some DIY electrical knowhow, watch this video. It will show you how to use an Arduino Ethernet Shield to make an internet meter to monitor email, stocks, and other online info on a simple analog display. You will need to know some PHP to make this work.
This tutorial shows you a very basic method to create an effective boffer sword using PVC pipe, a foam noodle, duct tape and some open-cell foam for a stabbing-safe tip. You're also shown a good method for constructing the hilt. This is a great tutorial for anyone looking to make a foam sword for their favorite boffer larp!
A lot of women mistakingly think that they can't do arm exercises or lift weights because they will bulk up like a classic chunkhead. But this logic is extremely false. If you're trying to lose weight, muscle burns more calories per unit than fat, which means gaining muscle is to your advantage.
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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function with approximate criteria to add when criteria has other content in the cell.
In this tutorial, we learn how to start an urban living indoor garden during the winter. You can easily place a shelving unit over the side of a window sill. This will also need a fastener attached to it to give it extra support. After this, you will need to install florescent tubes at the top of the shelving to help your indoor garden grow. Use small plastic bins to plant your seedlings in. These are perfect for a small greenhouse that you can place on the shelves and leave to grow with just...
Have you seen odd, square codes on some specific merchandise? These are called QR codes, or quick-response codes, and they are a type of bar code which your smartphone can read and then take you to a particular website, give you coupons or even a business card. Here's how you can get the most out of QR codes.
'Rooting' (also called jailbreaking) will let you install third party software or applications which the manufacturer may not allow (or get rid of apps that you don't want). It will void your phone's warranty, so make sure this is really what you want to do!
If you already own a copy of a song, it's silly to pay again for rights to use it as a cell phone. Especially in light of how easy it is to create custom, free ringtones with the latest iteration of Apple's digital music jukebox, iTunes 10. Take a look.
Need some help figuring out how to set up and configure your BlackBerry Torch 9800 cell phone? This clip will teach you everything you'll need to know. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this official video guide from the folks at Blackberry. For detailed information, including step-by-step instructions, take a look.
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
In order to properly measure flour with a scale, you will need the following: flour, a scoop, and a scale.
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to you can make a mobile wall of supply depots on your Terran base's...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to use the Protoss unit the Sentry and their force field ability to ...
There's a lot of questions about screen capture on Android cell phones like Motorola's Droid and the HTC Droid Incredible. Currently (and unfortunately) there is no simple way to take screenshots of you Droid's screen. There are no applications, except for ones that require a rooted phone. But this way may be the easiest for you…
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2 is finally upon us after 12 years of waiting, and it is just as majestic as you would hope it would be. If you're new to the series or just haven't played in five years, the barrier to entry for the unskilled can high, especially if you prefer playing online multiplayer. Fortunately for you, we've compiled videos on just about everything you need to know about the game, including strategies and tips for winning with different races in different modes and situations, and even how t...
Starcraft 2, like so many modern games in this age of modding, has a really robust level editor that's going to extend the lifespan of the game for years. You can edit almost anything about any of the game's many units buildings and maps, and make the game however you want it to be. This video will show you how to create a day and night cycle using the level editor that will make your games feel much more real. The creator included a download for a trigger library, but does not explain how to...
Starcraft 2, like so many modern games in this age of modding, has a really robust level editor that's going to extend the lifespan of the game for years. You can edit almost anything about any of the game's many units buildings and maps, and make the game however you want it to be. This video will show you how to use Galaxy Editor to make Warcraft 3 style shops in your custom map where you heros can buy and sell items. If you want to make a Starcraft 2 RPG (you aren't alone) watch this.
Jailbreaking any one of the i-family Apple products, be it the iPhone, iPod, or iPad, is a great way to expand their lamentably limited capabilities. If you were wondering if you could still do it on a unit with iOS4, the answer is you can! And this video will show you how to do it if you have an iPhone 3G or iPod Touch 2G by using a software program called redsn0w 0.9.5. If all goes well this should be quick, easy, and have you well on your way to enjoying all that your iDevice can offer.
The Google Android Market offers you thousands of free and for purchase applications to download to the HTC Droid Incredible cell phone. In this video, Verizon Wireless shows you how to navigate the Android Marketplace and download the newest and coolest Android apps.
You can customize the seven home screens on the HTC Droid Incredible cell phone by adding widgets, changing the live wallpaper, and creating scenes to fit your lifestyle. Live wallpapers move and respond to your touch and changing scenes is a quick way to match the Incredible to your current status. Verizon Wireless shows you how to personalize your phone.
Getting to know your HTC Droid Incredible cell phone will help you fully experience its benefits. In this video tutorial, Verizon Wireless shows you some basic navigation tips for the home screen for getting started with your Android device.
Just because you have more than one Gmail account doesn't mean you can't view them all on your HTC Droid Incredible cell phone. Verizon Wireless teaches you how to add multiple Gmail accounts to the Incredible's Android platform, making it easy to get all your emails as soon as they arrive.
We all know the G-spot as that sensitive area that drives women crazy, but for auto enthusiasts, it has a whole new meaning. The G-Spot, designed by Daniel Davies, is a vehicle immobilizer, which keeps your vehicles safe from car thieves. And you don't need to pay a huge amount of money to get one, either! You can make on yourself, right at home, provided you have all the right materials.
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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
Where do you get all of those cool apps for you Android mobile device? There's one place to go to find all of the latest apps for your mobile phone, so what is it? Best Buy has answers. The Best Buy Mobile team explains how simple it is to add a contact to your Android enabled cell phone.
Science fairs are some of the most creative moments during the elementary school period. Not only are you able to research a topic of interest, but you also have try to find various ways in which to showyour scientific results. In this case, you'll find out how to make an edible plant cell model for an easy science fair project of for biology class. It's easy to do and will surely attract the attention of your teacher and others. Enjoy!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 101st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use conditional formatting AND custom number formatting to add styling to a cell.
