...

100 Essential Excel Keyboard Shortcuts to Boost Your Productivity

100 Essential Excel Keyboard Shortcuts to Boost Your Productivity

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

Capture3.JPG

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.

Share This Post:

Add a Comment

Your email address will not be published.

Enhance your LinkedIn profile to get access to more opportunities
Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.