Self Study Excel

Excel建模最佳实践

It is a good idea to follow best practices when modeling in Excel, as it will help you build your model quickly, accurately, and reliably. You might have heard some of them before. In this article, we will explore these best practices so that you can make sure to avoid common pitfalls when building your model!

Index Match Formula

Index and Match are two of the most popular functions used in Excel. However, they can be combined together to form a tool that is more powerful than VLOOKUP and HLOOKUP in Excel. You might wonder what is the need for the Index Match formula when the same results could be achieved with VLOOKUP or an HLOOKUP formula. This article will empower you to use the best tool known to Excel users.

Advanced Excel Formulas

根据多年的经验，我们编制了每位世界一流的财务分析师必须知道的十个最重要，最先进的Excel公式。这些功能不仅可以帮助您放弃工作时间，而且还可以使整个Excel工作表更加充实和连接。虽然听起来可能不多，但这些分钟最终可能会加起来保存数小时。

Group in Excel

Ever worked on a cluttered spreadsheet, spending the whole night figuring out why your calculations are off, only to realize that some of the rows had been hidden and not updated? Some of us have. In this article, we briefly talk about why hide should never be used, at least not in financial modeling, before going on to talk about the powerful Group function.