Welcome to Office Mechanics coming up on the show we'll take a look at the new
Office 2016 for Mac Preview which brings together all the most recent updates for
Office on the Mac and we'll demonstrate highlights of what's new with PowerPoint, Excel
Word, Outlook and even the newest member of the Office for Mac family OneNote
Microsoft Office
Office Mechanics
I'm joined by Kaberi Chowdhury
and I know a lot of people have been really looking forward to updated
experience with Office on the Mac
that's already out on preview now but why don't you tell us what's new
well we started incrementally improving
on the Office for Mac 2011 experience last year by adding OneNote
in March and Outlook in October which was available exclusively for Office 365 users
and now recently with Office 2016 for Mac Preview
Outlook is available for everyone and we've rounded out the suite
with the addition of Word, Excel, and PowerPoint
so what are the main differences I might experience verses Office for Mac 2011
Well let me show you Jeremy. Right away
you can see that all the icons on the bottom here
match what you would see on Windows or any other device
because we've aligned the look and feel
Let me launch PowerPoint and you'll notice that
the similarities continue you can see all the file templates
that help you get started easily. Office 2016 for Mac is much more cloud connected
then Office for Mac has been in the past
You can have all your recently used documents
in this view regardless of which device you may have opened it on
and that's regardless of whether it's on that local Mac hard drive or whether it's in the cloud
Speaking at the cloud you can open your documents from OneDrive
One Drive for Business and SharePoint as well
These are really great changes that really accrue to
all the different apps in the suite but why don't we drill into PowerPoint in specific
Yeah PowerPoint is a great app for presenting your ideas
and we've added presenter view which is a great way for you to see
the slide that you're currently presenting which everyone can see
you can see the slides that are coming up
the notes for the slide that you're showing right now and
you can also track the timing up your presentation
at the top left corner
That's really great. I you wanna make a
couple of changes to some of those animations there
and we have another great feature for that as well right?
Yes we do. I'm not happy with this one particular animation and to do that
too to change the animation I'm going to pull up something called the animation theme
that's the new feature. I'm going to select this, add an animation
and what I'm also going to do because I also needed
animate at the same time is everything else. I'm going to say with previous
adjust the timing and let's take another look
right, so that's much better, now you've got your thermometer animating the same time as everything else
But I know we've done a lot of work as well to make the transitions
similar to other PowerPoint clients
Yes, so I'm gonna show you a few more
transitions and you're right these are very similar to what
you see on Windows and other endpoints
These are really great changes for PowerPoint
but why don't you show us what's new with Excel
we've made a lot of great under-the-hood improvements for Excel and many of these
are focused on power users
in Excel right here I have a bunch of expenses
in different categories from the month January to month of December
I may be interested in trying to figure out which month the 12
I spent the most amount of money in so what I'm gonna do here is take a
simple formula, the total for the month January divided by
the total amount of money spent. Just going to put the dollar signs in here
and then pull this out
for all the months. And as you can see because the entire table
is in dollar signs it's going to assume that this is also currency
I'm just going to use the quick keyboard shortcut
Shift-Control-5
and change that all into percentages and so it's really easy for me to see that
in July, because I spend so much money on travel 12 percent
of my yearly budget was spent in July
Another great thing I think for power users
is the ability to use the analysis ToolPak add in and that was also added right?
yes, for advanced statistical analysis you can
easily use the analysis ToolPak and the other great thing
is oftentimes when you want to calculate something
you you know what formula you want the you don't remember the Excel syntax
we've added in
the formula, which is a pane to the right
you can see here that have my most recently used formulas
and if I don't remember exactly what they are I want to be sure it's right here below
I have the syntax and the definition
so what I want to do is
calculate the average expenses.
the average amount of money that I've been
spending across different categories
and I can do that easily by double-clicking average
We want to make a little tweak there I think that you want to go O30
Exactly because it's taking over, it's also including the total
and I don't want that. So I'm going to fix that and right there I can see that a
I spend about on average $6,500 every
through all the categories
These are really great changes in terms of power users for Excel
but we've also added PDF printing as well right?
that's right now you can print the Excel to PDF
right here and you can send that off
This is great for Excel users now I know
beyond this we've done a lot with Word. So why don't you show us what's new in Word
we've improved Word in a lot of ways bearing in mind the collaboration that
people tend to do in Word
here I have a document on organic chemistry
and as I scroll down you'll see that there are a lot of comments
and edits that have been made particularly here or you can see that Alex
left me a comment
and I responded and the threaded commenting features is also something you'll see in PowerPoint
it's a great way of many people collaborating
and threaded comments tell you who said what to who
easy to follow along. Also here I can see that Aaron
has left me a comment, he wants me to change
chemistry fundamentals formatting and I can do that using a
new feature called style pane
style pane here has all of the different ways that I can apply a style
to text and I'm gonna do what he told me
and change this to a main heading
I'm going to select it to heading one you see the change right away
and you can also customize what's in those styles as well
yes, you can change the the fonts the colors and sizes
the ones that I have here put into the introduction to carbon bonding
document that I have
so beyond all this. I know that now that we're cloud connected you might wanna share
this file out with all the
all your fellow chemistry students why don't you show us what's new there
Exactly, so what I'm gonna do here before I do that
is remove the markup. so I say no markup
I just want to make sure that the document looks exactly the way I want
I think this is ready to send and I can send the
I can send the document from right within the app you can see below here
all the people that I've shared the document with already because I'm cloud connected
I'm going to send this document to my teammate Robin
I'm also going to assign edit rights, right from within
the Word experience. I'm going to send that off and it's going to trigger an
email in Outlook and she's gonna receive it
That's really great because it's going to set
permissions to where Robin can see it
edit the document and she's going to receive an email and speaking of the email why don't we
show what's new in the Outlook 2016 for Mac client
The first thing you notice with outlook
is that it's much more quick and responsive than it has been before
because we made a ton of changes
to the performance and reliability piece of the experience
and this includes improved search and also Office 365 push
email support for real-time email delivery
which is great because you wan't have to hit send/receive as often now
using Outlook for Mac
that's right the other thing that we've done is designed all of the features
bearing in mind the fact that people really like to live in Outlook
One of the features that you'll notice right away is conversation view
in conversation view under a particular email subject you'll see
all of the emails in chronological order and the other thing that I
particularly like
is the message preview
so in message preview, even without having to actually pull up the email,
there's a little preview within the Inbox pane which has the first few sentences
and knowing what that is gives you the ability to triage right from your inbox
I'm gonna delete this because they don't think I need that email
That's going to save a lot of people time but I think what's really great here as we
can see better integration with Office 365
we can also see a very familiar look and feel across all of these apps compared to
the other end points that were used to
Yeah and particularly
one of the features that I like that aligns to
Outlook on Windows is the easy navigation
on the bottom between mail, calendar, people, tasks and notes
I'm going to click on calendar as you can see this is a pretty well organized calendar
everything is color-coded and categorized
and now these run on the Mac as well and they sync with Office 365 with
category sync
across your different devices
Ok, so these are really great changes for Outlook
I know we wanted to talk about the newest member of the Office for Mac family OneNote
Yes we launched OneNote for Mac
in March last year. It's a great note-taking experience
I have a notebook here from my carbon bonding class
and I have my class notes, I have sections across the top
and different pages to my right and I also have
not just text notes but I also have images
here's an image of a chemical equation that my class teacher
drew the board and I also have a tab here where I have my to do list with all
my project mates
with the to-do feature right here on the top I have the ability to check off
things as I get them done
I also have the ability to
to categorize something as important with the star and also with a question
mark if that's something I need to attend to later
This is really great story from a note taking perspective because regardless of
where you took those notes
whether it's on your phone whether it was on a different PC or another Mac
those will all show up here just like all the other cloud connected documents that we have
absolutely it runs across all of your devices and what I like particularly about
OneNote is the search capability
especially when you have a notebook with a ton of different notes
you might want to find something from
many months ago search will reveal not just text but it will also reveal text in
the form of hand written notes
and also text that might be part of images using optical character recognition
Great. Thanks. This is a great preview all the different
Office 2016 for Mac Preview Apps
but work I get started how can I start using this today
Yeah, anyone can
get the preview
and I run the apps alongside your existing Office for Mac installation
just go to the link at the bottom of the screen and download the preview apps
and remember the Office 2016 for Mac suite will be officially available this summer
and courses stay up to date with all the news on Office for Mac and everything
else Office go to the Office blogs everyday and visit
Office Mechanics on Wednesday's and as news breaks
Thank you all for watching and goodbye for now.
Office.com/Mechanics