Just like previous releases, Excel 2016 has received many new features that make the usability of the software easier and more accessible and also provide you with new and useful capabilities to speed up your workflow and increase your productivity. It also means that Excel is slowly becoming more user-friendly, meaning that you do not have to be any sort of IT-professional to be able to use Excel to its fullest potential. No matter if you need Excel to track business budgets in a professional environment or if you simply just want to have a list of people attending an event with their information in one place, Excel is able to supply you with the tools needed to make your experience smooth and your work efficient.
Tell me what you want to do?
This is one of the new features included in Excel 2016, and numerous other Office products as well. The "Tell me" bar could very well be the first thing that catches your eye when you open up Excel 2016 to look for new features, as it is located on the top part of the application in the menu ribbon. It is a very user-friendly feature, especially if you're not familiar with the ribbon interface or haven't had a chance to learn Excel's toolset yet. It's basically a search function that is capable of listing tools, commands and other functions within Excel by understanding the words you enter into it. While it doesn't exactly tell you where a button you're looking for is located, you can perform the button's action right from the "Tell me" box. It also offers related buttons and even online help.
Charting is one of the most known tasks you can accomplish when using Excel. It is extremely important to present your charts well and display relevant information about your data, which is why Excel’s chart options constantly get bigger and better. In Excel 2016, there have been some new charts added to the roster, allowing you to add better visual impact. Each one of these charts can be useful depending on what kind of data you’re working with; not everything works for all kinds of data, and that is why it’s important to have options. There are six new charts in total, including:
• Sunburst charts
• Waterfall charts
• 3D data map
This is a tool that can definitely make your life easier when you need to quickly analyse some data, or in case you don’t know how to type up formulas from the top of your head. All you have to do is select the data cells you want to work with, and the Quick Analysis button will appear. When you click on it, you will be presented with a series of options, which allow you to either format the data, create charts or tables, calculate totals, and even add sparklines based on the selected data. With a few simple clicks, you can easily get things done even as a beginner.
Flash Fill is a handy tool that is capable of detecting and understanding established patterns and fill out data based off of them. For example, if you have a list of names that you want to separate into two different columns with first names and last names respectively, you can use Flash Fill to spare you from having to type everything down yourself. It can also work with many different types of data, such as phone numbers or dates.