Knowing Tips Search Results

How To: Remove Recent Contacts from the iPhone's App Switcher in iOS 8

Apple introduced recent contacts for the app switcher (aka multitasking menu) in iOS 8, useful for quickly calling and texting your most-contacted friends and family. Just tap on one of the contact bubbles and an assortment of options appear—call, message, or FaceTime. While the feature can be helpful when you want quick access to functions for recent contacts, it may not be for everyone. Check out the short guide below to learn how to easily remove recent contacts from the multitasking menu ...

How To: Use the SUMIF function with an array 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Bypass airport security easily with your gadgets

In this how-to video you'll learn all the tricks and tips to getting yourself through airport security quickly and easily, even if you have electronic gadgets. Some companies produce travel gear that the TSA will let pass through without having to remove your laptop or electronics. Timesaver! Watch this video and you'll soon be cruising through the "Expert Traveller" line.

How To: Make yourself pack light for business trips

Avoiding the need to check luggage has been one of the biggest goals of business travelers for decades, especially now that many airlines charge more baggage fees than ever. This video outlines six easy tips for packing lightly and efficiently, which will enable you to carry all of your bags with you and save a lot of time at every stage of your trip. These include wearing your heaviest clothes and organizing your belonging within your suitcase.

How To: Keep yourself from getting jet lag

Anyone who has flown across multiple timezones is familiar with the negative effects of jet lag, especially when traveling for business on a tight schedule. This video features four easy tips for avoiding the effects of jet lag. These include hydrating properly, going outside, exercising, and forcing yourself into the rhythm of whatever place you are in rather than napping in order to remain on your normal schedule.

How To: Enter a mail-in sweepstakes using tips & tricks

In this video, learn how to enter mail-in sweepstakes, what supplies you need, tricks and tips for filling out entries, how to organize your entries, and how to not get disqualified. This clip will walk you through the entire process so that you can increase your chances of winning and getting one of those oversized checks delivered to your door. So, follow along and enter those contests the right way to maximize your opportunities to win.

How To: Magnify to edit text on an iPhone

In this Electronics video tutorial you are going to learn how to magnify to edit text on an iPhone. This video is a part of a series of tips on iPhone finger tips. This is very simple and easy to do and takes practically no time to complete. If you wish to add something to a list or change an email, go to the springboard and click on the ‘mail’ icon. Then scroll and find the text you want to edit. Now simply touch and hold your finger on the text. This will bring up the magnifying glass. Now ...

How To: Generate random numbers not divisible by 3 in 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 261st installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random numbers within a certain range and with certain supplementary criteria (e.g., values that are not divisible by three) via the use of large array formulas.

How To: Take a cheap summer road trip

It's just the two of you, the open road, and a limited amount of cash. Just because you're on a budget doesn't mean you can't have a blast. This travel how to video gives you tips on taking a cheap summer road trip. Watch this tutorial and you'll be hitting the road on a budget in no time.

How To: Show your girl you really like her

In this video, we learn how to shower you like her with the Wing Girls. The first way to show a girl you like her is to do sweet things for her that she will really appreciate. Also, make sure you compliment her on her physical appearance. Don't be afraid to let her know she is pretty and tell her what you like about her. Comment on her hair or how great her laugh is. Blow off other girls for her and avoid answering your phone while you are out with her. Using these tips will show her that yo...

How To: Do Batman face paint

In this video, we learn how to do Batman face paint. First, you will need to apply a metallic silver paint to make a mask Batman design around the eyes. Next, use a fine tip brush to paint black for the outline around the Batman design. You may need to have the logo printed out by you so you know how to paint it. Next, draw a circle around each of the eyes, then you will have the completed Batman face paint! This is great for children and is extremely easy to do. This is great for parties and...

How To: Ride a motorcycle safely with a passenger

In this tutorial, we learn how to ride a motorcycle safely with a passenger. First give your passenger gear for themselves, then have them sit behind you on the bike. Make sure they hold onto you while you are driving, and you take turns more slowly at first. Turn the sides gently and have them lean into the turns with you. Before each of you get on the bike, tell your passenger how to behave while they are riding on it. This will better equip your passenger to know what to expect and how to ...

How to Write a song: Melodic phrases & lyric phrases

In this tutorial, we learn how to write a song using melodic phrases and lyric phrases. Instead of talking in syllables, you want to use a musical phrase. Practice humming your song without using words, so you know the road map of where the music should go. Make sure your words go with the melody of the music, and the lyrics match how the song flows. If they don't, you can create a new phrase so it matches the melody. Play your song and substitute different words to see how they fit with the ...

How To: Find and open documents the easy way in MS Word 2010

Before you can work in Word 2010, you'll need to learn how to work with it. See how to locate and open documents the easy when using Microsoft Word 2010 with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using this tip yourself, take a look.

How To: Build and use array formulas in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Preserve home-grown herbs

Growing your own herbs is easy. So easy, in fact, that you may soon find that you have more than you know what to do with. In this home gardener's guide, Melinda Myers discusses how to store herbs that you've harvested from your home garden.

How To: Steam an artichoke

A few tips and tricks in cooking involving artichokes. A simple trick of the trade made to use while cooking at home or even if you are out preparing artichokes on the grill. One of few examples that artichokes are known for in cooking is first by steaming the artichokes for about 35 to 40 minutes, or until you could take a knife and if it easily penetrates without being tough your artichoke is ready. This video gives you a small demonstration on what you could do with your artichokes. You co...

How To: Make paneer tikka masala

In this video, Chef Vah teaches you how to make a delicious paneer tikka masala. Full of spices and tons of flavor, this is a great dish to please all your vegetarian cravings. This is very similar to the chicken masala, with a few alterations. Chef here gives you a play by play of everything you need to know and do to achieve this great dish for an authentic Indian meal. Full of tips, and thorough instructions of how to make this, your mouth will be watering before you even begin your own pr...