Thanks for reading CFI’s guide to Excel shortcuts for your PC and Mac keyboard! By taking the time to learn and master these keys, you’ll significantly speed up your financial analysis. If you want to learn these keyboard shortcuts with your own personal online instructor, check out CFI’s Free Excel Crash Course! You’ll receive step by step instructions and demonstrations on how to avoid the mouse and only use your keyboard. Excel is quite robust, meaning there are a lot of different tools that can be utilized within it, and therefore there are many skills one can practice and hone. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T.

You may also want to check out our section on Excel formulas or the Excel formulas cheat sheet. If you follow our tips and tricks below you’ll be able to master these shortcuts on Windows or Mac operating systems. If you want to change the top row of keys to work as standard function keys without holding the Fn key, follow these steps: Choose Apple menu > System Preferences.

Your mouse will be taken away and you’ll be expected to learn financial modeling with only keyboard shortcuts. The first thing you’ll do if you’re hired as an investment banking analyst is take a series of intense Excel training courses. If you want to use the Mac keyboard you will experience that the alt key is very different, as we explain in this blog post. With Parallels Desktop virtual machine for Mac you have the choice to use the same keyboard shortcuts you had on your PC. These are critical for careers in investment banking, equity research, FP&A, finance, accounting, and more. Press and hold the Fn (Function) key on your keyboard to see F1 through F12 in the Touch Bar. The Mac keyboard doesn’t have the Alt + F4 shortcut. To be more productive, faster, and more efficient when building financial models or performing financial analysis, it’s important to know the main keyboard shortcuts in Excel. F5 ist ein funktionsreicher Reddit-Browser mit einer eleganten Oberfläche.

Alt f5 on mac