Formulas

How To : Autohighlight the highest value in a row 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 268th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply a ...more

How To : Factor the GCF and difference of squares

In this video the instructor shows how to factor the GCF and difference of squares. When you are asked to factorize a number or monomial or a polynomial, the way to do is break it down into individual terms. When asked to factorize a binomial, try to pull out any common terms ...more

How To : Find the perimeter of a rectangle

For people who are learning geometry and would like to be able to find the perimeter of a rectangle, this video provides and quick and simple tutorial which provides the formula as well as a good example. The formula for finding the perimeter of a rectangle is simple the sum o ...more

How To : Create Final Fantasy Lighting inspired hair

If you’re into final fantasy and wish to look like the character Lightning, this video will teach you how to style your hair to transform into the character. First, spray your hair with a root lifting formula and blow dry to add volume and texture. Next, separate the top por ...more

How To : Calculate the vest date for a contract in MS 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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the EDATE functi ...more

How To : Figure out circumference with given radius

Here Mr Misonet tries to teach to compute circumference of a circle when radius is given. First he convince you the formula. The circumference of a circle is proportionately equals to "pie" times of its diameter,where the value of "pie" is equal to 3.14 and diameter is equal t ...more

How To : Easily find the area of a rhombus

In this video, you will learn how to find the area of a rhombus. The formula is A = 1/2 d1 * d2. The d1 is the diagonal inside the rhombus, while d2 is the other diagonal inside the rhombus. You will need to find the length of these lines in order to complete the formula. For ...more

How To : Find the length of a side of a triangle using sine

In this video tutorial, viewers learn how to find the length of a triangle using sine. This task is very easy, fast and simple to do. This formula can only be done on right triangles. Begin by finding the angle first and figure which trigonometric ratio to use. Then find which ...more

How To : Calculate acceleration of a car

This video teaches how to calculate the acceleration of a car. The information for this calculation is for a car that accelerates by 12 meters per second in a time of 3 seconds. So to calculate acceleration use the following formula: acceleration equals change of speed divided ...more

How To : Conditionally format dates & weekends 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply c ...more

How To : Type math equations in OpenOffice Writer

In this Software video tutorial you will type math equations in Open Office Writer. Double click and open up the writer. First you got to add a button to the toolbar. For this, click on the arrow at the end of the toolbar and select 'customize toolbar'. On the window that pops ...more

News : Handmade Living Paper Dolls

Inspired by Jules Verne sea demons, Bea Szenfeld's “Sur la Plage” collection includes 12 pieces handcrafted with cardboard. The idea of unconventional material constraints is a classic art school "test", as well as a typical (and somewhat tired) formula for competitive design ...more

How To : Create a Nancy Grace makeup look

Whether you love Nancy Ann Grace or hate her, you can't deny that her eye makeup is always amazing. Watch Princess Pinkcat in this tutorial video about creating her Nancy Grace makeup look. She didn't curl her hair for this video, just tucked it under to make it look more like ...more

How To : Apply the Pythagorean theorem

Meet the Pythagorean theorem—an indispensable tool for any budding geometer. The Pythagorean theorem will allow you to measure the hypotenuse or any other side of a right triangle when the length of its other two sides are known. For specific, step-by-step instructions on how ...more

How To : Factor the difference of squares

In this video the instructor shows how to factor the difference of squares using a formula. The formula to find the difference of squares can only be applied if you have two perfect squares. The formula is (a * a - b * b) = (a - b) * (a + b). That is the difference of squares ...more

How To : Find a checking account's service charge MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 35th installment i ...more

How To : Do a Vanessa Hudgens smokey eye look

A major Hollywood player since she was a preteen, Vanessa Hudgens knows what looks on the red carpet and what doesn't. And, like most girls, she's found that the smokey eye never fails to make your eyes pop and to the make the eyes of nearby cartoon wolves pop out. In this vi ...more

How To : Find the volume of a sphere easily

Ever wonder how much delicious chocolate pudding you could fit inside a sphere as large as the earth? Maybe not, but after watching this video, you could figure it out! Follow along with the narrator as the formula for determining the volume of sphere is explained, accompanied ...more

How To : Find volume using rectangular prisms in pre-algebra

Lawrence Perez, from Saddleback College, and his assistant Charlie, give this pre-algebra lesson on finding the volume using rectangular prisms. You'll learn the formula for volume, and how to apply it. Get out your best pirate suit, and learn some math.

How To : Use the Cosine Law

