Category Archives: Tips

Become an Excel Wizard With These 5 Tips

All upgrades past the Excel 2010 versions are packed with interesting surprises. Excel is indispensable when it comes to handling and organizing large data. Regardless of a user’s familiarity with Excel, there remains tricks and hacks that are still unknown to many. Microsoft Excel training offers basic guidelines in order to perform basic excel functions. Here are 5 tips that will transform a user from a spreadsheet organizer to an Excel Jedi.

#1 Select the entire sheet with just a click: Ever wondered what this button —   does? Click on it to select the entire sheet.

#2 The function of Data validation: A handy tool while creating a survey form is the data validation function. This enforces a restriction on the value entered. Consider a form that needs to be filled out only by those who are in the age bracket of 25-35. To achieve this, Data → Data validation → setting → add restriction→ move to input message to label the restriction→ OK. When the cursor is on the defined cell, the input message is displayed to notify the user of the condition. If the entered value doesn’t conform to the restriction, an error message appears.

#3 Customize the shortcut menu: Stock Excel comes with three shortcuts – Undo Typing, Save and Repeat typing. When more shortcuts are needed like copy, paste, etc., addition of new shortcuts is done by clicking on this drop down button  . Check the shortcut you wish to add. Click on More commands to explore more options.

#4 Instantly add new columns or row: Instead of taking the long route and repeating the procedure n times to add n rows, select the number of rows or columns that need to be added. Right click→ Insert→ entire row /column (depending on the user’s need). New rows or columns similar in number, as per selection are added.

#5 Transpose Row to Column and vice versa: You do not have to retype the data to shift from row to column. There is a special function Transpose as an option in Paste. This option works off the data copied prior to choosing the transpose option.

Other useful excel hacks include toggling between multiple sheets by pressing Cntrl + Tab, shifting rows or columns from one location to another by selecting the row and hovering the curser around the edges till this icon appears  , then moving unrestricted in the spreadsheet and repeat the same while holding Cntrl to copy the selected values.