If you're new to Office Online use this free lesson to become more familiar with the program, including how it works with OneDrive.
Excel Online is the online version of Microsoft Excel. Like the desktop version of Excel, Excel Online allows you to use spreadsheets, or worksheets, to store and analyze data in organized workbooks.
If you’re unfamiliar with using Microsoft Excel, review our Excel 2013 tutorial to learn how to create and use workbooks.
Excel Online contains many of the most useful Excel features. For example, you can perform calculations with formulas. You can even organize your data into tables and charts, although you won't be able to customize their appearance very much.
Most of Excel's advanced tools are not included in Excel Online. For instance, you won't be able to create PivotTables, perform advanced data analysis, or customize the page layout.
Click the buttons in the interactive below to become more familiar with the Excel Online interface.
The View tab allows you to switch between Reading view and Editing view. Reading view hides the Ribbon and other toolbars, which makes your data easier to read.
The Data tab gives you access to advanced data options. However, this tab contains very few commands compared to the desktop version of Excel, so you may not find it very useful.
The Insert tab allows you to insert charts, tables, and more, which can help you visualize and communicate your workbook data graphically.
The Home tab gives you access to some of the most commonly used commands for working with data in Excel Online, including copy & paste, formatting, and number formats.
The Home tab is selected by default whenever you open Excel Online.
From the File tab, you can create new workbooks, open existing workbooks, print workbooks, and more.
This is where you'll enter the data for the current worksheet.
If you're working with a lot of data, it's easy to switch between worksheets.
You can also click the New Worksheet button to the right of the existing worksheets to add a new worksheet.
Click here to open the current workbook in the desktop version of Excel.
Note that you must have a version of Office installed on your computer to use this feature.
When you select a chart, the Chart tab will appear on the Ribbon. From here, you can customize the chart's appearance, change the chart type, and more.
Click here to access some of the most commonly used functions in Excel, like SUM and AVERAGE.
You can also click More Functions to search for advanced functions.
Click here to edit the workbook name.