Showcased Tips Search Results

How To: Ride a dirt bike safely

If you're going to ride a dirt bike, you better learn how to ride it right. With tips and instructions for both the novice and experienced bike rider, this video covers everything from positioning yourself on the bike to riding over obstacles and uphill.

How To: Make children listen with their "listening ears"

In this video from CullensAbcs we learn a tip for how to children should listen with their "listening ears." This is taught by a girl and a gator puppet. She says to ask children to put on their listening ears so they can hear a story you are going to read to them or if you have something that you are going to say. Children like doing these types of things. It's a great tip to use to get your child to hear what you have to say. They can also make a sound when putting on their listening ears t...

How To: Prevent eyeliner from smudging with tips

Makeup always looks good when it's freshly applied. The problem, however, is that most of us apply that makeup in the morning and don't get back until 7 at night, meaning it's been on for about 12 hours. And if you happen to have a date or need to go out that night, your makeup is probably looking more Courtney Love than Camilla Belle.

How To: Use four tricks to make your eyes look bigger

In this tutorial we learn four tricks to make your eyes look bigger. The first tip is to layer on a shimmery light shadow to the eyes and then add on a darker color to the crease of the eye. Curl the lashes and then apply mascara to the eyes after clamping and working up the eye. Next, take some false lashes and apply these to the outer edge of the eye. The lashes will give you a thick and luxurious look. Later when you go to take these off you just need to use simple eye makeup remover. Any ...

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula in 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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Make a spooky smoking punch bowl for your Halloween party

Hosting your own party for Halloween this year and want to really set the tone for the party? Some people have one of those smoking punch bowls that are somewhat like a smoking cauldron. Looking to make the same effect? Well you will need to get some dry ice, but regardless of that, you should probably watch this video first to get the tips on making the proper smoking punch bowl with the right tips for safety and more.

How To: Calculate hours worked in a shift with a lunchbreak in Microsoft Excel 2010

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 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.

How To: Light digital home videos like a professional

Shooting home video is fun, and is a great way to get started on the path to a film career. But one thing that can kill your video is poor lighting. Not everyone is rich enough to a professional light kit, so what do you do to compensate? In this video you will get some great low budget, and even some free, tips on how to create proper lighting both in-doors and outdoors and tips on what to avoid in your scenes.

How To: Calculate weekly gross pay from time values in Microsoft Excel 2010

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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Avoid double-counting duplicates within a list in Microsoft Excel 2010

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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.

How To: Play power chords with a 5th string root note

Justin Sandercoe teaches us how to play power chords with a 5th string root note in this tutorial. Start out by placing your first finger on the root note and your third and fourth finger underneath. The tip of your fourth finger should be touching the sixth string. Push the tip of it up until you've trained it to always touch the sixth string, without this the song will sound terrible. Once you have the chord shape down, you will need to start to play some riffs. Move the fifth string root a...

How To: Change strings on the erhu

In this video, we learn how to change the strings on the erhu. First, loosen and remove the inner string. After this, take and unwind the new inner string. Then, take the end with the loop and put it through the Qianjing. Then, loop it in the screw at the bottom of the erhu. Then fold the tip of the other end of the string and put it through the hole in the first peg. Then, loop the string one and push the tip into the hole. Now turn the peg clockwise to tighten it. Repeat this for all the st...

How To: Compare a list of numbers where one group is entered as text in Excel 2010

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 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.

How To: Create a data validation drop-down list from a table with duplicates in 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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.

How to Play conga: modern tumbao

Tumbao is a basic beat. It is 4 4 timing. The fingers on both hands are bandaged on ring and middle fingers. The left hand looks flat, but is played in a heel, tip, heel, tip rhythm. Fingers on right hand are curved to meet the drum head. The left hand keeps the constant rhythm. Right hand does solo portion and moves from one Conga drum to another. Video is slowed down to see the exact rhythmic patterns. It also makes it easier to practice.

How To: Do the "Fork and Apple" trick

In order to do the fork and apple trick, you will need the following: a fork, and an apple. Reveal the fork to the audience. Next, reveal the apple. Taking a bite out of the apple is a good way to demonstrate that the apple is real. Place the apple on the tip of a fork. It should be tossed from resting on the tip of the fork. Then, toss the apple into the air and catch it with the fork. When the apple is caught, it should be skewered, by the fork. Take a bite out of it to demonstrate that it ...

