Coming up.
We take a look at the last 12 months of updates for Office Mobile.
Including Sway.
A digital canvas for sharing multimedia content.
Updates to Word, Excel and PowerPoint universal apps.
As well as new Office experiences on the iPad Pro.
Microsoft Mechanics
I'm joined again by Ben Walters from the office team.
It's been about a year since we demonstrated Office universal apps on Windows 10
What's new Ben?
Yes, we've been continually adding capabilities to the Office apps
and even some new applications to the products Suite as well.
In August we released the Sway app for Windows 10 a native app
and also made some updates to the iOS apps for iPad Pro in September.
But why don't we start with Sway.
Yes, Sway is a great digital storytelling application
with the web based version we had originally
we now released a Windows 10 app as well
which is a new addition to the Office suite on Windows 10
And you can see here it looks very similar to what we've seen in the browser today.
So I have my story line
I can go through and add things in
and I had these great Sway that we created earlier
showing the financial report for Northwind & Contoso.
Now as I scroll through my preview here
you'll notice we've got a couple of new content cards that have been added to Sway.
And so the first is this chart preview
and I can start to show data and represent that information via my Sway.
And it's really easy for me to go and update that data
by simply hitting the data tab
or even go and change the way that's representated.
So if I want to update my chart from a column graph to a bar chart
I can do that even take.
Even take that out to a stacked bar chart so we can get a great view of those percentages.
And as I do that, the preview updates in real time
so everyone who is viewing that will see an updated view of that data coming through.
Now as I scroll through
you'll also notice we have these great new ways to represent images.
Sway is all about rich content and being able to work with that
and you can see here I have this great transition effect on two images that I have
so I can show a before and after effect
or maybe we're out with our products today and we where we want our products to go tomorrow.
Just with that simple slide of transition
making a great way to be really engaging with people on the site.
Very nice.
And then as we scroll down
I've got other ways to represent my images as well
So we just have a stack of cards
we could show before where images
would be stacked upon each other
but I can now represent those in a grid
and as you can see here I have this great view of
all of the products and branding we have for our solar panels right there in the grid view.
You'll also notice this image down in the bottom right corner
seems to have someone cut out.
It looks like his heads cut off a little bit.
Yeah just a little bit.
And while Sway is great at being able to position my content for me
sometimes it misses what the important piece of the picture is.
So if I come back to my storyline here
and scroll all the way to the bottom
I can see that that image has a picture of a guy in there.
and I want to make sure that his face shows up as the standard focus point.
And what I can do is, going into that image.
Simply tell Sway what's important and what should be shown
so as it goes through and rescales
it will make sure that that face is always shown
because that's the important focus of that image.
And you'll notice again in the background
that updates in real time
showing me that has been updated and ready for people to view straight away
So Sway is really an excellent digital canvas for storytelling
but why don't we bring this back to Word, Excel and PowerPoint.
Yeah. So the Office mobile apps for Windows 10 were RTM's back in July.
and later we extended the universal experiences for Windows 10 mobile as well
Let's start by having a look at Excel.
So here you can see we've got Excel.
And this is really still an application that was built from the ground up for mouse and keyboard.
We've continued to extend in and make it easy for you to work in a touch environment.
So I'm go and add a new line item to my product list here
I'm going to add a new solar panel
And you'll notice as I type
Excel is going ahead and doing auto complete for me.
Now in this case on the category line
It's pretty easy becuase I've only got one item to select from
But if I move over to my item code
I want and add a new AP100 item code.
You'll notice as I go through that I actually get a list of all the item codes that are there.
So if I decide I want to add another AP92
I'm even going to make this an AP923 rather than an AP100
I can go ahead and do that
simply by selecting from my auto complete drop-down list.
So really quick and easy ways to do things just based in touch environment
That's going to save a lot of time especially given you can use a touch keyboard.
Yeah exactly.
There's also other areas as well that have made it much easier for touch
Things like search and replace
You'll notice here, I have this new search icon in the top right of the home tab.
And if I click that
I actually get this new find dialogue
where I can go through and find the number of instances, in this case, of hardware
which I want to go and remove from my list.
And as I type that in on the right
I get the number of times it's been found within the document.
If I click on the cog
I can then upgrade that from just a find
to a find and replace, as well.
So I can come in here and say I want to replace this with
maybe I just want to remove the word hardware
I can go ahead and hit replace all
and have that word removed from my spreadsheet
really quickly and easily.
Again, no need to have a mouse and keyboard to do this.
All with just my hands.
And as we move on
I'm going to show you one of the other great features, that we've now made available for touch as well.
And that is a new auto fill feature.
And if you think about, when you want to fill out a list of months
or values sequentially
you would go and click that little icon on your Excel spreadsheet and drag that down
something that's really hard to do with just touch.
But now I'm going to select my data
I now get a fill option that pops up
which then changes my selector
And then as I go and drag that down You'll notice I get all that sequential data
placed in for me really quickly and easily
So again, taking those features and functions we have for mouse and keyboard
and making them available for touch.
One of the other areas we continue to make improvement in
is in the charts in visualizations.
In Excel 2016 we have some great feedback on our tree map charts
so all those new visualizations are available in Excel mobile as well.
As you can see here I have some hierarchical data
and I want to go and represent that in the chart.
So I can simply hit insert
go to my chart list and select the new tree map chart
And you'll notice right there
I have that hierarchical data represented really quickly and easily
via that tree map
Or if I want, I can go and change that out
and switch that out for a sunburst
and you'll notice really quickly and easily
a great smooth animations
it takes that chart and updates that form making it simple for me to work with that data.
We've also made quite a few updates to PowerPoint.
Yeah, let's switch over to that now and have a look.
I've got this great presentation here right now
about solar panel design process
and one of the things around PowerPoint
is creating really engaging slides and things that look nice.
And with the new Designer feature makes it even easier for me to do that.
So if I go and insert a picture into my title slide here
and I've got this great picture of solar panels.
you'll notice that PowerPoint goes through and suggests designs to me
based on the template that I have.
And so I can actually go through and see ways that image can be laid out.
You'll also notice it takes advantage of the template as well
so there's kind of little swirls and designs I have there overlayed on top
creating a really nice effect.
The area we've made some great improvement as well
is in a new transition called Morph
and so you'll see here if I put my presentation into slideshow mode
my transitions between my slides are kind of jarring and I tend to flip between each of the images
but going back to my design mode
if I decide to apply the Morph transition to each of my slides
Morph actually takes the objects that are in the slide
and creates a great really rich transition for me
really making engaging slide for me to move with.
So what I'm going to do now is come back to the slideshow
and I'll show you what that Morph looks like
and as we go through our slides
you'll notice that now as I transition through my slides
I get these great animations that help fade through from one slide to the next
and in this one here where I actually have four images
Morph actually goes through and puts in those animation paths
making it really easy for me to move between slides
and create a really engaging presentation for the people who was sitting there watching.
You're right that is much better.
The other area we've made additional changes to as well is around inking.
Now we've been able to ink in PowerPoint
while we've been in presentation mode, for a while now
but what I can do now is simply take my stylus
and actually start inking on my slides directly while I'm in design mode.
And so if I come to here and draw circle
you'll notice that PowerPoint actually takes that
not only takes my circle and allows me to ink
but also then converts that into a shape.
And so, I can do that with any shape I want
if I decide I want to put in there a square
or circle or a triangle I can go and do that.
And they're actually objects that I can work with.
So I can take those
resize them, move them around as I need to
right there within PowerPoint.
It's now, not just about using a mouse and keyboard
but also about using my hand and my pen
to be able to go in and do really really fine motion control on that.
SInce you've already got the pen out
we've also added inking to Word, right?
Yeah, in fact we've added inking to all of the core Office applications
PowerPoint, Word and Excel all have inking capabilities now.
And you'll notice here if I've got my Word document open
for the 2015 annual report.
What I want to do is actually start to annotate and mark this up.
So simply by taking my pen
you'll notice I can go and draw right across the top my document there.
I can make notes on things that need to be updated
and things that also need to be taken care of as part of this as well.
so you know, someone has missed adding a chart into my document
and I want to make sure that gets included
and it's really great that I can, you know
while I'm using my pen also use my finger to be able to do scrolling
and nothing gets confused anymore.
Like drawing while my finger touches
it only happens when I'm using my pen.
So beyond all the work you've done for Office on Windows 10
we've also made updates to Office for iOS
with new capabilities tailored to the iPad Pro.
Yes, the iPad Pro has a much larger screen
making things like multitasking and working with Excel much more capable now.
And with the new stylus
all those inking capabilities we saw on the Surface
are also available on the iPad Pro.
So you can see here if we start with Word on my iPad
that same document I had on my Surface Pro is right here for me
and you'll notice all of that inking
has followed across to my iPad is well
it doesn't matter where I am
with the power of the cloud that document follows me wherever I go.
And one of the new features with the iPad Pro
is this new ability with the pencil to go ahead and ink right on screen as well.
So I can go ahead
and as I write on that you'll notice that I can go and
annotate directly on screen with my pencil
And that's highlighted the draw tab giving you quite a few new options.
Yes, so because we are drawing
we have all these options for ink, highlighting and also
being able to erase marks that we made as well
with the pencil right there on the screen.
Now as we continue through
one of the other things that the iPad Pro is capable of
is multitasking.
So with the larger screen it much easier to have two applications side-by-side.
We can see here
I've actually been reminded that I needed to add that chart into the financial reports.
So if I slide in from the right hand side here
you can see I'll open up a previous application that I had loaded as well.
In this case my Excel where that chart is loaded
So go ahead and select that chart in Excel
copy that come straight over to Word
and paste that right in there.
Using the same functions and features that I have on Windows before
I can copy and paste between applications are now on the iPad Pro
making it really easy for me to work the same way I do anyway.
So if we move over to PowerPoint
those same inking capabilities follow us
and are available in all of the Office applications on iPad.
So Word, Excel and PowerPoint all now have that annotation capability.
Now in this presentation here
I'm comparing some mobile and desktop visitor stats
and rather than building a chart
I'm simply going to take my pencil
and drawing circles to represent each of those values.
You'll notice as I go and draw those circles
not perfect
but the into shape functionality takes that and turns into a perfect circle object for me
Really quickly and easily.
Now my next slide, I actually want to go and build a quick venn diagram as well.
So what I'm gonna do is
the same thing just draw out a couple of circles in varying colors
and then take that object and overlap that so I can get that venn diagram
So now, if I switch that into presentation mode
you'll notice that morph actually takes those objects
and then does that merge across for me
that really nice animation between slides
creating a really smooth transition between my different objects there
really quickly and easily.
so great productivity tools across every platform available to us now.
Really great to see all these new capabilities.
Of course these are just highlights of some of the new office updates
for Windows 10 and iPad Pro.
Ben, how can I get started with some of these experiences?
Yes, you can start using what we've shown today
by installing the apps from the Windows Store and iOS App Store.
And also keep checking back to the Office blog as well as Microsoft Mechanics
on Wednesdays or as news breaks for all the latest updates.
Thanks for watching and goodbye for now.
Microsoft Mechanics
www.microsoft.com/mechanics