Thursday, January 19, 2017

What's New in Word, Excel, and PowerPoint for Android Phones and Android Tablets

What's New in Word, Excel, and PowerPoint for Android Phones and Android Tablets

Want to get a quick overview of the features that are available in Word, Excel, and PowerPoint for Android Phones and Android Tablets? Take a look at the tables below. Also, check out the Featured updates section to find out which capabilities have been added most recently.

January 2017 featured updates *

Take a look at the table below to find out about some of the features that are being added this month. For more information about how to get the newest features, including the ones mentioned below, check this page.

* Only available to Insiders

Capture Whiteboards

Word and PowerPoint

Use the functionality of Office Lens to capture, clean up, and crop pictures of a whiteboard, and add them to your documents and presentations.

Make Your Pictures Pop

Word, Excel, and PowerPoint

Add Shadow and Reflection effects to enhance pictures in your documents, workbooks, and presentations.

Share One Slide

PowerPoint

Don't send a whole presentation when all you want to share is one thing. PowerPoint lets you share a single slide with others.

Open More Files

Excel

You asked for it! You can now open files that contain form controls.

Featured updates

Below are a few of the great features and capabilities that are now available in Word, Excel, and PowerPoint on Android. Also check out the links to additional content to help you take advantage of these improvements and additions. Note that some of the features listed below require an Office 365 subscription while others are only available either on tablets or on phones.

Chart Elements ^

Word, Excel, and PowerPoint

Add or remove chart elements such as titles, data labels, or legends.

Learn more about adding chart elements.

^ Requires an Office 365 subscription

Shape Recognition

PowerPoint

Automatically transform your drawings into shapes.

Learn more about drawing and annotating with ink.

Smart Lookup

In Word and Excel

Fact-check or explore terms in your documents with Bing-powered Smart Lookup. Simply highlight terms in your document and double-tap to bring in search results from the web right into your reading or authoring environment.

Learn more about getting insights into what you're working on.

Save files automatically

In Word, Excel, and PowerPoint

Once you create a new Word document, Excel workbook, or PowerPoint presentation, it is automatically saved to the cloud location of your choice.

Learn more about saving Office files automatically.

Funnel Charts

In Excel

Funnel charts can be used to help you display values as progressively decreasing proportions and help you show values across multiple stages of a process.

Learn more about creating a funnel chart.

Insert Picture from Camera

In Word, Excel, and PowerPoint

Open your camera directly from Word, Excel or PowerPoint and take a picture. Voila! The picture is on your document, worksheet or presentation.

Learn more about inserting a picture from the camera.

Version History

In Word, Excel, and PowerPoint

You can now look back and compare different versions of a document, workbook, or presentation as well as restore a previous version of the file.

Learn more about comparing the version history of a file.

Designer ^#

In PowerPoint

Deliver customized and high-quality presentations and maximize the visual impact of its most important content. As you use it, Designer learns about your preferences and adapts its recommendations to be tailored to you.

Learn more about the PowerPoint Designer.

^ Requires an Office 365 subscription

# Only available on tablets

Morph Transition ^

In PowerPoint

Create seamless transitions between slides and bring motion to your presentations to more effectively convey concepts and information.

Learn more about using the Morph transition.

^ Requires an Office 365 subscription

Contextual Commands ##

In Word, Excel, and PowerPoint

Ever struggle to locate and access the commands you need? Now you have quick access to commands that relate to what you're working on.

## Only available on phones

New Functions

In Excel

Avoid nested IF functions with the new IFS, MAXIFS, MINIFS, and SWITCH functions, and speed up formula entry with the CONCAT and TEXTJOIN functions.

Insert and Edit SmartArt ^#

In Excel, and PowerPoint

SmartArt graphics enable you to visual represent information. You can now choose, insert, and customize SmartArt graphics to enhance your content and more effectively communicate your ideas.

^ Requires an Office 365 subscription

# Only available on tablets

Working with Tables

In Word

Take advantage of your devices's touch capabilities to insert and resize rows and columns in tables with ease.

Easy Column Formatting

In PowerPoint

As you work on your slides, you may decide that information would be best presented in a column format. Now you can quickly split a block of text into easy-to-read columns.

Fresh New Look

PowerPoint

Enjoy a better experience when reading presentations on your phone. Also drag and drop to reorder slides and double-tap to edit.

Tell Me

In Word, Excel, and PowerPoint

Simply type what you want to do in the app using your own words, and then Tell Me will guide through the process as well as offer additional resources.

Learn more about doing things quickly with Tell Me.

Send files as attachments in Outlook *

In Word, Excel, and PowerPoint

Done editing a file and ready to send it with Outlook? Just use the "Send with Outlook" option to easily share Word, Excel, or PowerPoint shared files as attachments to the email conversation.

* Only available to Insiders

Export to ODF Support

Word, Excel, and PowerPoint

You can now export documents, spreadsheets, and presentations to the OpenDocument Spreadsheet (.ods), OpenDocument Text (.odt), and OpenDocument Presentations (.odp) formats.

Learn more about supported file formats.

Insert SVG Images

Word, Excel, and PowerPoint

Insert and edit scalable vector graphic (SVG) images in your document, workbook, and presentation to create sharp, well-designed content. No expert software required.

Learn more about inserting SVG images.

Ink Annotations

Word, Excel, and PowerPoint

Use your finger or pen to write and draw, and use the tools on the new Draw tab to highlight content of particular interest.