In this video tutorial the author shows how to use the Cosine Law. He shows how to find an angle of a triangle where he know all the sides of a triangle, using the cosine Law. He uses a lower case letter to designate a side and a capital letter to designate an angel apposite t ...more

How To : Use FREQUENCY array functions 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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll ...more

Friday Fresh : Create an Auto G-Spot and More

Every day of the week, WonderHowTo curators are hard at work, scouring the web for the greatest and most inspiring how-to videos. Every Friday, we'll highlight our favorite finds. Make your own G-spot & protect your car It's not what you think. The G-spot here does not refer ...more

How To : Stop breastfeeding

Is it that time? Time to wean your baby or toddler from the breast? In this tutorial, learn how to button your shirt for good with the help of these steps. You Will Need: • Pumped breast milk, formula, or another drink or snack • A cup or bottle • A pediatrician (optional) ...more

How To : Break in a new camshaft when building an engine

If you have a new camshaft, the break-in procedure is critical. Follow our guidelines and you won't flatten a cam lobe and ruin the internals of your motor. The basic formula is 20 minutes @2000 rpms and never going below 1500 rpms. Make sure not to let it idle. Changing from ...more

How To : Create a Lauren Conrad girl next door makeup look

Former "Hills" hottie Lauren Conrad is the type of girl you'd bring home to your parents. With girl next door wholesome looks, a can-do attitude, and charming demeanor, Conrad has undoubtedly been the most successful "Hills" star, garnering a book deal and a Kohl's clothing li ...more

How To : Automatically color alternating rows in Excel

This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the s ...more

How To : Get Lady Gaga's vixen makeup from "Alejandro"

Lady Gaga is usually a woman of many looks, shapeshifting from armadillo shoes (as in her "Bad Romance" video) to hair bows and computer chip necklaces seamlessly. And while Lady Gaga does transition between a number of different outfits in "Alejandro," she rarely changes her ...more

How To : Speak Any Language Fluently In Months

Revealed! The secret to learning a language quickly. It's a little known technique diplomats and royalty have used for centuries. I lucked up on it by analyzing how I could quickly boost my language and workforce marketability. You get it here by design. The secret to learnin ...more

How To : Do the elevation card trick

Learn the elevation card trick with this instructive how-to video. Fascinate friends with your ability to magically make cards rise up and out of a deck as if levitating. You Will Need: • A spectator • A deck of elevation cards • A table Step 1: Have a spectator pick a ca ...more

News : Basic Math Operations

It was brought up a while back in a Community Call to Arms that *math* is handy for encryption (and let's face it, everything) so let us go over things you just have to know. "In its simplest meaning in mathematics and logic, an operation is an action or procedure which produc ...more

How To : Look up a picture 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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll l ...more

How To : Simplify expressions involving algebraic radicals

In this video tutorial, viewers learn how to simplify expressions involving algebraic ratios. In some ways, simplifying algebraic radicals is easier than numeric radicals. When we are working with square roots, we need to find the highest even power of a variable to act as out ...more

News : The Smartphones of Austin's Underground Musicians

Smartphone technology has become as ubiquitous as automobiles. In Austin, Texas, a city that is widely known as the "Live Music Capital of the World," smartphones have been embraced by the music community not just as a way to document and promote, but to create music. A rock ...more

How To : Graph quadratic equations

In this video, the instructor shows you how to graph quadratic equations. When you have a quadratic equation in terms of x and y, first try to identify the coefficients of the terms. Now use front end of the quadratic formula to find the line of symmetry which is the first hal ...more

How To : Run a chart lookup with defined names 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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

How To : Correct colors in photos with Photoshop CS3

Need to color correct your photos and you're not sure how? In this video, the basics of RGB and CMYK colors are discussed as well as how to use them to color correct everything from everyday snapshots to portrait photographs. By using the eyedropper and the info palette to rea ...more

How To : Hydrate a video lab

This experiment is intended to introduce students to hydrated compounds. These compounds have water molecules coordinated in their chemical structures. Examples CuSO4*5H2O, BaCl2*2H2O, and NaC2H3O2*3H2O. Notice each formula has a " between the compounds formula and the number ...more

How To : Extract records from non-blank fields 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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

How To : Find the arc length of a function

In this tutorial, we learn how to find the arc length of a function. All you're doing when finding arc length is finding the curve between 'a' and 'b'. Imagine this as a string you're pulling straight to see how long it is going to be. The formula says if your function is in ' ...more

How To : Use absolute ($) cell referencing in Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using '$' to prevent excel ...more

  • Hot
  • Latest