How To: Use a string trimmer (weed wacker) for professional looking edges with Lowe's

There are many tools that homeowners can use to help with the curb appeal of their own and landscape. One of those tools is a weed wacker or string trimmer. This device enables the user to get rid of weeds instantly and makes lines and edges look clean and finished. So in this tutorial, you'll be finding out how to use one in your yard today. So good luck, be careful, and enjoy!

How To: Apply mime and clown make up

In this video, we learn how to apply mime and clown makeup. To start, outline your face in a mask shape. When you are done with this, apply white paint to the face until it's on thick and you can't see your skin color any longer. If you make mistakes, use a q-tip to clean up, then run it around the edges to make it a clean line. After this, use a q-tip to remove some paint from the eyebrows. Now, take black paint and paint it onto where the eyebrows are at. When you're done with this paint th...

How to Speak English: Pronounciation tips

In this tutorial, we learn pronunciation tips to Speak English. To help someone learn this, use an analogy, imagery, and vivid explanation so they understand what you are talking about in full detail. Use your hands to make the motions, then relate words to your base words. You will need to repeat yourself a lot, and also draw pictures so it can help them visually understand. Don't use difficult words, just start by doing simple words that are easy to understand. Once the easy letters are und...

How To: Use a macro to arrange a data set in a column in 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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.

How To: Play glissando on the piano

In this video tutorial, viewers learn how to play glissando on the piano. This task is very easy, fast and simple to do. Glissando is basically playing all the notes of the piano. When playing glissando, use the tip of the thumb to slide down the piano. When going up the glissando, use the tip of the middle finger and slide it up the piano. The fingers might hurt at first, but you will eventually get used to it with the more you play the glissando. This video will benefit those viewers who en...

How To: Increase hair elasticity

In this tutorial, we learn how to increase hair elasticity. A great mixture that will help increase your hair elasticity is honey and water. When your hair is wet, it can stretch up to 50% longer than it is without breaking! If you have low elasticity, your hair will not curl well and the heat will not keep your hair curly. There are many products out there that will give you more elasticity to your hair. Putting moisture in your hair will also help. The last tip is to see your doctor and ask...

How To: Whiten yellow teeth at home with a lemon

In this video, we learn how to whiten yellow teeth at home with a lemon. You will need: a q-tip, baking soda, and a lemon. First, cut the lemon in half and squeeze out all the juice into a container, then add in baking soda to the juice to make a paste and mix together with the q-tip. Now, apply this mixture onto your teeth and leave on for around 10 minutes. After you have done this, you will have whiter teeth in just a few minutes! Only use this mixture a couple times a week, because it is ...

How To: Clean an aluminum Apple keyboard by removing its keys

In this tutorial, we learn how to clean an aluminum Apple keyboard. You will need: soap , q-tips, and water. First, remove each individual key to your keyboard gently, then, clean off the keys and the inside with a mixture of soap and water on a q-tip. When finished, place your key back onto the keyboard. Repeat this step for your entire keyboard, making sure to be gentle when you remove and replace the keys back on. Don't do more than two at a time or you run the risk of forgetting where the...

How To: Cure acne prone skin naturally with ten tips

Acne sucks, and don't we know it. Our prom would have been ten times better had we not developed that continent-sized cystic blemish right at the tip of our nose (no concealor invented as of yet can cover up that monster), and the only thing more horrendous than going on first dates is going on first dates with a face full of stress pimples.

How To: Stop a nosebleed easily

In this tutorial, we learn tips from roadies. If you experience a nosebleed and don't know how to handle it, there is a very simple way to cure it. First, take a long string and tie it around the middle of your hand a few times until it's tight. Then, make a fist with your hand and squeeze for two minutes. By the time the two minutes is up, your nosebleed should have subsided. Another tip, is for when you have hiccups. First, take a pen and press it on the inside of the ear. After a few secon...

How To: Find APR, EAR & amortization for payday loans in 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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...

How To: Sum and average statistical data within 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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.

How To: Use some tricks in Alan Wake for the Xbox 360

With the release of Alan Wake, gamers were introduced to something they may have never seen before. This game is considered a full blown thriller that is sure to keep anyone on the edge of their seat. In this helpful tutorial from the awesome people at IGN, you'll find out how to fight the baddies in the game using some helpful tips. These tips and tricks will help boost your flashlight, flare placement, and dodging techniques. So check it out if you value your fictional life. Enjoy!