Jump to content


5 tips for data manipulation in Excel

  • Please log in to reply
No replies to this topic

#1 TheSentinel


    The man in the dark

  • General Admin
  • 31,818 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.