(funky music)
(applause)
- Welcome to Microsoft Mechanics Live.
Coming up, we're joined by Jack Elmore
for Demopalooza 3, as he takes on our third annual challenge
of demoing the latest Office and Windows experiences
in just ten minutes.
Now we're gonna try to look at as many of the latest
or lesser known capabilities across productivity,
collaboration, and of course much more.
So last year, he raised the bar with 20,
yes, 20 demos in ten minutes.
But can Jack do it again?
We're gonna find out now.
So everyone please give a warm welcome
to Macklemore, sorry, Jack Elmore.
(applause) - All right, thank you.
Glad to be back popping tags,
and thanks to everybody for stopping by.
- All right, so a lot of people are kind of moving towards
the newer builds of Windows and Office.
Especially now we've got Windows 7 end of support coming,
as well as Office 2010.
I think a lot of people are coming to Pro Plus,
and kind of the newer builds of Windows.
So I thought it would be a good theme around productivity
and time savers, you're the guy to actually do this.
You've actually been running
the Microsoft Technology Centers,
a few of those on the West Coast.
- That's right, we've got a little booth over there,
number 14, where you can meet a lot of our great colleagues,
but I've been working at the MTC for a year now,
and in that year I've found all kinds of new ways
to use Microsoft 365, and so I'm gonna share those today
and do my best to take on your challenge.
- [Jeremy] Right, as I mentioned, this is an annual event.
During Demopalooza 1, you were kinda lame.
You got 12 demos done in 15 minutes.
Yeah, sorry, but you brought your game back.
Demopalooza 2, redeemed yourself, 20 in ten minutes.
We gave you a little bit of stoppage time, yes.
- [Jack] I shoulda done less.
- It's gonna be hard to beat that,
'cause you coulda sandbagged a little bit last year
to see if you could do more this time.
- You know, at some point the laws of physics,
there really isn't going to be enough time.
- All right, but I have faith.
You guys have faith that he can beat 20 in ten minutes?
(applause)
- Okay. - Guess you better do it.
- All right, so looks like we've got
the timers queued up onscreen.
I think the audience is ready.
- [Jack] All right.
- I think the timekeepers are ready.
- Okay. - Let's go now.
- When I wake up it's typically dark in Seattle,
and so I like to use night mode or dark mode for my apps,
now supported across all Microsoft 365 experiences.
Boom, there's one. - Really, dark mode?
That was so cheap my cat could've done that.
I won't give you points for that one.
- All right. - That's a theme.
- But when I'm on my way to work, I go hands free
responsibly by using Cortana to navigate
with my voice. - I've just got one new email
for you. - And there's the email
from Andrew Roger reminding me
that I need to do something about some catering prices.
- [Jeremy] All right, that one's worth a point.
So you got one. - All right, now I don't know
about you, I don't have a personal assistant
that handles my calendar, but when somebody like,
I don't know, Satya Nadella requests a meeting,
it feels like probably something I should do, right?
So what I want you to see here is I've @mentioned Cortana
and used natural language to ask Cortana and AI
to find me a meeting time next week,
and I've atted Andrew to please join me for the meeting
so that if things go wrong I'll just blame it
on somebody else, right?
So I'm gonna send this message now,
and in a matter of seconds what's going to happen
is AI goes out, schedules the meeting,
calendar.help, and then we'll have a response back,
there it is, the deployment status update
has been scheduled for next week.
- Beautiful. (applause)
- Andrew was reminding me about Excel,
and this fact that I need to get this pricing to him.
Now my pricing showed up on this.
Anybody get paper still?
There's actually still a ton of paper processes.
- Too much paper. - So here's my spreadsheet.
I'm gonna turn on the camera here.
I'm gonna focus it in on my invoice here.
Take a quick picture, we'll crop it intelligently
so that we are just extracting
the tabular based information, go a little bit higher there,
and then like that, and then AI goes to work,
turns it into a table, and in just a few seconds
you'll see I can drop that right there
into my Excel spreadsheet. - So a table on Excel,
once it happens, hold on, there it is, and it's in.
- Insert, and there's your data.
- All right, nice one. (applause)
- There's a lot of great tools for collaboration.
Here's the good news, but the bad news is
sometimes it's hard to stay focused
on all of your followups and tasks,
and for that I use To Do.
Now the new updated To Do has connections
to Outlook and a planner, so what's awesome about this
is while I'm organizing my day, and you can kinda see
I've got some very important things to do here,
like don't mess up Demopalooza.
- On the phone. - And I'm gonna go to
assigned to me, and here you can see shared task list,
things coming from planner, even all of my followups
from Outlook, so I can really use To Do to stay prioritized,
and when I get in the office, I'm ready to rock and roll.
- [Jeremy] That's worth another point, good job.
- All right, now I'm in the office,
and I need to work securely, and I'm gonna use
the Edge browser to do that.
- [Jeremy] So Internet Explorer's not your go-to then?
- Not really. - Okay.
- But there's a lot of websites out there
still using ActiveX, Silverlight,
those types of technology, and having two browsers
is a less than ideal experience.
So here I am in Edge, I'm going to navigate to a site
that uses Silverlight, it's actually one of our sites,
and you notice I'm engaged here directly
in an interactive session.
The page is opened in Internet Explorer,
and when I navigate away, we just go right back to Edge.
- [Jeremy] It's still in Edge, but showing through
Internet Explorer, that's worth another point, keep going.
- [Jack] All right, now the next thing I wanna show you
is the new page tab, and you're looking at it right now.
You can see all of the relevant information
from Office 365. - MRU, trending stuff, yeah.
- [Jack] All that stands between me
and the next inspiration. - All right,
that's worth another demo, keep going.
You gotta catch up some time. - All right.
So then what we now need to do is take a look at security
and how we balance this with security.
So for that I'd like to show you
Microsoft Defender Application Guard.
So if we could switch to that machine, here we have it.
Now I wanna show you this, first off,
it uses virtualization and containers
to be able to isolate this application
from the rest of your host.
Let me show you what I mean. - This is the new Edge,
as you can tell by the icon. - You gotcha.
This icon up here tells you
it's opened inside Application Guard.
Now you went to Hanselman's Keynote, I hope,
and you saw that the power toys are available.
These are awesome, right?
But maybe my IT department doesn't really want to let me
install those, and you'll see when I try to open it,
nothing is happening when I try to open a file,
completely isolated and protected.
Let's go to uploading a file. - That's worth a point.
- Let's go upload a file.
Where's my files from the container?
Well, they're inside the container, so guess what?
There's nothing there.
And then when I close down the browser,
poof, it's gone, nothing. - There you go.
Another one. - That's available now.
Let me show you a peek around the corner.
Last year I brought the ransomware USB stick
with the Windows Vista logo on it.
Anybody want to see this?
- [Jeremy] Everybody loves that thumb drive.
- Hard to believe it still exists, and I put it in here.
We found it over on the walkway, and so I thought,
ooh, why wouldn't we just put it in
and find out what's on it?
It's labeled secret data, I mean,
there's clearly something on here important.
So I'm gonna open up the Mark 8 Competitive Analysis.
Now there's gonna be a delay here,
and I want you to understand, this is pre-release,
it's still in the oven, I'm losing a little time.
- [Jeremy] It's a future build of Office.
- [Jack] You should get it in 10 seconds fast.
Application Guard for Office opens it up.
Last year we clicked the button,
it went over here and said you've been hacked.
And then what it went to do was encrypt all of my documents.
You'll notice it can't do that because it has no access.
- [Jeremy] What happens in the container
stays in the container, that's worth another one.
I might even give you two points for that one,
'cause that one's pretty awesome.
Virtualization based security for Office coming out later.
- All right, now let's talk about Excel,
because Excel's one of my favorite applications,
and Excel junkies everywhere are gonna love
some of the new stuff that we're doing.
First is called dynamic arrays.
Very simply, one function can return multiple values.
- [Jeremy] So let's go to this computer here.
Hold on, there we go. - All right?
So check this out, here's a function unique.
So I'll just type unique, I'm gonna highlight--
Did you notice Brad shows up here a lot in this table?
- Yep, I see him. - And I type, wait a minute,
look at all those. - You've duplicated the Brads!
- [Jack] And what if I wanna change Sam to Jack?
- [Jeremy] You probably don't wanna do that.
- [Jack] Then you get the spill error
saying you've violated the integrity of the result.
- Yeah, cool stuff. - Here's one that returns
a random array of four rows, eight columns,
numbers between one and a thousand,
and they don't need to be even integers.
Very easy. - Awesome, that's another one.
- [Jack] If you're using VLOOKUP and HLOOKUP,
dark art, right?
So XLOOKUP is our new friend, if I can spell it right.
Or I just click on the little helper there.
The value I'm gonna look up is in that cell.
The value list that I'm looking it up against is right here.
And the results that I want back are right there.
So when I do that and I type Russia,
or let's say, yeah, Russia, you see how it updated there?
So XLOOKUP is gonna make this stuff so much easier
for you. - And with that, you passed
year one, Demopalooza 1's number, keep going.
- [Jack] Don't slow me down!
When I'm analyzing large amounts of data,
I used ideas to democratize insights
to be able to take action on that data.
What's new, and what I'm gonna show you this year,
is the ability for you to ask questions about your data.
Like which brand had the most sales?
Boom.
Which company, which category of Honda,
so now we're filtering.
Let's go to the next one, show me BMW sales over time,
and this is my favorite,
compare it, recursive.
So it's going in looking at the periphery
and then grading upon it. - Recursive search,
that's actually worth two points,
I think that was two different demos in Excel,
you're at 15 now. - Okay, now I love Excel,
but there are times when I'm without, and unfortunately
then sometimes I gotta go to the calculator here.
Now the challenge is, when I launch another application,
I don't know, do any of you alt, tab, tab, tab,
tab, tab to go find that calculator again?
Do you find out you have five of 'em open?
Guess what, keep on top, there you go,
I'm gonna create my document,
the calculator's not going anywhere.
- [Jeremy] Not bad, I was gonna not give that
to you, but I got the applause,
so I'm gonna give it to you this time.
- [Jack] Shall we talk about teamwork?
I use Microsoft Teams as my hub for teamwork,
and this is my colleague Andrew,
who appears to be phoning in from the moon,
so what I'm gonna do here is
turn on some live captioning here.
- [Jeremy] Cool, that's actually worth two,
because he's doing background swap and live captioning.
- [Jack] Well, I need the caption 'cause there's no oxygen
on the moon, so I'm not sure what you're doing up there.
Hey, how's it going, Andrew?
- Hey, how's it going?
I'm, like, just on the moon.
We came here looking to do a site survey
for our next MTC location. - I got 50 around the world.
- I'm just hanging out at your place
where you get back to at night.
- [Jeremy] All right, so he's actually hanging out
at your place, that's a little bit creepy.
- Yeah. (laughing)
In fact, catch you later, man.
Okay, so that's a great use of teams backgrounds,
but obviously there are many more business appropriate
use cases, but we just wanted to have
a little fun here today.
Okay, now the next thing I wanna show you
inside of teams is something called secure private channels,
and see, Jeremy, we actually kicked you out of this channel
as we were playing. - That's another one.
That's gonna be one that people
are gonna love. - The next one is the ability
to double click and pop out your conversations.
- Everybody loves this one. - Everybody loves that.
- You're at 19 now. - Unified file sharing,
get ready for this one, I go into my team,
here's my engagements, I've got a file I've put in here.
Now all the people in my team obviously have access
to this file, but what would happen then
when I copy the link, and then I go, say,
try to engage somebody that is not part of the team?
I'll give it, say, here to Kirk.
And now when I go into the IM here
and drop that message in here,
you see I have the same file sharing controls
that we have. - Awesome, that's worth 20,
you're tied with last year, you've got 50 seconds left.
- [Jack] Oh, 50 seconds, good lord!
Hey, how about multiple desktops that you can name?
- [Jeremy] That's worth another one, I love desktops,
I use them every day. - Let's go talk--
Ooh, I got caught there, didn't I?
Okay, we're gonna go to a blank presentation,
I get blank page syndrome all the time.
Cats, I love cats, not really true, but okay.
And then you see designer actually goes
and fetches me a theme.
- [Jeremy] Oh, that's amazing, all right,
that's 22, you're over the last year.
- [Jack] Finally, last thing, request files.
Drop Off folder, I click on request files.
This lets me bring 'em in
from outside my organization securely.
I give it a descriptive name like mechanics.
I copy the link, now I'm gonna switch personality
and pretend I'm you, Jeremy.
I'm gonna follow the link, and I'm gonna upload the file,
I don't know, Circle of Care Consent.
(buzzer) - Oh, oh, we're gonna
give you just one second of stoppage time for this one
to make sure it works. - Watch the right hand side.
Oh, there's the file showing up on your Drop Off folder.
- Not bad, you got to 23, Jack, you did it!
Ten minutes! (applause)
Awesome, so congratulations, you killed it,
that's three more than last year,
and you didn't even need an awesome bonus round this time.
- Yeah, what did I win, did I get a Surface Go?
- You can have that Vista thumb drive there
that's still in your machine.
There's a lot in the parking lot that I found this morning.
(laughing) - All right, well,
I'd still like a Surface Go.
- All right, it's about time to go,
so can you tell us the best way then
to get your hands on some of this stuff,
so all the folks here out in the audience
can use what we're showing today?
- Look, a lot of the stuff I showed you today
is available on the Insider's ring today,
so I encourage you to be an Office 365 Club Plus subscriber,
that's where we put all the latest innovations
where you're gonna see it first.
And then for the latest in Office and Windows,
join up on the relevant Insider's program
to gain access to the early preview builds.
- And of course you're gonna wanna keep watching
the latest on Microsoft Mechanics.
Thank you all for watching, we'll see you next time,
and goodbye for now. (funky music)