Microsoft office contains great tools for working professional. MS Word, Excel, PowerPoint and Outlook increase one’s productivity immensely. Only pre-requisite is sound knowledge of above tools. Although, all the tools in MS office have good use, yet, Excel stands out for its wide applications. Excel can perform innumerable complicated tasks. Pivot Chart, filtering, report preparations are some common applications. Besides, Excel can act as a potent statistical tool. Several mathematical, analytical and logical operations can be easily completed with Excel. Normal distribution, Binomial distributions are some statistical operation available on Excel.
Keeping in mind its wide application, it is worthwhile to have knowledge of various Excel shortcuts. Below listed are some short cuts:
Turn on/off Auto Filter: Filtering is powerful tool to analyse large quantity of data. Data can be filtered by a particular value, values containing string, values greater or lower than another value. General approach to apply filter on column is going to data menu and selecting filter option. Repetition of same action turns the filter off. However the same result can be obtained by just pressing Ctrl + Shift + L on keyboard.
Edit a Cell: Mistakes occur frequently while using spreadsheet. It calls for editing of concerned cells. The content could be text, a formula or a number. Generally, editing operation is performed by dragging mouse pointer to a formula bar. Thereafter, pressing the click in desired location enables editing. The task could become tedious if performed continuously. The same operation is possible by simply clicking F2 in any cell. Besides, the shortcut also applies to cells containing formulas.
Navigate around the Workbook and Select a Group of Cells: A quick and easy way to navigate through a spreadsheet is using Ctrl+ Arrow keys shortcut. This moves edge of the current data region within a worksheet, depending on the arrow pressed. Example: If we have a table with data in range A1:D10, Pressing Ctrl + Right arrow would jump to cell D2. Besides, pressing Ctrl + Shift + Right arrow will select all the cells from A2 to D2.
Format Cells: One of the main actions in excel is formatting. Formatting cells in excel means changing the appearance of the content without changing the actual content. One can apply a number format or other formatting (alignment, font, border, colour, etc.). Generally, format cells dialogue box is used for formatting. However, using the shortcut Ctrl + 1 eases the task conveniently.
Open Visual Basic for Applications Editor: Sometime spreadsheets have macros. A macro is nothing but recording of a series of tasks. It is the simplest form of automation. Visual basic editor has to be opened to view any aspects of macro. Standard path is opening the developer menu and then going to visual basic. Instead, click Alt + F11 prevents all the hassle.
Add Hyperlink: Hyperlinks are reference to another document, location or action. User can reach destination by clicking on the link. They make the spreadsheet pretty, tidy and resourceful. Hyperlink is generally added by going to insert menu and selecting hyperlink. However, even faster way is pressing Ctrl + K.