While some features work the same in Excel Online and Excel desktop, there are some essential differences. In this video, learn how to cite the basic features that work differently in Excel Online.
- [Instructor] With Excel Online, you can take basic data and transform it into something that's both interactive and powerful. If you'd like to follow along, then make sure you have XOL CustomerData open. As you can see, this data on its own, it doesn't look very pretty. However, in just a few simple steps, we can transform it into something that's meaningful and engaging. For example, let's go ahead and select the header row here and under the Home menu, click on the dropdown box next to Fill and let's change the fill color to say dark blue. With those cells still selected, click on the dropdown box next to Font Color and select White and as you can see, our heading text stands out a little bit clearer now. But with these cells still selected, let's go and click on B, which makes the text bold to stand out even more. And we can even select the dropdown box next to the Font Size and change it to say Font 14 and this makes the text even larger. The other thing that we may wish to do here is change our data format to comma format without any decimal places. I find that the easiest way to do this is to select the entire column and under the Number Format here, click on Comma Style and then click on Decrease Decimal twice. And this makes the data much easier to read. The last thing that we may wish to do is apply something called freeze panes and I'll show you what this looks like in a moment. Let's go and select row five. And then under View, click on the dropdown box next to Freeze Panes. And again, click on Freeze Panes. Now, select any cell in the table and then scroll down, either using the scroll bar over on the right-hand side or if you have a scroll wheel on your mouse, then use that. Have a look at what happens when we scroll down. We're navigating through the data but we're not losing visibility of our header row. Have a look at what happens if we click on the dropdown box next to Freeze Panes and then select Unfreeze Panes. Do exactly the same thing that you did just before by scrolling down and you'll see that we're moving through the data but we're losing visibility of our column headings. Now, it's worthwhile taking the time to play around with all of the other exciting Excel Online menu options but that's just a brief introduction to the basic features of Excel Online.
Note: This course is for users who know the basics of the Excel desktop app, but are new to the web version, Excel Online. It emphasizes features that work differently in Excel Online. For basic Excel guidance, please see Excel Essential Training (Office 365) or Learning Excel 2019.
- Using Excel Online shortcuts
- Customizing your view
- Integrating the desktop version of Excel
- Sharing workbooks in Excel Online and OneDrive
- Inserting and reviewing comments
- Creating and editing charts
- Working with PivotTables and PivotCharts