cgs-new-office-16

What's New in Office 2016

What's New in Word 2016 - In this clip you'll learn what's new in Microsoft Word 2016. We'll get started by talking about coauthoring. Coauthoring is a great feature that you can use with colleagues and others to live edit a document at the same time. I can tell my colleague J. Peter's already making some changes to this document by looking in the upper right corner where I see his name displayed. Notice the icon to the left of his name, the green picture placeholder. If I look through this document, I will be able to find where he is currently making changes. Here with this green outline, I can see that he's making changes, and if he were to move to another line within this document, we'd see that same icon shift around the document. If I make an edit, maybe I want to go ahead and change the WaVES, the a in WAVES to be upper case, he'll actually see on the other side the same thing happening. He'll see a color icon that's indicating that I'm making a change, and if he hovers over that my name will appear as well. Now we can see that J. Peter as moved to FLORIDA, and we can continue working. Great. So let's switch this over to Word on the computer. Right now we've been working in Word Online. Just as we were coauthoring online, we can co-author in the application installed on your computer or your device. If you've not used coauthoring before in the application, you will get a caption that appears here giving you a bit more information on what it looks like, what it's all about. We'll go ahead and close out of that. And from this panel, the Share pane, we're able to see a listing of who is also working in this document. Now you'll notice I'm listed here, as well as J. Peter. Well, that's because I'm still in the online application as well. Didn't close that document quite yet. But I can see he's editing in real-time, and if I scroll around I may be able to find where he might be making changes at the moment. And if I'm not seeing that happening or I see something that I have a question about, I can hover over his name and communicate through Skype for Business. If I'd like to take this instant messaging to something a little more collaborative like maybe a face-to-face video call, or even just adding audio, I can use those features that are built into the instant message window. Okay, I'm going to go ahead and close out of this share pane. Let's talk about the Tell me feature. This is new tool to help you find the features that you're trying to use. Let's say we want to change the color background. Page color. And the arrow indicates there's additional options. Let's go ahead and make this a dark blue. There are also new chart types. The new ones are Treemap, Sunburst, Histogram, and Box & Whisker. As well, version history has been updated. Let's take a look at this from the file menu. We now get a pane next to the document that gives us all of the details of each saved instance of this document. So every time changes have been made, if you're making those changes online, with each change there's a new version that's created, or even if you're saving those changes as I am in the application on my computer. I can see the most current version was saved by J. Peter today at 1:01, and then all the previous versions from earlier today. I can go back to any of those versions by pointing to it that I see here. There are more Send As options as well. The Share with People allows you to share things out to a SharePoint site to OneDrive or OneDrive for Business. You can also email, present this online, send it by an instant message, also known as IM, or post it to a blog. Well, just as you can share from here, they've simplified sharing with this Share tab that we were looking at earlier to see who was coauthoring. So let's go ahead and close out of our History tab here. From this Share pane, we can invite people to actually share this document on SharePoint, OneDrive, or OneDrive for Business, just as I mentioned in the File tab menu, but they've just made it a little easier to work with it in this pane as you're making changes to the document. Thanks for watching, and I'll see you in the next clip.

What's New in Excel 2016 - So let's take a look at what's new in Excel 2016. We've got about 12 new things, so there is plenty to see here. First we start off with 6 new chart types. So let me select some data here. And with the data selected, we can head up to the Insert ribbon tab and take a look in the Charts group. We have 2 entirely new categories. And the first one is the Insert Hierarchy Chart. Use this chart type to compare parts to a whole. If I give a click, you can see we've got the Treemap. Right. That's why I selected some data, so you could see something. The Sunburst. And remember, the descriptions are there to help you understand what the charts can be used for. We also have the category here, Waterfall. Give it a click. Here's our Waterfall. As we move on into the Statistic Chart group, statistical analysis, we have a couple that are available in here. So we've got the Histogram, we've got the Pareto, and a Box and Whisker. Now my data is not formatted for all of these examples, but 6 new chart types. We also have 1-click Forecasting. Let's switch sheet tabs and here, click into my data, anywhere in the data. Let's head up into the Data ribbon tab, into the Forecast group, and Forecast Sheet. Look at this. Yes. In a click, we'll be able to predict data trends. I give it a click. There's some different options in here, but after I make some choices, I can create and see how my future data should trend. We have 3D Maps. Now 3D Maps used to be called Power Map. Alright, now it's built into Excel, it's available here, and we find this one on the Insert ribbon tab, 3D Map. How about some PivotTable Enhancements? As far as our PivotTable Enhancements go, one of my favorites is the automatic time grouping. So if I take a date and place it into columns, watch what happens. I get years, but I get more than that. Look it, I get Years and Quarters and Date, automatically. I didn't do that. I happened for me. That really simplifies that. We also have a smart rename feature. And with smart rename if any of the columns and fields that are used in the original data are renamed, they automatically update here. We have a new Search bar to help you search for different fields, so when you have a lot, you don't have to scroll up and down; you can search. We also have something new with the slicer. The slicer now has a Multi-Select button on there, so we can go Multi-Select and just click and click. No Shift key needed. On to the Tell me sheets. Tell me allows Excel to help us pretty quickly. Right up here at the top, Tell me what you want to do. We can click right in here and start typing what we want to do, and when I type in format shape, look at this -- Shapes, shapes did you say? Yeah, we get the whole Shape area and if we have a shape selected, it'll take us directly in so we can format it. I love this quick help. Let me scroll down my spreadsheet. I happen to have a big shape down here. I can select it. Something else that's new. Quick Shape Formatting. So with the shape selected, if I head into the Format ribbon tab and into my Shape Styles, using the more button, we have Presets. If I scroll down, these are new so we can quickly and easily format and make it look great. Moving on, we have the get and transform Query. Now, built right into the Excel interface is a way that we can quickly and easily Get & Transform data from different places: From Files, From Databases, From Other Sources, so very easy to get your data and bring it into Excel and have the ability to transform it from here without having to go to that other data source. Smart Lookup is another new one. And with Smart Lookup we have the ability to look things up on the internet without having to leave Excel. I know, right? So if I select a cell that has something in it, head up to my Review tab, I have here Smart Lookup in the Insights group. I give it a click, I get the Insights pane that opens and shows me all over the internet where to find Ice skate so you don't have to leave the program to find more information. Let me close that pane down. We also have simpler sharing. Take a look in the top right corner. We have a Share button right here that can help you share it very quickly with a few clicks. We've got new themes available. File ribbon tab, Options. And down here we have the new Colorful Office Theme so you can change your theme. And last, but not least, In the File ribbon tab, we have Publish, and now we have the ability to Publish to Power BI right here. So we can share it with our workgroups, our clients, with just really one click. So there is a lot of new things happening in Excel 2016. I hope you found this information helpful and I look forward to seeing you in the next lesson.

What's New in PowerPoint 2016 - In this clip you'll learn what's new with PowerPoint 2016. We'll get started by taking a look at a feature called coauthoring. Coauthoring lets you work together with others from any device to make changes to a document in real-time. Right now, I have a presentation open from OneDrive for Business and I can see that my colleague, J. Peter, I making edits. How I can tell is the upper right corner where I see his name. Notice to the left of the name there is a picture placeholder icon. It has the color orange. Anywhere that I see this icon next to the slides in the navigation pane, I can see where he's making changes. He's currently making changes to slide 4. Let's take a look. Wherever he's making changes, whatever textbox, graphic, sentence, bullet point that he might have selected, that area is going to be called out by a line in the same orange color and that picture icon in the upper right corner of that object or that text box. So we can see that he is currently editing the bullet list on slide 4. Now as those changes are happening, I'm able to see anything that he is deleting, anything that he is typing, and he's creating a fourth bullet point at the moment, and if I go ahead and try and make some changes in here as well, you'll notice I'm not able to select this area. If I select a different object, I would be able to make changes to that. Let's take a look at what this would look like in the application installed on my computer. Now on your computer, you may see something in the top right corner that'll allow you to edit this in PowerPoint on your computer. Instead, I'm going to use a new feature called Tell me to find out how I can easily switch to that. So by typing in this box, I'm going to say edit in power, and it's giving me a list of results. So I want to open this in PowerPoint. Let's go ahead and switch over. Great. You can see in the caption from the top right corner, 3 other people are editing this document. That may not be necessarily true, because I am still editing this online; I never closed out of it. So we take a look at those 3 in the Share pane here, in the bottom you can see there are two instances that I am currently editing these slides, and J. Peter is still editing these slides. Just as we were seeing where J. Peter was editing the slide online, we're also able to see the same thing as he makes additional edits here. I can see that he's editing this, but over here I don't see any of the slides selected at the moment. If he did make changes to one of those slides, we'd see that same picture placeholder next to the slide where he's making the changes, and it would look similar on the slide wherever he's making those live edit changes as well. If I'd like to talk with him or collaborate in some way with him about these changes that he's making, from here I can actually contact him through Skype for Business. So they've made it a little easier in this Share pane to communicate. So I could start an instant message. If I want to make this a face-to-face conversation, I could always enable this as a video call or just add some audio to it. I mentioned the Tell me feature. That's also available from this field here within the application. Let's talk about what's called Smart Lookup. Maybe I need additional information about orange trees. We're going to go ahead and do a lookup. But before we do that, let's close out of the Share pane, and by selecting a word and right clicking over it we can get additional information. This is called the Insights pane, and from here there will be two tabs that you can get information from: Explore and Define. Bing is searching the web and pulling back information about orange trees. I'm able to read in this pane everything that it pulls up from Wikipedia, images from the Bing image search, as well as maybe some websites that are relevant and additional I can click on to browse out to. If we take a look at Define, well, it doesn't have a definition for orange tree. There's a couple other features that have not come down the pipe just quite yet. One of them is called Morph, and this is a new transition that will allow you to bring motion to your presentations more effectively and make sure that you're conveying the concepts and information as you need to. Designer is the other new one that's available. Just by adding an image to any slide, it will give you a gallery view of many different slide layouts and themes and different design elements that you can choose from, and as you make these choices, Designer starts to learn about your preferences and it adapts its recommendations to be tailored to your needs. Now as I mentioned, Morph Transition and Design are not available yet, but you should see those coming out sometime in the near future. From the Insert menu, there's something new called Screen Recording. This allows you to record anything on your screen. You just make a few criteria selections from this menu. The first thing is what area would we like to record. So with our mouse we can drag to an area. Of course, whatever you have on your screen it's recording, whether that's a browser window, something from Outlook, something from another application as you're moving and clicking, and if you'd also like to include audio and recording the mouse pointer. So those can be turned on or off. When you're ready you'll click record, and once you're done you'll click stop and it will import this into the slide that you have selected in PowerPoint with the play controls below it, as a video. While we're talking about videos, there's another new feature I'd like to show you called Higher Video Resolution. This feature is found in Export, and by selecting Create a Video there is a new presentation quality that let's us know the largest file size is now 1920x1080. So if you're delivering this video in a large room or somewhere with a large screen display, this is what you may want to consider choosing for recording that and outputting that into a video format. Great. Let's take a look at a slide that has a table on it now. You may be familiar with smart guides as you select an object and you drag that around, you'll notice a dotted line or a dashed line appearing, letting you know how that lines up with other objects on the slide. See in this line how it's moving around? This used to be something that you would have to enable. Not any more. Anytime you're inserting a table or some other type of an object, it automatically enables those smart guides to work for you. We're going to move over and we're going to select this picture of Ponce de Leon, and we're going to take a look at something else on the Home ribbon. This is called your Quick Styles. Sure, you've had Quick Styles before, but now you have a new category called Presets. You also have some new charts that you can choose. The new ones are Treemap, Sunburst, Histogram, and Box and Whisker. And, you have more Send As options so let's take a look at those. You can Share with People. That would be sharing something out to SharePoint, OneDrive, or OneDrive for Business, as well as Email, Present Online, Publish Slides, or Send by Instant Message. While we're here, let's talk about version history. They've improved that a bit for you. Now what we have is a pane on the right of our document that tells us the most Current version, when that version was saved so we can see the time stamp there, who it was Saved by, as well as all previous instances of the document. There's also something new out called Conflict Resolutions, so as you're working through these versions if you've made changes to the same area or same slide or page as someone else, it will give you the option to resolve that conflict and choose which one you would like to use. And they've simplified sharing for you. In the upper right corner we took a look at the Share tab. This is also a great place that you can invite people to your document if you're storing that on OneDrive, OneDrive for Business or SharePoint. Thanks for watching, and I'll see you in the next clip.

What's New in OneNote 2016 - In this clip, let's talk for a bit about what's new in OneNote 2016. OneNote, which is an electronic note-taking software application allows you to organize information with notebooks, sections, and pages. It is synced on all your devices for anytime access to your notes. OneNote automatically saves so you don't have to worry about losing information. Let's take a look at my notebooks, sections, and pages. Right now, I'm in this notebook called Patricia's Notebook and then across the top, I have different sections, and then in the sections, I have pages. I could have many notebooks, and in those notebooks, many sections, and within those sections, pages. The one thing you might notice with OneNote is this colorful border around it. This is called the Office Theme. If I go to my File tab and I choose Options, I can change the theme, Colorful is the default but if I choose a different one, for instance, Dark Gray, and I click OK, notice the gray borders. If I go back to File, Options, Office Theme, and change it back to Colorful, I'm back to a more colorful design. You can choose what color is best for you. When you first bring up OneNote, it'll bring up a Quick Notes page. The Quick Notes page will give the information about OneNote and if I slide to the right a bit, I can also watch a video, and then it gave me another page of OneNote Basics, so some other information about things I may want to do. After looking through those pages, you'll be ready to get started. OneNote is part of the Microsoft Office 2016 Suite products. It runs on Windows PC, Windows tablet, Windows phone, Android phone, iPhone, iPad, the web, and even the Mac, but you don't have to have a Microsoft Office account to have OneNote, it's free for everyone. You can just go to www.onenote.com, and download a free copy. The Microsoft Office products come in a variety of versions designed for different needs, uses, and computers. There are Office 365 subscriptions. There's Office 2016 Home, Business, Professional. Some of the features have been added to OneNote do not work on all versions of Office. To see what version you have, open the File tab and select Account and you'll see your version right here. So again, some of the options that have been added do not work on all versions but you can always check yours by going to File, account. Many of the new things that have been added to OneNote are apps. The apps are at www.onenote.com and they can be downloaded for free. One of the nice apps is called Clipper. Clipper will let me clip things from the web. So, if I go down to my taskbar, I have a website open that I'd like to clip. So, while I'm in here, if you take a look at the top, I have Clip to OneNote. Once I installed Clipper, this appears on my favorites bar, and then when I need it, I can just click on it, and Clipper will come up. I can have a full page or I can have the article. I'll leave article and I'm going to put it into my Office 2016 Excel book, and then I'll click on Clip, and then it's going to clip the page, and it told me it was successful, I can view it in OneNote online but I'm going to close that, go back to my OneNote, and then I put it into my Office 2016 notebook, in Excel, and notice you don't see it yet, here comes. It'll take a few seconds for your pages to get uploaded so sometimes when you add something, you might not see it right away. Now, if you don't have Clipper, that's okay. On the Insert tab, we also have Screen Clippings or you could go to any website, highlight the text, copy it, come into OneNote and paste. If you have Microsoft Edge, the new browser for Windows 10, you can write on the web. There's an icon to click on, make a web note, and you can jot notes on the screen, and then you can click that information and bring it right into OneNote, but again, that only works with Windows 10. You can also send notes to yourself in an email. I'm going to go back to my other notebook, and I have this tab called Emails. Again, this is something I had to set up prior to working with it but when I go to onenote.com, there's an option to set up me@onenote.com that allows me to email notes to myself. When I go to email, in the address after I had this setup, I type in me@onenote.com, I type in a subject, and then the body of the text. And then, when I send it, it says it here right to OneNote for me, so I can have different emails sent to me using me@onenote.com. Another app Office lends and it's a phone app, it's a great way to capture notes and information from whiteboards, signs, menus, anything with a lot of text. It's great for capturing sketches, drawings, equations, it gets rid of shadows, odd angles, so the images are easy to read. One Lens is a free app that you can go and download. Another option is inserting videos into a page. Not all versions of OneNote allow this at this point but if yours did it, would be in your Insert tab and right next to Online Pictures, you would have Online Video. You choose Insert online video, paste in the address of the link you want, and then click OK, and then you'll be able to get to that online video right from OneNote. With OneNote, we can share notebooks with many people. If I go to the File tab, it shows me my notebooks, I can invite people to this notebook. So, if I wanted to share a notebook, I can click on Invite, I can share with people, type in who I'd like to share with, put in a personal message if I'd like, and then hit Share, we can share notes and things about different organizations, groups, projects, whatever it may be. So, with any of your notebooks, you save them to the cloud, and then wants they're saved to the cloud, they could be shared with other people. I'm going to click back on Info, and again, taking a look at my notebooks, there's an option here to View Sync Status. So, if I want to make sure my notebooks are all up to date, I can click on here, I can sync all, and I'll go through and sync up my notebooks to make sure that I can get to any information on any device that I have. OneNote does sync automatically but I can always come here and sync myself. There are many additional available apps and devices that work with OneNote. To learn more about these, go to www.onenote.com. Thanks for watching and I'll see you in the next clip.

What's New in Outlook 2016 - In this clip, let's talk for a bit about what's new in Outlook 2016. Outlook 2016 for Windows has all the tools and functionality you've been used to before as well as new improved features for professional email, calendar, contacts, and task management that help you communicate faster and easier. If you take a look at the interface it looks very similar to Outlook 2013. The one thing you will notice is the icons at the bottom left to change from Mail to Calendar are smaller. This can be changed if desired. So when I come down here to the bottom left, and I go here to Mail, and then Calendar, People or Contacts, My Tasks, they're small icons. And I click on the dot-dot-dot, Navigation Options, and I'll clear Compact Navigation, and click OK, and now you'll see there's larger names that we had in 2013. Now I'm going to turn that back. Navigation Options, Compact, to make it smaller. The other thing you might notice is this blue background up here at the top. This is called the theme. If I go to my File tab, Options, Office Theme, Colorful is the default. If I pull down the dropdown, I'll choose Dark Gray, I'll click OK, and now notice the gray background. I'm going to go back to File, Options, change it back to Colorful as the default, and click OK. Another thing that changed is the way we work with help. If you look here at the top it says Tell me what you want to do. If I click in there, I can type something that I'm interested in. So let's say I'd like to create a task. If I type in tasks, notice it shows me some choices. I can have a task, I can have a follow up, and then you'll see Arrange By, To-Do Bar, Remove from List, some other choices that are currently grayed out. But if I click on Tasks, it'll take me to My Tasks list and I can add a new task. So I can click on New Task and I need to update my project plan, and then I can fill in the information as desired. I'll give it a due date for Friday, and then I'll save and close. So it helped me create a task. Any time I need to do something I come in here, what would you like to do, and I'll type in new email. And then again, if I click on New Email Message, it'll take me right there. So when you're not sure what to do, click in the Tell me box and start typing your question. Another thing that changed is working with attachments. So since I'm in a new email, I'm going to click on the Insert tab. I'm going to go to the Insert tab, I'm going to click on Attach File. Look what happens when I choose Attach File. It's going to show me recent files that I've worked on, and if I want one of those I can click on it and attach it. Not only does it attach it, if I pull down the dropdown I have some options for it. If I don't want any of those options I can just click off of that to get out of there. If I go back to Attach File, take a look down here, I can browse for web locations on my OneDrive, or other web locations that I've been to, or I can browse this PC. So this list will change as I use different files and then I can choose which files I'd like to attach. If I don't need to attach anything at this point, I can just click somewhere else. I'm just going to close that and not save it, and then down the bottom left I'm going to go back to Mail. When I get back to Mail, another thing that we can do is search. Outlook 2016's email search is faster, more reliable, and provides improved performance. You can seamlessly search emails across your local computer, Exchange 16 Server, or Office 365 mailbox. So if I'm looking for a message, I can come up here, I click in the Search Current Mailbox, and when I click in there, notice the search tools come up and I have additional options here. I'm just going to type in the word dell, and then when I do, take a look at the messages that it found. So it found all these messages that have the word dell in it. If I want one of them, I can click on it and then read the text over here. When I'm done, I can click on that X, it'll take me back to my inbox. So when you're looking for something in Outlook, click in Search, and then when you click in Search take a look at your tools that you have, type in your keywords, and then when you're done, you can just click anywhere to get out. Another folder you might notice on the left side is called Clutter. Clutter is something new and what this allows me to do is to move things into the Clutter folder. There're things I don't really want to look at, things that are cluttering up my inbox. So if I go to my inbox and I have a message from someone that I don't want here, an advertisement, I can just drag it and drop it into my Clutter folder. When I do this, Outlook's going to see my pattern and based upon my pattern, it will choose automatically things to move to Clutter. You will know if you have something in Clutter, that's a new message because you see the number next to it, but from time to time you might want to click on your Clutter folder to see what's in it and make sure everything there is what we would consider things that are cluttering our inbox. Another thing you might notice is groups. In Outlook I have the option to create groups. Groups would be used instead of distribution list to communicate and collaborate with your team members. A group is a shared workspace for email, conversations, files, and calendar events where group members can collaborate and get stuff done. I have a couple of groups already created, I have an Office 2016 Team and Office Move team, and Windows 10 Upgrade, but I can create additional groups. Notice when I clicked on one of my groups, I get on the ribbon tools to work with the group. I'd like to create a new group, so I'm going to choose New Items, and then Group. It's going to ask me for a group name, I'm going to type in QRC for Quick Reference Cards, and then you'll see it gives me a group ID and it says it's available. So it looked to see if that group has already been created. I could have it as public or private. If I leave it to Public, anybody can join it. If I leave it to Private, I have to approve the members. I'll leave it as Public, and if I'd like to I can check this to subscribe new members so they can receive group conversations in their inbox. And then I'll click OK, and then it's going to create the group for me. At this point I can add people, and if I come in here and start typing I can choose someone and add them as a member. I can put a description about the group so when somebody is looking at that they'll have a better idea what the group's about, and then I'll click OK. Let me just click on one of my other groups for a minute and then come back. Sometimes it takes a little bit of time for these things to get updated on the server. There we go, and now my group is ready. So now if I want to, I can start a conversation, add a calendar item, add some files, create a one book notebook and put the information there for the individuals of my group. So if you have a team and you need a place to work, you can create a group in Outlook. With Outlook 2016 there's a lot of new enhancements to help you work better. I hope you learned some tips. Thanks for watching and I'll see you in the next clip!

What's New Access 2016 - In this clip, let's talk for a bit about what's new in Access 2016. Access, which is a database management system, has all the functionality and features you're used to, with some added enhancements, and the best new features from Office 2016. If you're upgrading from Access 2013, you'll still have all the features you're used to, and you'll notice a few new ones as well. The first thing you'll see when you open Access 2016 is it has the familiar look of 2013 with a more colorful border. I can change that if I'd like. I can go up to the file tab, choose options, and we have office theme. The default is colorful, but I can change that to white, and I'll click okay, and now notice the white border. I'm going to go back to file, options, and then change this back to colorful, which again is the default. Something else that has changed is the way we work with help. Up here, there's a box that says, tell me what you want to do. I'm going to click in there, and then I can tell Access what I'd like to do. I'd like to sort my list, so I'm going to type in the word sort, and then when I do, it'll show me choices. And I can point to the different choices, see what I have, and then when I find the one I want, which I'd like sort descending, I can click on it, and then when I do, take a look. My list is sorted in descending order. If I go back to tell me and I click in there, it shows me what I just did. If I want to do something else, let's say I'd like to create a form, I'm going to type in form, and then take a look at the choices. A blank form, a regular form, use the wizard, client forms, a bunch of different types there. So again, it's given me helpful information, in this case, with forms. And then if I don't want anything, I can just click somewhere else and that box will close. Another thing we can do is create a list of links that we have, and put that information in Excel. I have some items here that are linked to my database that are not part of Access. And if I'd like to get a list of these in an Excel file I can. I'm going to choose the external data tab, linked table manager, and then it shows me all my links. I'm just going to choose the first two. And then to the right, export to Excel. And then when I do, it wants to know what I'd like to call this. I'm going to call this one access links, and then I'll hit save. And then it brings up an Excel file, and shows me those, where they are, and again the type of file. So if you have an Access database that has a lot of links, this might be a very useful feature. I'm just going to close Excel for now, and I'll close this dialogue box as well. Another thing you'll notice when you're working with Access, is there's a larger show table dialogue box. So for instance, if I go the create tab and I choose query design, here's my show table, and look how large that box is. So one of the enhancements was to make this dialogue box larger, so if you had a lot of tables, you wouldn't have to scroll. So any time you go to a show table dialogue box, you will see the dialogue box looking like this. I'm just going to close that for now. Another thing that has changed is if I go to the file tab, and I click on new. Access has templates. We have templates for web apps, and for desktops. The desktop templates have been enhanced. They've been given a new modern look and feel. If I'd like to use any of them, I just have to click on it. So I chose this one for a desktop student database. I'll name it here, student, and then I'll click create. It wants to know if I want to save the changes to my other table that I was in, because in Access again, we can only have one database open at a time. So I'll say yes to save those changes, and then it's going to bring up the template, and it shows me here a welcome screen. There's a video if I'd like to watch, or some information here. I'm going to click get started, and then you'll see the student database has been created. I'm just going to hit enable content, just a security warning. And when I do, it's going to bring back that welcome screen. I'll click, get started, and now I can see all tables it created, the queries, the forms, reports, macros, modules. So it created all these objects for me. I could just start adding my new students to my list, and then as I need, go to the other objects and work with them. So again under file, new, many of these templates have been changed to a new modern look. There have been a lot of changes to the Access web apps. Customers using SharePoint 2016 with Access services within their organization will see additional features, and take advantage of service improvements. The list of Access web app features in Access services for SharePoint 2016 include, cascading controls, data sheet filter improvements, related item control enhancements, image storage and performance improvements, Office added integration with Access web apps, additional packaging and upgrading functionality for Access web app packages, on deploy macro action for upgrade scenarios, locked tables for editing functionality, and then download in Excel features for database views. So with SharePoint 2016 and Access services, a lot of enhancements have been made to the web apps. Access 2016, take a look at the new features and see what you think. Thanks for watching, and I'll see you in the next clip.

What's New in Visio 2016 - In this clip, we'll look at what's new in Visio 2016. Visio is a very powerful diagramming tool that's really an extension of Office. With Visio you can create simple or complex diagrams, that can be eye-catching and informative. So with the release of Office 2016 what changes have been brought to Visio? Well, one thing you might notice when you first open Visio 2016 is there's more color. You'll notice up here in the ribbon by default, you have a new theme that's enabled. Really this is a feature that extends across all of the Office products. To make changes to your theme's appearance you can go to File, Options. And under general you now have a drop down for Office theme. You can select from colorful, dark gray, or white. Now white really gives you the same appearance you had with Visio 2013. Selecting colorful here really amplifies the accent color that was previously only visible on the File tab. Dark gray is a completely new theme choice and this brings multiple shades of gray to your ribbon and menus. Besides these increased color choices, you might also notice that some of the clusters of controls up here on the banner have been spaced out a bit. With Visio 2016, attention was given to some of the stencils that are used in some of the popular templates. You'll see that some of these stencils have been modernized, others have had extra details added to them and some have been updated with more modern shapes. Let me give you an example. I'll open a new drawing here using the Office layout template. I'll expand the shapes pane as I look at these stencils, you might notice right away that some of these shapes have been updated. You can see nice contrast. It's very easy to see. As another example here in the Office accessories stencil you'll see that there's a lot more shapes that there used to be and the shapes themselves or have much more detail. Now tell me, who couldn't use a pool table in their Office? You may also find the addition of people to be a nice accent to add to some of your drawings. Some of the other templates that have been updated include site plans, floor plans, home plans, and if you work with electrical drawings, you'll find the basic electrical template has had a lot of work done to it. Shapes are now I-EEE compliant. You find the shapes and the stencils to be much more functional with increased capabilities such as auto-snap. Now it's not just eye candy with Office 2016. There are some noticeable improvements that will also improve your workflow in some situations. For example, it's not uncommon to prepare data in an Excel spreadsheet that's easily accessible and can be quickly modified. That external data can be brought in to Visio and linked to shapes and diagrams. Here I have a floor plan and you can see that there's quite a few Offices but there's no information here. So I'm going to bring in an Excel spreadsheet that has names, titles, phone numbers, information about the occupants of these offices. Now I used to involve a few different steps to it that information into Visio but watch how easy it is now from the data tab. As you can see there's a quick import button right up here on the ribbon. I'll point this to my Excel spreadsheet and it will start to analyze the data and here it quickly compiles all of the data from the cells on my spreadsheet. Of course, as before, once that's done I can now easily link this data to my drawing using the link data tool. Here I can select the two fields that correspond to one another and here just that quickly my diagram has been updated with all this information. Now in the feature if something changes, and Office is re-assigned, a phone number changes, it's simply a matter of updating the Excel spreadsheet and the diagram gets automatically updated. Visio 2016 also brings important improvements that will benefit organizations and businesses that wish to implement information rights management. You'll notice a new button when you select File and here under info, you'll see Protect Diagram. This tool allows you to select restrictions for your diagram. This tools requires the use of Azure or active directory rights management servers. By placing restrictions on your diagram with information rights management. You don't have to depend on the discretion of people that you work with, or collaborate with. You can actually use information rights management to prevent them from forwarding a diagram to others with email. You can also prevent common tasks like copying or printing. So using the Protect Diagram button can really enable you to protect sensitive or confidential information. Another nice new feature with Visio 2016 is the presence of starter diagrams. Now generally in the past when you would open up a new drawing, you would select your template from the choices available, and then you start with a blank drawing. But you can still choose a blank drawing as your starting point but you'll find that many diagram types now include starter diagram templates. You'll find that these starter diagrams include content that's already been placed on the page as well as some tutorial information. Often you'll find more than one starter diagram available. You may find with the starter diagram that many of your essential components are already on the page and it's simply a matter of re-arranging these to suit your needs. Another great thing about starter diagrams is that for many people they may use Visio for one or two basic tasks but many of the other diagram types are mysterious to them. So starter diagrams help you to visualize a little more how these diagrams can be used and with the presence of tutorial information, you may see ways to use these diagrams in your workflow. Finally, you may have noticed up on the banner, there's a new text box up here. Tell me what you want to do. Now I'll admit, the first time I saw this I thought that this was just a link to some of the help documentation but you'll find it to be a pretty useful feature. The Tell Me tool helps you to locate controls and commands as well as help documentation that will help you accomplish your task. It can be especially useful when you have something selected in your diagram. Here I'm going to place a shape in my work area and here just for the sake of the example, I'm going to use a tools that's not used very often. In fact, it's not even located on a ribbon. But if I want to take this three dimensional tool and break it up into different shapes, I can use a tool called Fragment and here you can see in my list of results that Fragment is right there at the top and I can simply select it. And now I can grab individual components of that shape. You'll find the Tell Me tool to be a quick and easy way to find tools and commands that are especially relevant to things you've selected in your work area. This is going to be especially useful to people that work with a smaller screen and prefer to work with a ribbon collapsed. In this clip, we've looked at what's new in Visio 2016. Thank you for watching.

What's New in Project 2016 - In this clip, let's talk for a bit about what's new in Microsoft Project 2016. Project is a project management software program designed to assist a project manager in developing a plan, assigning resources to task, tracking progress, managing the budget, and analyzing workloads. In Project, there are a host of improvements and new features to help you be more productive. Let's take a look at the interface. Across the top you'll see the interface looks very similar to what it did in 2013 with the Quick Access tool bar, the ribbon, TIMELINE, and the GANTT CHART view as default. One of the things we can change is called the Office Theme and that's the coloring that you'll see. The default is called Colorful, but if I go to File, and I click on Options, to the right you'll see Office Theme, and if I change it to one of the other colors, I'll choose Dark Gray, click OK, notice how the colors have changed. I'll go back to File, Options, Change that back to Colorful, and click OK. So if you don't like the colors you can always change the Office Theme. If you look across the top here, there's a box that says Tell me what you want to do. If I click in there, I could type something that I'd like to do. Let's say I'd like to change the start date of the project. So I'm going to type in there start date, and then, notice it brings up suggestions. I can point to these, take a look at the description, see if any of these is what I'd like, and I do want this one here that says Project Information. I'm going to click on it and when I do, notice I can change the Start date. I brought the Project Information dialog box up and gave me the opportunity, if I'd like, to change that start date. I'm just going to hit cancel for now, and if I click back in Tell me you can also see the last things you were working on, type something else new --- let's say I type in the word resource, and then also I can get Help. Now if you want to get regular Help, notice the question mark is no longer here. But if I press my F+1 function key, it'll bring back the Help screen and I can Search for something or click on these different topics. So there's plenty of help available in Project 2016. I'm just going to close that for now. Another thing that has changed in Project is working with timelines. Timelines are now more flexible. You can have independent start and end dates; we can drag and drop items between timelines, and then we can save the information to a PowerPoint presentation in email or copy the screen. So if you look across the top here, we have a timeline. I'm going to click on it to make it active, and let's say I'd like to add some tasks to it. So I can select my Task, right-click, Add to Timeline, and then you'll see it adds those tasks to the timeline. Well, let's say I'd like a second timeline. I'm going to click back up here to make the timeline active, and then take a look, Timeline Tools, Format tab. On the Format tab, I'm going to choose Timeline Bar, and when I click on that you'll see it adds a second one. Now I can choose different task for that bar and make it active first, select the tasks that I'd like, and then right-click, Add to Timeline. If I'd like to change the color of those, I can click on a task, fill paint can to fill the background color; I could pick a different color. So let's say I'll take a, how about a yellow, and notice the changes. So I can change each of the tasks to be different colors just so they stand out a little better on my timeline. I can also take a task from one timeline to another just by dragging it and moving it. So if I'd like it to go from a different timeline, just drag and drop. I can also change the date range of a timeline. I'll click here in the first one, click on Date Range, and I'm going to use custom dates. I'm going to choose the Start date of the project, December 3, and let's say I want this one only for 2-weeks, so I'll choose the 17th, and then I'll click OK. Notice the timeline is much shorter. Once I get my timelines organized the way I like them, I can copy my timelines for E-mail, for PowerPoint Presentation, or for Full screen that I can take and copy this information into let's say, Word. If, by chance, your timeline was not displayed, on the View tab there's a choice for Timeline that toggles is off and then toggles it back on. So if you'd like to use it you can have it on, if you don't you can always turn it off. Some other features that they added are, if I go to the tab across the top that says Project, there's a Store icon. There are many Office add-ins that you could download from the Office Store that add functionality to Project. So this means you can customize Project to your taste. So when you have time, take a look at the store and see if there's any options that could be helpful for your project environment. Project 2016 includes significant updates to Project Professional, Project Pro for Office 365, and Project Online with Resource Management and Resource Capacity Planning. With Project and Project Online installed, we can do Resource Engagements. Resource Engagements allow you to schedule resources by a resource manager so the project manager submits a resource engagement to the resource manager, the resource manager can accept that engagement for a resource, and then when they do, that resource can be assigned to task. We also have the Resource Manager Experience, in that a resource manager may not be interested in all project, just resource information and they have views that just allow them to understand that capacity of utilization with their resources at a glance. And then there's the Resource Capacity Heat Maps which allow you to see resource utilization either under or overutilization with different colors on the screen. So if you have Project and Project Online, there's many additional features you can use. So go take a look at some of these new features in Project 2016. Thanks for watching and I'll see you in the next clip.

