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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.
In this video, we learn how to make caramel custard. To make this, you will need: 10 eggs, 1 liter fresh milk, and 150 grams sugar. First grab your six eggs and take 6 yolks and 4 whole eggs, then mix your sugar with milk until it tastes how you like it. Now, mix the sugar and milk and eggs all together. Now make your caramel by heating up equal parts of sugar with equal parts of water and cook until it gets to a dark brown color. Pour the caramel into the bottom of separate trays when you ar...
This video is about Annual percentage Rate(APR) and the Effective APR rate.The video begins with an example of a credit card which has a APR rate of 22.9% and daily periodic rate of 0.06274%.You can get the APR rate by multiplying the daily peiodic rate with 365, which in this case will be 0.06274*365 which is equal to 22.9.If you convert the daily periodic rate into decimal values , it will be 0.006274.So for example, if you have 1 dollar in your balance on day 1, on day 2 you will owe 1.000...
This educational math video describes the steps necessary to solve an equation involving absolute values. "Absolute value" refers to the magnitude of a quantity and is always expressed as a positive number. You can think of absolute value as the distance a number would be from zero if plotted on a number line. Positive 17 and negative 17 both have the same absolute value because both are 17 units from zero on a number line. Because of this, all absolute value problems have two answers, one wh...
In this "Math Made Easy" geometry episode, you learn how to prove that two triangles are congruent (equal) by using the "side-side-side" evidence. By using "side-side-side" to prove that two triangles are congruent, you are stating that all the respective corresponding sides of two triangles are equal in length thus proving the triangles are congruent. The narrator in this tutorial provides you with definitions about statements, proofs, and congruency. This becomes useful when setting up a ta...
Exponents are the times you multiply a number by itself. So 3 to the third power would equal 27. Another example could be 3 to the second would be 9. Any number with an exponent is always multiplied by the same number depending on the power. So this means that 5 to the third power would be 5x5x5, which would equal 125. One thing to remember is that when any number is multiplied by the power of 0, the number always is one.
In this tutorial, the instructor shows how to compute the surface area of a regular pyramid. A regular pyramid has four equal sides which are in triangle form, and the base in square form. Its surface area is four times the area of its side plus the area of its base. He goes on and takes an example with sample values and demonstrates how to compute the final value using the formula. He reminds the viewer to use square units in the final answer, as square units equal the area. To find out the ...
Who doesn't like zombies? This tutorial shows you how to get the ripped face prosthetic from Nimba Creations, and how to apply it. This is a fairly pricey prosthetic, so make sure that you get your money's worth by making it look as awesome as possible!
Running over someone's head or burying them alive so that they can rise from the grave are dangerous, and not worth using in filmmaking generally speaking. But yay, there are special effects! Watch this video for a guide to running over someone's head with a car or burying them alive for your film using After Effects and some fun props.
If you play Mario games and don't try to collect all of the collectible items like Star Coins, you're really not getting your money's worth. Watch this video to learn how to get all three Star Coins in World 2-End Castle of New Super Mario Bros Wii.
Finding all of the occult shrines in Assassin's Creed Brotherhood is a challenging but rewarding task that will net you many gamer points worth of achievements / trophies. This video will show you how to find and open the Catacmobe di Roma shrine and get the Undertaker 2.0 achievement / trophy.
Sorry all of you Justin Bieber fans, this ukulele lesson is for the Third Eye Blind song called "Never Let You Go". It's a very detailed uke lesson, complete with chords, strumming and picking parts. This may be a little hard for ukulele novices, but definitely something worth aspiring towards.
This snack is so good it might kill you— literally. These miniature bacon bites will clog even the healthiest of arteries, but it's so worth the risk! Robin Benzle of Chow Time shows you her dangerously delicious recipe for her bite-sized bacon bits, which ate breaded with breadcrumbs and filled with brown sugar, then oven-roasted for crispy delight. If you're daring enough, make these for your next party or get-together— this recipe makes 100!
If you're not afraid to stray from your origami craft, then kirigami worth a shot. It's just like origami, but you're allowed to cut the paper, not just fold it. Kirigami makes origami look more mature and more accurate, like when it comes to flowers. This video will show you how much better a kirigami cherry blossom looks! Learn how to make this cherry blossom with five petals.
In this clip, learn how to make a perfectly thin, crispy Italian style pizza with Food Mob. You will also learn how to top those beautiful bases with the best ingredients so absolutely everyone at the table will be happy. Don't bother with delivery or one of those store bought pizzas - make your own! It's worth it.
Falling off-the-bone tender Spareribs dinner served with Homemade Bread Stuffing is a quick and easy to do recipe as shown by the BBQ Pit Boys. In fact, these hot off the grill Pork Ribs and Stuffing taste so good that some say they're worth fightin' for.
This video tutorial will teach you a simple hack that will allow you to hide a secret message in any digital picture. Who knew a picture could actually be worth a thousand words? Real words, embedded within! For detailed, step-by-step instructions on recreating this hack yourself, take a look. Keep your messages on the Internet secret with this how-to.
One of my longest videos to date, but well worth it if you have half an hour to kill. This is to thank you all for putting up with me until now what with the voices and poetry and secrecy of my real voice and all.
One of the most soothing card trick videos we've seen yet, follow along and try your skill at Tenkai palming. Learn how to use the palm to vanish cards (or credit cards, when you get good enough). You might have to crank the volume all the way up on your speakers, but it's worth it.
In this tutorial, we learn how to understand angle relationships. Start out by drawing an angle out and looking at the different parts of it. From here, you will start to find where the different angles are. Linear pairs equal 180 degrees and are on a straight line. Once you learn this, you can write them out on the paper. Supplementary angles equal 180 degrees as well. Two angles that add up to 90 degrees are complimentary angles. Once you learn the relationships between angles, you can bett...
Factor a trinomial by grouping
This is a video tutorial in the Education category where you are going to learn how to convert Fahrenheit to Celsius for chemistry. Doing this is really simple and easy and doesn't take much time. But, you must know the formula for doing the conversion. The formula is degrees Celsius is equal to degrees Fahrenheit minus 32 divided by 1.8. Using this formula let us convert 75 degrees Fahrenheit to degrees Celsius. Inserting 75 in the formula, we get (75 - 32) divided by 1.8. and the answer is ...
In this tutorial, we learn how to divide numbers with exponents. The quotient rule states that we can divide two powers with the same base by subtracting the exponents. With the same base, you can subtract the exponents to get something that would be the answer. For example, if you have 6(to the fourth) divided by 6(to the second), this would come to equal 6(to 4-2). This would break down to equal 6(to the second power). Once you have this, you will be able to do the math for this and figure ...
In this video, we learn how to solve a single-step equation using multiplication. For the first step, get rid of any number surrounding the variable. To do this, you will need to multiply the numbers around it by their opposite to make them equal zero. Once you have done this, you will need to repeat the process on the other side of the equal sign. Just do the same exact thing you did in the first step, then you will be able to easily solve the problem at hand. You can check your answer by re...
This video tutorial is in the Education category which will show you how to evaluate a line integral along a straight line segment using the definition of the line integral. This video evaluates a line integral along a straight line segment using a parametric representation of the curve (using a vector representation of the line segment) and then integrating. A vector representation of a line that starts at r0 and ends at r1 is r(t) = (1-t)r0 + tr1 where t is greater than equal to 0 and lesse...
College students don't exactly have an abundance of time. With midterms, finals, brick-size books to read, social events, and volunteer activities, they're lucky enough as it is to get a full eight hours of sleep a night.
In this video, we learn how to back out the tax from a receipt. If you have a receipt where you see how much you paid and know the tax rate, except you want to figure out the cost of the item before the tax. First, take the cost of the item including tax and what the tax rate is. To figure out the original price, let x equal the cost of the item. Add the tax to the cost of the item which will equal the cost you paid. Perform the equation 1x+(tax rate)= (total price). After you figure this equ...
If you would like to create the look of stitches or sutures on your clay sculptures, you will need the following: clay, a toothpick or sharp implement, and a cutting tool.
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...
Have you ever thought about creating small boxes out of newspaper? Tomoko Lipp shows you a simple folding and cutting method to do this. Making these can be another way to recycle and be environmentally conscious. You might also consider using them for a unique gift box idea or for storing small items. All you'll need is some newspaper, a pair of scissors, and a pen to mark a few measurements.
In this video, it is shown how to calculate the area of a circle where the diameter is given. The formula for calculating the area of a circle is pi multiplied by square of radius. Radius is actually half of the diameter. In this video, the diameter is given as 10.6 meters. Hence, the radius will be half of 10.6 which is equal to 5.3 meters. Now, to find the area we shall multiply pi with the square of 5.3. Square of 5.3 is 28.09. If we multiply 28.09 with pi we shall get the area of the circ...
To recycle an old towel into shorts, fold the towel and cut it into a short leg's length worth of fabric. Cut another piece into a short leg's length worth of fabric. Draw a curved seam on one edge. Stack the towels and pin them to hold the fabric in place. Cut out the seam on both of the towels. Separate the towels and sew up the seams on both of the fabric pieces. Do not sew the top seam and front side seam of the shorts. Instead, sew the front and back side seams together. Thread and sew a...
If you're in a situation where you like a person in an abusive relationship, then most likely the person seems to be reluctant to get out of their relationship. The person most likely has self-worth issues. Until those self-worth issues are resolved, the person will never be happy with you or anyone else. Most often they feel that they don't deserve to be happy. Until that person feels that they deserve happiness, and want happiness with you, you can forget ever moving beyond the friend zone....
You need to have three kinds of ingredients – Vanilla vodka, pumpkin spice liquor, and Baileys. Find your martini shaker and fill half of it with ice. Add one ounce of vodka, one ounce of pumpkin spice liquor and one ounce of Baileys all in equal parts. You do not need to measure it exactly; you could just pour them into the shaker just approximately in equal parts. Put the cap on your shaker and shake until the outside of the shaker is frosty cold. Then pour the contents of the shaker into a...
This tutorial looks at how to describe a linear system without actually graphing it. In order to do that, you will need to convert both equations of a problem into the Y=mx+b format. Once you have done this, you will be analyzing the m and b values. There are a few rules to follow. If the slopes (or m) and the Y intercepts (or b) are equal, there are an infinite number of solutions (or dependent equations). A second rule is if the slopes are equal and the Y intercepts are different, then the ...
In this video the instructor shows how to solve quadratic equations by factoring. You can solve a quadratic equation by factoring them. To do this first write the equation in the standard from which is a*x*x + b*x + c = 0. Now factor the equation into two smaller equations of single degree. Now you can apply the zero-factor property to solve the equation in this from. The zero-factor property states that for a real values a and b, if a multiplied by b is equal to zero then value of a must be ...
This is a very interesting mathematical instructional video on how to find rational equation with no solution. How to solve the equation and check the answer. Let us take the example m over m-3 minus 4 is equal to 3 over m-3. In this equation we get m-4m+12 over m-3 is equal to 3 over m-3. When we simplify it further we get -3m +12 = 3. Or -3m = -9 and m = 3. This video teaches you very clearly how to solve a rational equation with no solution.
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 by time. So, using the information provided for this calculation, acceleration equals 12 meters per second divided by a time of 3 seconds. So this gives an acceleration of 4 meters per second squared.
Learn the correct method for graphing inequalities on a number line. Inequalities are, simply, mathematical comparisons between numbers or expressions. Numbers and other expressions can be greater than, less than, and/or equal to other numbers or expressions. Typically, this is indicated in mathematics through the use of the less-than (<) and greater-than (>) signs, along with the greater-than-/less-than-or-equal-to signs. Using other special notations, which you will learn in this video, the...
Calculating The Area Of A Parallelogram A parallelogram is a 4-sided shape formed by two pairs of parallel lines. Opposite sides are equal in length and opposite angles are equal in measure. To find the area of a parallelogram, multiply the base by the height. The formula is:
