[Music]
hello and welcome to Microsoft Mechanics
live coming up we're gonna do something
a bit different with the demo Palooza of
office 365 in the next 15 minutes we're
gonna challenge ourselves to bring you a
demo pack tour of the latest updates to
office that bring intelligent and cloud
connected capabilities to your favorite
office apps and to do that I'm joined by
Jack Elmore from the office demos team
welcome all right Jeremy very good if I
could speak power I'd be even better all
right so we've got 15 minutes
effectively to highlight all the cool
stuff in office and what we're going to
do is we're gonna pull up a clock
because we want to make sure that we can
time it how many people think that we
can get through five really good demos
how many people think we can do better
than five all right how about seven I
think we're gonna go for go for 10 let's
go for 10 demos quantity not quality ran
good ones they've got to be good one not
little not little ones like stalled
really good one a minute all right so
let's let's dig into it we're gonna
bring up the clock we've got the clock
visible now I think you can see the 15
there yeah so Jack you've got 15 minutes
and your time starts now all right so
we're gonna start at the new office comm
it's the place where you should start
your day with office and it's your
gateway to all of the different office
applications we've got a list at the top
of the apps that you use most
we've got search across documents people
in site so here you can invoke your apps
see your recent documents even recent
sites that you visited this is designed
to be a very quick place for you to get
logged in and get where you were back on
track focused on your content your
onedrive and all of your favorite sites
yep
now we are gonna start by showing off
some intelligence features I'm gonna
start in PowerPoint now Jeremy did you
know that we release new capabilities in
the office 365 suite every month I
actually do know that how did you stay
on top of it all I film things okay well
you've all seen the demo I suppose of
real-time subtitles and speaking into
the microphone and translation into
other languages and that's a great demo
I'm not gonna do it today because it's
already been done by somebody more
senior than me so I take the leftovers
I'm gonna translate these slides for
French to English so I'm gonna use text
content slide translation I'm gonna save
a copy of the PowerPoint and in just a
matter of seconds we're gonna be
drumroll please lighting this French
document into English that's right this
is about building on the work of others
stealing other people's ideas and making
them your own and the Canadians are
gonna be really happy with this one
correct so here you go
on slide three if you look on the left
there's the original French on the right
there's the English translation so not
only do we have real-time all right cool
people are down with that Jeremy that's
all the phrase phones out there should
be clapping all right you know you got
more time you've got 13 minutes left
when I talk about unleashing my
creativity I'm talking about slides like
this this is pretty sweet right any of
you create slides like this you've
unleashed nothing I did not major in art
not a key talent of mine I'm gonna
insert some pictures and now people that
are loyal followers of your show Jeremy
are gonna be like oh yeah
he's doing that again I think I saw that
a year ago hold on we're drop Center
isn't it in there yeah and we're gonna
come up with a number of designs for
those slides we said it's cloud powered
and by the way the engine gets better
over time so a year ago when probably
David Alexander stood up here and showed
you that you saw something similar that
now because we've seen that one well
check this one out
so you got barista here on the right
it's a very long photo salient region
detection cognitive services knows what
your eyes drawn to crops the photo
intelligently how about that right but
this is what you have not seen the
moment you've been waiting are you ready
new capability is here a series of gates
in consistently formatted anyone
creative online right yes
and lastly a slide that's got a series
of call to action steps that each start
with a verb can create a beautiful
layout like this right and then of
course these are just SmartArt so you
can play around with them to suit your
liking right do whatever you want turn
them into 3d change the colors so this
is about helping you to stay focused on
your content create professional results
all right with a minimum of freaky guys
think of this all right nice
you don't have to spend all the time
formatting those slides alright you've
got you got about 12 minutes left keep
going this is gonna be so easy man like
seriously you should have come up with a
bigger number than that all right let's
talk about inking because the pen is
pretty amazing
on the surface Pro that I'm using here
yeah this a-frame sketch was created
using ink annotations and PowerPoint
right so you can you can draw lines of
course you grab a pen and then you draw
your own but in obviously those and the
ruler feature and I'm not really very
good at that so what I want to do is I
want to bring up a ruler here that I can
position exactly at the angle I want and
that way when I use my pen to draw I get
a perfectly straight line see that so
for those of us to shake your hands or
doing demos onstage the ruler will
totally help you and you want his hand
on purpose up here because he's got
trying to get through ten demos in less
than fifteen minutes does stress you
killing me stress is killing me one
thing a lot of people don't know about
ink is that we actually not only pay
attention to pressure and of course all
of the things you would expect from the
demo here but we also pay attention to
the sequence of the ink and we can
replay it back which is really important
when you're looking at how something was
marked up there's a lot of times you can
infer intent based on the sequence of
the strokes of the ink and in fact
actually when we do ink to text it's
very important to know which way you
drew a letter you don't just look at a
picture of the letter you know it's the
stroke started here and it went that way
and there therefore it's an ego this is
ink playback and you can you have this
for example to do Chinese character
annotation to see how those strokes were
done in the right order mathematical
equations etc Jeremy it's crazy what I
can do with ink alright but you can do
better than that and you've got ten
minutes I know I think this one's gonna
be cool like alright we're in we're like
the home of NASA or one of them 3d
imagery 3ds should not be reserved for
$10,000 plus devices we believe 3d can
be democratized available for everybody
on a Microsoft 365 device so we've got
great tools like paint 3d remix 3d which
is a great way to online share 3d models
and we also support it across the office
applications if you want to rotate a 3d
model in Excel you can totally do it if
you have a great reason to do that
please let me
no but I'm gonna go ahead and do this in
PowerPoint so I'm gonna take this model
and you can see I can just rotate it
around there and view it from a lot of
different angles but what's interesting
is somebody like me that's kind of
simple I'm just gonna copy this slide
okay so this is just gonna make an exact
duplicate of the slide okay
and then I'm gonna do Jeremy is I'm
gonna take a look at a different
perspective all right I'm gonna look at
the bottom of this Hubble telescope
there we go yep and then under my
transition now you'll see the
transitions page push wipe split reveal
so 2015 so we look at morph morph is a
new transition that automatically
calculates the Delta between the slides
and provides a cinematic movie like
effect it's basically going to kind of
interpolate all of the different changes
of that 3d model that's correct Jeremy
so what we're gonna do is we're gonna
start the show from the beginning there
we go
are you ready for the Hubble telescope
let's see okay there we go there's
rotation number one learn about
controller panels communication antenna
that's your custom one and then
helicopter tomorrow it's so copy paste
morph
you're in the 3d business and the
backwards backwards or forwards works so
all of that is interpolated between any
of the slide moves you got eight minutes
though you did one of the demos that
counts so okay the tick okay so what's
what's new that one is ripening word one
more thing for the pen all right okay
like a very good school teacher we can
all grab the red pen and say bad right
but you could do that for a while yeah
that's not new right oh you want to
replay that oh yeah there you go we'll
see how bad it was just just to make it
even worse when your teacher gives you a
bad at a total okay totally but we can
also use ink to edit a document so I'm
gonna activate something here called the
ink editor and with the ink editor I can
do something a little different with the
ink which is I can just scratch through
this paragraph like that and you'll see
it automatically deletes the items that
I scratched through and reflows the
document or maybe I want to just scratch
through a portion of this sentence
and you'll see it automatically reflow
the document so the pen is quite useful
beyond Oh how about we just select this
paragraph and then we'll highlight it
with the yellow text so we can use it as
a selection
tools one so great innovations on the
pen site if you want to impress your
friends at the next cocktail party trust
me I've tried this it doesn't work you
can tell he goes a lot of cocktail
parties any of you that are excelled
junkies you know the rand function
random numbers right in the demo world
we use this a lot it has very limited
practical applicability except in
college when the teacher doesn't
actually read your paper but if you put
a number in the middle and you hit Enter
you get that many number of random
paragraphs so if you're just looking to
pad your yeah yeah right super useful
yes let me tell you what the ROI is on
that one yes and if you're an IT this is
even better if you use desktops and this
and it looks like you're busy all the
time
totally it is all about looking busy yes
alright alright you got now I'm going to
take us into the word web app the same
thing I'm gonna show you here is
available in word and it's also
available in OneNote and it's embedded
in the Outlook Web App it's a super
important tool we're using to improve
accessibility I'm going to bring up a
document here in the word web app this
is the document that has multiple
languages in it and what I'm gonna do is
bring up something here called the
immersive reader now this originally
came as a hackathon project actually
from within Microsoft a group of people
got together across the and then it came
into OneNote and then it came into
OneNote first and then it's kind of
grown from the out severy where
originally it was designed for students
especially those with additional needs
for learning so here I can highlight
syllables or I might say I want to
highlight it's changed the color of what
the nouns are or for some with
additional vision support that's needed
we can change you know the background
color so of course making it possible
for everyone to be able to consume your
content there is another interesting use
case though and that is in proofing your
own stuff have you ever noticed when you
read your own stuff for proofing you
still miss a lot but if you engage an
additional sense with hearing you can
improve your proofing substantially take
a look at this
traveling in Costa Rica you will have
the peace of mind of knowing our support
staff is a local phone call away a Banco
Sabadell
Montreal sangra nada es para mañana lo
que puede cetera Anjali or even an
ayakashi ah ha Jun su Joe Alvin Nina
how about that right to left what do you
think yeah an excellent enunciation
doesn't sound like an American trying to
speak all these languages which is
really cool totally alright so look for
you know amazing support coming in is
this language stuff just gets better and
better and better as the cloud services
are used and refined and they learn over
time all right all right now the heads
in 45 seconds well Stephen what's our
count up to Jeremy I don't know stock
seven
okay we're Excel numbers text
calculations on numbers and text for 30
years right oh and pivot tables don't
forget to pivot tables with
cloud-connected excel we start to infer
datatype definitions Microsoft Intel
human beings no those are companies how
about we add snap and the minute we do
we get this little thing says hey I
think that's a stock I'm gonna click on
that now I've turned it into an
intelligent entity see the little icons
to the left there how about we add in
Starbucks now what is what is being an
entity do for us well it puts a bunch of
properties behind the object so here I
can see hey we know a certain amount
about snap this has Fox going now looks
like well see how are we doing today
Jeremy all right oh hey all right now
what can I do then with that I can start
to fill out things like hey what's the
ticker for this stock symbol or I can
say gee what other properties do you
know about maybe the open or the close
of a high or the low etc very cool all
right cities same idea here Orlando oh I
think that's a city about my hometown of
Portland Oregon well pop that one in
there we got any portlanders here there
we go all right oh Portlandia I'm sage
there we go there you go and in the same
vein here we can start to say hey when
was it incorporated and what's the
population so think about the
possibilities here in terms of
harnessing curated trust the data from
the cloud to come in and bring
intelligence reduce errors improve the
quality of your analysis all using
search awesome that's coming later this
year so I want to be clear everything
I've shown you if your office insider
you've got now that was the Excel
capability is coming soon as is this one
here's a bunch of data and the table now
with insights much like PowerPoint
designer I can use the cloud to give me
insight
analysis of this content so in the
beginning you okay I can make you a
chart of some of units by years and
you're like wow that's impressive I
think I could have highlighted that hit
recommended charts and come up with that
one but as we keep going down you'll
start to see it smarter and smarter
insight a litt where accounts for the
majority of the some of the units so
what you've got here is not a
replacement for a data analyst right so
don't anybody get worried about their
jobs because there's a lot more data
analysts need to do than this but think
about just the ideas and the conjectures
and the hypotheses that elements like
this can bring to you so okay India has
more sales then I'm going to insert the
chart traits a new chart creates the
pivot table behind it and then you can
do ad hoc analysis from now yeah we're
really excited about the work Excel is
doing to bring bring to life the data
that you have stored and spreadsheet all
right I'm back in just a minute warning
we're a minute warning sounds like
alright fine fine not not you know what
I forgot on my way here I forgot to
expense this parking I know if you have
trouble with receipts go to the phone if
we well I'm gonna take my little parking
receipt here and I'm going to bring up
the office lens now this thing is
awesome for whiteboards too if you're at
the end of a meeting you're standing off
to the side and you snap one of those
nasty curved pictures of a whiteboard
it'll straighten it for you so you've
got a whiteboard mode there or a
document mode I'm gonna go ahead and hit
take a picture there and you'll see it
automatically straightens the receipt
from there then I can say I'm done I
want to deposit that in OneNote
I'm gonna hit save and right now I'm
transferring that file right into
OneNote I can toss this in the trash
except I'll use it for my next demo very
cool alright alright keep going go back
to the PC more OneNote in just a second
we'll have a sink come down there look
at that there's the receipt I just took
a picture beep our evening 27 folks if
you wan there you go alright
no fake demos here man no we are serious
no powerpoints it's good to go high risk
baby ok so now I'm gonna take this
little triangle here first I'm gonna get
rid of the triangle we don't need that
I'm gonna circle this mathematical
equation all right I'm gonna bring up
math here
and math that's gonna say hey I think I
know this is an equation right and if I
do Inc two math it'll just turn it into
text but I can say hey I want to solve
for X and he'll do your homework for you
right we'll say yeah I want to do this
you know using the quadratic formula and
it'll be like hey dude here's how you do
all this
don't tell your teacher you got it from
awesome all right okay so that took us
through more than ten demos in 15
minutes what do you guys think was that
good all right all right so a lot a lot
of new capabilities these are things
that we can use both have users as i.t
all these things where do we wait are we
stay on top of all these different
changes that are coming to office so the
great news is we communicate it all to
the office 365 portal right logs dot
office comm is a great place to go if
you're interested in the roadmap we've
got a road map office comm that will
kind of show you by product by feature
next 30 days beyond 30 days we published
that in a pretty transparent format very
cool yeah
all right let's end it with that so yeah
thank you Jack the great set of demos
and thank you all for watching of course
we're gonna demonstrate all the great
stuff across IT end-user office windows
everything else on the next in the next
series of Microsoft Mechanics shows
thanks for watching and good bye for now
Cheers
[Applause]
[Music]