New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
Create a table with sales data with this video.
If you are a user of FileMaker Pro then this video teaches you how to use calculation and summary fields in it while making new files. In Filemaker you can create a various kind of fields that you want your file to contain. In Filemaker a calculation is a data that gets computed depending up on the formula that is set in the Filemaker database settings. Calculations are very critical in file management. Open the Manage Database and there you can find some of the calculation fields. There in t...
In this how-to video, the author, , Davitily, has a simple drawn out diagram of a cone figure and it's measurements, and also has the mathematical formula of how to find the surface area of this and any other cone figure.
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 roots of the parabola. Now he substitutes these values in the equation to obtain the corresponding y coordinates. Now using these pairs of values he plots the parabola on a graph and draws it. This video shows how to fi...
This is an interesting mathematical instructional video on how to make a quartile diagram. This example is about 34 grades obtained by chemistry class students. We need a minimum value, a maximum value, Q1, Q2 and Q3 values to make a quartile diagram. The minimum is 43 and the maximum is 92. To calculate Q2 median formula (n+1 over 2)is used. The Q2 median is 17.5. So the average of 69 and 71 is 70 and hence Q2 70. Similarly Q1 is calculated as 61 and Q3 is calculated as 79. Now you can draw ...
In this video the instructor talks about compound and continuous interest formula calculations. You need to understand the concepts of simple and compound interest. Only then you can understand what the bank is doing to your money which are in your bank account. Simple interest is a method where when returning a borrowed sum to some one you pay additional price for using the money all this time. Compound interest is a similar concept where you pay interest on the original sum borrowed, and al...
In her video, Carol describes her skin care regimen, which she claims has been very effective in treating her acne and improving her skin. This regimen is for acne-prone / combination skin types and involves the use of multiple products, including cleansers, scrubs, masques, washes and moisturizers. Carol takes us through her morning, evening and weekly cleansing routines, explaining which of various products she uses for each such routine. She also discusses each product, explaining its stre...
Steps involved in calculating the lateral surface and total area are:
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 ...
Pixie Lott is an English music artist whose song "Boys and Girls" topped the UK charts in September of 2009. If you want to look like her from the music video, just watch as Princess Pinkcat shows you how to create a Pixie Lott "Boys and Girls" makeup look.
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.
From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. This is Mathematics for Dummies. Just watch this video tutorial to learn how to find the area between two curves, For Dummies.
From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. This is Mathematics for Dummies. Just watch this video tutorial to learn how to find the surface area of a surface revolution, For Dummies.
Pickling isn't rocket science. In fact, anyone can make their own speciality pickles using just about any fruit or vegetable. For example, I've pickled everything from lemons, watermelon rinds, and apples to red onions, carrots, radishes, and cucumbers.
When it comes to dressing up your face for the holidays, your LBD of makeup looks is without a doubt the classic neutral eye and red lip combo. Beautiful since the days of Marilyn Monroe, this look is timelessly feminine and sultry.
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...
The Pythagorean theorem is a simple theorem that states that - for a right angled triangle the square of the length of the hypotenuse is equal to the sum of the squares of the length of the remaining two sides.
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...
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...
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...
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...
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...
You don't need a ton of makeup to look fresh and sexy. You can tone down your makeup and still look hot! Zhareena shows you how to tone down you look and still appear fabulous, just by using less cosmetics. This makeup look is great for school, running errands, dates, and more! It's really easy to apply and consists of affordable products.
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.
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...
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...
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.
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...
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...
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.
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...
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!
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 ...
"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.
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.
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.
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...
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:
