Cost Function Search Results

How To: De seed a vanilla bean

This video show you how to get those deliciously fragrant vanilla beans out of their pod. Whenever possible, opt for the fresh whole vanilla beans over the extracts. A vanilla bean can cost anywhere from $1.50 and up, but the flavor it adds is priceless.

How To: Avoid jet lag

You don’t have to accept fatigue and sleeplessness as the cost of traveling to distant lands. There are a half a dozen things you can do to lessen the impact of crossing time zones.

How To: Make a cheap squib

This is an informational video for people that want to have some action in their movies but have a small budget. Each squib ended up costing us about $0.78. These are for fake gunshots.

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: Find the sides of a right triangle with trig functions

Learn how to use trigonometric functions to calculate the sides of a right triangle. 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 ...

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: Force a function to becom an array 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 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...

How To: Use differential equations to represent growth

This video shows the method to use differential equations to represent growth. Consider the function y=multiple of C & e raised to kx or Ce^(kx). Differentiating it with respect to x, we get dy/dx=kCe^(kx) or ky. So, the solution of the differential equation dy/dx=ky is Ce^(kx). There are two possibilities in the function y=e^(kx). It can be exponentially growth or decay function. This depends on the value of k. If k is greater than 0 or k>0, we get an exponential growth function. On the othe...

How To: Ignore hidden rows with MS Excel's AGGREGATE function

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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Ignore filtered values making calculations 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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.

How To: Integrate exponential functions in calculus

Looking for a primer on how to integrate exponential functions? This free video calculus lesson will teach you how. 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 study for that next big test).

How To: Graph trigonometric functions

Learn how to graph the amplitude and periods of sine and cosine functions in basic trigonometry. Learn how to use trigonometric functions to calculate the sides of a right triangle. Need to know how to solve a matrix-form linear equation 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 h...

How To: Use VLOOKUP function 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:

How To: Look up formulas in Excel with the CHOOSE function

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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP function.

How to Train Your Python: Part 10, Making Our Own Functions

Welcome back! In the last iteration of how to train your python, we covered error detection and handling. Today we'll be diverging from this and discussing functions. More specifically, we'll be creating our own functions. First we'll need to understand exactly what a function is, then we'll get on to making our own! So, let's get started!

How To: Use the TODAY and NOW functions in Microsoft Excel 2010

Learn how to make time-based calculations with the TODAY and NOW functions in MS Excel 2010. 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, including step-by-step instructions, take a look.

How To: Use the DATEDIF function in Microsoft Excel 2007

Looking for a primer on how to use the DATEDIF function in MS Excel 2007? You're in luck. 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 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.