This is a strictly for fun and comical video tutorial that teaches you how to make a musical instrument specifically a "kazoo" with a gas mask. A kazoo is a wind instrument which adds a buzzing sound to a player's voice. This makes a creepy sound effect to a mask. You simply remove specific parts of the mask to turn it into a kazoo. The video also has a great finale where the performers use the kazoo masks to sing the acapella version of "The Lion Sleeps Tonight".
MAKE and Collin Cunningham brings the do-it-yourself mindset to all the technology in your life. Make Magazine celebrates your right to tweak, hack, and bend any technology to your own will.
This is a video tutorial in the Education category where you are going to learn how to understand polyatomic chemical formulas. When writing the formula using polyatomics, the same cross-over rule applies. 1st identify the metal and non-metal. Then you write the symbols, write the charges, cross-over the charges from top to bottom, remove the charge and simplify the numbers and remove the 1s. for example, iron (II) phospahate. The "ate" ending implies that phosphate is polyatomic. The symbol ...
In this tutorial, we learn how to use the Quintile Formula in Statistics. To find the quintile rank of a formula that is in a certain set, you will first need to count the number you are given. Then, read the equation so you understand what the R, N, equal side, and other numbers mean. Once you understand what all of these mean, fill in the formula with the correct information. Use the information you are given in the question to fill it into the equation. When finished, you will apply the ru...
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 2nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to get started using functions and formulas in MS Excel. Specifically, you'll see the different elements of formulas (the equal sign, cell references, math operator...
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...
Area of a triangle can be calculated when you have the length of its base and height. In this case the area is 1/2 times the base and its height. If you do not know the height of the triangle but know the lengths of all the sides of the triangle then you can calculate its area using the Herons formula. First to use it you need to computer the semi perimeter of the triangle S, which is S = (a + b + c)/2, where a, b, c are the lengths of the sides of the triangle. Now the area of the triangle i...
New to 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 Excel tutorial from ExcelIsFun, the 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.
This two part video walks you through the steps of in proving Heron's formula. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
This video is a tutorial for setting up Native Instruments' Traktor Scratch system. While the setup can seem a bit confusing, with this video's help, you will be able to setup and use your system easily. You should practice setting this system up repeatedly, especially if you intend to use it in live performance, so that setup is quick, and troubleshooting is straight forward rather than a sweaty, nervous mess!
Learn all about Combinator controller instruments within Reason 5. This official video guide from James Bernard of Propellerhead will teach you everything you'll need to know. Whether you're new to Propellerhead's virtual music studio application, Reason, or their newer DAW app, Record, you're sure to find much to take away from this brief video software tutorial.
In this video tutorial from Boy in a Band, you'll learn how to create a psytrance-style acid lead synthesize instrument in Reason. For all of the details, including step-by-step instructions, and to get started creating and using trance-style acid lead synths in your own Reason projects, take a look.
One formula that you will run into in Calculus is calculating the percentage growth rate using a logarithmic derivative, elasticity of demand, relation among elasticity of demand and also revenue. In this video you will learn the different formulas that are used, methods of solving each formula, and also the full solutions.
hether 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 35th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see an efficient IF function formula get beat by an even more efficient VLOOKUP function formula.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to count unique records with a formula with a helper column to speed up calculations.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel array formula series, you'll learn how to create array formula for adding the 3 largest or smallest values in a data set.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for stock portfolio return & standard deviation.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function in a formula to replace a long IF function formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 37th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a table of formulas and labels based on formula inputs in an assumption area.
DrawingNow teaches you how to draw musical instruments on a computer. Start by drawing a guitar and then draw all the other instruments on top and near it. Use straight lines for the neck and interior. Use curves on the outside. Make sure to draw simple shapes and add detail later. Also, don't over complicate your drawing. Remember to keep proportions. The trombone is all about curves and circles. Don't be scared if it doesn't come out smaller than the guitar. Finally add drums and you can al...
Microsoft Office Excel 2007 Tip - Using Formula Auto-Complete - Microsoft® Office Excel® 2007 is truly at its best when it's working hard behind the scenes to execute complex calculations, working with any of a number of standard formulas. When we're creating spreadsheets, formulas should be easy to replicate again and again, but human error can sometimes get in the way.
Take a look at this instructional video and learn how to use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later.
What if you've recorded a great jam that feels right but doesn't sound quite right? With GarageBand, it's easy to change real instrument tracks to alter the pitch or timing of the track.
You can attach a microphone to your Mac and record your own voice or any acoustic instrument right to a track in Garageband.
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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.
This is a video tutorial in the Education category where you are going to learn how to convert Fahrenheit to Celsius for chemistry. Doing this is really simple and easy and doesn't take much time. But, you must know the formula for doing the conversion. The formula is degrees Celsius is equal to degrees Fahrenheit minus 32 divided by 1.8. Using this formula let us convert 75 degrees Fahrenheit to degrees Celsius. Inserting 75 in the formula, we get (75 - 32) divided by 1.8. and the answer is ...
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.
Using the quadratic formula to solve equations may bring one, two, or no algebraic solutions. The quadratic formula is special to quadratic equations, which can have fractions, radicals, or neverending decimals. Learn how to solve quadratic equations using the quadratic formula with this free video algebra lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's ea...
Could you use a little help figuring out how to find percentage composition? Watch this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this free math tutorial, you'll learn how to calculate percentage composition by formula.
With all of the new travel laws these days, taking baby formula with you on a long trip can be complicated.
This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if you pay attention during this presentation you'll pick up the skills quickly! Several ideas covered in this video are Formulas with cell references, how to find various Excel functions to use in formulas, and the Effect f...
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.
In order to find the cosine of a triangle in trigonometry, you will need to understand the CAH formula, part of the larger mnemonic of SOHCAHTOA, which outlines how to find the sine, cosine, and the tangent of an angle. The video offers accurate diagrams as well as examples in order for their viewers to better understand the CAH formula. The CAH formula simply outlines the fact that the cosine is equal to the length of the adjacent side of the triangle over the hypotenuse of the triangle. By ...
In this video lesson, you learn how to find the area of a circle. The video starts with an explanation of the area's formula. This formula can then be used to find the area of any circle, given its radius, which is half the diameter of the circle. There are many applications for this formula, whether in architecture, or studying for a basic geometry test. Euclidean geometry is the cornerstone of any education, and this video teaches you one of the many formulas in geometry.
This video teaches "How to solve Formula Problems". You will be given numbers to replace all letters in the formula EXCEPT one.
In this video, we learn how to use Logic Pro: Changing presets in Logic instruments. First, insert the ES2 and add in a preset that you like. You can also use key strokes to step through presets instead of using the mouse to click through all of them. By doing this, you will save time while you are going through presets to audition a bunch of presets to find the one you want. Use the drop down menu within the instrument to find the different presets and then choose one you would like to inser...
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract month and year data from transactional records by filtering, array formula and non-array formula.
