Jump to content


Photo

5 tips for data manipulation in Excel


  • Please log in to reply
No replies to this topic

#1 TheSentinel

TheSentinel

    The man in the dark

  • General Admin
  • 31,812 posts

Posted 04 March 2014 - 07:03 PM

5 tips for data manipulation in Excel
There's plenty you can do, if you know the correct formulas.
By Sharon Machlis
March 4, 2014 06:30 AM ET

 

 

Computerworld - If you work with data much, you don't need a statistical model to predict that the odds of consistently getting data in the format you need for analysis are pretty low. Those who do a great deal of data cleaning and reformatting often turn to scripting languages like Python or specialty tools such as OpenRefine or R. But it turns out that there's a lot of data munging) you can do in a plain old Excel spreadsheet -- if you know how to craft the proper formulas.

 

http://www.computerw...lation_in_Excel