Salient Functions Search Results

How To: Solve operations on rational functions (f o g)(x)

YAYMATH In order to use rational functions in intermediate algebra, Robert Ahdoot begins by setting values to the functions f(x) and g(x). He then adds these functions together, with the equation (f+g)(x). After addition comes subtraction, using the equation (f-g)(x). And finally multiplication, which is (ftimesg)(x). This is a little more complicated, requiring distribution of a binomial across a polynomial, but it's clearly demonstrated and explained. This video explains what to do with add...

How To: Create a table for the VLOOKUP function in Excel

In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Excel Table feature and Table Formula Nomenclature for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup tabl...

How To: Find the x & y intercepts of rational functions

In this tutorial the instructor shows how to find the x and y intercepts of rational functions. Finding the intercepts of a rational function is similar to finding the intercepts of other normal equations. You can find the x intercept of the equation by setting the value of y to zero and solving the equation. Similarly you can solve the y intercept by setting the value of x to zero and solving the equation. Now while solving this rational function for intercepts if you face a situation where ...

How To: Find the equation of a tangent line

This is the video about how to find the equation of a tangent line. As you may recall, a line which is tangent to a curve at a point a, must have the same slope as the curve. Therefore, the slope of the tangent is m = lim f(a + h) - f(a) h-->0 h Since the slope equation of the tangent line is exactly the same as the derivative definition, an easier way to find the tangent line is to differentiate using the rules on the function f. For example, Find the slope of a line tangent to the function ...

How To: Use YEARFRAC, INT, and DATEDIF in Excel

In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...

How To: Use the QUOTIENT and MOD functions in Microsoft Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about the QUOTIENT and MOD functions. Note that, in urder to use these functions, you'll need to install the analysis ToolPak. For more information, watch this Excel how-to.

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.

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

Need an introduction to Excel's useful TODAY & NOW time functions? You're in luck as this clip provides just that. 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.

How To: Use names in formulas and functions in Microsoft Excel

Looking for a primer on how to create and work with names 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 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.

How To: Use the ADDRESS function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 98th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the ADDRESS function to make labels in templates easier for users to understand.

How To: Find the equation of trig functions by their graphs

Need to know how to determine the equations of trigonmetric functions by inspecting their graphs? Learn how. 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 f...

How To: Chart data & use Excel's SUMIFS & AVERAGEIF 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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and use simple charts in MS Excel as well as see how to use Excel's SUMIFS & AVERAGEIFS functions. Specifically, this video covers the following topics:

How To: Use the WORKDAY & WORKDAY.INTL functions in Excel 2010

This video tells us the method to use the WORKDAY & WORKDAY.INTL functions in Excel. These functions are used to find a workday after a finite number of workdays in the future. WORKDAY uses Saturday and Sunday as off days. Its syntax is WORKDAY(start date, days, [holidays]). 'days' refers to the number of days in the future and holidays is the list of holidays written below each other in the same column. If Saturday and Sundays are not your off days, use WORKDAY.INTL. Its syntax is WORKDAY.IN...

How To: Calculate days with Microsoft Excel's INT 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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use date and time functions together. Specifically, you'll see how to use the INT function to calculate total days worked and the TEXT function to calculate total hours worked.

How To: Use conditional IF formulas in Microsoft Office Excel

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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.

How To: Graph radical functions in college 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 study for that next big test). With this two-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to graph a rational function in college-level algebra.

How To: Find the inverse of a function in intermediate 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. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to solve problems involving function inverses.

How To: Convert integers to dates with Excel's DATE 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 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.

How To: Use Excel for daily interest and monthly deposits

Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...

How To: Graph linear functions by finding X & Y Intercept

This video shows the method to graph a linear function by finding the X and Y intercept. Only two points are needed to graph linear functions. So we find the point on Y axis or the Y intercept and the point on the X axis or the X intercept. We notice that on the Y axis the X coordinate is zero. So, we find the Y intercept by putting x=0 in the given equation and solving for y. In the same way, we find the X intercept by putting y=0 in the given equation and solve for x. We join the two points...

How To: Find the formula of a piecewise function given a graph

This video shows how to find the formula of a piecewise function when given a graph. The first step is to write a definition for the graph, which is done by identifying the different domains shown in the graph. The second step is writing formulas for each domain specified by the lines in the graph. The point-slope formula is used to identify the slope and y-intercept for the leftmost domain, which has a sloped line. A point and horizontal line make for simpler equations in the other pieces of...

How To: Draw the "y=A|x-h|+k" graph

In this video, one teacher talked in detail about how to solve absolute value functions and how to translate different absolute value functions from one point in the matrix to another one horizontally and vertically. If the function is y=A|x-h|+k, generally, the diagram is symmetric based on the line of X and can be moved vertically based on k. The teacher gave several examples to explain how to illustrate the absolute value function. He started with a simple one: y=|x-h|, then continued with...

How To: Find the horizontal asymptotes of rational functions

Finding horizontal asymptotes is very easy! Not all rational functions have horizontal asymptotes. the function must satisfy one of two conditions dependent upon the degree (highest exponent) of the numerator and denominator. If the degree of the numerator is equal to the degree of the denominator, then the horizontal asymptote is y= the ratio of the leading coefficients. If the degree of the denominator is greater than the degree of the numerator then y= 0. If the degree of the denominator i...