Formula Instruments Search Results

How To: Calculate the area of any triangle

This video will show you simply how to calculate the area of any triangle using basic geometry formulas. Since a triangle is basically half of a rectangle, the formula for calculating the area of a triangle is base times height. This video offers some insight and examples provided to you by a teacher about how to apply this formula to various types of triangles, whether they are right triangles, equilateral, isosceles, or another form of triangle. By watching this video, you will be well prep...

How To: Change the operator in formula from drop-down in Excel

In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...

How To: Find the area of a trapezoid quickly

In another installment of Math Problem Generator this video shows how to find the area of a trapezoid. First it displays the dimension of the triangle, with the corresponding formula to find the area. This quick and easy demonstration shows how to plug in the correct dimensions into the formula. From there you use the order of operations to solve the formula correctly. The video will teach you the basic procedures in solving for the area of a trapezoid, and will help you take on more complex ...

How To: Derive the annual compound interest formula

In this video tutorial the instructor shows how to derive the formula to compute interest compounded annually. He starts with explaining the basic concepts like principle which is the amount you borrow and the rate of interest or annual percentage rate (APR), which is the rate at which you pay the interest up on the borrowed principle. He shows that the amount after the end of one year is amount A = P(1+APR),and he goes on and generalizes how to compute it for n years. This video shows how to...

How To: Calculate simple interest

Learn how to calculate simple interest with step-by-step instructions using the formula I=prt. Simply defined, interest equals principle times rate times time. The video shows various examples of calculating this formula by plugging different variables into the equation. Although, these calculations can seem hard to follow, the way they are presented is straightforward and simple to understand. The video also explains converting percentages to decimals, which is the cornerstone of applying th...

How To: Use the midpoint formula to find midpoint of a line

In this video the tutor shows how to find the midpoint of a line. He goes on and gives a formula to find out the mid point of a line. The x coordinate of the mid point of a line is the average of the x-coordinates of the end points of that line. Similarly the y coordinate of the mid point of a line is the average of the y-coordinates of the end points of that line. He notes down the formula and explains it by taking an example. This video shows how to compute the mid point of a line given its...

How To: Find the surface area of an aluminum can or cylinder

This video tells us the method to find the surface area of an aluminium can or cylinder. The surface area includes the outside area of the curved portion and the aluminium top and bottom. The formula to find area is the multiple of 2, pi, r, r+h or (2)(pi)(r)(r+h). The radius of the cylinder is the radius of the circular top or bottom. In the example shown in the video, the radius is 4 inches and the height is 12 inches. Substituting the values in the formula, we get the surface area as (2)(3...

How To: Get started using Numbers '09

Check out this informative video tutorial from Apple on how to get started using Numbers '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.

How To: Print spreadsheets in Numbers '09

Check out this informative video tutorial from Apple on how to print spreadsheets in Numbers '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.

How To: Handle large intervals on a mallet instrument

Over the past 5-10 years, there has been an enormous growth in 4-mallet percussion. With the rapid increase in popularity, there comes the possibility of students moving too quickly through the learning process, or not having adequate instruction. In this installment from his video tutorial series on four-mallet percussion, Gifford Howarth explains how to handle larger intervals on a mallet instrument like a vibraphone or marimba without getting into bad habits.

How To: Turn your guitar into a Tumbi

Learn how you can use your guitar as a tumbi to play Punjabi music with this tutorial. The tumbi is a traditional North Indian, high pitched, single string plucking instrument from the Punjab region. This instrument is associated with folk music of Punjab and presently very popular in Bhangra Music. Watch this how to video and you will be able to turn your guitar into a Tumbi.

How To: Use the LARGE and SMALL functions in Microsoft Excel

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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:

How To: Input values & formulas into a cell in Excel macros

This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...

How To: Calculate the area of a triangle by formula

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. With this free math tutorial, you'll learn how to calculate the area of a triangle by formula.

How To: Play "Telephone" by Lady Gaga on a keyboard instrument

Want to play "Telephone" by Lady Gaga? See how it's done with this free video piano lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the piano, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Telephone" on your own piano or keyboard instrument, take a look!

How To: Play the "Amazing Grace" hymn on a piano or keyboard

How sweet the sound of an instrument properly played! With this clip, you'll learn how to play "Amazing Grace" on a piano or other keyboard instrument. Regardless of your preferred style of music, if you want to be great, you'll need your head and hands on the same page. And there's no better way to get your head and hands on the same page than to practice. Happily, the Internet is awash in video tutorials like this one.

How To: Prepare for the SAT math section

How to prepare for the math section of SAT:Eva for brightstorm2 gives us a few quick tips to solve the math section in the SAT test. They are simple, easy yet crucial to help you get through the math section. Let us begin with the basics. Basic are simple tips like read carefully, use your calculator wisely, use all the information given, do not worry about formulae and symbols, tackle the “always”, “never”, “must and “could and “can” problems. To explain them in detail; you should pay attent...

How To: Calculate the circumference of a circle

This video shows how to calculate the circumference of a given circle. The video first describes the circumference or perimeter of a circle as the distance around the outside of a circle. To find the circumference we need either the radius or the diameter of the circle. When you know the diameter of the circle, the formula to find the circumference denoted by 'C' is 'pi' times the diameter, where 'd' is the diameter and 'pi' is a constant, the approximate value being 3.14. And when you are gi...

How To: Trigger instruments on key release in Reason 3 or 4

This music production software tutorial describes a hack to allow you to trigger an instrument or effect when you RELEASE a key in Reason 3 or 4. This is useful for guitar strums, Hi-hats, mutes or delays, or vinyl scratch effects. With this trigger trick you can create back beats easily. Have one effect produced when you push a key, and another when you release the key using release gates in Reason 3 or Reason 4.

How To: Increment numbers in formulas in Microsoft Excel

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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.

How To: Create a defined name for a dynamic range in MS Excel

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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).