The most important financial modeling Excel shortcuts are: Ctrl + R (fill right), Ctrl + 1 (format cells box), Alt = (auto sum), F4 (anchoring cells), F2 (edit formula), Ctrl + PageUp/Down (move between sheets), Ctrl + Home (go to beginning of sheet), Alt, E, S (paste special), Alt, D, G, G (group cells), Alt, A, W, T (data table), Alt, A, S, S (sort). To learn more, check out CFI’s free Excel Crash Course.
Below is a screenshot from one of CFI’s online analyst training and certification courses, offered 100% online.
To learn How to Build an Excel Model step-by-step, click on the image below.
CFI is the official global provider of financial modeling and valuation analyst FMVA Designation. CFI's mission is to help anyone become a world-class financial analyst and has a wide range of resources to help you along the way. In order to become a great financial analyst, below are some additional questions and answers for you to explore further: