Join Curt Frye for an in-depth discussion in this video Surveying Office Online, part of Office Online Essential Training.
Office Online provides online access to Office applications. In this course I will cover Word, Excel, PowerPoint, and OneNote. And in this movie, I will give you a brief tour of the apps to provide an overview of what you can do in each one. To start out in Microsoft Word, you will notice that you actually have quite a bit of capability. Currently I have a document open and I'm displaying the Home tab. And you see that you have many of the same formatting options, including pretty much the entire font group.
And you have a choice of a good variety of styles. You're not able to create your own styles in Office Online but there are quite a few to choose from. And of course you can always just create your own formatting as you go. You also have options on other tabs of the ribbon. For example, Insert lets you add pictures and clip art, hyperlinks and other elements familiar to Word users. You can change your page layout. And this is a bit more limited than what you would find in the regular desktop application.
You can review by checking spelling and working with comments, and you can also change the view. So as you can see, there are quite a few things that you can do, and any Word document that you open in Word Online will have all of its features retained, it's just you won't be able to edit or affect all of them. Now, let's move on to Excel. Also with Word Online, you'll see a lot of familiar options in the Home tab. You have all kinds of formatting options available. You also can, paste formulas, values or formatting which is very useful when you're working in a workbook.
You can insert and delete cells, and you can also sort your data. Sorting and filtering isn't quite as powerful as it is in the desktop application. But there's quite a bit that you can do, so I think you'll find it to be useful. On the other ribbon tabs you can insert tables or charts or hyperlinks. On the Data tab, you'll notice that there is quite a bit less here than there is in the desktop application. But you can still force a workbook calculation, and there's another place to sort your data.
You can also review, by adding and editing comments. And you can also change your view. The most important thing about Excel Online is that you have access to the entire calculation and formula building engine that is part of the desktop application. So that means any formulas that you create in Office Online will work in the desktop application and vice versa. So that's Excel. Lets move on to PowerPoint. In PowerPoint Online, you'll see that you once again have pretty much all the same controls on the Home tab that you have on the desktop application.
Some things are a little bit out of place, but I'm sure that everything will look familiar if you've used the PowerPoint desktop application before. So here, you can format your slide contents after you click an item. For example, if I click this text box, then the font and paragraph areas light up. You can also delete slides, create new slides, hide them in the navigation bar and so on. As with the other apps, you can insert pictures and clip art. You can also insert shapes and SmartArt, which are unique to PowerPoint Online.
You can also go to the Design tab, to select another theme, and if a theme has any variance, they will appear over here on the side. And also, a recent addition is the ability to add slide transitions, which appear here. And animations. You only have a few options for transitions and animations, but I think that the Office Online team did a good job of selecting which ones to include. And finally, on the View tab, you can change your view, and create a slide show.
So once again, you'll find that the core capabilities from the PowerPoint desktop application are all available here. Let's wrap us this movie by going on to OneNote. OneNote Online behaves a bit differently than the OneNote desktop application. You'll see the details in Chapters 9 and 10. That said, you'll find a lot that's familiar. One thing that's different in OneNote Online is that the ribbon is collapsed by default instead of open. So for example here, you can see the ribbon tabs, File, Home, Insert View and Print, but you don't see any of the contents of the ribbon.
The content of your pages is maximized. If you want to display your ribbon tab though, all you need to do is click it and you'll see your controls. And as before, the Home tab which includes formatting, is pretty much taking over verbatim. From the desktop application. You can also insert pages, sections, tables, pictures, cliparts, and hyperlinks. You can change the view. And you can also print your page. And that's a quick overview of the Office Online applications.
You can perform many important tasks and remember, anything that you edit in Office Online will be available for you in the desktop version of the application as well.
- Syncing files with OneDrive
- Managing files from the ribbon with the File tab
- Editing Word documents online
- Changing page layouts
- Creating, sorting, and filtering data in Excel
- Creating charts
- Editing slides in PowerPoint
- Adding slide notes, transitions, and animations
- Tagging online OneNote page contents
- Sharing and embedding Office Online files