Real-time collaboration—As
with other Office 365 apps, you and your co-workers can securely work
simultaneously within an Excel file from any device (mobile, desktop, and web).
This allows you to know who else is working with you in a spreadsheet, see
where they’re working, and view changes automatically within seconds, reducing
the time it takes to collect feedback and eliminating the need to maintain
multiple versions of a file. Live, in-app presence indicators through Skype for
Business make it easy to connect with available co-workers in the moment.
Powerful data
modeling—Get & Transform is one of Excel’s most powerful
features, enabling you to search for data sources, make connections, and shape
your data to meet specific analysis needs. Excel can connect to data sitting in
the cloud, in a service, or stored locally. You can then combine different data
sets from these sources into a single Data Model for a unique, unified view.
Plus, you can create a Data Model to import millions of rows of data into
Excel—keeping your analysis in one place.
Insightful
visualizations—Excel is an inherently visual tool, giving you
new perspectives through a variety of charts and graphs. We continue to enhance
visualization in Excel—with geographical maps and waterfall charts—to provide
easier analysis and a better, more impactful way to share insights across your
company.
Dashboard creation
and sharing—Power BI is the cloud-based data visualization tool
that allows you to create and publish dashboards. We intentionally designed
Power BI and Excel to work together, so you can surface the most relevant
insights for the task at hand. Excel data can be imported into Power BI, while
Power BI reports can be analysed in Excel for new perspectives. You can then
easily share these dashboards and insights with others in your company.
Built-in
extensibility—Like other Office 365 applications, Excel can be
customized to meet the specific needs of your company. Excel’s rich ecosystem
of add-ins and other tools can help you work with data in more relevant ways.
Plus, the Excel platform is flexible enough for IT admins or Microsoft partners
to develop custom solutions.
-Office Blogs, Dec 2017