5 ms·

I'd be curious how you're using MSFT Office, but I've been bouncing between a Surface Pro for work and Mac Mini at home, and love the Office 365 suite. Virtual

I'd be curious how you're using MSFT Office, but I've been bouncing between a Surface Pro for work and Mac Mini at home, and love the Office 365 suite. Virtually 100% of my clients can open Word / Excel / Powerpoint documents, and you'll have to pry Excel from my cold, dead hands =). I personally love the power features of Excel, and even do some VBA scripting to automate some workflows in Excel and Outlook. I don't do much real-time collab on documents at the same time with other folks on my team, so I can't attest to that - though I hear that Msft has come a long way here and the Fluent roadmap looks really promising.

mikedilger 7y ago
I can't stand excel. It thinks it knows what I mean and actually edits my data destructively, mistakenly, especially when I enter dates in day/month/year format. If you just import a CSV and then export it directly, it mangles the data. I will not tolerate such behavior. If you have a column of phone numbers with leading zeroes, coming in from a csv, it decides it's a number and drops the leading zero, which breaks the phone number.
- davchana 7y ago
  I paste the data via Text Import Wizard, choose Text for the date columns, & then later split & join again as correct date format.
- bransonf 7y ago
  I figured out that you can technically specify type in Excel to prevent destroying the data, but by that point I’d much rather just load a data frame in R or Pandas.
- invisiblerobot 7y ago
  Maybe you just suck at Excel ;) https://youtu.be/0nbkaYsR94c https://youtu.be/0nbkaYsR94c
kerng 7y ago
This. Microsoft Office and O365 are magnitudes more useable and mature compared to GSuites. This wasn't clear to me until I'm now at a shop that only uses Google - its like a giant step back tech and usability wise. A year in now, and slowly getting some O365 shadow IT going to improve everyones life. Lol And everyone knows, Microsoft Office isn't perfect...

mikedilger 7y ago

I can't stand excel. It thinks it knows what I mean and actually edits my data destructively, mistakenly, especially when I enter dates in day/month/year format. If you just import a CSV and then export it directly, it mangles the data. I will not tolerate such behavior. If you have a column of phone numbers with leading zeroes, coming in from a csv, it decides it's a number and drops the leading zero, which breaks the phone number.

davchana 7y ago
I paste the data via Text Import Wizard, choose Text for the date columns, & then later split & join again as correct date format.
bransonf 7y ago
I figured out that you can technically specify type in Excel to prevent destroying the data, but by that point I’d much rather just load a data frame in R or Pandas.
invisiblerobot 7y ago
Maybe you just suck at Excel ;) https://youtu.be/0nbkaYsR94c https://youtu.be/0nbkaYsR94c

kerng 7y ago

This. Microsoft Office and O365 are magnitudes more useable and mature compared to GSuites. This wasn't clear to me until I'm now at a shop that only uses Google - its like a giant step back tech and usability wise. A year in now, and slowly getting some O365 shadow IT going to improve everyones life. Lol And everyone knows, Microsoft Office isn't perfect...