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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.
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.
This video both shows the viewer how to calculate the volume and surface area of a cylinder. It also explains what these different numbers mean. The volume is the amount of ‘matter’ that the cylinder can hold. The surface area is literally the area of the cylinders curved face and the two end circles.
This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...
This is the fifth video in the Statistics in Excel. He gives the website address where content can be downloaded. He speaks about the different types of formatting like stylistic and number formatting. He talks about the different formats like accounting and percentage, and how to use both of them. Accounting format is nice because it lines up the decimals nicely. He shows how to apply the accounting format. The percentage format displays the value in as a percentage. He shows you how to appl...
In this video the instructor teaches how to add and subtract integers. When adding or subtracting two numbers there can be four kind of situations depending on the signs between the numbers. When you are adding two numbers which are both positive then you move forward on the number line adding the two numbers together to give the result. Similarly when adding two negative numbers together then you move left side of the number line. Go to the left by the value of first number and go further le...
In this video, the instructor shows how to find an unknown coordinate given the other coordinate of that point and the equation that passes thought the point. A point is said to lie on the graph, if the point can satisfy that equation of the line. To check if a particular point satisfies an equation, all you have to do is substitute the value of the point in that equation and check if it validates the equation. Now, substitute the given point with an unknown coordinate in that equation. If th...
In this video the instructor teaches about inverse functions. Normally in inverse functions problems you are given a function that has a set of points and you are asked to find the inverse of that function. So if the function has a point in the form (x, y) then the inverse function has its points in the form of (y, x). Now when you are given a function f(x) that is in the form of x and asked to find its inverse, equate the function to y. Solve the equation to get the value of variable x in th...
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 half of the vertex using the formula x = -b/2a. This gives the line of symmetry. Next, plot the line using a few points starting at the line of symmetry. Take sample values of x and find the corresponding values of y on eit...
In this video tutorial, viewers learn how to hack the Flash game "Defend Your Honor" using Cheat Engine. Users will need Cheat Engine version 5.5. Begin by starting the first level of the game. Open Cheat Engine, click on the computer icon and select the internet icon. In the game, start a battle and kill an enemy. Type in the money you receive in the Cheat Engine "Value" bar. Continue doing until there is one or two addresses in Cheat Engine. Then, check both boxes and change the value to nu...
The video demonstrates the solving of radical equations in algebra. The first thing to be done is to keep the radical number on one side and the other numbers on the other side. The radical is then changed to a rational number by squaring, cubing etc. Once the roots are removed, it becomes a simple equation which can be solved by keeping the unknown number on one side and the rest of the numbers on the other side. The value, thus arrived at, is checked by putting the value of the unknown numb...
In this video the instructor shows how to solve a quadratic equation. If you have a quadratic equation with complex fractional terms and you find that a particular term is repeating then equate that term to a new variable and replace the variable in the given equation. Now try to get the equation a*x*x + b*x + c = 0, and solve for the roots of the equation which gives the values of the intermediate variable. But this variable was replaced instead of another term. So equate that term to the va...
YouTube user NotesCollegeAlgebra teaches you how to interpret a graph. You will learn how to read it and extract information. You go to the graph to see that f(-4)=-2. f(1.5)=2, so it's positive. You then have the question: For what x-values is f(x)<0? You go to the graph and see that you come up with (-5,3). The x-int is (3,0) (4,0). The y-int is (0,4). The domain is (-5,4) and the range is (-4,4). You then have the question: how often does y=7/5 intercept the graph? The answer is 4 times. T...
In this video tutorial, viewers will learn how to hack the flash game Cube Crash using Cheat Engine. Begin by opening Cube Crash. Then open Cheat Engine. Start the game and earn some points. Multiply the points by 8 and add it to the value box in Cheat Engine. Click First Scan. Repeat this step again and click Next Scan. This time, there should only be one address. Double click it and change the value to any desired number. Now when you play, you will receive that amount every time you score ...
In this video the instructor shows how to graph a piecewise defined function. A piecewise defined function is a function that is defined in separate pieces. In these kind of functions, for different ranges of the value of x, you are given different small functions, all of which together make the whole function. This means your equation of the function is given in the form of smaller functions. Now to graph these kind of equations all you have to do is graph the individual equations in the sam...
This video teaches how to convert a value in Celsius to Fahrenheit in simple steps. First take a paper and marker and keep in mind a Celsius value (e.g-32) to convert into Fahrenheit. Now use the formula to convert Celsius to Fahrenheit which is F=1.8(32)+32. Use a calculator to calculate the formula and you will get the result as 89.6 Fahrenheit. Now round it off the and your final result will be 90 degree Fahrenheit.
In this tutorial the instructor shows how to complete the square to graph a quadratic function using transformations. You can do this by transforming your equation in a series of steps. First make the coefficient of the square term to one by pulling out its numerical coefficient. Now to complete the square of the first part add half the coefficient of the variable with a degree one. Now to maintain the original value of the equation also make sure that you subtract the same value from the equ...
In this tutorial the instructor shows how to factor a trinomial with Greatest Common Factor (GCF) and then how to group it. The first thing you have to do when you want to factor a trinomial is look for the GCF. First factor the numerical coefficients of the terms of the equation. Now separate out the common numerical factor and if any common variable. This leaves you with a binomial to be factored. Now to solve this multiply the numerical coefficients of the first term and the last term and ...
Slope is the change in Y over the change in X. Written out, the formula looks is as follows: (y2-y1)
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 tutor shows how to simplify a quadratic formula result. You can solve a quadratic equation using the quadratic formula. The first thing you have to do when given the quadratic equation is bring all the terms to one side so that you have a zero on the other side of the equals to sign. Now the formula to calculate the roots of the quadratic equation ax*x + bx + c = 0 is x = (-b + root of(b*b - 4*a*c) ) / 2 * a. The other root can be obtained by using the minus sign before the ...
This video is describing how to solve quadratic equation by quadratic formula. The quadratic equation is given in the video and we will use quadratic formula. We will put the equation in the formula our equation is 4psquare= -23p - 15. Now add 23 to both sides and then add 15 to both sides now we will get an easy equation, 4 will be used as a and 23 will be used as b and 15 will be used as c and we have a=4,b=23 and c=15 put these values in the quadratic formula and we have the value of p=5.-...
This video starts out with a basic view of a rectangle and its dimensions. The base is 7 inches while the sides are 4 inches. It then displays the formula for finding the perimeter of the rectangle which is the addition of both bases and both sides. After the substitution of the values into the formula you can quickly come up with the perimeter. Then moving on the area, the formula is the base multiplied by the side. In this case, the base being 7 inches and the side being 4 inches you come o...
In this video tutorial it shows you how to find the x-bar by using the Z-score formula. In the beginning of this video the formula is displayed on the right, while the values that you need to plug in are on the left. Once you plug in the values and do the cross multiplying, all you have to do is get x-bar by itself on one side of the equation. This is a simple problem on using the z-score formula to find x-bar, it can help you solve more complex problems in the future.
Wondering how to use a mean and scatter plot for statistics? Just follow the few simple steps as below.
In this video the tutor explains about the concept of Equivalent Fractions and how to find them. She states that equivalent fractions are fractions with same value. She explains this with an example saying that a fraction can have many forms in their unreduced states and all these fractions will have the same value which can be obtained by reducing them. She shows that we can make an equivalent fraction of any fraction by multiplying the numerator and the denominator by the same number and go...
This how-to video is about Fourth Law of Exponents. Before going to see this let's first know what the fourth law of exponent says. The fourth law of exponents says that "any value other than zero brought to an exponent of zero is equal to one".
In this tutorial the author shows how to draw a rectangle with given base b and height h values. First she uses a ruler to draw a horizontal base line of b cm. Now she uses a protractor and marks a 90 degree angle at one end of the line, then draws a straight line of h cm which is the height of the rectangle. Now she finishes the remaining part of the rectangle by drawing similar lines of the other sides. This video clearly explains how to draw a rectangle given the values of its base and hei...
Learn how to apply the fundamental rule of proportions just follow simple few steps. First step is take two fractions and equate them. For example (Top/Bottom)=(Top/Bottom).
In this tutorial the instructor shows how to solve ratios and proportions. He gives a two step approach to solve an equality of two fractions in which the value of a variable in unknown. He says that in the first step we should cross multiply the numbers across the diagonal. In the second step we need to divide and simplify to get the value of the unknown variable. This video gives a simple two step method on how to solve ratios and proportions.
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 of all sides, or l+l+w+w, where l is the length and w is the width of the rectangle. After attaining the values of the length and width of the rectangle, you can simply plug in the values to this equation in order to find...
In this video the tutor explains about the standard error of the mean. He starts explaining by drawing the diagram of a distribution and now he takes ten samples from the distribution and starts plotting them. He says that in theory if we do it infinite times then we can obtain the sampling distribution of the sampling mean. For the example he takes the number of samples as 10. Now depending on these values of n we can get different sampling distributions. Now he intends to find the mean of t...
For people who are interested in math or who need to know how to find the volume of a cone for any reason, whether it be homework or architecture, this video will show you how to do so. The formula for finding the volume of a cone is (1/3) pi x radius^2 x height. You can find the radius of your cone by finding half the length across the center of the circle which is the cone's base. After plugging in all the values into this equation, you will be able to find the volume of any cone when given...
ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.
The video is a tutorial in trigonometry. The teacher teaches that the tangent or the tan of an angle is the ratio of the opposite side to the adjacent side of a right angled triangle. If one side and one angle is given then the value of the unknown side can be found by solving the equation tan of angle is equal to opposite upon adjacent side. If the angle is to be found then the tan inverse of the value is seen in the calculator.
In this video the author shows how to plot a point on the coordinate plane. He explains about the coordinate plane and shows how to read and write points to it with an example. He says that any point on the coordinate plane has an x, y- coordinate values. He says that for any point its projection on the x-axis is its x-coordinate and the points projection on y-axis is its y-coordinate. He shows how to find this out for a sample value and plots the coordinates of it. In this video the author u...
In this tutorial the instructor shows how to find the surface area of a sphere. He explains the equation to calculate the surface area of a sphere as 4 * Pi * r * r , where r its the radius of the sphere. Now if you have the radius of the sphere, by substituting its value in this equation and substituting the value of Pi, you can obtain the surface area of a sphere. If you want to compute the surface area of a sphere watch this video where it is clearly explained how to compute it along with ...
In this video tutorial the instructor explains about the concepts of standard normal distribution and the empirical rule and how to use it to solve an exercise. He starts by explaining about standard normal deviation saying that in a standard normal deviation the value of mean is zero and the value of standard deviation is one. Now he draws the standard normal deviation by drawing a bell curve on an axis. Now he points the mean and standard deviations on it. Now using these concepts he goes o...
In this video tutorial the instructor shows how to solve a single-step equation by taking the reciprocal. He says that in the equations of fractions containing a variable on the one side, you multiply the reciprocal of its numerical constant to it so that only the variable x stays out. Similarly we need to multiply the reciprocal value that we used on the left hand side on the right hand side too to maintain the equality. Now after simplification as only x is left on the one side we get its v...
In this video the author shows how to perform custom number format for turnover ratio in a Microsoft excel document. He shows how to perform custom number formatting in which he shows how to display a decimal value in words. He opens the Format Cells option and there he shows how to set the Custom option. He shows how to configure different options so that we can format the decimal value and display it as text with some meaning attached to it. In this video the author shows how to use custom ...