What's New in Publisher 2016 - In this clip, we'll discuss the new features of Microsoft Publisher 2016. Now, some of these features may not be necessarily new, but there have been some improvements, that make them easier to use or more easily to find for use. So to get started, we're going to talk about simplifying working with photos, then we'll move onto personalizing your publications by the use of Mail Merge, and finally, we will wrap up this clip with publishing in a way that works best for you. So I've started a publication here called Travel the Globe Newsletter and I'd like to add some images and make some changes to my text, just to kind of polish it up a bit, before it's finalized. So let's first take a look at some of the new effects, that are available for text. Select Newsletter, and once I have some text selected, you'll notice there's two contextual tabs, that are now appearing at the top of my ribbon, Drawing Tools and Text Box Tools. Let's take a look at the Text Box Tools format ribbon. With this ribbon, there are many new things, that you'll discover, but the ones that we're going to focus on right now are called Typography. With Typography, we can use many different things, like Drop Case. Now, if I pick one that doesn't fit correctly, you're going to see that the handles of the outlined area for the text are now shaded red. If I go ahead and expand this, we should be able to see the text in this area, once it's able to fit, so this is what the newsletter would now look like. That may not be the best thing that we'd like to do, so let's go back to Typography and let's reset that. There's also some Number Styles available. If there's a way that you wanted to proportionally use an old style, if you'd like it to have proportional lining or the default style, as well as Ligatures. Now this can improve text readability. You also have some stylistic effects, that you can use or if you'd like to make sure that Ligatures are not used at all, you have that setting as well and finally, there may be some Stylistic Sets and Stylistic Alternatives available. While we're talking about effects, let's take a look at some of the effects that are available for pictures. Now, before we can actually check out the effects, we need to add some pictures to this publication. There is an easy way that that can be done. By restoring this application down to a smaller size, we'll go ahead and drag this over to the right side of the screen and we will open a folder, that we know has some pictures available, that we would like to use. Go up to these sample pictures and we're just going to drag and drop these right over the publication. That's OK, we're not going to leave these in the publication. What we're doing is we're getting these out to the canvas, so that we can arrange them in the scratch area, that surrounds our publication. Great, we have some images to work with. We'll go ahead and close this file, restore this application to a larger window and I could manually size each one of these photos to make it smaller and drag them out to this scratch area to the side of the publication or instead, if I have each of these images selected, with the handles appearing around each of the images, we can use something new, that's found on the Picture Tools format ribbon, called Arrange Thumbnails. This does two things at once. We've actually resized these to be thumbnails and it's auto-organized them in the scratch area next to the publication. Now, as I want to try an image, that I'd like to work with in this publication, I can drag it on to the screen, resize it as I would like to. If I find that it's not something that I want to use, I can drag that back to the scratch area and try another image. Let's go ahead and place that picture back on the screen. Let's take a look at some of the effects, that are available for this image now. So while the image is still selected, I have a contextual tab at the top called Picture Tools Format and I go into this format ribbon. There's many things, that I can apply to this image. I can do some color Corrections. As I hover over this, we're getting a live preview of what this would look like. We can actually recolor this completely. Maybe we'll go with something like this. As well, I have the Picture Style Gallery, which gives me some additional options of giving this a beveled edge, a three dimensional type of a frame, or even some shadowing and while we still have this image selected, let's take a look at a new way, that we can actually use this image to create a high resolution background for this page. With a right click over the image, I'm going to select Apply to Background and I have two choices, I can apply this as a Fill, which means it's going to use just one image, or as Tile, which means it's going to be many thumbnail images, that are filling the background. I'm going to go with Fill. There you go, and now I can actually move this back to the scratch area, or delete the image altogether and the background would remain. Now, of you notice over to the left in the Pages pane, it's only applied that background to the first page. Any additional pages in this publication would still have different images, that could be applied as the background for each page. The next topic is Personalizing Your Publications by Use of Mail Merge and for this one, we're going to switch to another publication. I've already started creating some labels. So we'll move over to the Mailing Labels publication and if you take a look at the top, you can see that I've already selected the Mailings ribbon. This is where you'd need to go to work with Mail Merge. If you've ever used Mail Merge in another Office application, like Microsoft Word, this should look fairly familiar to you. Starting on the left is where you would select what type of Mail Merge it is that you're working with. If you'd like to use the Wizard. The next is if this is going to be an Email Merge. So if you're using this publication to send it out by email, that would be your next choice. The third step is selecting your recipients. I'm using an Excel spreadsheet, so I've already created a list and I've associated that with this publication, as you can see here and I don't really need to edit my list, so I'm going to move on to actually including an Address Block for this. Everything looks good and I'm going to go with the defaults for that. We've inserted the Field Address Block. If I'd like to go ahead and take a preview of this, here's how I can see how this label would look. That's great, but there's something else we can do with this. With your Mail Merge, you can now include email addresses and even links and photos, but I'd like to add a photo directly to this Label and just as we were talking about pictures earlier and how you can actually include a picture from the Bing Image Search or actually from a social media site, you can do that here as well, but in this instance I'm going to choose a file, that is on my computer. The third area that we're going to discuss are all the different ways that you can publish, that works best and for this one, we're going to switch to another publication. So we're going to be working mainly from the File tab and we're going to start with the Share area. So talking about emailing out a publication, you can send just one page, you can send the entire attachment or you have the choice to send it as a PDF or XPS. Now let's talk about the difference inside this. If we were to send just one page, it's going to send the page, that we have selected, so it would just be the cover of this cookbook, that would be sent out. If we go back and instead we select Send as Attachment, you're sending the entire publication in a PUB, a PUB type file format. That's great, but what if they don't have Publisher on their computer? Instead, you may want to send it as a PDF or an XPS file type. With any PDF reader, or anyone that has Microsoft Windows installed on their computer, they would be able to open these files and actually see everything just as you've designed it within Publisher, the layout, the images, the formatting, the fonts that have been chosen, any styles that have been applied, everything will remain unchanged. By choosing PDF or XPS, this also gives you assurance that the content will not be easily changed. The last topic is Photo Printing. I mentioned if you'd like to send this off to a print shop, there's something new, that's available now and that's from the Export menu. Here again, you have a couple of choices, that you may have seen in the previous menus. Another way that you can easily create a PDF or an XPS document, you can also publish this as an HTML file or change the file type, if you'd like. This is a great place to go if you need to make this either compatible with an older version of Publisher, or actually change that image type to a PNG, a JPEG, a GIF or a TIFF, but if you're saving this to send it to a print shop, you may want to use the Save for Photo Printing. This gives you the capability again to choose whether it's going to be a JPEG or a TIFF file, that's typically what print shops will be requesting. If it is for a commercial printer, you have some additional options here as well. Commercial Press is going to make that the largest file size with the highest resolution, highest quality available, but you do have some additional options, if you need to lower that some, or make sure that it's the smallest size file for onscreen display. As well, if you're saving this for another computer, you can use the Pack and Go Wizard to take that publication to another computer. Thanks for watching and I'll see you in the next clip.

What's New in Skype for Business - In this clip, we'll talk about all the new features of Skype for Business 2016. To get started, let's talk about the application interface. If you formerly used Skype or Lync 2013, this should look pretty familiar to you. As Microsoft has taken both applications and brought the best to this new application. Now what we're looking at here in the me section at the top, is the color icon over my picture placeholder. You see that green check mark? Formerly, in Lync 2013, to the left of what would be the rectangular shaped or square shaped picture placeholder would be a bar with the color indicator letting you know what the status was currently set to. Green for available, yellow for away, red for busy or in a meeting. You get where I'm going with this. So now, directly over the picture you will see a round icon, like these, that'll indicate the status. Same for any of the contacts that you have listed in the lower area. Notice those are all round now as well, with the same type of status indicator overlaying the picture. Now something else that you'll notice on this main interface that's changed, is a smiley face at the top. This is a way for you to provide feedback to Skype. So by selecting this, it'll take us out to the Skype for Business page. Let you know how many ideas have been suggested, so you can actually add your own ideas. You can go ahead and take a look at all the current ideas that are out there and vote for which ones you like. And you can also share ideas of how you're using Skype with others. Great, let's take a look at some more features. I'm going to start an unscheduled meet now. And you may notice a few things that have changed here, as well. So anytime you're in an instant message, it could be a scheduled or unscheduled meeting. Whether or not you have certain features enabled like an audio call or a video call or sharing out some content, you're going to see that there are some new icons in this area. We'll start with the top right. You'll see what looks like signal strength, and this is your network quality. This is going to indicate to you, is the quality good enough for you to be using video, for you to be using the audio call, or sharing some type of presentation content out? At the bottom of this area, you also have additional call controls. So a quick easy way for you to be able to place your call on hold, transfer your call maybe to another device, another number, or switch what type of devices you're using, like a headset. If I go ahead and expand the instant message area to the side of this conversation, we have some new emojis available. They're called smileys now, but of course it's more than smileys, and these are all of the ones that were available in Skype. We also have some animated emojis, so let's find our ninja. And there you go. There's also what's called call monitor. So maybe I want to stay in this conversation, but I really need to use my screen to work on something else. Maybe I have a document or I need to do some research online. I can switch the size of the screen by minimizing it here. While that's minimized, I get this compact call control area, where I can easily hang up the audio call, mute my mic, or unmute. If a video stream is being shared, I'd be able to see that in this compact window. And if I'd like to bring the call window back, I just double click over my name. Now this is always going to stay on top of whatever you're working on. So if you have something full screen just keep in mind this will overlay on top. And that's important for you to know because the function of this is to remind you that you are still in this conversation. So I'm going to go ahead and double click on my name and bring it back to the original size. The last new feature, really it's more of an interface change to discuss, is presentable content. The icon still looks the same. Still looks like a monitor. But when it's selected, in the previous version it looked like a caption gallery, where you had icons to click on in a table view for presenting your desktop or presenting a specific application. Maybe PowerPoint files, brainstorming with a whiteboard, sending files, or using that Q and A, or taking a poll. Now you'll notice that we have what is a vertical format list that you would select from. And if you don't see what you would like to present in this menu, you'll go to more and see the last three choices. Thanks for watching and I'll see you in the next clip.

