Blenderized Formula Search Results

How To: Cheat with a blank piece of paper

Household Hacker brings you fun hack how to projects in a variety of areas: electronic hacks, computer hacks, pranks, etc. Search Household Hacker on WonderHowTo for more videos by this creator. In this video, learn how to cheat with a blank piece of paper.

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. So, GCF of 6, 28 and 16 is 2. The trinomial can now be written as 2{3r(squared) – 14r + 8}. To factor by grouping, see the trinomial as the general formula of ar(squared) + br + c. To factor this, you got to look at the...

How To: Balance chemical equations properly

In this video we learn how to balance chemical equations properly. What is a chemical equation? It's a statement that uses a chemical formula to show identities and relative amounts of the substances involved in a chemical reaction. To balance an equation out you must have the same number of atoms on both sides of the chemical equation. Or, you must have the same amount of mass or matter on both of the sides. Once you have these balanced out so they are the same then you will have it complete...

How To: Understand and determine equivalent fractions

In this video, we learn how to understand and determine equivalent fractions. If you have an equation with an equivalent fraction, you will first multiply the first numerator by the second denominator. Then, you will divide this answer by the denominator of the first fraction. After you do this, it will give you the correct answer. You can also do the reverse multiplication for this to check your answer and make sure you are correct. You can get an answer no matter what the numbers in the equ...

How To: Find the area of a trapezoid

In this video, we learn how to find the area of a trapezoid. The formula to figure out how to find the answer is: Area= 1/2x (base1 x base2) x height. Now, find the bases and the height of the trapezoid. Remember that the height must always be perpendicular to the bases. Once you have found these, add the bases and multiply by the height. You can use a calculator to do this or do it off hand if you're good with math. For the third step, divide the answer by 2 and then write down the answers w...

How To: Find the surface area of a cube

In this video, we learn how to find the surface area of a cube. Finding the surface area of a cube is something everyone will have to do in math. The easy formula to figure out this is: surface area= side x side x 6. Your first step to figuring out the problem is to find the length of a side. Once you have found this, you will substitute and evaluate the numbers in the equation. After this, write the units in for the problem. You will then come up with the answer of the equation with the unit...

How To: Find the area of a triangle given three points

In this tutorial, we learn how to find the area of a triangle given three points. First, you will need to plot the points on a graph. After this, find the base and the height using the graph. Next substitute into area of a triangle formula and then evaluate. When you finally find the area of the triangle, then you will write down the answer ending it with the units. This is a simple way to find the area of the triangle, you just have to make sure you count correctly and have calculated the ar...

How To: Create a Cincinatti Bengals football makeup look

There are more ways to show your team pride for the Cincinatti Bengals than by painting your hair orange and drawing tacky orange and black tiger motifs on your face. If your urge is to paint your face to root for your favorite team on game day, then check out this makeup tutorial to learn how to paint your face the natural, flattering way.

How To: Convert yards to inches with simple arithmetic

In this clip, you'll learn how to convert between yards and inches by formula. 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 installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to solve word problems that require you to express yards as inches or in...

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 sides are given. For sine, users need to divide the opposite and hypotenuse of the triangle. Then cross multiply it with the sin degree to find the length of the triangle. This video will benefit those viewers who are s...

How To: Create a "True Blood" Bon Temps swamp makeup look

Out in Bon Temps, the town in which "True Blood" takes place, everything you thought couldn't exist comes alive. Vampires and werewolves roam the town, so is it any surprise that the Bon Temps swamp is a character all its own? While not a living and breathing character, the swamp provides a murky, dark backdrop for the show's most harrowing scenes. And in that sense, it tells you a lot more about the characters than you'd get just out of their performance.

How To: Link two (multiple) workbooks & cells in Excel

In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...

How To: Calculate and add running percentages in Excel

In this tutorial, we learn how to calculate and add running percentages in Excel. First, write out your value and percentage into the different columns. Next, write the formula in the cell where you want the answer to appear. To have the answer appear, highlight the box and drag it down, then the answers will start to appear in each of the different columns for the different equations. This is an extremely simple way to calculate these percentages without having to do any math! As long as you...

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: Find the area of a square or rectangle in geometry

In this video tutorial, viewers learn how to find the area of a rectangle. The formula for finding the area of a rectangle is: A= b x h. The base is the horizontal bottom lie of the rectangle and the height is the vertical straight line of the rectangle. Whenever working with area, users must square the unit of measurement. To find the area of a square, multiple the side of the square twice (square it). This video will benefit those student viewers who are struggling with math, and are in nee...

How To: Apply makeup to look gorgeous in pictures

It's obviously important to look better than everyone else on your wedding day (sorry, but you know it's true), but even more vital to look great in wedding photos since you'll be looking back at them 10, 20 years down the road and you want to know you looked your best on your special day!

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: 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'll get you noticed even if, like Pamela Anderson, you live in a town full of A-listers.

How To: Create random dates within a set range 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 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.

How To: Display trend arrows in a Microsoft Excel spreadsheet

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 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.

How To: Calculate simple and compound interest in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how c...

How To: Use Microsoft Excel 2007 as a complete beginner

If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:

How To: Solve markup & markdown math problems in 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 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve simple markup (mark-up) & markdown (mark-down) business math problems.

How To: Avoid a #NUM! error when changing NPER inputs in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use SUMIFS or SUMPRODUCT to get invoice info 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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.

How To: Use numerical truth values 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 367th installment in their series of digital spreadsheet magic tricks, you'll see that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE and learn how to use this fact to your advantage when writing formulas.

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 portion of your hair and tie it into place. Then using a straightening iron, crimp and curl the bottom half of your hair to create nice, wavy hair. Let down the top portion of your hair. Again using a straightening iron, fl...

How To: Divide exponents with the quotient rule

Exponent of a number is nothing but the number multiplied to it self the exponent number of times. So five squared it equal to five multiplied to it self. Now when an exponential number is divided with another such number the result is the number raised to the different of the exponents. That is the ratio of x raised by a to x raised by b is x raised to (a-b). Similarly if we multiply a exponential number with other such number, the result is equal to that number raised to the sum of exponent...

How To: Return multiple items for a single Excel lookup value

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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to return multiple items from one lookup value and see a formula to return just the numbers from a column containing both text and numbers.

How To: Use the MCONCAT 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 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table values.

How To: Add with case-sensitive criteria 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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).

How To: Do dynamic range w/Excel's OFFSET function & top data

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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.

How To: Display time over or under a hurdle 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 173rd installment in their series of digital spreadsheet magic tricks, you'll learn how to show negative time with the "Use 1904 date system" as well as how to create a formula that will show the time over or under a given hurdle.

How To: Create a column of unique values in an Excel LU table

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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.