Category Archives: Office 2016

How to make Office UI look like Adobe UI

This is a special post for avide Adobe users. Adobe products have dark gray menus. It reduces the eye-strain. Office UI are white in color by default. And many people work on Office as well throughout the day… so how do you reduce the eye-strain? Simple.

Go to File – Options and choose Dark Gray theme. This theme was introduced in Office 2016. Office 2013 also has a gray theme but it is not as dark. See the difference for yourself.

Office UI Office Theme

Default Theme is white

image

Change it to Dark Gray theme

change Office UI to dark gray theme

You can also try the Colorful theme. It changes color based upon the product.

image    Office UI - colorful theme   image

Quality Management 5: Pareto Chart

Pareto chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.

Pareto chart Quality Management

Continue reading Quality Management 5: Pareto Chart

Outlook 2016: Insert Attachment shows OneDrive recent files

Office 2016 has enhanced the integration with cloud. Inserting attachments into a mail requires you to select the file to be inserted. Often this file is something you have been working on very recently (as in, few minutes back). But often we forget the path and struggle to locate the file. Now that problem is solved. Find out how…

Continue reading Outlook 2016: Insert Attachment shows OneDrive recent files

New, better alternative to Pie Charts: Treemap

We have been using Pie Charts for decades. Although these are useful for looking at proportions, there are disadvantages. Now, we have a more effective and easier to interpret chart available in Office 2016 – Treemap. What’s more, this chart is available for all devices – including mobile phones!

TreeMap - better than Pie Charts

Continue reading New, better alternative to Pie Charts: Treemap

Outlook 2016: Insert Attachments – Recent Files

As you know, the new version of Office is almost ready. I will be covering the new features in future articles. Here is the first one. Simple but extremely useful capability.

While inserting attachments, older versions just allowed you to choose the files. But now, you can see recent files in the same drop-down. That saves you lot of trouble because it is highly likely that you will insert a recently edited file.

Insert Attachments - Recent files shown in Office 2016