Formulas

How To : Count unique items with multiple criteria 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. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use ...more

How To : Calculate simple interest

Learn how to calculate simple interest with step-by-step instructions using the formula I=prt. Simply defined, interest equals principle times rate times time. The video shows various examples of calculating this formula by plugging different variables into the equation. Altho ...more

How To : Divide fractions in math

When you see a problem involving a fraction, don't freak out. Dividing fractions is actually fairly easy once you learn the simple formula of how to do it. Math can be scary, but don't give up. Follow these simple steps, and soon you'll be dividing fractions like a pro. Step ...more

How To : Get Christina Aguilera's "Dirrty" makeup look

As a mom and now in her late 20s, Christina Aguilera sports classy and age appropriate makeup, attending red carpets with classic ruby lips and light cat eyes. But this Ecuadorian and Irish beauty wasn't always this put together and chic. A few years ago she was known as XTin ...more

How To : Use the AVERAGE IF function 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 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use ...more

How To : Prevent duplicate entries in an Excel spreadsheet

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the ...more

How To : Use the future perfect tense in English easily

The future perfect tense describes a situation which is finished in the future. This video tells us how we can use future perfect tense easily. It gives us a deep insight through the grammatical aspect of future perfect tense. It shows us how to use the helping verb i.e "will" ...more

How To : Count the number of days between dates 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 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between ...more

How To : Treat and prevent diaper rash the right way

Ouch! Is your baby's bottom red and sore? Say goodbye to diaper rash with these tried-and-true remedies. You Will Need: * Diapers * Diaper-rash cream * Unscented baby wipes * Unscented, alcohol-free soap * Washcloths * A squirt bottle (optional) * Cotton balls (optional) * War ...more

How To : Find the zeros when graphing a quadratic equation

In this tutorial the instructor shows how to graph a parabola and also how to find its roots which are also known as zeroes. He gives the quadratic formula of how to find x-intercepts of a parabola. He takes an example and substitutes the values and finds out the values of the ...more

How To : Master Excel with This Certification Bundle

Microsoft Excel is one of the most useful tools you can bring into your professional life. However, as useful as Excel is, it can also be difficult to learn on your own. The All-In-One Microsoft Excel Certification Training Bundle is an incredible tool that will take you from ...more

How To : Score a Pamela Anderson makeup look for cheap

"Baywatch" babe Pamela Anderson is famous for big, sultry smokey eyes and plush, nude lips. In this tutorial you'll learn how to achieve an utterly gorgeous purple-based smokey eye that's perfect for a night out club hopping with your posse. It's a beautiful makeup look that'l ...more

How To : Use implicit differentiation

Taking this formula 9x²+y²=9 your instructor shows you how to find the solution for the variable y. Finding a second derivative is no more difficult that finding the first derivative, you only have to do the problem equation through twice. The derivative of 9x² will be 18, of ...more

How To : Use MS Excel Effectively

Welcome to the first chapter of Excel is Simple, a place where we will burst all myths around excel and try to make it simpler and fun to use. I would like to share an important tip…if you want to be fast with Excel, try to avoid using the mouse as much as you can. We will so ...more

How To : Find the Perimeter of a Rectangle

If you have a rectangle and the length of only one side is given,how do you find the perimeter. The video shows how the diagonal creates a right triangle. This right triangle can be used to find the other side of the triangle, and then the perimeter. Video: . The formula for f ...more

How To : Find the area of a trapezoid easily

Finding the area of a trapezoid can be done easily by using a simple formula. The area can be found by adding the length of base 1 plus base 2 then multiplying by the height and then dividing the sum by 2. The bases of the trapezoid are the straight lines that are parallel to ...more

How To : Factor a trinomial by GCF then grouping method

This is a video tutorial in the Education category where you are going to learn how to factor a trinomial by GCF then grouping method. For example how to factor the trinomial 6r(squared) – 28r + 16. The first thing is to get the greatest common factor (GCF) of the numbers. S ...more

How To : Choose fish for a cold water fish tank

This film will show you how to select fish for a cold water temperate aquarium. It will help you decide which types to choose and how many to keep in your tank. The type and number of fish you can keep will depend on the size of your tank. An easy formula for calculating how m ...more

How To : Use the entes de and después de verbs in Spanish

In this video, we learn how to speak Spanish: Antes de / DespuŽs de + verbs. When you say "antes de" this means before and "despues de" means after. Saying these in sentences can help describe doing something at a specific time. The formula for this is to have the "antes/despu ...more

How To : Keep a baby calm on a flight

Reduce your chances of becoming the seatmate everyone hates by learning how to head off a screaming jag. You Will Need * A seat over the wing * A baby bottle, breast milk, or a pacifier * Frequent diaper checks * A midweek, midday flight * A baby stroller Step 1: Go midday Tr ...more

How To : Deal with a circular reference warning 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 214th installment in their series of digital spreadsheet magic tricks, you'll learn how to deal wi ...more

How To : Find the parallel line to a given equation

This videos explains how one can easily find the parallel line to a given mathematical equation. He starts by explaining what it means for two lines to be parallel mathematically speaking. Defining two lines, then comparing the slope of both lines you can mathematically determ ...more

How To : Find the area between curves

This video shows how to find areas between curves. The basic idea is that we find the space trapped between two curves on a graph. The formula for finding this is top curve, subtract bottom curve and then integrate. The presenter shows a parabola that goes through the origin. ...more

How To : Get a flawless skin foundation face

Ever wonder how to get a flawless face? Kandee Johnson shows you how. After cleansing your face or getting out of the shower, use St. Tropez bronzer and then moisturize. After moisturizing, apply foundation using fingertips. Kandee uses Lauren Mercier Moisturizing Foundation i ...more

  • Hot
  • Latest