GRAPHS Column: used to compare values across categories.
Line: used to display trends over time.
Pie: display the contribution of each value to a total (use it when values can be added together).
Scatter: compares pair of values (use it when values are not in X axis order, or when they represent separate measurements)
Simple Operations Multiplication The multiplication function works just as a normal multiplication and it does the same thing and it is very effective and fast to use. First to use the multiplication you have to put the equal sign first in the cell (you have to do that for every formula you use). Then you put the first number you want to multiply after the equal sign and then you put the multiplication sign and then the other number. Then you just have to click enter and it gives you the answer. You can use the multiplication function in a number of ways and it is very simple you just put the equal sign and the numbers you want to multiply. Constant Cell The constant cell function helps you use one cell and so that it is always constant Divison Same as in multiplication you have to put the equal sign before anything and then just put the formula you want to multiply Exponents You just use the numer you want then the exponent sign that is this one ^ and then put the number you want to raise it to
USE OF FUNCTIONS Sum
SUM function works to add a range of numbers, example from A2 toA7, from a data chart. It works when you have big numbers and you want to add them all. You just have to highlight all your values and click on the sum icon at the right part of the home bar. The sum icon looks like this: ∑. This function can be used in many situations, like adding all the money got from all the sales per month. SUM IF
Sum if works to get the Sum of certain type of values. This means that if you have a long list of values and you want to know the total for just one type, you can use this function. First you need to go to the sum icon, and click on the dropen arrow and click on More functions then on search you put SUMIF. There you will get a table, there you fill the range by highlighting all your values, then on criteria you select the cell number in which the type you want to know about. Finally on Sum range the numbers you want to add. Count if
The count if function works to count number of cells within a range that meets s certain conditions. This means that if you have a long list with repeated values, and you want to count how many times certain criteria appears, you can use this function. To use it you go to the sum icon, select the dropen arrow and select more functions, there you search for Count if and select it. Then you select the range and the criteria you want to add. IF
Works to see out of a list of values weather value reaches certain condition or not. For example if you want to see which students pass, you can make appear if a student passes by making understand the computer that greater than sixty id pass otherwise is fail.
Features Sort: Sort is a very useful tool in the Features of Excel. As the name says it, the tool Sort helps for sorting, or in other words organizing information that is long, hard and deals with many different number ranges.It could be very useful for business people that have statistics of number and percents and need to organize it quickly and efficiently. Once you know how to use it, you can organize any type of information by any criteria you want. Filter: Filter is a really efficient tool in the Features of the program Excel. Filtering can help you organize a long and wide ranging information and classify them into which ever criteria you want. If you have a table with long list of information that are classified with many and different types of criteria and you want to count only certain piece of information then you would filter that table for your own use and commodity.
-And: The And tool can help you classify any two ranges of information with any criteria you want.
-Or: The Or Tool can help you put in order one or two ranges of information with any criteria you want.
-Wildcards: The Wild cards can help you find information that you can’t remember and by outing only one key word can successfully search your item. Pivot Tables: The Pivot Table is another useful tool in the Features. It can help you do a table that is organized based on whatever criteria you want. They are composed by an efficient organization of table in which any row or column you can edit them for your commodity. In each row or column a criteria can be placed and automatically Excel would do the best calculation to form a really good table that shows values and information very properly classified.
Column: used to compare values across categories.
Line: used to display trends over time.
Pie: display the contribution of each value to a total (use it when values can be added together).
Scatter: compares pair of values (use it when values are not in X axis order, or when they represent separate measurements)
Simple Operations
Multiplication
The multiplication function works just as a normal multiplication and it does the same thing and it is very effective and fast to use. First to use the multiplication you have to put the equal sign first in the cell (you have to do that for every formula you use). Then you put the first number you want to multiply after the equal sign and then you put the multiplication sign and then the other number. Then you just have to click enter and it gives you the answer. You can use the multiplication function in a number of ways and it is very simple you just put the equal sign and the numbers you want to multiply.
Constant Cell
The constant cell function helps you use one cell and so that it is always constant
Divison
Same as in multiplication you have to put the equal sign before anything and then just put the formula you want to multiply
Exponents
You just use the numer you want then the exponent sign that is this one ^ and then put the number you want to raise it to
USE OF FUNCTIONS
Sum
SUM function works to add a range of numbers, example from A2 toA7, from a data chart. It works when you have big numbers and you want to add them all. You just have to highlight all your values and click on the sum icon at the right part of the home bar. The sum icon looks like this: ∑. This function can be used in many situations, like adding all the money got from all the sales per month.
SUM IF
Sum if works to get the Sum of certain type of values. This means that if you have a long list of values and you want to know the total for just one type, you can use this function. First you need to go to the sum icon, and click on the dropen arrow and click on More functions then on search you put SUMIF. There you will get a table, there you fill the range by highlighting all your values, then on criteria you select the cell number in which the type you want to know about. Finally on Sum range the numbers you want to add.
Count if
The count if function works to count number of cells within a range that meets s certain conditions. This means that if you have a long list with repeated values, and you want to count how many times certain criteria appears, you can use this function. To use it you go to the sum icon, select the dropen arrow and select more functions, there you search for Count if and select it. Then you select the range and the criteria you want to add.
IF
Works to see out of a list of values weather value reaches certain condition or not. For example if you want to see which students pass, you can make appear if a student passes by making understand the computer that greater than sixty id pass otherwise is fail.
Features
Sort:
Sort is a very useful tool in the Features of Excel. As the name says it, the tool Sort helps for sorting, or in other words organizing information that is long, hard and deals with many different number ranges.It could be very useful for business people that have statistics of number and percents and need to organize it quickly and efficiently. Once you know how to use it, you can organize any type of information by any criteria you want.
Filter:
Filter is a really efficient tool in the Features of the program Excel. Filtering can help you organize a long and wide ranging information and classify them into which ever criteria you want. If you have a table with long list of information that are classified with many and different types of criteria and you want to count only certain piece of information then you would filter that table for your own use and commodity.
-And: The And tool can help you classify any two ranges of information with any criteria you want.
-Or: The Or Tool can help you put in order one or two ranges of information with any criteria you want.
-Wildcards: The Wild cards can help you find information that you can’t remember and by outing only one key word can successfully search your item.
Pivot Tables:
The Pivot Table is another useful tool in the Features. It can help you do a table that is organized based on whatever criteria you want. They are composed by an efficient organization of table in which any row or column you can edit them for your commodity. In each row or column a criteria can be placed and automatically Excel would do the best calculation to form a really good table that shows values and information very properly classified.