Potent Formula Search Results

How To: Graph the slope of a line through two points

If you want to learn how to get and graph the slope of a line using two points, you should watch this. 1. Let your two points be (x1 , y1) and (x2 , y2). Draw a straight line that connects the two points. 2. Use the formula, m = change in y over change in x , for finding the slope which is represented by the variable m. 3. The simpler form of the formula would be m = (y1 - y2) / (x1 - x2). 4. If you were given two points, just substitute the values in the given formula. 5. For example, the tw...

How To: The Perfect Formula for Making Any Cocktail

Like many others, I like a good cocktail every now and then, and I've always been impressed when my cocktail enthusiast friends would come up with a new drink or even just remember how to concoct a Clover Club (FYI, it's made with gin, raspberry syrup, lemon, and egg white). There's a secret bartenders and craft cocktail aficionados know, though: It's all about math, the simplest and most intoxicating math. Pythagoras would be so proud.

How To: Multiply Numbers by 9 Using Nothing but Your Fingers

From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this free math tutorial, you'll learn how to calculate the area of a triangle by formula. In this clip, you'll learn an easy finger-counting trick for quickly calculating multiples of 9.

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 to use this useful formula, usually given as a^2+b^2=c^2, where c^2 is equal to the length of the hypotenuse, watch this free video geometry lesson.

How To: Construct confidence intervals with Excel's NORMSINV

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 85th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.

How To: Play scales in the Locrian mode on the piano

The Locrian mode has the formula 1, b2, b3, 4, b5, b6, b7. Its tonic chord is a diminished triad (Bdim in the Locrian mode of the diatonic scale corresponding to C major). This video explains how to play scales in the Locrian mode on the piano and also gives a great breakdown at the end of each mode in C.

How To: Make a simple homemade journal from index cards, dental floss and a cereal box

Traditional bookbinding can be a complicated job requiring specific tools and crafts. But when you're making a personalized homemade journal or diary at home, anything goes. This video will show you the basics of making a simple, small book using easy methods with materials you likely have around the house, like index cards (for the folios), a cereal box (book cover), paper, duct tape, scissors, dental floss (binding), glue, Sharpie marker, and an awl or sewing needle.

How To: Create and build chords on the guitar

For beginners, you may learn a few basic chords here and there, but somewhere in your mind you must think about why do these chords sound like this, why is this an A chord and this a G chord? Well, wonder no more! In this video you will learn how the construction of a chord works, which is basically taking the root and adding a specific formula for what you're looking for. Let's say you want to build an A major chord. Well, you first have to build the triad which is the 1st note of the major ...

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 learn how to create, edit and otherwise work with FREQUENCY array functions.

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 read the colors in the photos, you can then color correct. Based on the CMYK read out of the color sample targets, you can then adjust the color channels using a curves adjustment to achieve the kind of colors you'd like. A...

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: DIY Natural Homemade Mint Toner for Healthy & Beautiful Skin

Hey beauties,it's summer time..we need to take extra care of our skin in summer.You must have all noticed skin problems in summer due to the hot-warm weather and the easy,simple and effective formula is to use toners in summer.In market their are so many toners are available but it's always better to use natural products for skin,and nothing can beat the Mint toner.so today I am sharing with you how to make mint toner at home

How To: Make Jello shots

Deceptively tasty, jello and alcohol makes for a potent combo. Spice up your next party by serving chilled Jello shots. These flavorful treats are sweet and easy to make. But watch out! They are sweet and potent, so it can be easy to go overboard and not realize quite how much alcohol you have consumed.

How To: Find the area of a circle with pi

This video shows how to find the area of a circle using a formula. The formula for area of circle is pie multiplied by square of radius. Pie is actually an infinite number but for the sake of convenience we consider the value of pie as 3.14. So we multiply the square of radius with 3.14. Radius is the distance between the center point of the circle to any of the outside arcs. It is actually half of the diameter (diameter is the distance between two arcs of a circle). As an example here the ra...

How To: Clean and used dried chiles

In this video from Gourmet Magazine, Ian Knauer shows us how to clean and use dried chilies. Chile de arbol is the spiciest. To make a great hot sauce, boil about 40 of these with the seeds in and blend with some garlic and water. Next is the chipotle chili. You can often find these in a can but they are more potent when fresh. The larger the chili, the less heat it contains. An ancho is like a poblano. A guajillo is often paired with an ancho in a recipe or an adobo sauce because they comple...

How To: Use Excel round function & number formatting

In this video the instructor shows how to use the Round function and also format numbers in Microsoft Excel. Normally while calculating formulas in Excel, the formatting of numbers can get you into a lot of trouble and to get around this problem you need to use the Round function. To do this take some sample data in a Excel work book and apply any formula that you want on the data to arrive at some calculation. Now because of this formatting some times you can arrive at a wrong result as show...

How To: Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.

How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions

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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

How To: Calculate Commission Based on Varying Rates 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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...