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.
Default Theme is white
Change it to Dark Gray theme
You can also try the Colorful theme. It changes color based upon the product.
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.
Continue reading Quality Management 5: Pareto Chart
Well, the histogram articles don’t seem to be ending. I promise, this is the last one. With Excel 2016, a new chart type called Histogram was introduced. Now we don’t need either Data Analysis ToolPak or Pivot Table to create a histogram. Have a look.
Continue reading Quality Management 4: Histogram in Excel 2016
Office 2016 has introduced two new charts for hierarchical data: Treemap and Sunburst. Let us explore Sunburst in this article. These charts do NOT work as Pivot Charts. We will use the same data as last time.
Continue reading Excel 2016 Sunburst Chart: Hierarchical data visualization
This is the first thing you should do when you get Office 2016. There are three options available. Choose the one which suits you the best. Try each for few days if you are not sure. Here are the details…
Continue reading Office 2016 – Better look and feel options for menus (ribbon)
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
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!
Continue reading New, better alternative to Pie Charts: Treemap
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.