Excel with ALT Excel Keyboard Shortcuts

In this competitive world, good knowledge of Excel can help you to grow faster. Our Program - MS Excel Training for Corporate Professionals is a must do program for all who work in Corporate World. This Excel Workshop includes all those functions and formulas that are much needed to use MS Excel efficiently and effectively. We have spread MS Excel Training program on two weekends that allow participants to do practice. Program is full of Illustrations, Case study and based on real business problems.

Here's some advanced excel formula's & functions:

Text Formula's (Left, Right, Trim, Len, Upper, Lower, Proper etc.).Lookup Formula's (Vlookup, Hlookup, Index, Transpose, Row, Column etc.).Logical Formula's (If, And, Or, etc.).Date & Time (Day, Month, Year, Date, Datevalue, EOMonth, Workday etc.).Math & Trig (Sumif, Sumifs, Sumproduct etc.).

(Do you really know what Vlookup can do?)

Vlookup can extract value from multiple tables on multiple sheets.Using Vlookup for two way lookup. (Vertically and Horizontally at same time).Vlookup can calculate Income Tax on any Income falling in any slab.Using Vlookup for AR Aging analysis.When to have Range lookup True in Vlookup and how it impacts?

[ALT] key can be used to access ALT Excel keyboard shortcuts on all visible tab on the ribbon and Quick Access Toolbar (QAT).

Being on Excel spreadsheet, press ALT key. It will display keyboard shortcuts for Quick Access Toolbar (QAT) and for all the tabs on the ribbon. For E.g., "H" is the shortcut to access Home Tab, N is the shortcut to access Insert Tab and so on. On press of ALT key, you can see all the shortcuts on Excel File.

Further, on press of "H" Key, one can access to all the shortcuts withing Home Tab. For E.g., 1, 2 & 3 is the shortcut for Bold, Italic and Underline format respectively. So, Alt + H + 1 is the keyboard short cut to apply bold format to any cell.

Similarly, K with in Home Tab is the shortcut to apply comma style format to any number. So, Alt + H + K is the shortcut to apply comma style to any number.

Please make a note that Alt key has to be pressed only once and not with all the keys.

Hope you will Alt Excel Keyboard Shortcuts useful.

Do you need Excel Training?

Consider participating in our training programs. Please visit "Upcoming Training" section on our website.

Our Program - MS Excel Training for Corporate Professionals is a must do program for all who work in Corporate World. Rate this Article

Excel with ALT Excel Keyboard ShortcutsNot Rated Yet

Jeetu Kumar has published 6 articles. Article submitted on August 13, 2013. Word count: 381

Maintenance of large buildings like painting, glass replacement and repair, installation and other works is always a difficult task. Because working at height requires sufficient skills for the workers.

Written by: Riaan Aggenbag

We all appreciate the importance that Microsoft has played in ensuring that tasks are simplified and carried out in a harmonious way that seeks to improve work flow.

Written by: Chandan Saha

A single. Educational integrity connected with online pupils: demands a completely new frame of mind for you to on line evaluation.

Written by: Megan Manning

Software professionals rely upon PMP Certification in order to realize their strategic goals in a successful manner. PMP Training standards too have improved according to the latest software features in a perfect way.

Written by: Jane Smith Rose