Tax Functions Search Results

How To: Use hotkeys to navigate 3DS Max for beginners

For 3D artists new to 3DS Max, learning your way around this massive piece of software can take a long time. It need not do. This video will teach you how to use some of the many hotkeys in the program to navigate it like a pro, easily accessing all of the most popular tools and allowing you to save a lot of time modeling. Now that you know what buttons to press to access functions, watch some of our other 3DS Max tutorials for more advanced functions.

How To: Create a distribution for categorical data in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...

How To: Evaluate functions by substituting in the variable to the input given

In this video, we learn how to evaluate functions. When evaluating functions, you substitute in the variable to the input given. Once you do this, you will rewrite the equation filing in the appropriate spots with the numbers that you are given. After this, you will evaluate the equation with the proper steps in math. Once you have figured out the problem, you can do this in reverse to make sure you have the correct answer. This is a very easy process and it doesn't take that long. Just make ...

How To: Solve basic linear function word problems in algebra

Need some help solving linear function word problems? See how it's done with this free video math lesson. Need help finding the 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 o...

How To: Tell whether a relationship is a function in math

Can't tell if a given relationship in a sequence is an actual mathetmatical function? See how to find out with this free video math lesson. Need help finding the 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 pedagogica...

How To: Break up hours worked by shift 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 624th installment in their series of digital spreadsheet magic tricks, you'll learn how to break apart the hours worked in a given day into one part for the day shift and a second part for the night shift using the MEDIAN function instead of the IF function. The MEDAIN function can be used when there are different ca...

How To: Graph the sine function in trigonometry

Learn how to use the unit circle definition of the sine function to make a graph of it. 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 ...

