Welcome to Office Mechanics. Coming up on the show we're going to take an early look
at the new Office 2016 public preview. we're going to also take a look at the new Office
for Windows 10 on phone and stay tuned at what's new in Excel, Word, PowerPoint and
more on the show
Microsoft Office
Office Mechanics
Okay, so I'm joined again by Ben Walters. Welcome
Thanks, great to be here Jeremy
So last time we looked at Outlook and some of the new things you could do in mail. But
I really want to a roundtrip of all the great things that we've done from Office end-to-end
on Windows and on the phone.
Sure, so one of the places I want to start with is Word. We had co-authoring the online
version of Word now for a really long time and I'm really excited to show you now, and
if we switch over to demo machine one, a new co-auth experience that's happening in the
rich client. So you can see here as I've opened up this document I can see flags, where people
are I can see those moving around my document here and you can also see as I start to edit
that text comes straight through for me. No more having to worry about saving or hitting
refresh to get those changes coming through. Everything streams just straight back to my
machine, and it autosaves to everyone else who is editing that file as well
That's really amazing because we've had these experiences in Office online for a while now
with Word online and also in PowerPoint and Excel as well but really the rich clients
is really where most people are getting the majority of their work done, from Words perspective,
this gives them the ability to do that real-time co-authoring, that real-time typing you are
seeing here on the screen amazing, great stuff coming there. But beyond what were doing
there we're also doing a bunch in Excel too right?
That's right, it's been a really long time since we've had any new charts coming to Excel
and I'm really happy to announce we have 6 new chart types coming into Excel in the new
version of Excel 2016. This is really based off the fact that data visualization and the
way people work with data has changed over the time since we last had new chart types
come in. So if we switch over to demo two here, you can see I have my new Excel chart types
up this is the waterfall chart. Great for being able to show financial data gains and losses
as part of that. We also have this great new tree map chart as well where you can see the
leaf nodes of those rectangles really kind of showing you the values there and while
this treemap chart is really great at showing you overall averages of data it probably doesn't
show me the structure so its really easy for me to go into here change my design out and
I'll switch this over here to one of our other new chart types which is called sunburst and
you'll see again we get that data reworked in there its been changed to look like a sunburst
which means I also get the view of structure as well as the value and the big piece on
these new charts is that they are built on a new platform which means we can update them
and continue to work on those as we go forward so we will see new interactive charts coming
through as we move forward.
And some of the things also across both Word and Excel that you might be seeing with an
eagle eye things like TellMe also being integrated in all the apps we're able to find functionality
very quickly but one of my favorite features in Excel is actually something around security
and preventing data loss. So we flip over to demo three here we have a brand new capability
inside of Excel. As we're typing you'll notice I have credit card information here but I'll
see a policy tip as I'm actually inputting that information in the document and it we'll
say exactly what I'm doing wrong here because we want to be able to include the user in
the compliance process to make sure they are educated in terms of what's going on make
sure that Excel, kind of like we had in mail in the past, actually informs that user of
any sensitive information they might be working on and at the back end it will do things like
be able to lock down permissions to just the author of that document. So really cool stuff coming
not only in the visualization side of Excel but also with DLP. And this DLP Data Loss Prevention
is going to be available across Word and PowerPoint as well
That's right really making sure the data you've got wherever you've got it is protected. So next
I'd like to switch over to demo two and really shift gears into mail and mail is still where
we spend a lot of our time today i know I'm always triaging my mail before I get up and
out of bed the first thing I do is check my email. But when we look at Outlook this is
where a lot of people spend most of their days. So what I want to do here is show you
very quickly one of the great new features we have called modern attachments. So here
I can go and create a new email and historically if I was to attach a document to an email
I would have to go and find that document where was I working on it but we've included
now a recently used items list. So as I open up the attached file dialog, with the attach
file icon, I get a list of all the documents that I've been recently working on. Now some
of these documents have nice little cloud icon on them that means they are stored in
OneDrive and I can share a link directly to those documents. I also have a list of documents
that are sitting on my PC as well. So if I want to attach those documents through I can
do that. Now as I go ahead an click that document will get attached to my email just like an
attachment and you'll see here it actually looks and feels like an attachment
So with the great thing here is it's actually finding all the documents you've been working
on so it saves me personally a ton of time working through files cause I don't always
know exactly where I saved them on a local machine that finds that for me as well and
then with the cloud sharing it means that we don't have to worry about the version control
issues you might have sending that document to 10 people and having to collate all those
different edits into one doc now we can actually centrally author against the same file
That's right, and if I wanted to actually go and correct the permissions on that I can
do that as well. I don't always have to share documents to edit I can very easily come down
and change that to be just to view. So if I want someone just to review something and
not make changes to it I can set that in my Outlook as well
That's a beginning or a taste of things that we've done in Office 2016 and what you'll
be able to see in the public preview but I know that we want be able to see what's on
Windows phone. We're going to switch gears here and we're going to go back to demo three and
show what's new on Windows phone, so this is really exciting cause we're bringing a
lot of functionality and such a small form factor
This is so what I have here is my Windows Phone 10 device I'm going to open that up
and you can see right there own my start menu I have Outlook, I have a new mail, new calendar
Excel, Word and PowerPoint applications right there ready to go. Like I said I can start
mail main and start in Outlook and you can see we've got these great new fresh view of
Outlook ready to go through and work on my email. Now with my email I have this ability
as well to use swipe gestures to be to triage that email. So here you've got delete probably
got a mark as unread in there, I can change that to flag or archive, so it's really simple
for me to go through and process that email and get triage and ready to go. The other great
benefit that we have here is that if I go and open up this email here from Julia and
I want to reply to that. We're using the Word editor that exists within the Office universal
applications right here on the phone. So this gives me a couple of great benefits first
of all I have all of the editing capabilities that I within Word first of all when I'm editing
my email i also have this great ability to be able to do inline editing. So where historically
I'd have to go through and re-write an email from top to bottom, I can now do things like
say refer to my answers inline and simply go and respond to those as I need to, making
it much simpler for me to work with that, The other piece we have with mail as well, we know
you like to work with mail but you also like to work with your calendar and we've integrated
the calendar directly into my mail experience. So if I open up my menu I can go straight
down to the bottom here select calendar and I'll link straight through to my schedule
and what's going on within my calendar there as well
So that's great to see, but even beyond mail and calendar the app experience for Word,
Excel, PowerPoint have changed quite a bit and added a lot of new functionality why don't
you show us PowerPoint
So let's have a look at PowerPoint here then there we go there is my PowerPoint presentation
looking beautiful it's a nice rich experience I have my slide navigator on the left-hand
side there I can also use swipe gestures to be able to navigate through my slides as I
want to go through deck and review things but because we have these great devices that
can connect to projectors I can also put this straight into projection mode and when I do
that I get all those animations slide transitions come up and so no longer do I have to spend
time with a PC connecting up to projectors and those kind of things I can bring my phone
in and actually do my deck right there from within my meeting on my phone. We also have
all the feature you see in the universal apps as well. So if I want to go and ink and draw
attention to certain areas on my slides I can do that just as well with touch
Very cool. So you can use your phone basically as your presentation PC or computer for an
actual presentation using things like mirror cast very exciting and even beyond that we've
done a lot in Word as well right?
Let me open that up and show you. Word here is amazing we have this beautiful rich document
full fidelity view, I can see all of my graphics, all of my feedback that's gone through on
that document. If I zoom in there you can see I've got some comments come through on that,
really easy for me to work with that document and see everything that's in there. You'll
also notice that if I open up the menu at the bottom, that same pallet UI I had when
I was in Outlook is also in here. So we have a familiar experiences as we make our way
across the applications, and it doesn't matter where I am I have access really easily to
all the functionality that sits within Word making it really easy for me to work with
this on the go
So really really great stuff of course we couldn't cover all the bases in terms of
all the different apps that we had in the time that we have today but what you are seeing
is greater focus in terms of collaboration also better connection to Office 365 and web services
better visualization in Excel, fuller and richer fidelity on a phone device and we've got the
compliance in all of the security controls around things like Excel, Word and PowerPoint
using features like DLP so really really great set of new features thanks for showing us
those today Ben, of course, all this informationa and more can be found on the Office blogs
also on Office Mechanics Wednesdays or as news breaks. Thank you all for watching and
goodbye for now.
Office Mechanics
Office.com/Mechanics