Advance Service Search Results

News: How to Get Unlimited YouTube & Google Play Movies on T-Mobile

Google dropped its opposition to T-Mobile's Binge On service due to some favorable policy changes at the magenta carrier. From now on, YouTube and Google Play Movies will happily work with the feature. Binge On rolled out late last year, allowing many customers to receive unlimited video streaming at 480p. That's not a great offer if you care about video quality, but it's nice if you want to save money.

How To: Disable T-Mobile's 'Binge on' for Better Quality Videos

T-Mobile's "Binge On" service for streaming videos has received mixed reactions so far. On one hand, it gives any T-Mobile subscriber unlimited access to popular streaming video services like Netflix and Hulu without having to worry about going over their monthly data cap. On the other hand, it reduces video quality to 480p, which is 6 times lower than full HD.

How To: Make Companies Call You Back Instead of Waiting on Hold

Getting on the phone for customer service can be extremely frustrating. First you've got to find the correct phone number for your region (good luck trying to get customer service from a sales department), then you have to listen to the annoying automated system to navigate your way to the department you want. More often than not, you'll be stuck with some elevator music while you wait to speak to an actual human.

How To: Use your Mac as a wireless adapter for XBox Live

In this video, we learn how to use your Mac as a wireless adapter for Xbox Live. You will need: a Mac, monitor, Xbox, and Ethernet cord. Start out by going to system preferences, then going to the sharing folder. Go to internet sharing and make sure the Ethernet box and internet is selected. Then, click the box next to internet sharing and click "start". Now, go to the network option and go to advanced, TCIP, and then write down your sub maps and router IP address. After this, plug the Ethern...

How To: Do the Presto Printo card trick

To do the Presto Printo Card Trick, you need to begin with a deck of standard cards and a deck of plain white cards, which have been cut to the same size as standard cards. You will need to print the effects that you want to achieve on the cards in advance. You will need extra blank white cards to conceal.

How To: Play "Numb" by Linkin Park on acoustic guitar

In this video, we learn how to play "Numb" by Linkin Park on acoustic guitar. Start out with putting your middle finger on the second fret of the A string and play an E minor. Now, move your ring finger to the third fret of the A string and your pointer finger on the E string. Now, play a G with your middle finger on the first fret and your ring finger on the third fret. Learn how to get your finger movements correct while doing this, then start to play the intro and the rest of your song. As...

How To: Properly use the words "whether" and "weather" in English

In this video, we learn how to learn how "whether" is used while speaking English. The word "whether" is used when you are going to talk about different things, not the weather that is outside. If you can use the word "if" instead of "whether", you are using the word with the "th" instead of "ea". The "weather" is used when you are talking about what it's like outside. This includes if it's hot, cloudy, raining, snowing, and anything else. Any other time you are talking, the word "whether" ca...

How To: Disable quick fill handle & drag-drop Excel features

In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...

How To: Use the Mail email app on an Apple iPad

If you want to send and receive email on your Apple iPad, unless you're an advanced user, you'll most likely want to go through Apple's official Mail app. Fortunately, it's easy to use. So easy, in fact, that this guide can present a complete, step-by-step overview of the process in just over three and a half minutes' time. For detailed instructions, and to get started reading and composing email on your own iPad, take a look!

How To: Do a yoga flow into a handstand with Tara Stiles

Despite common misconception, yoga is extremely intensive and a challenge for core stability and muscle stability, especially when you encounter poses like handstands. Not easily done by even the most experienced yoga experts, handstands are a true test of your yoga prowess and ability to say "ohm" with two feet up in the air, arms aching and trembling.

How To: Install the Window Seal Onto a VW Bug Window

Restoring any car can be a difficult task for even the most advanced mechanics. It takes time and patience to turn an old pile of junk into something new and beautiful. So in this tutorial, you'll find out how to install new window seal and trim onto a classic VW Beetle Bug. It's fairly easy to do and in the end, will result in a great looking vehicle. Good luck and enjoy!

How To: Adjust the brightness on your Android phone

Some people like their screens to be dim while others like theirs to be bright. Some like brightness to automatically adjust, while others like a constant level. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to adjust the brightness of the d...

How To: Map a walking route with MapMyWalks on Android

Take walks for exercise, to roam around your neighborhood, or just to get outside? Want to know how far you walked? Well, it's easy to do with MapMyWalks and Google Maps! One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to map out your walks us...

How To: Use location and security settings in Android

Many applications, especially those found in the Android Market are more effective when they know your physical location; like an app that's going to find the nearest gas station, restaurant or ATM. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial, in particular...

How To: Extract email extensions with filters in MS 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 338th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension.

How To: Extract the top 5 values from a given list 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 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Build a mini fridge

In order to build your own mini fridge, you will need the following supplies: a heatsink, a cardboard box, a petier unit, popsicle sticks, standoffs, an AC adapter, scissors, and on/off switch.

How To: Do hip pushups

In this Fitness video tutorial you will learn how to do hip pushups. This one is for advanced body builders and not for beginners. You can use push up stands or use towel to cushion your fists while doing hip push ups. This is not to be done with palms open. Keep your elbows on your sides and you will be pushing from your hips. Stretch your body with the weight on the fists and toes. Keep your torso straight, abs flexed tight, then go down slow and come up slow. The body should be straight. D...

How To: Apply cologne properly

In order to apply cologne properly, you will need to choose the best cologne for you in advance. The cologne will need to mix well with your own natural scent. It is important to avoid overuse. Stick to a three (3) spray rule: never exceed 3 sprays. The distance from the body is important. Therefore, you should spray a distance from your body.

How To: Extract a unique list from a huge data set in MS 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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.

How To: Do the "air chair" in breakdance

Have you mastered the beginning break dancing tricks and are looking for something a bit harder? Try the "air chair". To do the air chair in breakdance, you'll need to already know how to do a chair, because the air chair is an advanced version of the chair. Get the air chair down with help from an expert.

How To: Group duplicates & extract unique records in MS 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.