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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
Artist Matt Busch shows how to render a full value monotone comp for his STAR WARS 30th Anniversary movie poster. In addition to getting into the nitty gritty of light and shadow in sketches, see Matt show you how to draw Stormtroopers, as well as busting out his killer happy dance! Learn how to sketch Star Wars by watching this video drawing tutorial.
In this math lesson we will learn how to solve a proportion word problem. Watch the video to learn how to set up a proportion, solve it, and interpret the answer.
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.
There are a few key ingredients that you always need on hand when baking cookies and other desserts, but when you run out, you run out. You either have to stop what you're doing and go to the grocery store, find a good substitute, or scrap the project entirely. Chances are, you'll never accept defeat, and why go to the store if there's a good substitute on hand?
Forget using glue or wallpaper paste, the best recipe for paper mache uses nothing more than flour and water. There's no set ratio, just mix what you think looks right. The key to this recipe is boiling the paste after you have mixed it.
Sometimes black bars can appear on videos you have uploaded to YouTube (or any other video sharing website). This can get annoying, and is usually the result of uploading a video whose aspect ratio is not synced up with YouTube. This video shows you a couple fixes to getting rid of those bars.
Ready to bring your digital photographs into the world of tangible objects? Before you do, you'll need to understand a thing or two about aspect ratios and image cropping within Adobe Photoshop. Fortunately, this guide will tell you everything you need to know. For a complete overview, and to get started cropping your own images for printing, watch this free video guide.
This short Final Cut Pro tutorial shows how to export a still image from Final Cut Pro and then deinterlace it, and alter its aspect ratio in Photoshop. This is a great tutorial for learning how to work with still images from Final Cut Pro.
Alex Oliver demonstrates how Art Directors and Cinematographers can use the Film & Stage plugin in SketchUp to explore the use of different camera lenses and aspect ratios on location or on a production set. The Film and Stage plug-in is a great way for film makers and directors to pre-visualize shots and scenes in SketchUp, a software you may only have thought useful for architecture and product pre-visualization. Learn how to plan shots and do animatics in this SketchUp tutorial.
This video will teach you how to make an origami paper star. The paper in the video is 6 inches long by 1/4 inch wide. But any size paper can be used, as long as it fits a similar ratio, and the paper is not too thick.
Learn the basics of VLC player - a free media player that plays almost all video formats (including Flash .flv) as well as DVDs. Learn how to use VLC player to play videos and DVDs as well as how to adjust the aspect ratio, filter videos, or adjust audio quality.
Sometimes you need to print a perfect 5x7" or 8x10" photo that will go into a frame with correct aspect ratios. Or maybe you need to make an image for a video that will be just the right size for DV. Photoshop has a variety of ways to accomplish this task, and in this video Terry White will show you some of the easiest ways.
What's up readers? We have ever so slightly touched upon this concept of scope with variables but still don't really know what it means. In this tutorial we will learn the behaviors of variables existing in our programs and within functions.
In the last tutorial, we learned how to make functions and how they work on the high level. This time, we will take a peek under the hood again, stare deep into its soul and see its ugliness face to face to see how it works in the lower level.
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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS functions.
In order to convert Celsius to Fahrenheit, you will need to use this formula: F = 9/5C + 32. Therefore, you will need to solve for C or substitute values and solve in that manner.
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...
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...
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").
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. ...
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.
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...
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.
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.
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 514th installment in their series of digital spreadsheet magic tricks, you'll learn three methods for conditionally formatting duplicate values:
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...