Knowledge Pack: Google Docs vs. Microsoft Office 365

Here is a series of articles about this commonly performed comparison.
It offers an unconventional yet practical perspective.

  1. Google Docs vs. MS Office: Want vs. Need – the concept with few examples
  2. We are doing a feature comparison. So we should know the quantification as well.
    How many features does Microsoft Office have?
  3. Google Docs vs. MS Office: “I don’t need all these features”
    This post discusses the commonest response to feature explosion in Microsoft Office

more articles coming soon …

How many features does Microsoft Office have?

I often mention during my sessions and posts that we have 12000+ Office features. Some of you may be wondering as to where I got that number from. Here is the list. It covers only Word, Excel, PowerPoint, Outlook and OneNote. It does not cover other Office 365 products. Source: Office Menu reference workbooks. I have actually counted the other features, like galleries and Options one-by-one, manually!
How many do you use? Post comments and let me know.

image

Related posts:
Google Docs vs. MS Office: Want vs. Need
I only use 5% features in Office. Why should I pay for the remaining 95%? Part 1 & Part 2
Office 365 Worst Practices – Part 2 – Phased Release: Underutilization by Design!

How to succeed in office politics using Office

Here is the recording of my session in Pune DevCon – a gathering of developers in Pune, India. Please pardon me for using Hindi language intermittently. I needed to use local language for maximum impact.

Thanks to Mahesh Mitkari, Mayur Tendulkar, Vikram Pendse and team for arranging a great event. Enjoy!

This is a live recording. Please pardon the background noise and poor video quality.

What did I learn today: Remove all hyperlinks

imageExcel provides a direct feature. Select multiple sheets and select the desired range. Home – Clear – Clear Hyperlinks.
The default blue color and underline is NOT removed. Therefore, you may feel that nothing has happened. You have to remove formatting separately. There is no way to select only those cells which contain hyperlinks. DO NOT choose clear formatting because it will remove formatting for ALL selected cells. There is no way to quickly select cells containing hyperlinks. Be careful.

Word has no such menu option but does have a shortcut. Select entire document and choose CTRL SHIFT F9. That removes all hyperlinks. It removes formatting as well. Simple and effective.
PowerPoint has no such menu option nor shortcut. Simple macro code is available here.
OneNote requires third-party add-in to do this. One such tool is OneNote Gem.
MS Project also has Clear Hyperlinks command like Excel.
In Visio, just clearing the formatting removes the hyperlink. However, there is no way to select all items having hyperlinks in one step. This has to be done manually.
MS Publisher has no built-in command.

IT as an Enabler (really!) – use Office Group Policy

This article is for IT professionals only. The language is technical. As a user it is not relevant to you.

IT presentations say “IT is an enabler”. But ask any user – they will tell you that the primary job of IT seems to be “disabling” things. From Start Menu, IE settings, USB Ports, Web sites, network settings, ability to install new software, everything seems to be deactivated by IT. It is frustrating. But everyone knows that it is required for security, compliance and privacy reasons.

As an IT professional, here is your chance of ENABLING things which users will really thank you for. This opportunity comes from a seemingly unlikely place – Microsoft Office. Read on to find out how you transform your users lives using Office Group Policy.

image

Photo credit: Stuck in Customs / Foter / CC BY-NC-SA

Continue reading