But Excel Online is free, and offers additional advantages to using the desktop version. Another option for moving desktop spreadsheets to Excel Online is downloading the OneDrive app, logging in with your Microsoft account, and copying your Excel files to the OneDrive folder to sync them. Excel Online Features Excel 2016 desktop version offers 471 functions. Here’s Microsoft Office’s complete list of features offered in Excel Online, verus Excel desktop. If there’s a feature unsupported in Excel Online, but the majority of your project can be completed in Excel Online, perhaps you can work back and forth between Online and desktop, using OneDrive to sync your data automatically. Excel Online vs. desktop The majority of Excel desktop features and functions are displayed and supported similarly in Excel Online, and for most data spreadsheet projects, you won’t notice a difference between Online or desktop. If you use conditional formatting on your desktop Excel, you will still see the changes to your workbook when you open it in Excel Online. To create a survey in Excel Online, click New > Forms for Excel. Next, name your Survey and click “Create”. You can choose an add-on by category or name, and then click the “Add” button.
If you’ve been using Excel from your desktop for years, switching to the online version can seem like a scary — and even unnecessary — transition.
But Excel Online is free, and offers additional advantages to using the desktop version. If you use the Online version, you can sync your spreadsheet to other web apps, allowing you to gather additional data or automate workflows.
Better yet, using Excel Online helps you collaborate with coworkers on larger projects.
Is Excel Online free?
Yes, Microsoft Excel Online is free. It offers almost every Excel function, including tools to help you analyze, gather, and visualize spreadsheet data, and collaborate with coworkers. Compared to the desktop version of Excel, which costs hundreds of dollars, the Online version is its almost equal free alternative.
Excel Online is a fantastic option for gathering, viewing, and analyzing your data. Even if you haven’t paid for Excel’s desktop version, you can begin using Excel Online for free today. And Excel Online offers almost all the same features, so if you’re interested in collaboration or taking advantage of the web add-ons, it could be worth the switch.
Here, we’ll investigate how to use Excel Online, compare the features of Excel Online versus desktop Excel, and take a look at some of the hidden online features you’ll definitely want to know about.
How to Use Excel Online: Beginner’s Guide
There are two ways to locate Excel Online: first, click this Products.Office link, and select “Excel.” It will ask you to sign in, and then you can begin creating a spreadsheet.
Or, open OneDrive, and select a spreadsheet you’ve saved.
If you want to move your desktop spreadsheets to Excel Online, you can use OneDrive.com to do this — there are two different ways.
First, you can open OneDrive.com and drag and drop your spreadsheet files from your desktop to OneDrive.
However, dragging and dropping files means if you edit those files online, your edits won’t transfer to your desktop. If you want to switch back and forth between the two, this can become problematic.
Another option for moving desktop spreadsheets to Excel Online is downloading the OneDrive app, logging in with your Microsoft account, and copying your Excel files to the OneDrive folder to sync them.
This option is likely more favorable. After downloading the OneDrive app, you can sync your files to the cloud. Then, any edits you make online will automatically transfer to your desktop files, and vice versa.
Once you’re all set up in Excel, you can use it the same way you use the desktop version — the design is the same, and most of the functions are the same.
Now, let’s take a closer look at Excel Online’s features, so you know exactly what Online includes.
Excel Online Features
Excel 2016 desktop version offers 471 functions.