Microsoft Excel Online – Office 365Create IT’s introductory series of blogs on the apps included in Microsoft Office 365 continues today with a look at Excel Online.

Create and edit spreadsheets online

Excel Online allows you to create, view, edit spreadsheets in your web browser, and it allows you to collaboratively edit spreadsheets with your colleagues on Office 365 in real time.

Excel Online creates fully Office-compatible xlsx files that you can open with Excel on the desktop, and share with colleagues, partners and customers using OneDrive or email.

What you’ll see

Excel Online is launched from the Office 365 menu and opens in a new browser tab. The default launch screen is only slightly different to the launch screen in Excel 2013 and Excel 2016.

Microsoft Excel Online – Office 365Here’s what you’ll see when launching Excel Online:

  1. A list of recently opened spreadsheets
  2. New blank document and online templates
  3. ‘Get Excel for your device’, and your Office 365 account links.

When you’ve chosen a new blank spreadsheet, or a template from the list, Excel will open and show the familiar tab menu.

The editing screen has these main features:

Microsoft Excel Online – Office 365A.    The tabs menu, with File, Home, Insert, Data, Review, View, and Edit in Excel, to open the spreadsheet in whatever version of Excel you have on your computer. Each tab shows many of the functions of desktop Excel
B.    The spreadsheet editing field
C.    Sheet control – create a new sheet, rename or move a sheet and navigate through sheets
D.    Share button

Using Excel Online

Excel Online automatically saves your changes as you enter data and amend the spreadsheet – there’s no need for a save button. It’s immediately familiar for users of Excel 2013 or Excel 2016, with many of the functions you’ll see in the desktop version.

A few of the less commonly used functions aren’t in Excel Online, but it’s a very capable spreadsheet program. Here’s a comparison of the File tab menu between Excel Online and Excel 2013:

Microsoft Excel Online – Office 365
Excel Online Home menu
Microsoft Excel Online – Office 365
Excel 2013 Home menu

Real-time collaboration

One of the greatest features of Excel Online is that you can collaborate in real time with colleagues, creating a spreadsheet together and saving time. Co-authoring is easy and you can see in real time what changes your colleagues are making to the document.

Integration with other Office 365 apps

Excel Online saves documents to your OneDrive folder, where you can share them with people in your team, attach them in emails, download them to your desktop or share them on SharePoint.

Previous posts

We have an ever-growing list of articles about the apps in Office 365, including Mail, Calendar, People, OneDrive, SharePoint and more. To view them all see our list of Office 365 blogs.

Future posts and more details

We will continue to provide introductory blogs about the apps in Office 365 to help you get started. If you want to know more about how Office 365 can help your business, contact Create IT.

Back to Blog