Learn more about drawing and annotating with ink.

IRM-Protected File Support ^

Word, Excel, and PowerPoint

You can now read documents, spreadsheets, and presentations that are protected with information rights management (IRM).

^ Requires an Office 365 subscription

Quick Access to Files

Word, Excel, and PowerPoint

You can now add your favorite files to the home screen to keep them handy.

Learn more about pinning frequently used files.

Format Background

PowerPoint

Add some visual interest to your slides by adding a background color of your choice.

Learn more about formatting the background of your slides.

Tables Built for Touch

Word

No more cut and paste! Drag tables to move them, and let text wrap around.

Open More Files

Excel

You asked for it! You can now open files that contain Excel 4 macro sheets, custom properties, custom toolbars, and shared workbooks to name a few.

Discover More Office Apps

Word, Excel, and PowerPoint

You can now discover and quickly install Office apps for your device.

Learn more about discovering more Office apps for Android.

Collaboration: Front and Center

Word, Excel, and PowerPoint

Quickly share your document, spreadsheet, or presentation, and see who's working on it.

Learn more about sharing and collaborating on files.

Shared With Me

Word, Excel, and PowerPoint

Find and open files others have recently shared with you.

Learn more about seeing files others have shared with you.

Sharing Notifications

Word, Excel, and PowerPoint

No need to keep checking your shared documents, workbooks, and presentations. We'll send you a notification when there's activity.

Learn more about document collaboration and co-authoring.

Box, Egnyte, and 腾讯微云 work with Office

Word, Excel, and PowerPoint

Enjoy even more flexibility for storing and accessing your Office files with Box, Egnyte, and 腾讯微云.

Learn more about 3rd party cloud storage services supported by Office apps.

Turn Data Into Maps ^

Excel

Use the new Maps chart type to transform geographic data into professional visualizations with just a few steps, and identify insights, trends, and opportunities.

Learn more about creating a Map Chart.

^ Requires an Office 365 subscription

Accessibility Built Right In

Word, Excel, and PowerPoint

Improved support for using TalkBack, your keyboard, and other assistive technology to read and edit documents, presentations, and workbooks.

Land on the Page You Want

Word

Looking for a specific page in a document? You can now see thumbnail previews while you scroll and quickly pick the right page.

NOTE: These capabilities are also reflected in the tables below.

Top of page

Excel-only features

● Feature is supported
◌ Feature is not supported

Feature action

Excel

Viewing conditional formatting

Viewing data validation

Viewing PivotTables

Refreshing PivotTables

Sorting and filtering PivotTables

Filling cells with drag handle

Formula Autocomplete for partial search strings

Creating and editing funnel charts

Converting table to range

Grouping and outlining in worksheet

New functions: CONCAT, TEXTJOIN, SWITCH, IFS, MINIFS, and MAXIFS

Opening CSV files

Copying an entire worksheet

Inserting and editing hyperlinks

Top of page

PowerPoint-only features

● Feature is supported
◌ Feature is not supported

Feature action

PowerPoint

Playing YouTube videos

Playing other video types

Adding video

Removing video

Embedding YouTube videos

Morph transition *

PowerPoint Designer *

Playing audio

Removing audio

Playing audio in slide show

Playing audio across slides

Playing audio in the background across slides

Saving ink annotations on slides *

Finding text in presentation

* Requires an Office 365 subscription

Top of page

Word-only features

● Feature is supported
◌ Feature is not supported

Feature action

Word

Viewing footnotes

Adding and updating footnotes and endnotes

Viewing citations

Adding and updating citations

Viewing captions

Adding and updating captions

Opening table of contents

Adding and updating table of contents

Tracking changes

Showing word count

Opening RTF files and saving them as DOCX files

Merging and splitting cells

Opening TXT files and saving them as DOCX files

Top of page

Authoring features

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Adding and editing hyperlinks

Adding tables

Adding shapes

Adding SmartArt

● *

● *

Adding charts

● **

●**

Adding text boxes

Multi Window Support (requires Android 7.0 OS)

More colors ^

* Tablets and large phones (>5.5") only

** Pasting charts copied from Excel

^ Requires an Office 365 subscription

Top of page

Bi-directional text feature

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Support for right-to-left (RTL) languages

Top of page

Editing features

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Displaying comments

Adding, removing, and changing comments

Finding and replacing

Using Paste Options

Zooming

Applying table styles

Top of page

Inking features

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Draw or Pens tab

Ink to Shape

Instant Ink

Top of page

Opening and saving features

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Opening files saved on SharePoint sites *

Opening files saved on OneDrive and OneDrive for Business *

Saving files to SharePoint sites *

Saving files to OneDrive and OneDrive for Business *

AutoSave

Pin files to Start

Saving files to SD cards (requires Android 5.0 or newer

* Only when files were opened from those locations from the Most Recently Used (MRU) list

Top of page

Picture features

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Finding and adding pictures

Displaying background images

Inserting pictures from camera

Top of page

Print feature

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Printing

Top of page

Proofing features

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Checking spelling

Checking grammar

Top of page

Sharing and collaborating features

● Feature is supported
◌ Feature is not supported

Feature action

Word

Excel

PowerPoint

Inviting people to view or edit a document

Real-time presence

● *

Real-time typing

● *

Tracking changes

Sending a document as an attachment

Sending a link to a document saved to OneDrive

Sharing as a link or email

* Tablets only

Top of page

No comments:

Post a Comment