| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Created by John DiFini | ||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | Google Apps | Office 365 | |||||
6 | Functionality | Weight | Score | Notes | Score | Notes | Reference |
7 | Security | 4 | 4 | For Finance & Healthcare, the score is probably a 3 b/c you cannot restrict Google access by IP or managed devices without 3rd-party add-ons; Otherwise the score is a 4 The default for "Stay signed in" is checked; Shame on you Google! | 5 | Using Intune EMM in conjuction with Azure AD IdP, you have tight controls over access from specific IPs and managed devices | |
8 | 5 | 4 | Can't sort emais; "Literal search" doesn't really work Video calls & click-to-call all in 1 interface | 4 | Can't save save attachments to a specific drive folder; Can't easily switch commonly-used fonts; Using Ginger is problematic; Have to use a desktop app for video calls & click-to-call | ||
9 | Calendar | 4 | 4 | Reminders are a bit buggy | TBD | ||
10 | Collaboration | 4 | 5 | Spreadsheet funtionality makes collaboration easy; Ability to tag collaborators in Comments | 2 | Difficult to open a spreadsheet in online/collaboration mode; given the limited Excel Online functionality, hard to encourage usage | |
11 | Spreadsheets | 4 | 5 | Quite simply, wow! | 2 | In summary, it's nowhere near Google Sheets, but here are the details: Cannot search across tabs; No search options (e.g. Match Case), replace, etc.; No conditional formatting; cannot change borders; cannot truncate cells; no custom colors; cannot remove excess cells; cannot select a different tab for formula; does not highlight cells that comprise a formula; cannot paste large set of data; can't figure out how to go straight into edit mode; can't figure out how to move a row/column; cannot tag someone in comment; redo doesn't work; Can't duplicate sheet; No Cltr+A; Does not support Cmd+D on OS X; Can't use different font within same cell; The entire page often refreshes; Can't freeze panes; No spell check; Can only insert in one direction; Can't copy tables to other apps | |
12 | Drive | 4 | 4 | Can't search within specific folder | 2 | Can't view previous versions w/out restoring them; Can't download an entire folder | |
13 | Click-to-call | 3 | 4 | Phone icon only appears for contacts with whom you have had recent conversatoins Free domestic calls w/ no associated calling plan!; part of the Gmail interface | 1 | Not part of the Outlook Online interface (i.e. have to use desktop app); Have to have an associated calling plan | |
14 | Video Calls | 2 | 5 | Part of the Gmail interface | 2 | Not part of the Outlook Online interface (i.e. have to use desktop app) | |
15 | Drawings | 1 | 5 | Google Draw meets all basic functionality | 1 | No Visio Online available | |
16 | Storage | 1 | 3 | Entry-level plan allows 30GB of storage | 5 | 1TB of storage | http://www.cio.com/article/2902255/cloud-apps/google-for-work-vs-microsoft-office-365-a-comparison-of-cloud-tools.html |
17 | Licensing Simplicity | 1 | 5 | 2 simiple, flat pricing plans | 1 | 6 pricing plans with License vs. Software Assurance implications; need to factor in Core CAL discounts too | |
18 | Weighted Average | 4 | 2 |