https://youtube.com/watch?v=hrbaL0EGwN0The Excel Expert summarized most common functions in 10. You will be able to solve any problem in excel , if you understand these formula. working file can be downloaded…