Whats new in Excel 2016 and Excel 365

As of Excel learner and MIS professional you should regularly check for new and improved Excel updates and features. Excel 2016 and Excel 365 were released with some new charts and tools.  Here is the list of updates in Excel 2016 and Excel 365 –

Want to Join Excel Training Training on Latest Version i.e. 2016 and Excel 365..? 

Call us : 8802000175, 0124-4360863

Course Name:Excel, Advance Excel & VBA Macros
Course Duration: 60Hours (2-3 hours classes)
Timings: Weekends & Weekdays Classes
Batch Size: 4-5 Candidates

Address : Webs Jyoti 225, Old delhi road, Opp Raj Cinema, Near Bus Stand Gurgaon

Forecasting : Using Forecasting tool you will be able to forecast and guess your future data as well as showing levels of confidence at each end of the spectrum. Once you have made your forecast you will be able to display it on the charts i.e.  line and bar graphs.

Search field in PivotTable : When you have large amount of data and headers then it very time consuming to browse fields from the list. in Excel 2016 you can just search for the field you are looking for easily using search field.

New charts : Various charts were added in excel 2016 list is given below-

Sunburst charts

Waterfall charts

3D data map

Box and Whisker

Tree Map

Funnel Chart

Other New Features in Excel 2016

Excel 2016 Training Institutes in Gurgaon

Time Lines in Pivot Table : To deals with Date column excel 2016 provide time line to analysis data quicky

Auto complete a data range and list

Quick Analysis Tool

Smart Lookup and manage Store

 

Comments are closed.

Enjoy the tutorial? Please spread the word :)

Follow by Email
Facebook
Facebook
Google+2k
Google+
http://hirdeshbhardwaj.com/2017/12/11/whats-new-excel-2016-excel-365
YouTube60
YouTube