Variable Sized Search Results

How To: Fix other people's Microsoft Excel spreadsheets

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:

How To: Create a budget with formula inputs in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...

How To: Use and find x & y-intercepts in algebra

A straight line can be represented in the form of a liner equation containing two variables x and y. When the equation is graphed on a pair of coordinate axes, the line passes cut through the axes in two points. The point where the line cuts the x-axes is called as its x coordinate and the point where the line cuts the y-axes is called as its y coordinate. In this way a line has x-intercept and y-intercept. The x-intercept of a line lies on x axes and is in the form (a,0). Similarly the y-int...

How To: Find the percentage of total from a DB set in Excel

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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.

How To: Hack Demolition City 2 with Cheat Engine (10/12/09)

This is a video about "How to Hack: Demolition City 2" by Travis. This is a flash game. To begin hacking, go to the game and enter the first level. At this point, you do not have any cash. Specify that you are using Mozilla in the cheat engine. After you have completed the first level, write "double" variable in value type and then type the value for the first level, and you can easily notice the game appearance seems to be changed, because the second level of the game consists of first level...

How To: Solve a two-step equation

This video is a detailed step by step explanation as how to solve a two step equation. The video provides an example of how to go about a two step equation problem and the steps necessary in order to solve for the value of one of the variables. This video uses very simple mathematical terminologies, therefore, most people should be able to understand and learn the concept easily. The video is very helpful and recommended to anyone who plans on taking algebra in the near future.

How To: Find a missing part of a triangle, similar to another

In this tutorial the author shows how to find out the missing part of a triangle that is similar to another triangle. He explains the concept of similar triangle diagrammatically by showing that similar triangles have similar angles and parallel sides. Now he labels sides of similar triangles and marks the value of unknown side as variable x. Now in similar triangles as the lengths of sides of proportionate he shows how to write a equation of proportion and solves it finding the missing part ...

How To: Take Control of the Mouse & Keyboard in Python

While hackers adore the command line, working with the GUI (graphical user interface) of an operating system has some advantages. This is especially true when it comes to post-exploitation. When we can control the mouse and keyboard of a remote computer, we can truly say we have complete control over the device. Today, I'm going to introduce to you the PyAutoGUI module, which does just that, and just how much fun you can have with it!

Basics of Ruby: Part Two (Loops)

In the last Ruby article, we talked about how to store information in three different kinds of storages: variable, array, and a hash. After we get the data, we have many ways of using them, but, for right now,

Hack Like a Pro: Scripting for the Aspiring Hacker, Part 2 (Conditional Statements)

Welcome back, my greenhorn hackers! I recently began a series on scripting and have received such positive feedback that I'm going to keep this series going. As I've said before, to graduate from the script kiddie to the pro hacker, you'll need to have some scripting skills. The better you are at scripting, the more advanced your hacking. Ultimately, we are leading up to developing the skills to build your own zero day exploits.

How To: Solve a system of equations with two unknowns in algebra

In this free video math lesson YAY MATH, we learn how to simultaneous equations — sets of equations with multiple variables — in basic algebra. With mathematics, as with anything else, not everyone progresses at the same rate. Algebra is no exception. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. Whether you need help fini...

How To: Solve a single-step equation using multiplication

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

How To: Find the standard deviation with the Z-Score formula

In this tutorial, we learn how to find the standard deviation with the Z-Score formula. First, take your problem and write it out one by one underneath each other. Then, you will need to substitute the numbers in for the variables that are in the problem. Once you do this, you will follow the basic rules of math to find out what the answer to the problem is appropriately. Once you have done this, finish off the problem to find the answer, then you will have found the standard deviation using ...

How To: Screw drywall to studs with a drywall screwgun

Bob Schmidt teaches us how to screw drywall to studs with a drywall screw gun. A countersink bit is a great option to help you screw drywall studs in. This will fit in a variable speed drill for setting counters and drywall. Use a DeWalt screw gun, which is specifically made to install drywall. It has a clutch driven head with different adjustments on the head for different screws. The gun should be inexpensive and doesn't have a very large motor, so it's perfect for a homeowner. If you just ...

How To: Use log to solve for an unknown variable

Thinking of an unknown exponent as a cat stuck in a tree, you will see how to bring down the exponent by using the the log function. In other words, you will be utilizing the Power Law to bring the exponent down in front of the log function. In this slightly more complicated example, a little work has to be done to first be able to take the log (i.e., get the base by itself). Then once you take the log, the unknown still isn't entirely by itself, so you divide off everything it's being multip...

How To: Compare loans with a spreadsheet in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform debt analysis with the following input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Pay...

How To: Factor trinomials with 2 variables & GCF by grouping

