Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...
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 216th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pivot table (PivotTable) with 4-variable cross tabulation. Learn to use multiple fields in a pivot table with this free video tutorial.
NOTICE: Ciuffy will be answering questions related to my articles on my behalf as I am very busy. Hope You Have Fun !!!
Need to insert a scrollable gallery of thumbnails into your website or web project? You've come to the right place. In this tutorial, learn how to build a scrolling thumbnails video and take it to the next level by building a fully functional gallery with a bonus randomizer button. Learn about using variables and rounding numbers and navigating time lines within a flash movie with actionscript.
Being able to write your own hacking tools is what separates the script kiddies from the legendary hackers. While this can take many forms, one of the most coveted skills in hacking is the ability to dig through the binary files of a program and identify vulnerabilities at the lowest level. This is referred to as binary exploitation, and today we're going to check out a tool known as Protostar.
Hello everyone. I've recently made the annoucement of the Null Byte suite of tools, and we've covered how to download and install it. Now it's time we cover how to submit a tool for inclusion into the suite. It's relatively simple, but we need to get a few ground rules out of the way.
Solving Equations with Fractions Using Addition In our first example, our equation is b - 11/10 = -13/5
A video that demonstrates one of the basic techniques involved in factorizing an equation that contains the difference of two terms which are also perfect squares themselves and are equated to 0.
In this tutorial, we learn how to solve inequalities by multiplying or dividing. Start out with your equation written out in front of you. Now, find the variable in the equation and figure out how to get rid of the denominator underneath it. Divide this on both sides, then you will be left with the variable with the inequality. Don't flip the inequality if you don't divide by a negative on both sides. Then, write out the rest of the equation. Once finished, do the rest of the math for the rig...
Probability computation is a complex process and even using a calculator can be difficult. But normal probability calculations can be performed quickly with the help of calculator once you know how to use it. So when you have to calculate a probability from a normal distribution you can use the functions on your scientific calculator. You can use the normal CDF function from you calculator to compute the area under a normal curve. The function requires lower band and upper band values, the me...
This video gives you brief tutorial on simplifying expressions, or canceling out common factors. He starts out by answering the question "What is canceling?" and demonstrates a basic example. You find the greatest common factor between the numerator and denominator, which you then divide both by. This can also be done if you have variables in your fraction. He then shows it can be done the same way if you have binomials in your fractions. However, you must be careful that the denominator does...
In this video the instructor shows how to solve a 3 x 3 linear system using the Cramer's rule. In this kind of problem you are given three equations in three variables x, y, z and you need to solve for the values of these equations. You can solve this using the Cramer rule which says that the value of x is Dx/D, where Dx and D are two different determinate. Now you have to figure out the determinate to get the value of variable x. The determinate D is called the foundation determinate and is ...
In this tutorial the instructor shows how to solve equations with fractions and decimals. When you have a fraction first try to simplify it by canceling out the common factors in the numerator and the denominator. If there are any decimals convert them into fractions. Now if you have a number multiplying a equation apply distributive law and simplify the equation. Now finally try to get the variables on one side and numerical terms on the other side of the equation and finally solve for the u...
In this video the instructor shows how to use proportions to solve fractions. When you have a proportions problem with an unknown term, cross multiply and divide it to get the value of that unknown term. For example if given 7/8 = m/4, cross multiply 7/8 with 4, giving 7/2 which is the value of the unknown variable m. So if two quantities are proportionate then you can equate them as shown in the video and cross multiply to get the value of any unknown variable. Proportions are just fractions...
This is a mathematical instructional video on finding the point slope form of a line equation. This technique allows you to find the x and y intercepts of a line. The point slope form is (y-y1)=m(x-x1). The instructor tells you what each of the variables represents, and shows an example. He then shows you how to find the slope-intercept form from the point slope form. Finally, he shows you how to graph the line using both of the equations. He shows you how to find the equations with different...
In this video the instructor shows how to solve mixture problems using two variables. Usually in these kind of questions the problem statement goes like, if A costs $x for a pound and B costs $y for a pound, in what ratio should they be mixed such that one pound of the new mixture sells for $z a pound. So, in these kind of problems start with a box where you list down all the given data in the form of a table as shown in the video. Now denote the unknown quantity of A and B by two variables a...
In this video the instructor shows how to do temperature conversions using y = m*x + b. Now if Celsius is represented by the variable C and Fahrenheit is represented by the symbol F, you can replace then in the previous equation in place of the variables x and y giving you the equation C = m*F + b. Now to solve for the values of the constants m and b you need to have values of two sample temperatures in both Celsius and Fahrenheit. Take the first sample and substitute in the above equation gi...
In this tutorial the instructor shows how to solve percent equations. The general form of a percent equations is that a is b% of c. As there can be three kinds of variables a, b, c, the questions involving percent equations can be of three types having one of the three variables unknown. These kind of percent statements can be solved easily by setting up an equation. So, to convert percent statement into a equation replace the unknown term with n, the 'is' term with equals sign and the '%' si...
Confused in math class and need some extra help? This educational video gives instruction on how to solve mathematical algebraic equations. It shows you how to break an equation down and make them less scary to solve. Step-by-step instructions show you how to solve more complicate equations when there is a variable on both sides of the equation. An instructional video for students who need some extra help on their math homework, or parents who can't remember what they learned in high school.
In this video the tutor shows how to add and subtract monomials. He says that to add or subtract monomials they have to be similar terms. Similar terms are those that have same variables and equal exponents to the variables. He shows how to do this using illustrative diagrams and solves a couple of sample problems. He adds a few monomials with similar terms and also explains how to subtract a few monomials. This video gives an introduction to similar terms and how to add and subtract monomials.
This video will show you the simple mathematical concept of solving a single-step equation using multiplication. This is very useful for equations in which you need to solve for a variable and the variable is a part of a fraction. The example provided in the video shows a very fast and simple way to solve these types of problems. By multiplying your fraction by the denominator of the fraction, you will cancel out the fraction and multiply the other side by the same number. By following these ...
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.
In this tutorial the instructor shows how to identify similar terms in a polynomial equation. He states that in similar terms the variables and their exponents are exactly the same but they may differ in the co-efficient. He shows how to identify similar terms by using some examples. He shows that a change is even the co-efficient makes them dissimilar terms. Similar terms can be further added as the variable of both the terms is same. This video gives an idea of what similar terms are and ho...
This video explains how to solve a single variable linear equation. Keep in mind that your equation should be in the form ax + b = c. The goal is to solve for x. Isolate the variable. Begin by subtracting b from both sides of the equation. Look at your new equation. It should now be in the form ax = c - b. Solve for x by dividing both sides by a. Your expression is now in the form x = (c - b)/a. You have solved the expression for x.
This video is a great one on learning about evaluating fractions. The voice explains how to first plug in the numbers given for each variable in the fractions. He also explains the importance of simplifying the top and bottom first before simplifying the entire fraction. He also explains ways that would not be helpful in solving the problem and comparing that with the correct way. Then he notes the use of your simple math rules to find the answer. Excellent video for viewers.
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...
Bucky from The New Boston serves up this Python video tutorial on how to overwrite variables on a subclass in Python. This is the program you use to write all of your Python code down. Fun with subclasses!
Once you've learned to draw sculptural forms in perspective you will naturally want to begin placing several objects within a common space. You would like to draw a background. The trouble is, when drawing in perspective, there is no flat background. It helps to map out the space using halfway points to make note of significant objects. Watch this four part instructional video to draw several objects against a single background.
Lattice work is used as filling or for backgrounds. Worked on a plain ground (with only the fabric behind the lattice stitches) it can be easily managed by beginners. Adding a colored background (for example, a background worked in satin stitch) kicks the stitch up a notch to intermediate level. Here's a video tutorial from Needle 'n Thread on working lattice stitch over a satin stitch ground.
Watch this video to learn how to draw backgrounds for anime and manga. "Miki Falls" manga creator Mark Crilley presents a tutorial on how to draw and color backgrounds for a manga-style illustration. The emphasis is on using color and linework to create the illusion of depth.
Hello there! This will probably be the final tutorial on functions where we will be looking over a method called pass by reference. This technique allows us to modify large amounts of data without the overhead and return multiple values. Let's go!
What is Programming? Why need to learn? How to get started? Which language to choose? While surfing web, you must be encountering various softwares, games, etc. and might be thinking to make one, but don't know where to start. Here, I am starting series in Programming.
Welcome back, my greenhorn hackers! Recently, I asked the Null Byte community what subject they would most like me to cover in future tutorials. Many of you cited scripting, and I decided it's best to cover this subject soon, so here goes.
This video explains the process of simplifying an algebraic expression with negative exponents. The video starts with an example of such an algebraic expression; the expression contains negative powers in both the numerator and denominator. The location of the negative exponents is first pointed out visually. Next, it is observed that there are like based or variables in both the numerator and denominator; however, it is explained that the numerator must first be expanded before the expressio...
This video demonstrates the quotient rule as applied to exponential expressions that appear in the form of, to use the word loosely, a fraction. The name, "quotient rule", refers to the fact that it applies to expressions which are divided by other expressions. The video begins by explaining that the quotient rule allows expressions in this form to be simplified if they contain like bases (i.e., the terms are of the same variable). The quotient rule allows the expression to be simplified by s...
Have you ever wanted to create a background with one of your photos? This video shows you how to use one of your photos to create a photo background using Adobe Photoshop. It will show you how to use the free transform tool, overlay blend modes, hue and saturation, drop shadows, and other cool effects. Learn all about creating photo backgrounds with this video tutorial.
Welcome to my tutorial where Voidx and I will be expanding on my previous article to provide more clarity into the logic of the code.
What's up, peeps? In this quick tutorial, we will be looking at structs, a special kind of data type.
Welcome back, my fledgling hackers! With this first article, I am initiating a new series intended to convey to my readers the skills necessary to develop your own exploits.
This video will explain to you how to preform one of the more fundamental but confusing tasks in 3D Studio MAX: setting up textures as a template background for you models. Doing this will make sure that your models are displayed in front of the proper background and that said background will function properly. If you need a little help setting the scene for your 3D modeling, watch this video.
