In the process of using Excel, there is no doubt about the power of functions and pivot tables. Although they are powerful, they are not omnipotent.