|
Key topics |
|
1. Naming Cells and Ranges |
|
1) Creating a Name |
|
2) Making a name list |
|
3) Using the name for calculation |
|
2. Address Notation |
|
1) Relative address |
|
2) Absolute Address |
|
3. Database functions(Used to analyze data stored in lists or databases) |
|
1) DAVERAGE |
|
2) DCOUNT |
|
3) DCOUNTA |
|
4) DMAX |
|
5) DMIN |
|
6) DPRODUCT |
|
7) DSUM |
|
4. Date and Time Functions(Used to convert a serial number to different date and time format) |
|
1) TODAY |
|
2) YEAR,MONTH,DAY |
|
3) DATE |
|
4) TIME |
|
5) HOUT,MINUTE,SECOND |
|
5. Financial Functions(Used to calculate the Payment for a loan or investment) |
|
1) PMT |
|
2) IPMT |
|
3) PPMT |
|
4) PV |
|
5) FV |
|
6. Information Functions(Used to checks the type of value an d returns TRUE or FALSE depending on the outcome) |
|
1) COUNTBLANK |
|
2) ISBLANK |
|
3) ISERR |
|
4) ISERROR |
|
5) ISLOGICAL |
|
6) ISNONTEXT |
|
7) ISNUMBER |
|
8) ISTEXT |
|
7. Logical Functions(Used to perform a logical test or comparison for a value) |
|
1) AND |
|
2) IF |
|
3) OR |
|
4) TEUE |
|
5) FALSE |
|
8. Lookup Functions(Used to look for a value in a reference table and return the desired result from the table |
|
1) HLOOKUP |
|
2) VLOOKUP |
|
3) LOOKUP |
|
9. Math and Trigonometry Functions(Used to perform some Math’s calculations) |
|
1) ABS |
|
2) CONUTIF |
|
3) INT |
|
4) MOD |
|
5) PRODUCT |
|
6) RAND |
|
7) ROUND |
|
8) ROUNDUP |
|
9) ROUNDDOWN |
|
10) SUMIF |
|
11) SUMPROCUCT |
|
12) TRUNC |
|
10. Statistical Functions (Used to perform the statistical analysis) |
|
1) AVERAGEA |
|
2) COUNTA |
|
3) MAXA |
|
4) MINA |
|
11. Text Functions(Used to apply the text format to the data in Excel ) |
|
1) CONCATENATE |
|
2) DOLLAR |
|
3) EXACT |
|
4) LEFT |
|
5) RIGHT |
|
6) LEN |
|
7) SUBSTITUTE |
|
8) TEXT |
|
9) TRIM |
|
10) UPPER |
|
11) LOWER |
|
12) VALUE |
