VLOOKUP function 

This performs a vertical lookup by searching for a value in the Range and returning the value in the same row .

Syntax

VLOOKUP( value, table_array, index_number, [not_exact_match] )

Example

=VLOOKUP(10248, A1:B6, 2, FALSE)
Result: #N/A

=VLOOKUP(10248, A1:B6, 2, TRUE)
Result: "Apples"

SUMPRODUCT

This function Multiplies All values in Array 

and Return the SUM as Result 

Syntax   

SUMPRODUCT( array1, [array2, ... array_n] )

=SUMPRODUCT(A1:B2, D1:E2)

This would also return the sum .

SUMIF

On the Base of Criteria "SUMIF" Adds all number in the given range 

Syntax  

SUMIF( range, criteria, sum-range)

Examples 

=SUMIF(A2:A6, D2, C2:C6)
Result: 218.6

=SUMIF(A:A, D2, C:C)
Result: 218.6

=SUMIF(A2:A6, 2003, C2:C6)
Result: 7.2

=SUMIF(A2:A6, ">=2001", C2:C6)
Result: 12.6

After Finishing the course "MS Office"  Most of  My Students often ask me that when you will teach us  Excel Advanced :)  

actually they thinks that there is a separate  Software or separate  version which is called (Advanced Excel) And i think you also have the same vision..?   

But  today I am gonna clear this confusion from your mind

          Advanced Excel Skills..?

So lets start.., I will try to define in few words

Basically some of excel formulas are called Advanced formulas 

which makes Excel Advanced..,  

you might be already have good commands on that formulas 

if  No.., your just need to learn following formulas and logic's

1. SUMIFS
2. SUMPRODUCT
3. VLOOKUP
4. INDEX + MATCH
5. Handling Formula Errors
6. Array Formulas
7. Circular References
8. Formula Auditing