Formula Instruments Search Results

How To: Make musical instruments from household items

This SUPER cool video shows how to make some fantastic percussion instruments out of items you can easily find around your house, or for cheap around your neighborhood. From plastic pails, PVC pipes, tin cans, buckets, 45 gallon drums and more. This video is short, but very inspiring when you see what cool things you can build on your own. Musical instruments can cost thousands of dollars, but with this video you can make dozens of instruments from items around your home!

How To: Sum & count with array formulas in Microsoft Excel

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 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.

How To: Perform a standard non-precision approach and landing procedure in an aircraft

A pilot that earns an instrument rating is a pilot that's mastered his or her flight skills to a level or precision and accuracy needed to safely fly an airplane through clouds, fog, and other adverse weather conditions. While flying in these weather conditions, known as IMC, or instrument meteorological conditions, a pilot is tasked with flying an airplane solely by reference to flight instruments. The pilot needs to be able to go from takeoff to landing, without having any outside visual re...

How To: Build and use array formulas 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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Find surface area and volume of a sphere

In this how to video, you will learn how to find the volume of a sphere and surface area. Let's say you need to find the volume of a sphere with a surface area of 200 cm cubed. You will need to know the formulas for surface area and volume of a sphere. The formula for surface area is 4 pi r squared. The formula for volume is 4/3 pi r cubed. Plug in the surface area of 200 cm cubed and plug it into the formula. You should get an answer of about 3.99 cm. Now you just have to solve for the radiu...

How To: Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.

How To: Use Studio Instruments with SONAR and Project5

This music editing tutorial gives an extensive overview of how to use Cakewalk's new Studio Instruments to build your Drum, Bass, Keyboard, and String tracks. This video shows Studio Instruments in use in both SONAR and Project5. Studio Instruments is a collection of 4 virtual instruments in one package that can be used in combination with SONAR or Project5 as this tutorial illustrates.

How To: Create a formula timer in Microsoft Excel

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 2nd installment in his "Excel Formula Efficiency" series, you'll learn how to compare alternative formulas to see which is faster.

How To: Make calculations in Excel with formulas & references

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 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...

How To: Combine Studio Instruments in SONAR with Shane Olivier

Cakewalk Studio Instruments is made up of four high quality virtual instruments. Throughout this tutorial, Shane Olivier demonstrates how quickly you can integrate midi files and use Sonar's Step sequencer to producing quick, polished results. He also shows how Cakewalk Sonar DAW editions and Studio Instruments work together by adding Rapture LE (of a softsynth of your choice) into the mix. Watch as Shane Olivier shows you how to integrate Studio Instruments with SONAR.

How To: Create a basic array formula in Microsoft Excel

Looking for a primer on how to create and work with arrays 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 very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel.

How To: Use instrument tracks in Logic Pro

This audio editing software tutorial will show you how to create, setup, and use instrument tracks in Logic Pro. First, Connor Smith shows you how to pick instruments from the library browser in Logic Pro. Then, learn two different ways to create instruments in the Mixer window (first with manually inserting instruments, and then by using the channel strip settings). If you want to learn how to use instrument tracks in Logic Pro, this tutorial is a great place to start.

How To: Find Z with the Z-Score formula

In this video tutorial the instructor shows how to find Z with the Z-Score formula. He uses a sample problem to show how to find this. He tells you the formula for z which is a real simple formula. Now he notes down the formula on the board and brings in the example problem with sample values. He substitutes the values in the z-score formula and solves it finding out the z value. This video shows how to find z using the z-score formula and also demonstrates the formula using a simple example.

How To: Make a musical instrument from junk

This instructional video demonstrates how to make an exciting stringed instrument from simple junk materials. This is one of the projects from Nick Penny's book "Making Musical Instruments from Junk". This musical instrument is called a poptar, because of the unique sound it makes. You will need a 2 liter plastic bottle, scissors, and plastic twine.

How To: Solder instrument cables

Learn how to solder up some great, rugged instrument cables in just a few minutes! Patch cables and instrument cables don't need to cost a fortune. Make you own with cable and whatever plug-in head you want. Watch this video circuitry tutorial and learn how to solder instrument cables.

How To: Speed up calculations with custom Excel formulas

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 very first installment in his "Excel Formula Efficiency" series, you'll learn how a custom function (i.e., a user-defined function) can speed up calculations.

How To: Solve complex indefinite integrals in calculus

In this video the math teacher explains the meaning of the indefinite integral formula in calculus by stating it in terms of antiderivatives. He then shows in general terms how this indefinite integral formula has a related derivative formula, i.e. if the derivative of F(x) is f(x) then the indefinite integral of f(x) is F(x) plus a constant term (C). With this general relationship the teacher takes us through three related examples where he converts a derivative formula to an integral formul...

How To: Use database functions in Microsoft Excel 1997-2003

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 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Calculate running total by formula in Microsoft Excel

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 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.

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: Create a Tangent Line with Excel

Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.

How To: Convert a formula to a value in Microsoft Excel 2010

Learn how to convert a formula to a value in a Microsoft Excel 2010 spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started converting formulas in your own MS Excel 2010 projects, watch this free video guide.

Prev Page