Monday, December 19, 2016

Want To Become 'Excel'lent - Learn These Simple Excel Tips

Posted by Sharath Chandra
In a day to day life of programmers/accountants/anyone knows computer - Excel is the common application for all of their account related or report related works. If you know these simple excel tricks you can become 'excel'lent - I mean these are very simple but not known by everyone so if you learn these you will be standing out of the box. Try out these tricks in your next encounter with Excel. 

excel-tricks






1. Enter same data in several cells at a time: 

  • Select all the cells where you want to enter the same data.
  • Type the data
  • Press CTRL+ENTER That's it!
enterdata

2. This is extension to the above trick - where if you have to enter the same data in the random cells - still you can do the same thing 

  • Select all the cells where you want to enter the same data (it may be random cells).
  • Type the data
  • Press CTRL+ENTER That's it!





3. Do you want to filter odd/even fields - then here is the simple formula

oddoreven


4. How to delete all similar data at a time - 
  • Select all your data
  • Press CTRL+F and search for "<<DATA WHICH YOU ARE TRYING TO DELETE>>"
  • Click on "Find all" button
  • Now, select the first result.
  • Scroll down, holding SHIFT key, select the last result. This will select all search results.
  • Close the Find box.
  • Press CTRL + - (minus symbol) (to delete cells)
  • Select "Entire Row"
  • Click Ok - That's it!
deletedata





5. Read this post to learn 25 Excel Tips 



Some of these tricks I have learnt from 'Chandoo' website. 


Please share because in knowledge 
Sharing is Gaining