How To: Summarize survey data with a pivot table 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 and Mr. Excel, the 20th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to summarize survey data with a pivot table (grouping & report filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function.

How To: Calculate & compare interest rates 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 48th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the RATE, EFFECT, NOMINAL and NPER Excel functions to solve the following problems:

How To: Use rounding functions & paste special values in 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 28th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use Excel's rounding functions, how to paste special values – and quite a lot more besides. Specifically, this video addresses each of the following topics:

How To: Use TEXT & custom number formatting 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 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:

How To: Use functions and formulas in Microsoft Excel 2007

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 2nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to get started using functions and formulas in MS Excel. Specifically, you'll see the different elements of formulas (the equal sign, cell references, math operator...

How To: Use text functions (TRIM, PROPER, SUBSTITUTE) in 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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...

How To: Do multiple regression with MS Excel's LINEST function

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 13th installment in his series of Excel array formula series, you'll learn how to do multiple regression and linear algebra problems with Excel's LINEST array function. Also see how to use the SLOPE, INTERCEPT and the FORECAST functions for linear algebra and how to create a s...

How To: Use basic functions in Excel (AVERAGE, COUNT, MIN/MAX)

This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact sa...

How To: Find the average value of a function over an interval

When you have to find the average of two or five numbers then you have to add all the numbers and then divide then by two or five respectively. However in the case of the function you have infinite many values over any interval. But it is not possible to add all and then divide by infinity. Therefore you have to calculate in a different way. Imagine that you have to find the average of y=f(x). Then you have to average it from the interval from ‘a’ to ‘b’. The inner area under the curve shall ...

How To: Extract the three largest values from a list in 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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.

How To: Use an array formula to filter data in 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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...

How To: Use & add/delete words from AutoCorrect in Excel 2007

In this video we learn how to use the AutoCorrect function found in Microsoft Excel 2007. This video is the second part of the Microsoft Excel 2007 tips series. The video shows on screen and the host explains how to find the AutoCorrect function and gives an address to download the example spreadsheet from their TeachExcel website. AutoCorrect is a nice function but it is not personalized, and if you often misspell a word it can be handy to add it to AutoCorrect to catch it every time. Unlike...

How To: Insert special characters in MS Word 2007

A video from Helpvids.com that shows how to insert special characters in MS Word 2007. A seldom used function in MS Word is the Insert Symbol function. Symbols like the copyright, infinity, registered trademark, Yen, Pound, Euro etc can be of use in some documents. Word provides an easy way to insert these and many other such symbols into your documents without much hassle (For example, using the Character Map utility provided with Windows).

How To: Use the map function on the iPhone 3GS

This video will show you how to use the map function on your iPhone. Follow these steps to use the map function on your iPhone: From the Home screen, tap 'maps' to open the Map window. Use your finger to navigate and scroll around the map. Pinch your fingers apart and you will zoom in to the location, pinch your fingers together and you will zoom out. You can use your GPS to track where you are by tapping the Tracking icon. If you wish to search for a location, simply tap on the Search field ...

How To: Use the Photoshop CS4 patch tool

As each new version of the award winning Adobe Photoshop is released certain functions remain the same from prior versions while other functions are changed. In the latest version of Photoshop, Adobe Photoshop CS4, the patch tool works significantly differently than prior versions. In this video we are shown how the patch tool originally worked in Adobe Photoshop CS2 compared to how it now functions in Photoshop CS4. Finally the author gives us step by step instructions on how to operate the ...

How To: Use the copy and paste functions on a Mac or PC

In this video 2 people show you copy and paste functions on a Mac and a PC. On the PC, the girl copies a paragraph of text on a web page by highlighting it, right clicking, and selecting copy. Then she opens up a TextEdit program and pastes it into there and saves it. On a Mac, just like the PC, he highlights the paragraph, but this time he drags the highlighted portion right to the desktop. This will automatically create a file right on your desktop. If you open it up, it will open up in a t...

How To: Find the arc length of a function

In this tutorial, we learn how to find the arc length of a function. All you're doing when finding arc length is finding the curve between 'a' and 'b'. Imagine this as a string you're pulling straight to see how long it is going to be. The formula says if your function is in 'y=x' you have to take one times the derivative squared. This is a basic formula that you will use to find the arc length. When you plug in your values to this equation, you will find the answer. Practice with the example...

How To: Graph a parabola

In this tutorial, we learn how to graph a parabola. Quadratic functions are parabolas. To graph these, you will first need to look at the function, which is the set of outputs for a set of inputs. Write this out on a t-chart to find what your 'x' and 'y' values are. Once you find these, you will plug in the coordinates to a graph. After you have written down the coordinates, you can graph your parabola. This is easy to do if you are familiar with quadratic functions and good at math. Just pra...

How To: Evaluate functions

In this tutorial, we learn how to evaluate functions. A function is an equation with an input and an output. For the value of "X" there is going to be a value for the rest of the values that are in the equation. To start, write out the equation, then substitute the "x" with the appropriate number. After this, substitute the "x" in the rest of the equation where it belongs. Once finished, work out the rest of the equation in the appropriate order. Now you will be able to finish it and get the ...

How To: Use the loop function on a CDJ turntable

Interested in jockeying discs? Compact discs? If so, you'll want a CDJ, which will permit you to do with your CDs what your turntable permits you to do with your records. In this DJ tutorial, you'll learn how to use the loop function on a Pioneer CDJ turntable. For more, and to get started creating loops on your own Pioneer CDJ-800, take a look!

How To: Cleanse toxins from your body

In order to cleanse your body of toxins, you first need to determine the types of toxins you've been exposed to. This can be done with blood screening or urinalysis or liver function tests. If the liver isn't functioning properly, then there will need to be some steps taken or the benefits of cleansing won't last very long.

How To: Use startDrag and stopDrag functions in ActionScript 2

Add interactivity to your Flash files with this basic tutorial on start/stopDrag functions in ActionScript 2.0. This function allows the user to manually move objects with their mouse clicks. Whether you're new to Adobe's popular Flash-development platform or a seasoned web developer looking to better acquaint yourself with Flash CS3, you're sure to benefit from this free software tutorial. For more information, and to get started using startDrag and stopDrag in your own projects, watch this ...

How To: Count Mondays between 2 dates in 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.

How To: Find mean, median, & mode (averages)

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 34th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can repr...