Valued Clients Search Results

How To: Do a shatter & disintegration effect in After Effects

Themadcowmoo continues to show us how to create a shatter & disintegration effect in Adobe After Effects. In the second part of his two part video series he begins by getting rid of the extrusion depth in the shadow by changing the value to 0 (0.00). He then instructs on how to accomplish and even smaller disintegration effect by selecting the 'Shatter Map' tab, going to the fractal layer, choosing 'Fractal Noise' in the top right panel and then selecting '10' as the value within the 'Transfo...

How To: Find mean, median, & mode (averages)

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 34th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can repr...

How To: Remove eyebrow hair using thread

This is a video tutorial that is showing its audience how to remove their excess eyebrow hair by simply using a thread. The first step in removing your eyebrow hair with a thread is to ask the client how they want their eyebrows to look when you are finished. Take two threads and place them between your fingers, crossing the thread in the center. Then you should begin to slowly shape the eyebrow. Ask the client to close their eyes so that you will have access to the whole eyebrow. For men mak...

How To: Check to see if a string contains a value 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, the 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").

How To: Smooth skin with noiseware plug-in using Photoshop

In this video tutorial, viewers learn how to smooth skin with noise-ware plug-in using Adobe Photoshop. Users will need to first download the plug-in to be able to use it from the menu of the filters. Now modify the values of Noise Level Adjustment and Noise Suppression. Max the Luminance and set the other values to 50%. Click on the preview from above to see the difference. Then use the filter a second time to make a stronger effect. Any small wrinkles can be eliminated with the patch tool. ...

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: Properly read a decimal number

Decimal numbers are numbers which contain a integral part before a point and a decimal part after the point. The first step in solving decimal arithmetic is being able to understand decimal numbers. Reading a decimal number is similar to reading a whole number except for a few minor differences. In a normal number the right most digit is ones place and the place next to it is tens place and so on the value of the position increases as you move left. But a decimal number starts from a tenths p...

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: Sum the values from many cells to a single Excel cell

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.

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.

How To: Find the volue and surface area of a cylinder

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.

How To: Use the IF function with letter grades in Excel

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...

How To: Apply accounting & percentage formatting in Excel

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...

How To: Add and subtract integers

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...

How To: Find a missing coordinate given: coordinate & equation

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...

How To: Solve problems with inverse functions

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...

How To: Graph quadratic equations

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...

How To: Hack Defend Your Honor with Cheat Engine (12/30/09)

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...

How To: Solve radical equations in algebra

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...

How To: Solve a quadratic equation

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...

How To: Interpret a graph

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...

How To: Hack Cube Crash using Cheat Engine (07/01/09)

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 ...

How To: Graph piecewise defined functions

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...

How To: Convert temperature measured in Celsius to Fahrenheit

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.

How To: Complete the square to graph a quadratic function

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...

How To: Factor a trinomial by GCF then grouping

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 ...

How To: Describe a linear system without graphing

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 ...

How To: Simplify a quadratic formula result

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 ...

How To: Solve a quadratic equation by quadratic formula

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.-...

How To: Find the perimeter & area of a rectangle

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...

How To: Find X-bar with the Z-score formula

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.

How To: Find equivalent fractions

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...

How To: Apply the 4th Law of Exponents

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".

How To: Draw a rectangle

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...

How To: Solve for ratios and proportions

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.

How To: Find the perimeter of a rectangle

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...

How To: Find the standard error of the mean

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...