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 321st installment in their series of digital spreadsheet magic tricks, you'll learn how to match text substrings with an array formula that uses the AND, ISNUMBER and SEARCH functions.
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 213th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a non-array formula to extract data dynamically using two different methods.
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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.
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 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to grade student answers where more than one possibility exists using the IF and OR functions.
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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel formulas.
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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.
Add a instrumet (or MIDI) track to your project in Pro Tools! This tutorial shows you how you can take advantage of many of the various functions available to you in Pro Tools and incorporate instruments into your current music project.
In this video tutorial, we learn how to set up VST plug-ins and virtual instruments within Studio One. Whether you're new to PreSonus' DAW or new to digital recording more generally, you're sure to find much to take away from this free video software tutorial. Take a look.
If your LEGO men are raring to get a rock band going, then who are you to stop them? With a few LEGO blocks, you can easily create some nifty instruments for them to start jamming with. In this video, watch and learn the steps to creating a guitar, bass and cello out of LEGOs. Also, after the credits, check out the cool LEGO microphone!
Want to know how to perform "Jingle Bells" on the piano? Learn how with this free video piano lesson, which presents a complete breakdown of the popular Christmastime song. While this tutorial is best suited for intermediate players, pianists of all skill levels can play along given a little sticktoitiveness. For more information, and to get started playing this popular winter song on your own keyboard instrument, watch this how-to!
This is a video about the multiplication, determination, and inverse of matrix using excel. First we have to take two matrix in excel. If you take two 3x3 matrices and multiply it then you will get a 3x3 matrix as a result. First we have to select 3x3 cells in the excel and give then a formula of =mmult(and then select the first matrix it will automatically takes the row and cell numbers, next select the second matrix). Then it will give the answer. Next if you want to find the determinant of...
Have you ever been curious about how a guitar goes from a couple slabs of wood, to a beautiful hand crafted instrument? In this two-part video series, learn how these precious instruments are made from start to finish. In two parts, witness the adding of kerfing, inlaying the tail wedge, the installation of the binding, and construction of the back, the soundboard, the fretboard, and the bridge.
This is a tutorial on how to make a $2.00 didgeridoo. This musical instrument is made Redneck style out of ABS pipe. The Digeridoo is an Australian wind instrument. This one is a non-traditional plastic version.
Rocketboom Field Correspondent Bre Pettis on how to make a mellotron. You might remember this organ-like, polyphonic keyboard from the Beatles song "Strawberry Fields Forever." With a Walkman tape players, a keyboard, and a speaker, you can create your own musical instrument. Watch this video tutorial and learn how to make a modified mellotron musical instrument.
A "voice changer" can be rewired so that you can play a pre-amped instrument through it like an effects pedal. It makes some relatively freakish sounds and is much more interesting this way. You can still use a microphone to talk through it but now you can rock out through it as well. Watch this video circuitry tutorial and learn how to modify a voice transformer into an effects pedal for musical instruments.
Toshio Iwai's "tenoir-on" is a really cool musical device, but is quite expensive and due to short supply. This version is an unplugged version, the creator has dubbed the "tenori-off." You will need a plastic board, vinyl pipes, and bubble wrap. Watch this video tutorial and learn how to build a tenori inspired tenori-off acoustic musical instrument.
This tutorial shows how to connect and set up a device/instrument (in this tutorial it's an electric guitar) to your Motif XS audio input, how to apply two effects, how to record the audio together with a performance to a song or pattern, and finally how to export the whole song to your hard disk as a .wav file.
Watch to learn how to say the names of musical instruments, like the trombone and the balalaika, in French. For intermediate French speakers--no English translation.
In this tutorial, we learn how to find the formula of a given sequence. First, you need to decide what you're starting with. Start with a1, then continue on with a2, a3, and a4. Eventually, you will have an "An". You will have an "n" in your numerator and the denominator will start between the numbers of your fractions. Look to see if that works, then you have to see where the signs alternate on the fractions. Write in any negatives that you have, then figure your power out. Once you follow t...
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 51st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an if formula to indicate whether a bond is sold at discount, premium or par.
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 40th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create a perpetuity preferred stock valuation formula in Excel.
In this video, we learn how to find soulful loops in Reason Soul School. First, select to create an instrument. Then, browse through the Reason SoulSchool Refill. There will be several categories of instruments with soul styles. Select either Cincinnati, Detroit, or Memphis. In each of them, there will be instrument loops, drums, and grooves. Each are tailored to match each other. By loading these, you can start a tight groove easily. Find the different loops and then select the one that you ...
In this tutorial, we learn how to use the distance formula for two points. The distance formula is D= the square root of (X2-X1) squared, plus (Y2 minus Y1) squared. It may look confusing, but it's just a derivation of a theorem. First, find the two points that you have and graph them. If you want to know the distance between them, you cannot just count squares if it's a diagonal line. If you remember geometry, you can draw a right triangle over the line to figure out the distance. After this...
In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to determine the empircal and molecular formulas of a substance given percent composition. Whether you need help studying for that next big test or could just use a hand finishing your homework, you're sure to be well served by this video lesson. For more information, including detailed, step-by-step instructions, take a look.
In Studio One, you can drag and drop workflow. Open a song in Studio One. Here, you can isolate particular instruments. Alt + click, will allow you to isolate. You can search a list of plug-ins in the mixer or press F7 to open the effects browser. You can also drag and drop the gate onto a mix.
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 630th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy formula through a huge range using keyboard shortcuts.
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 626th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart to show the amount of time a project takes during a day.
Looking for a guide on how to find the vertex of a parabola using the vertex formula? Learn how 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 easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).
See how to use the quadratic formula to solve quadratic equations with this free video algebra lesson. Solving quadratic equations is a cinch once you know the proper method to tackle them. 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).
Need to know how to find the formula for a piecewise function from a graph? Learn how with 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).
If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 3rd installment in said basics series, you'll learn how to use formulas that make reference to the values of a cell or multiple cells.
If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 22nd installment in said basics series, you'll learn how to write and use basic IF function formulas in Microsoft Excel.
If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the nth installment in said basics series, you'll learn how to work with VLOOKUP function formulas.
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 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:
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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
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 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...
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 about the SUMIFS function and how it blows SUMPRODUCT away when it comes to calculation speed.
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 15th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for larger-sized mathematical word problems.
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 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for finding the largest improvement in sales from one year to the next.
