Meet Excel 2016 |best 8 new features

A stunning feature and most graphically effective is 3D map in it. You can compare data such as temperatures, rainfall, populations of a given area over a specified time rendered in three-dimensional images.

1 3D power map in excel 2016- techlala.coom

  1. Hand written

This new feature converts your handwritten equations (or mathematical problems) to text, so you can insert them into your documents. You can use whatever tool works best for you it may mouse, a digital/ light pen or your fingers too.

2 hand written feature in office 2016- techlala.com

  1. Major database enhancements

The database enhancements alone:which include merging some of the previous Add-On programs such as Power Pivot and Power Query: more than justify the upgrade? You’ll find options for

  • Power Queries
  • Data Models
  • Reports
  • Pivot Tables
  • One-Click Forecasting

And some new one-button workbook sharing through Power BI for creating and using interactive reports and dashboards.

 

3 database enhancemet in office 2016 -techlala.com

  1. Quick analysis tools

Quick analysis tools are a real timesaver feature letting you in the right direction with your data. After you’ve completed your spreadsheet or table selects the entire range. Worksheet icon at the bottom right corner of the range: Click this icon and a popup menu appears that displays a number of options for what to do with this data.

4 quick analysis tool in office 2016 - techlala.com

  1. New charts

Excel has six new charts. It’s still an easy process to create them.

Just highlight the database table, select InsertRecommended Charts, and then choose one from the pictured samples.

5 charts in ms office 2016

Pareto sorts the bars by highest first and shows which bars have the biggest impact or highest return.

5.1 Petro charts in ms office 2016

Waterfall provides a visual method for viewing a series of positive and negative data. Because the bars seem to hover between the start and end columns, it looks sort of like a waterfall, hence the name.

  1. New templates

Excel’s new templates come with sample data and charts, plus hands-on exercises that teach you how to use each template.

6 new temolate in ms office 2016 - techlala.com

8 New template Cashflow:- click the Let’s Get Started button.

For example, in the My Cashflow template, “Let’s Get Started” button and Excel displays the My Cashflow charts. Click the buttons 2013, 2014, or 2015 to see the chart data change by year.

6.1 ms office 2016

09 New template CashFlow chart

If you click the Go button, you can add some new data to the Sample Data spreadsheet, then watch the charts change based on your new input. Once you get the hang of it, just replace Excel’s sample data with some real data of your own and Excel does the rest. Other new templates include Stock Analysis and My Calendar.

  1. Easier sharing

Real-time collaboration is finally here. Share ideas, data, queries, reports; and coauthor worksheets, charts, graphs, Pivot Tables, databases, and more.

Click the Share button in the top right corner. When the Share panel opens click the Save to Cloud button. The Backstage menu opens and displays the Save As screen. Choose the option that fits your situation: OneDrive, SharePoint, or another online location. Select the appropriate folder and click the Save button.

7 easy sharing in office 2016 - techlala.com

Once saved, the document reappears with the Share panel opened. In the Invite People field, click the open book icon and select colleagues from your address book in Outlook. Set permissions and notifications and then click the Share button to send the document links to your colleagues/ friends.

  1. Tell Me

Located on the right side of the Ribbon menu after the last tab, this feature provides a search box with a light bulb that says “Tell me what you want to do.” It’s like your personal valet: Ask it a question, command it to do something, or select one of the Recently Used queries, and it obeys.

8 ms office 2016 - tell me - techlala.com

Just click the Tell Me box and type your question. A list box drops down with your current request on top; followed by alternate choices (if there are any); followed by the most Recently Used queries; followed by an option to select and use the official Help menus; followed by the Smart Lookup feature, which adds the knowledge of the Internet to help you find the right answer.

8.1 ms office 2016

One Comment

  1. Armena January 2, 2017 Reply

Add a Comment

Your email address will not be published. Required fields are marked *