NavigationPopular content |
Excel Considered Harmful (by me)I've been meaning to post this for a while: Excel is a horrible way to store and transmit data. Let me explain further what I mean: when working with data, it's important that those data are not modified unless you want to modify them. Excel likes to tamper with whatever you insert into its cells unless they're text type, so something that may appear to Excel to be a date is irrevocably lost when Excel decides to corrupt it. Just another example of Microsoft-induced lossage (another rant altogether). Excel is not a database. It doesn't preserve your data as you intended them to be. And while I'm at it, creating multiple tabs is not a substitute for some kind of indicator. Whenever I encounter data that is generally a mess and disorganized it has been sent to me as an Excel file. Excel is good at what it is, but it isn't, as I say, a database or a reliable means to transmit data to another party. |
SearchRecommended ReadingUser login |
Post new comment