 |
|
 |
Home »
Microsoft Excel »
Functions and Formula
::
ReportRelated Tutorials
 |
|
|
 Microsoft Excel / Functions and Formula Learn how to use the basic statistical function in MS Excel. Easy tutorial videos, with many examples and demonstrations, |
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The next function we will discuss is IF. The IF function will check the logical condition of a statement and return one value if true and a different value if false. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used for the car purchase in the first example. There are a few things that we must know in order for this function to work. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Probably the most popular function in any spreadsheet is the SUM function. The Sum function takes all of the values in each of the specified cells and totals their values. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula There are many functions built into many spreadsheets. One of the first ones that we are going to discuss is the Average function. The average function finds the average of the specified data. (Simplifies adding all of the indicated cells together and dividing by the total number of cells.) Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula Discuss Max function(which stand for Maximum). This will return the largest (max) value in the selected range of cells. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The function we will discuss is Min (which stands for minimum). This will return the smallest (Min) value in the selected range of cells. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula In Excel there is a help tool for functions called the Function Wizard. Site: www.usd.edu
|
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula The function we will discuss is Count. This will return the number of entries (actually counts each cell that contains number data) in the selected range of cells. Site: www.usd.edu
|
||
|
|
|
|
|
 Microsoft Excel / Functions and Formula In this tutorial, we calculate the depreciation of an investment by using the SYD function, which returns the sum-of-years' digits depreciation of an asset for a specified period. Site: excel.brainbell.com
|
||
|
|
|
|
|
 Microsoft Excel / Functions and Formula Learn how to use the vlookup function, with easy examples and simple tutorial videos. |
||
|
|
|
|
|
|
Microsoft Excel / Functions and Formula A series or collection-based function is one that operates on a group of values. The values are stored in a collection called an array. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Excel / Getting Started Data validation makes it easy to specify rules your data must follow. Unfortunately, Excel insists that lists used in data validation must appear on the same worksheet as the data being validated. Fortunately, there are ways to evade this requirement. In this tutorial, we provide two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call. Site: www.brainbell.com
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|