What’s New in Outlook on the Web - In this clip, let's talk for a bit about what's new at Outlook 2016 Web App, also known as OWA. OWA is supported by many operating systems and web browser accommodations. But not all OWA features are available in all accommodations, some of the features you see might not be available on your computer. Let's take a look at the screen. Right now, I'm looking at Mail but I can switch to Calendar, People, Tasks by clicking on my Office 365 icon. Let's go take a look. Up here at the top, if I click on my icon, I'll take a look at my calendar. Or I can go to People on my contacts. Or get to my tasks. So depending on where I need to be in Outlook, I can quickly switch. I'm going to go back to Mail. One of the new things added to Outlook was Apps. There's a Bing's Maps, Suggested Appointments and Action Items. These Apps attempt to anticipate your needs and automatically propose actions. You might want to tick by using the content of the email message. For example, if an email message contains a street address, the Bing Map offers you a Bing tab with a quick link to a map and directions. Take a look at my screen, I have an email message here that says, Sam's Address. Notice the address, has the blue dotted line. If I click on it, it's going to bring up a Bing Map and then I can choose the address I want. Since it's not sure which one I need, I want this one here. Now it finds that location. Down at the bottom, I can click Get Directions, and then it'll bring up a whole map and that'll give me opportunity to type where I'm coming from, to get to that address. I'm going to close this and then I'll click somewhere else to get rid of that little Bing Map. Or, if a phrase in the email message suggests the possible Action Item, the Action Item's app creates a suggested task for your review and offer to meet, is suggested as the appointment to be added to your calendar, thanks to the suggested appointment app. Let's take a look at this. I have an email message here, with a date. When I click on that, again, notice the blue line. When I click on that, you'll see it thinks it found an event and it would like to add this event to my calendar. So if I like to, I can schedule it or I can edit the details. I'm not going to edit, I'm just going to click here for now to get out of that appointment. If you take a look at the left, there's something called Groups. Groups is another item that has been added to Outlook. Groups are a better way to collaborate with teams. Now you have a shared place for all your email conversations with full history, allowing teams to engage with members right from the group's inbox. Create team events, join existing groups or create new ones. If you have a team of people, then you might want to create a Group. I'm going to create a Group, I'm going to hit Create group, and then you'll see it brings up the Create pane on the right. It wants me to choose a name, I'm going to choose Office Tips, once I typed in the name, you'll see that that group is available, it wants a description, in the description, I'm going to put, Tips and Tricks for Office 2016. The purpose of the description is for anybody who wants to join your group, to have an idea of what this group is about. Below that, you'll see here for privacy, I can have a public group or a private group. Public, anyone can join, private, I approve the members. I'm going to leave this as public. English, I'm going to check this. Subscribe new members so they receive group conversations and calendar events in their inbox. Once I have this filled in, I'm going to choose Create and then I'll create my group. Now, it wants to know if I'll like to add members. So if I click here, I could type in an email address, found the person I want and if I want to add more, I could add more. I'll just add this one for now. And then across the top, I'll hit Add. Now my group has been created, you'll see here, it's ready to go. Some information and then over here on the left, you'll see the Office Tips. If I right click on that and go to View details, you'll see I can create a conversation, add a calendar item, add more members, upload some files to OneDrive for business, I can add notes in OneNote, so if I need to add something or change something for this group, I could do so. I'm just going to click down here, to get out of that for now, but if you have a team, you might want to think about creating a group so you can communicate together. I'm going to click back on the inbox and if you notice right below the inbox, there's a folder called, Clutter. I'm going to click on Clutter, and I have some items in my Clutter folder. What Clutter will do, is move messages for you automatically into this folder, based upon your past history. If I go back to my inbox, and I have a message I don't want, it's just cluttering up my inbox, like you're just an advertisement. I could take it and drag it and drop it into Clutter. Another one here I don't want, I'm going to take it, drag it, drop it into Clutter. And then I'll click back on Clutter and those messages have been added. Outlook will start to see my patterns and automatically move things into Clutter based upon my past history. But it's a good idea to click on your Clutter folder, just to make sure that whatever gets added to here, is items that you do not want. You'll always know if you have something new, because you'll see, again, the number of new messages. I'm going to go back to People, so I'm going to click up here, go back to People and if I'll like to add anybody to my contacts, I have New up here, to add new contacts, I can Manage, Edit, Delete my contacts, make somebody a Favorite. But a new thing that's been added, is we can create links for people. For instance, I have two Dan Kennedys here. Created it twice, I'd like to make this one contact. So if I click on the first one, I'm going to Ctrl Click on the second one, to select them both and then up top, I'm going to click Link. When I click Link, you'll see now, it made it one contact with both email addresses. The other thing you'll notice in Contacts is, the groups. You can also create your groups right here, from Contacts if you need. At this point, I'll like to go to the Calendar, so I'm going to click on my Office 365 icon, and choose calendar and then take a look at the calendar. Up here in a monthly view, and I have my items down here, if I click on a day, take a look, I have on the right side now, an agenda for the day. Any day I click on, it'll show me what I have for that day. If I want to change to different ways, the day view or week view, I can easily do so. But something I can do now, is display multiple calendars. I'm looking right now, the calendar which would be our work calendar. I'd also like to see my home calendar, so if I click on home calendar, you'll see it adds that calendar. Notice the two calendars are merged together. The items here in this greenish color, are my home calendar items, the blue are my work items. I can see them all together, if I want to take my home calendar off, all I have to do is, come up here, click on that little X and I'm back just to my work calendar. If I'd like to see more information about any of my calendar items, I could just point to it and then when I point to it, you'll see it brings up a pop up and shows me that information and again, from here, I can Edit or Delete that item. Then I'll just click somewhere else to deactivate that. It's a good idea to put items on your calendar, so I can always add a new item for anything that I need to do, so that people who want to schedule meetings with me, will see that I'm busy, I can have additional calendars, I could share my calendar, I could print my calendar. But it's a good idea to keep your calendar up to date. I'm going to take a look at Tasks, I'm going to go to Tasks. Now see I have some tasks on my task list. You can add tasks, just by clicking on New. Or I can delete or categorize tasks, add a charm or a little picture to it, or complete it when it's done. I can also get tasks on my task list, by flagging the item in mail. So if I go back to Mail, and I have an item in my inbox, that I need to get back to, I can flag it. When I flag it, you'll see it turns yellow in my inbox and then if I go back to Task, I have that item in my task list. So your Tasks will keep anything that you flagged in mail or any new tasks you create. As you can see, the Outlook Web App, has a lot of new and exciting features, go try some. Thanks for watching and I'll see you in the next clip.

What's New in Delve - In this clip we'll discuss the new features of Microsoft Delve. Delve helps you discover documents and people in Office 365. Let's take a look at what's new in the people experiences area. We're going to start with what's called Favorites. If you take a look at the content cards that are displayed on my home page, in the upper right corner of each of these cards you'll see a gray star. Now this star signifies if this content can be made a Favorite. There may be certain document types that aren't available yet for you to create Favorites, but most of the Microsoft documents you are able to do that. Let's say, for example, this SAVE THE WAVES file. Let's make it a Favorite. I'll click right over the star. The blue highlighting now is indicating that I have made that a Favorite. And to see all of my Favorites, I'm going to go to the Me area and then over to the Favorites tab. So here's the SAVE THE WAVES that I just made a Favorite, and if I scroll through this list, I can see all of the other content cards that I've also made Favorites. At any time, I can decide to no longer have this document as a Favorite by clicking directly over the star again. Now we started by marking a content card as a Favorite from the home page, so you can actually see what are Favorites in either that feed on your home page, or right from here within the Me page in the Favorites tab section. Another new feature of Delve is the People-based Search and Discovery. Sure, I can use the Search field in the upper left corner here to find everything there is to know about my colleague, Tim. And here I'm able to see search results for everything that Tim has, either created, edited, marked as a Favorite, something that he might be collaborating on. But instead, if I just go to the People area and select the name of the person that I'd like to get more information on, there's a new tabbed area next to activity called Profile. This area promotes their About Me information, ways that I can contact him, if he has a blog that would be listed here, if there's an organizational structure, that's also listed here, and there may be some additional content as well. So at the moment, I can see his Contact information, Organization information, and Praise. And that leads us to our next new feature, Praise. You can add praise for your colleagues right from this same area. Notices that I've already given Tim some praise earlier today. If I'd like to give him additional praise, right from this area I'll select the +Praise, type in the message of what I would like to praise him about, and then select from one of the six categories at the bottom as to, you know, what is this praise exactly; is it a thank you, is it teamwork, is it an idea. Once I'm done I'll click send and it will send that message on to Tim. It'll also send a notification to Tim's boss, letting him know of the praise that he has received. Let's go ahead and look at what that email would look like. So here's an example of praise that Tim shared with me today, letting me know that I did a great job on the Skype training recently. Great. Let's go back over to Delve, and we're going to talk about the fourth new feature called Author Canvas. Now I mentioned blogging. Tim's not using blogging yet, because I would see that in this lower left corner here. Let's switch over to my area and take a look at my Profile, and here you can see the blog area. Now if I'd like to see all of the blogs that I've created so far, I can take a look at All Posts. Here you can see that I am able to create a new post. I already have something that I've started drafting, but I haven't quite published yet, so it's just saved to this area. I also have a published blog titled Teamwork. So at any time if I'd like to view one of these two blogs that are Published or Unpublished, I can click right over those, or if I'd like to start a new blog I can select New post. Now before we go through drafting this blog, let's talk about exactly what it is. So blogging within Delve is an internal way that you can start writing and sharing your ideas, your thoughts on something, with your colleagues and others within your business. Since this is embedded across the Office 365 Suite, it's easy for you to embed documents inline from OneDrive for Business, videos from Office 365 Video, or even photos from your desktop. It also provides you the ability to post pages directly to Yammer, so let's take a look at how it's done. We'll start by adding an image, and we have the choice to actually browse out to OneDrive or My device as I was describing earlier. We'll go ahead and pick the Koala bear. Next, we move on to adding text. We have the capability to add a Title, a Subtitle, and your blog post. There's a recycle bin to the right, so if you'd like to discard this element you have the capability to do so, and while you are typing the actual text area of the blog, notice that you have a tool bar that is some quick formatting options for that text, whether you'd like to make it bold, italic, underline. In the upper right, next to our Koala bear, you'll also notice that there is a trash can. That's also to discard that content. And just above that is Save and Publish. So this is where you can actually Save it as a draft, or if you're ready to publish that content, select Publish. Now by publishing this, it's going to appear, possibly in a few different areas of Office 365, but the most relevant place that it will appear is within that Delve Content feed that you see on your Home page. Let's go back and take a look at Delve. The final new feature to mention about Delve is the new mobile app that is available for Android and iPhone. In the lower left corner is a link that you can go to to get more information about getting those applications. Thanks for watching, and I hope to see you in the next clip.

What's New in Sway - In this clip we'll discuss the new features of Microsoft Sway. You may not be familiar with this app. Microsoft Sway was released in November of 2014. With Sway you can collect, visualize, and share your ideas in a new way. Consider it a modern take on a presentation app. Since it was released, there have been some new features that have come along the way and we're going to take a look at a few of the more recent features. We'll start with importing a PDF. There's a couple of ways that you can go about importing a PDF. The first way that we're going to take a look at this is how you can start a new Sway from an existing PDF. You can either tap or click directly over Import Word, PowerPoint, PDF, browse out to where the PDF is saved, Open this. Now it may take a couple of minutes for it to upload. And here we have the Sway. We're currently looking at the story-line view of this, and within the story line we have sections that we can work with. But before we move onto the next new feature, I mentioned there was another way that you can incorporate PDFs. The other method is if you already have an existing Sway, you can choose the Upload option and select a PDF to have that content imported into that part of your Sway. The next new feature is Reordering your sections. Just as I mentioned, we have our sections here and any of these sections, as you grab the border of the section, or anywhere that you place the mouse over it and get the four-way arrow, you can left-click and drag to reorder your sections easily. There have also been improvements to the color picker, and that is part of the design element that we would work with in our storyline. So let's switch over to the Design view, and in the Navigation pane we can see many colors that we could scroll through and pick from to apply those styles to our storyline. But if we take it a step further and go to customize, there is a color palette in here called Curated. And notice to the right of it we can actually pick an image that is part of this storyline, and based on the image that we select, it gives us color choices in the Color palette area below of the ones that we could select and use. So let me go ahead and pick one more image, and you can see how those update. If you've watched any of our Office 2016 New Feature clips, you may have already been introduced to what's called coauthoring. Well, they've also introduced coauthoring to Microsoft Sway. If I need to share this Sway out to my colleagues and allow them to come in and make some changes or give some suggestions with that, I can do so by going to the Share icon and choosing to Share with my organization, or I can actually provide a link. By saying Anyone with a link, I can copy the link that you see in the field here and send that out to my colleagues by email, by Yammer, by SharePoint or any other method that you'd like, and they can easily make changes to this Sway. Again, you can send that to one colleague or many colleagues. The last topic is Apps. There are several apps available for Sway now. Sway is now available in the Chrome Web Store, as well as the Google Play for Education store for registered schools and organizations. It's also available for the iPad now, and it supports seven languages: Dutch, French, German, Italian, Japanese, Portuguese, and Spanish. And, the app has been updated for the iPhone. And finally, with the launch of Windows 10, there's a new Sway app available there as well. This app brings a few advantages over the web version; mainly it can be used offline. Although, while you're loading web-based content like YouTube videos or Interactive Maps, that will require a connection. Other elements will now be accessible without the internet. Thanks for watching, and I'll see you in the next clip.