Microsoft Office 2016 introduces Colorful which is the default theme and each app gets a different color. Word is dark blue, Excel is green, PowerPoint is orange, Outlook is light-blue, and OneNote is purple. That helps to alleviate the whitish monotony of the previous versions, the ability of using the Office 2016 promo code is an added advantage.
Labels on the Ribbon tabs are now in title case. These are two little changes and hardly one that will convince you to switch to the latest version. But it’s nice to make a pleasant beginning before we get to the heavy features.
Get More Done with Some “Tell Me” Assistance
For those who have felt lost among the endless options in Office, the Tell me what you want to do is Clippy’s smarter cousin. Notice the little bulb icon in the middle of the Ribbon. It is intelligence personified – you just have to tell it what you want to do. No digging for commands or shoveling through the Help file.
Type what you want to do in the Office program and the little genie not only shows you how to do it, like a help feature, but let’s you do it directly from here.
For instance: if you want to adjust line spacing, but don’t know how to do it, just type it in the little field. The line spacing options are displayed in an eye blink.
This feature is available across all programs in Office 2016 except OneNote. Maybe, they will include it in the next update but for now the feature makes Office mastery easier and tasks swifter. Even though, I can’t say it came back perfect when I tried it with the obscure commands in Office.
Collaborate and Co-Author in Real Time
If collaboration isn’t real time, it isn’t collaboration in the true sense. Collaboration wasn’t real time in Microsoft Office 2013 (via OneDrive) and it suffered when compared to Google Drive. The missing link — real time co-authoring — is now the core feature of Office 2016. Team workflow is more productive as you can now instantly see what your team members are doing in a Word document or a PowerPoint presentation.
Notice the Share tab on the extreme right of the Ribbon. You will be prompted to Save to Cloud. You can save it on a OneDrive shared folder or a SharePoint location. Invite others and give them access to either view the file or edit. Team members can also open the document in the free Office Online – they do not need the desktop Office suite.
The co-authors receive an email invite and as soon as they join, you can see their profile pictures in the Share panel alongside the document. With real-time typing, watch what others are working on and view their edits as they happen. Office locks the edits so that you can’t work on the same part. That’s a tiny feature, but it is sensible when multiple people are working on the same document.
Office also retains versions of previous edits in the History section of the File menu. The Microsoft Office Blog explains how to share with a click of a button.
Pro Tip: With Office 2016, you can share a OneNote notebook with anyone you want. Add documents, images, videos, worksheets, or emails and a notebook can be a single-click container for group projects.
Visualize Data Better with New Chart Types
Word, PowerPoint, and Excel get new chart types that help to visualize raw data with neat diagramsin easier ways. Data is moving towards richer storytelling and you will need all the tools you need. New chart types include Treemap, Waterfall, Pareto, Histogram, Box and Whisker, and Sunburst.
How useful are they? Very.
An instance: A Treemap chart can be used to display a high level view of your data. With the right color coding your eyes can spot the patterns and proportional differences between different sets of data. You can get a bird’s eye view of large data sets easily, without becoming mired in the confusing individual items. For example, compare the population densities of all U.S. states.
New Features in Microsoft Office Apps that Make a Difference
There are some specific features exclusive to the apps in the Microsoft suite. Here’s the short look.
Microsoft Excel 2016
Power Query Goes Native - Power Query is a business intelligence tool that is available as an add-in in Microsoft Excel 2013 and 2010. It also works with only PowerPivot in Excel Professional Plus. With the arrival of Query in Excel 2016, the two obstacles have been removed. Access Query from Ribbon > Data > Get & Transform > New Query.
With the time grouping enhancements in Pivot Table, Excel 2016 is now head and shoulders above any free Excel alternatives for business intelligence tasks. Gavin introduces you to a short tutorial on how to use Pivot Tables for data analysis.
Better Forecasting of Time Series Data
From linear forecasting available in earlier versions, Excel 2016 gets a one-click button for exponential forecasting of a data series. Go to Ribbon > Data > Forecast Sheet.
Exponential smoothening of your data could be better for approximating trends when compared to linear regression.
Cool Geospatial Visualizations with 3D Power Maps
The Power Map tool is now called 3D Maps and built into Excel 2016. Use it as an advanced business intelligence tool by visualizing any geospatial data that you have already brought into Excel with Power Query and combined with Power Pivot.
Microsoft PowerPoint 2016
Record Your Screen with PowerPoint - Seamlessly record any process on your screen with a new screencasting tool in PowerPoint. Go to Ribbon > Insert > Screen recording. Capture the part of your screen with audio and insert it directly into your presentation in a one-click process.
You can stylize it with the many video style presets. Crop the video to the size you want. PowerPoint also allows you to save the video file on your desktop for use outside the suite.
Share Better with Conflict Resolution
This is a neat feature which helps you avoid conflicts by observing the changes made by each collaborator – thanks to a side-by-side visual comparison. Choose the slide with the changes you would like to keep.
Microsoft Outlook 2016
Read Important Emails First - A smart email management feature learns your inbox behavior and removes low-priority messages to a special folder called Clutter. You can also sort them manually and review them later. Clutterneeds an Office 365 subscription to work with Office 2016.
Quicker File Attachment
Email workflow is accelerated when attaching files just works. Outlook 2016 makes it easier to attach recently opened files from the menu.
You can also set file permissions on the attached files. Share them as View only or allow edits so that recipients can work together on shared cloud files on OneDrive, OneDrive for Business, or SharePoint. By default, recipients have permissions to edit.
The Best Reason to Upgrade — Work Anywhere and Anytime
Microsoft has made smart and subtle changes to make use of Office 365 promo code . It is not a radical makeover from the previous version. For casual users, older versions will do the job as well as before because a standalone purchase of the desktop suite could be a wasteful spend, moreover, you could use the Office 2016 promo code.