Advanced Features Search Results

How To: Get Google's Avengers AR Sticker Packs on Any Android Device with ARCore

The idea of augmented reality isn't new, but the world of smartphones is looking to push it forward in a big way. As with any platform, both product demand and technological advancements have to catch up to the industry before it can become a viable solution for daily consumer life. Apple and Google are working to introduce the smartphone consumer to AR for the first time with basic features for now.

How To: 5 Ways to Improve the Bluetooth Experience on Your Samsung Galaxy

Many of us rely on our smartphones for all our media needs. Now more than ever, we're using Bluetooth connections to play audio over speakers, headphones, car sound systems — the list goes on. If you own a Samsung smartphone like the Galaxy S9, there are a number of Bluetooth tweaks and hidden tricks that can maximize your audio experience.

How To: Unlock Android 9.0 Pie's New 'Feature Flags' Menu to Modify System Settings

There's a new secret settings menu hiding in Android 9.0 Pie that offers Chrome-style "flags" to the overall operating system. Since it's currently the first Developer Preview and Public Beta versions, it's possible that this menu could disappear entirely when the stable version finally gets released, but it could also persist in its current hidden state where you have to unlock it.

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

How To: Create a daily Gantt Chart in Microsoft Excel

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 two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.