Are you looking for a way to make your Microsoft Excel formulas 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 about the basics of Excel's SUMPRODUCT function — why some people use double negative and why other use times one.
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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 5th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use Excel's built-in SUM, AVERAGE, PRODUCT, LCM, QUOTIENT and MOD functions.
This video tells us the method of interpreting derivatives of marginal cost and revenue. If C(x) is the cost of producing x units of a product, C(400) would be the cost to produce 400 units. Now marginal cost is the cost of producing one unit which is equal to the derivative of the cost function or C'(400) which is equal to limit of h tends to zero or lim h->0 [lim(400+h)-lim(400)]/h which is approximately equal to [lim(401)-lim(400)]/1. Similarly, if R(x) is your revenue function, marginal r...
If you're thinking about venturing into the world of using Camera Raw in Photoshop, you've come to the right place. The camera raw function in Adobe Photoshop provides easy access to raw image formats produced by many digital cameras. In this video, learn all about how to get started using the Camera Raw Utility plug-in for Adobe Photoshop.
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...
This video is a tutorial for a music producing software program called Ableton Live 8. In this tutorial he shows you how to apply effects to effects to audio using the audio effect rack function. The way this function works is by being dragged into the bottom of the program and being applied as a place to hold various effects. Using the effect rack you can modulate and manipulate the sound waves in the effect. This is a very convenient tool to have in Ableton because it allows you to have mor...
This how-to video produced by Photoshop Universe gives step-by-step instructions on how to batch automate a process in Adobe Photoshop. With this tutorial you'll be able to learn to correct white balance, enhance colors, resize, and save for the web whole folders' worth of images in one go. The first step to doing this is to open up one of the images in your folder and correct the white balance, enhance the colors, resize the photo and save. The next thing you want to do is to record all of t...
While we personally like to learn a new software program by playing around with its buttons and various functions, sometimes it's a nice primer to actually read the instruction manual. And when it comes to video editing, knowing the particularities of each and every function is crucial to producing professional-quality results.
Welcome back, reader! In this tutorial, we will be covering our first program! So let's get to it. We all know the unspoken tradition of the first program when learning a language and of course, here we will respect and complete it. Fire up your favorite text editor (be it vim, emacs, gedit, it's all the same to me, no h8) and try to keep up.
Thiamine, aka Vitamin B1, keeps your body fully functioning and ready to move!
Regression functions are a vital part of statistical analysis of populations, and if you're involved in business, science, or nearly any academic field you should understand how it works. This series of videos will show you how standard regression functions, ANOVA, ordinary least squares, and everything else you need to know.
Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple. The Microsoft Office for Mac team shows you just how to build formulas by using the new Formula Builder in this how-to video.
Learn how to make and use a hydroponic seed starter to produce seedlings with this video tutorial. This is a very easy setup to make. Start with a basic metal shelving unit. Hang florescent lights above each of the shelves on the shelving unit. Make sure the lights are balanced for day time. Put a plastic container on each shelf that is about the size of the shelf and tall enough for the rim to sit just below the florescent light tubes. You will need some pecks tubing and some plastic clamps....
Got a Canon Powershot whose resolution or functions are not cutting it for you? Then amp up its abilities - without flat out buying a new camera - by checking out this digital camera hack video. By modifying the camera's firmware you'll be able to add games as well as a manual mode for ultimate control of how you produce your images.
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 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...
Bassline (otherwise known as 4x4 garage) is a popular bass laden variety of electronic music that has found it's way into mainstream pop production as well. If you want to start producing it, watch this video to learn, step-by-step, how to produce a 4x4 garage song from scratch in Reason 4.
In this clip, you'll learn how to create and call simple functions when coding in Python 3. Whether you're new to the Python Software Foundation's popular general purpose programming language or a seasoned developer looking to better acquaint yourself with the new features and functions of Python 3.0, you're sure to benefit from this free video programming lesson. For more information, including detailed, step-by-step instructions, watch this video guide.
This tutorial video, from tasktutorial demonstrates how to create animation using the motion guide function in Flash. You will learn how to create an object, in this case, a ball, and create an animation that makes it appear to bounce. The guide shows you, how to add a motion guide by selecting a key frame and drawing it in. Then you will learn how to snap the object to your guide line, and add motion to it by selecting another key frame between the first and last frames, and snapping the obj...
In this video tutorial, viewers learn how to light-scribe with a Nimbie BB11 disc burner. This device is an auto disc loading system that allows the user to light-scribe multiple disc without manually inserting them one-by-one. Simply load the disc into the machine with the labels faced down. On your desktop, double-click on the Q-Q-Box icon to start the program. Start up the labeling function, select a desires image and quantity up to 100. Then click on Print. The machine will then product l...
In this tutorial, viewers will learn how to use the synthesizer functions of the Yamaha PSS-780 keyboard. Starting with the basic piano voice, the presenter shows how this can be modified to create a new sound. He shows how the attack rate of the sound can be modified with one setting, how the modulation button affects the tones of the sound, and how sounds can be further modified with the frequency control. The presenter concludes by noting that with practice the user will learn to create ot...
Make your embroideries more accurate and beautiful by designing the letters and words on a computer software called Compucon EOS 3.
To find a vertical asymptote, you are trying to find values of x that produce 0 in the denominator but not in the numerator. If 0/0 occurs, that means you have a "hole" in the graph. A vertical asymptote is a place in the graph of infinite discontinuity, where the graph spikes off to positive or negative infinity. To find the vertical asymptote, set the denominator equal to zero and solve for x. Check that the values also do not give a zero in the nominator. If the values work, you have found...
Hello everybody. I'm back with Part-2 of this series. In this part we will be programming in C our server and i will be explaining one more "key concept" so everybody got a better understanding on this.
MapForce includes a powerful visual function builder that lets you create new data processing functions in a graphical way using existing functions and libraries. Learn how to combine multiple separate functions that returns a single result with this tutorial.
Liquid DnB is a subgenre of drum and bass faithful to the mission of the original: making smooth, bass-heavy tracks to groove to. In this video you'll learn how to use Reason 4 to produce a liquid DnB track from start to finish, including the beat, melody, and mastering.
Drum and bass was originally a lighter style of jungle, but now has become dark again with the advent of dark DnB, otherwise known as darkstep, neurofunk, techstep, or darkcore. It sounds pretty evil, but you can still dance to it, and in this video you'll learn how to produce a darkstep track from start to finish using Reason 4.
Making rap beats is one of the most lucrative branches of electronic music that aspiring producers can get in to at this point. If you love hip-hop, have Reason 4, and want to start making some beats, watch this video to learn everything you need to know to get started.
Electro pop has been big business since The Postal Service made their era-defining record in 2005, and few artists since have captured that magic as well as Owl City. If you fancy producing some electro pop yourself and have Reason 4, watch this video to learn how producing a good electro-pop song works using Owl City's "Cave In" as an example.
In this video, we learn how to play Jazz guitar: Functioning & Static Dominant Chords. When you play an A7 going to a D chord, you are playing a functioning dominant, because a five chord always wants to go to a one chord. This is because of the tension in the five chord and how it resolves to the one chord. You will hear that the chord wants to go to a different chord, so make sure you understand this concept as you are playing. If the chord does go to the other, it's referred to as a functi...
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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.
Need to know how to solve function problems in algebra? 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 installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to work with and solve functions.
Exponential functions are functions which contains terms which are integers raised to the power of variables. Note that the variables are not raised to the power of integers, but the integers are raised to the power of variables. Variables raised to the power of integers are called as polynomials and are a different class of functions. But exponential functions grow very fast than polynomials with the increase in the value of the variable. To understand the growth of these functions take a si...
This video teaches us to draw the graph of a piecewise function. This is shown using two examples. In the first example we have 'y' equal to 'x + 2' for x less than zero and '1 - x' for x greater than equal to zero. We plot two points on the function for x less than zero and do the same for the function with x greater than equal to zero. The graph for the first function is erased for x greater than equal to zero, and the same is done for the second function for x less than zero. Note that the...
This video shows the method to plot the graph of the absolute value of a function. The video shows the example of the function of cube root of 'x'. The demonstrator first plots the graph of a cube root function. This is done by taking the reference point of positive one and positive eight. The graph is drawn for both negative and positive values of 'x'. After this the graph of absolute function is drawn by taking the absolute value of the cube root function. The resultant graph comes out to b...
The video shows the explanation of greatest integer function. This video explains this with the help of graphs. The video first describes the basic greatest integer function. This means the greatest integer less than or equal to the number gave. The graph of this function is drawn. The video then shows the variations of this function. The first variation shows the function that replaces the 'x' coordinate with it subtracted by three. This shifts the graph to the right by three units. The seco...
Check out this instructional math video that demonstrates how to calculate mathematical functions and graphs. In this 9th lesson, learn how to solve on SAT Algebra problems using the Official SAT Study Guide (as always). Here are the math problems and their page numbers that this video covers:
What does f(x) mean? What does g(4) mean? We explore this and more in this 3-part series, "Understanding Math Functions."
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 31st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to build frequency tables and simple histogram charts in Microsoft Excel. Specifically, this video addresses the following subjects:
