What is Advanced excel

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