Wednesday, April 20, 2011

Some Useful Tricks For Excel Consultants

Excel consultants are a very important part of every business organization. They are the people who are responsible for making spreadsheets, by formatting the data from a large number of records available within the organization. As a consultant you can use some tricks that will save your time, as well as increase your efficiency. Here are some useful tricks that can be used while formatting, navigating, selecting while working with data.

1.    While formatting the text,  as an excel expert you can use Ctrl+ B for bold, Ctrl+ I for italics, Ctrl+ U for underlining a selection on the worksheet.  
2.    To change the style of the worksheet you can press [Alt] and, this will open a style dialog box from where you can select option as desired.
3.    Ctrl+1 will open format cell dialog box, which can be used as and when required depending on need, for different formatting style.
4.    For general formatting style you can press Ctrl+ shift key from the keyboard, whereas Ctrl+ shift+$ for currency. The other formatting keys in the keyboard are: Ctrl +shift+% for percentage, Ctrl +shift+# for date formatting, Ctrl +shift+@ for time format, Ctrl+ shift +^ for exponential number format.
5.    Moving from one worksheet  to the other and again back to the same one is also very easy if  Excel consultants use Ctrl+ page down key form the keyboard to navigate to the next worksheet whereas Ctrl +page up key to come back to the same sheet.
6.    Arrow keys in the keyboard can be used to move one cell up, down, left or right, whereas the Ctrl and an arrow key will help you move to the edge of the data region.
7.    The other important keys used while navigating are: home key to move to the beginning of a row whereas Ctrl+ home key to move to the beginning of a worksheet. You can use Ctrl + end key to move on to the position, which is the end of the last data entered.
8.    Active cells can be displayed using Ctrl+ backspace key. You can move down, and up within the selected range of your worksheet by pressing enter and enter + shift key.
9.    Knowing some selection technique will be an add-on benefit to excel experts, you can select a row by using shift and space bar key from the keyboard, whereas while selecting a column ctrl + spacebar saves a lot of time.
10.    While working with data you can open the workbook that is already being used by using ctrl +O, a new workbook can be created by using Ctrl +N key. It is very important to save the workbook after every entry so that your hard work is not wasted. To save the worksheet you need to use Ctrl +S key from the keyboard.

Apart from all the above tricks an excel consultant can use entre key to complete an entry and move on to the next cell. He or she can use Alt + enter key to insert line within a cell. Editing can also be done easily by pressing the F2 key and enabling the wizard.

No comments:

Post a Comment