5 Professional Excel Time saving Tips

Working on a tight timeline with no time to lose? Save yourself a great deal of pressure by learning and incorporating these helpful productive excel time saving tips into your everyday routine and buy yourself precious time. Here’s 5 of what you should know and what you should be doing:

1. Autofill

Autofill is an ideal tool to use if you have a large amount of repetitive data to key in. You can do so by entering values in a cell, then hovering over the bottom right corner of your cell so that the icon of your mouse turns into a black cross. Then simply drag to copy the contents over the cell range you need them to be. Upon releasing, you will then be able to see an autofill options icon, clicking on it will enable more options.

2. Case functions

Sift through and fix case typing problems quickly without overlooking them by making use of the case functions. UPPER()function helps convert all text to uppercase text whereas LOWER()function helps convert everything to lower. If you want a mixture of both, then PROPER() works as well. You can locate the proper function under the Formulas tab. Select Function library and choose text.

3. Adding Comments

By default, Excel formulas are usually straightforward and easily understood. However, as time goes, you may find yourself having to go for more complicated formulas in your excel worksheets. Getting back to your projects or working together with others can potentially cause confusion when deciphering and understanding data. That’s where the N() function comes into place, since it helps add colibraryo you can use it to explain the details. Simply choose +N(“your comment here”) and you will be done.

4. Adding Notes

Keep track of what formulas you have applied and what for in the form of easy reference. The FORMULATEXT() function comes in place here. By using this, you can create a reference mode so that a text version of your formula print in certain cells are automatically shown when you click on it. Simply choose the cell and apply this function through the Formulas section. Choose function librabry and locate look up and reference. Inside the reference field that is made available, choose the relevant cell.

5. Rearrange columns/rows

When it comes to rearranging massive amounts of data, you can save yourself the hassle from having to do it row by row or worse, retyping everything. You can rearrange your columns or rows to your desired setting by choosing highlighting the data matrix and choosing copy. Next, move your mouse to a new location and locate your home tab. Choose clipboard and look for pastem then choose paste special. This should pull up a dialog box, choose the transpose option and select okay. This should make sure that all your data is shifted into the new location you chose, including the transposed columns and rows.

These are the 5 useful excel time saving tips that you can implement into your everyday excel projects to save yourself some time. With each minute precious to you, can you make use of any of these tips? Do you find everything more convenient and less frustrating?