In the video, the process of factoring trinomials is described. A trinomial that cannot be easily factored in its original form is shown. It is simplified by pulling out the greatest common factor. After that, a trinomial that is easier to factor is shown. Next, the simplified trinomial is broken up into four terms so that factoring by grouping can be done. Once again, a common factor from each pair is taken so that two binomials are created. Once the greatest common factor is added back with...

How To: Factor polynomials by grouping

A factoring problem that has to be solved by grouping is easy to identify, because you can always identify if there are any similar terms in a polynomial. Now, if you find any variable common in any terms pull them out as the common leaving the rest of the terms. After pulling out the common terms you can group the rest of the polynomial. Be careful while pulling out signs. Pulling out a positive number does not effect the signs of terms in the polynomial, where as pulling out a negative numb...

How To: Solve rational equations easily

This video revolves around solving rational equations in Algebra 2. When you are given a rational equation, you have to find the greatest common factor and multiply all fractions to get that common factor. If a fraction already has that common factor, then no further step is necessary for that one. Next, you have to multiply all fractions by the greatest common factor to get rid of all denominators. Finally, the remaining equation is simple math and you only need to solve the equation for the...

How To: Simplify expressions involving algebraic radicals

In this video tutorial, viewers learn how to simplify expressions involving algebraic ratios. In some ways, simplifying algebraic radicals is easier than numeric radicals. When we are working with square roots, we need to find the highest even power of a variable to act as out perfect square. When working with cube roots, we look for the highest multiple of 3 as an exponent for our perfect square. This video is very descriptive and clearly explains all the functions of the formula. This video...

How To: Solve exponential and logarithmic equations

In this video tutorial the instructor shows how to solve exponential and logarithmic equations. Solving exponential equations can become very difficult if it involves large numbers. To solve these kinds of complex equations you need to get all the numbers to the same base number. The base number raised to some number should give you your original number. Now if you write the numbers as exponents of your base number you can directly equate the exponent part and solve for the missing variable. ...

How To: Factor a trinomial

In this video the instructor shows how to factor a general quadratic polynomial. Here the first step is to identify the coefficient of the squared term. Write the reciprocal of the numerical coefficient of the squared term out side and write two separate parenthesis which are going to contain the binomials which are the factors of the original equation. The first term of both the binomials is the first term numerical coefficient times the unknown variable. Now multiply the first term numerica...

How To: Factor a trinomial, GCF, then unfoil

In this video the instructor shows how to factor a polynomial. A polynomial having three terms is called as trinomial. Now if you factor it you will obtain two binomials whose product will be the original polynomial. Before factoring a polynomial you need to find out if the polynomial has a GCF. Look out for the common variables in all the three terms and pull them out which is the GCF of the polynomial. This simplifies the original equation to a polynomial which is of lower degree. Now facto...

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: Simplify complex fraction w/ 3 fractions top & bottom

You Tube User robichaudd teaches you how to simplify a complex fraction with 3 fractions top and bottom. Your result should be 1 fraction over 1 fraction. To do this you must find the L.C.D. at the top, which x cubed. That is the largest variable there. Thus, the L.C.D. at the bottom is x squared. Now you want to make each x below the fraction line be x cubed, respectively x squared. You then have one large fraction over one large fraction. But that is just one large fraction multiplied by th...

How To: Graph half an ellipse

If you are given an equation of ellipse in the form of a function whose value is a square root, you may need to simplify it to make it look like the equation of an ellipse. Now equate the function to a variable y and perform squaring on both sides to remove the radical. Now simplify the equation and get it in the form of (x*x)/(a*a) + (y*y)/(b*b) = 1 which is the general form of an ellipse. Now you will have the x and y intercepts which are a and b respectively. Using this values graph the eq...

How To: Shift a graph

This video will demonstrate exactly how to shift a graph on a x,y axis. When shifting a graph on the x axis you will need to replace x with x-h; where h is the variable to shift the graph. No matter how far you need to shift a graph, h is always the number of units you are shifting; shifting up or right is represented as a positive and down or left is negative. Just plug in your units into your equation and you will have your shifted graph.

How To: Solve linear equations w/ the multiplication property

This video demonstrates how to solve a linear function with rational coefficients by multiplying by the reciprocal of the coefficient. The reciprocal is just a fancy way of saying the numerator and denominator are swapped. Two sample problems are solved using this method. Multiplying each side of the equation by the reciprocal of the rational coefficient of the variable 'x' is an allowed operation, but only because both sides are multiplies by the the same amount. The teacher then demonstrate...

How To: Multiply rational expressions

The video describes the basic process of multiplying two rational expressions. The problem illustrated in this video involved multiplying rational expressions of monomial terms with integer coefficients. As with the other example problems, we follow the steps of: factoring, canceling, and multiplying. Because these terms are monomials, no factoring is required (but we still state it as a step for similarity to solving other problems). We then find the greatest common divisor for both terms to...

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