You can learn Excel shortcuts in the same way, searching for them when you need them. Some shortcuts can be found in Excel, and some can be answered on the Internet. As for the formulas in Excel that frustrate many people, it can be learned in the same way, of course. Microsoft provides official documentation, Excel functions (alphabetical) and Excel functions (by category) , which list all Excel formulas.