Excel 2016 is now available for organizations that have upgraded from Office 2016 or Office 365. What’s next? Are there new features? Yes, especially if you have a business that requires new tools or ways to present data.
Excel 2016 features are now available! Here are seven things that I am most excited about:
1. The ‘Tell Me’ Box
Excel’s most notable new addition is the “tell me” button. It’s a shame it wasn’t available in 2007, when the menu ribbon was first lowered. Do you remember how difficult it was for us to find our favorite tools. The “tell me” field is basically a search function that lists functions and operations that match your search term. It’s a quick and easy way to get to the place you want. Smart look-up is also a great way to search the Internet for relevant articles that match your search terms.
Excel 2016 now provides “one-click” statistical prediction of data with a time element. As long as you have enough data, it will work. Excel’s forecasting function can also be very useful. It can detect seasonal trends and factor them into the forecast. It is quite smart! It’s quite smart! If you make any changes to the data, these changes will not automatically be reflected in your chart.
3. Search field “PivotTables”
PivotTables now have a search bar. This makes it easier for you to work with large data sets with many fields. You can search for the field you want and it will be displayed for you to select.
4. Date Grouping (PivotTables)
Excel PivotTables are used to register dates individually. Your charts would have hundreds to hundreds of fields along each date-axis. You can now group dates into years, quarters, and months. To expand the grouping, you can use + next to the date segment. It’s much simpler, I believe.
5. New Chart Types
Microsoft claims Excel hasn’t been updated with a new type of chart since 1997. What happens when you wait for a bus? You can then get a lot of them all at once. Excel 2016 introduces six new chart types, each with its own unique uses. Here are my top picks.
– Pareto, histograms
Histograms can display frequencies (e.g. It can show how much one product was sold against another. They are not based upon product categories but on the values assigned to different bins. You can change the chart to show different categories. Pareto charts go one step further and sort these frequencies. They also add a cumulative percentage line to show a trend through data.
These charts show the hierarchy of values. Sunburst charts are useful for analyzing sales figures in a company. They can be broken down by salespeople, customers, or products purchased. Based on how many sales they have made, the chart will show you the top salespeople as well as the size of their sections. Next, you’ll see which customers have purchased the salesperson. The final level shows the total number purchased by each customer. Sunburst charts allow you to drill down to your data at dozens upon levels.
– Waterfall charts
Waterfall charts are great for showing movement from an opening and closing position. These charts are great for plotting financial data, such as cash flow over time. They show your opening balance and your progress through trading stages. Then they stop at your closing balance.
3D Data Map