Microsoft Excel 2016

Microsoft Excel 2016 is a spreadsheet, which is a part of Microsoft Office 2016. The program allows for calculations in tables and automatic recalculations thanks to formulas and functions. It can also help to visualize the data in charts and graphs.

Download Microsoft Excel 2016

To download the latest version of Microsoft Excel, click on the Download button at the end of this review.

Microsoft Excel 2016 – New Features for the Whole Suite

Smart Lookup is a new feature that has been built in all the programs of Microsoft Office 2016. Thus it is also available in Excel 2016. If we right-click on a word or phrase in our sheet, we can choose Smart Lookup command. It opens a new pane on the right side of Excel windows. Inside it, text and images of Bing search for the term appear. We can thus read this information or even copy it to the sheet.

Another common new feature is Tell me what you want to do windows. Whenever we want to do something in Excel and we are not sure how to perform the task, we can type inside this box. The result will be a list of commands we can choose from, which are related to our need. It is then enough to choose one.

The new Share button upon clicking invokes a panel that allows us to save our document in the cloud. Then we can type in an email of our colleagues with whom we can share the document. There are two modes available: edit and view only. The editing process is being then done in real time.

Microsoft Excel 2016 – New Features of the Spreadsheet

An interesting new feature can be found in the Data menu. There’s a new section added Get & Transform. With the help of the buttons in this section, we can get data from different sources: from a file, another spreadsheet, XML etc.. In the case of a query from an Excel sheet, the program gives us a choice of which tab of the sheet we want to copy the data from. In the right pane, we can see the information about the source of the data. This pane can be quickly turned on and off by a click of Show Queries button. The Recent Sources button shows us another window where we can look up all the sources of data.

Another new guest in the Data menu is Forecast Sheet. It allows for interesting forecast based on time-related data that we have. For example, we can predict future sales trends. Microsoft Excel 2016 allows us to choose from a number of visualizations.

Ink Equation is another user-friendly feature. We can access it from Insert tab, from Equation drop -down. With a help of a mouse or another device, we can then draw our equation instead of painstakingly choosing the mathematical symbols from a set. The Excel is intelligent enough to recognize what we are drawing and will turn it into a mathematical formula.

Microsoft Excel 2016 has also a number of new charts. These are Treemap, Sunburst, Histogram, Pareto, Box and Whisker and Waterfall. It is also worth to mention the new ability to add 3D maps, which are built based on the geographical data we have in our sheet (for examples sales numbers for cities). As a result, we receive an interactive 3D map with data.

Last but not least now we can easily open two (or more) Excel documents in separate Windows. This makes working with two sheets at the same much easier. Before 2016 edition to achieve it, we had to run two instances of Excel.



Microsoft Excel 2016

Microsoft Excel 2016 is the world's most popular spreadsheet. With it, we can do advanced calculations in tables and we can illustrate the data with charts.

10 Total Score

User Rating: Be the first one!
Specifications
Publisher
Microsoft
Publisher Website
Operating System
Windows
Windows XP
Windows XP SP1
Windows XP SP2
Windows XP SP3
Windows Vista
Windows Vista SP1
Windows Vista SP2
Windows 7
Windows 7 SP1
Windows 8
Windows 8.1
Windows 10
Linux
macOS
Android
iOS
Windows Phone
PS2
PS3
PS4
PlayStation Portable
PlayStation Vita
Xbox
Xbox 360
Xbox One
GameCube
Wii
Wii U
Switch
Nintendo DS
Nintendo 3DS
Windows 95
Windows 98
Windows Me
Windows NT
Windows 2000
Windows 2000 SP4
Windows Server 2003
Windows Server 2008
Windows Server 2012
DOS 5.0
Windows Server 2016
License
full version
File Size
3 GB

We will be happy to hear your thoughts

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.