Using Excel short cuts help work much faster and improve efficiency. Here is a list of 100+ keyboard shortcuts for commonly used functions. Practicing these short cuts would help you to memorize them, thus improving the productivity drastically while working on complex data analysis or financial models.
Shortcuts using Control and alphabet keys
The Power of Alt Key
When we press the Alt Key, we see the shortcuts for the Tabs in the Menu Bar.
Here are a few useful examples of shortcuts using the Alt key.
Shortcuts using Alt Key
Function Key shortcuts
Other useful shortcuts
Paste Special Shortcut
Normally we use Control & C to copy and Control and V to Paste the data. Paste special is a very important feature in excel. With the help of this feature, we can paste values, formats, formulas, transpose data or do simple calculations (addition, subtraction, division, multiplication etc.) in a large data set quickly.
Go from beginner to an Expert in Data analytics Skills in Excel. Explore our Data Analyst Skills Training in Excel (DAST) training program.
Keep Learning and have fun.