Excel Online Cheat Sheet – A Quick Guide To Excel’s Web Version

In this post, we cover Excel Online’s main features. Looking for excel shortcuts? See our Excel Shortcuts Page!

What’s Excel Online?

Excel online or “Excel for the web”, is the web version of Microsoft Excel. With Excel-Online you can create and edit Workbooks by using your browser and share your workbook with other users.

How can I get Excel Online?

Go to http://OneDrive.live.com.

Sign Up With Your Email
Super cool Shortcut! after you have onedrive username – type excel.new into your browser! or…
Open One Drive and press the following buttons:
1. New >>
2. Excel workbook

The shortcut way (or.. type excel.new into your browser:

Congrats! You can go ahead and use Excel online.

Does Excel Online cost money?

Excel Online is free. Want extra storage or more features? See OneDrive Plans: As low as $5 user/month

How can I share my workbook with others?

Go to the excel file and press the “share” button in the upper right range of the window.

Now, the following view would open up:

You can add your teammates’ email addresses or share the workbooks link with them by pressing copy.

You can enable editing preferences by checking and unchecking the edit button. Add expiration date and password if needed.

I have an Excel Online Workbook – Can I Open Excel online on your desktop?

By pressing the Editing/Viewing button – you will see that the lowest option is “Open in Desktop App”; it can take a few minutes – but then you will be able to edit your Excel-Online version on your desktop.

Don’t forget to :

Enable editing
Save before you close the workbook!

Excel Online Workbooks, Sheets and Cells:

TheExcelBee.blogspot.com is the best way to learn and test your knowledge in Excel. If you are completely new to Excel – we recommend starting with our Excel Basics Tutorial.

Work With Cells, Formulas and Functions

You can enter text, or alternatively, add a formula by starting with the equals sign (=)

Work with Excel’s Most Popular Functions and Tools!

We’ve created the table below to share with you an overview of each of the most popular functions and tools! press on the Function’s name to learn and practice them online!

SUMIF