Excel on the web - Step-by-Step Guide

Introduction

Excel on the web lets you create, edit, and share spreadsheets right in your browser. It helps you work on Excel files without installing software, making it easy to collaborate with others in real time.

When you need to quickly edit an Excel file on a computer without Excel installed

When you want to share a spreadsheet with coworkers and work on it together at the same time

When you want to access your Excel files from any device with internet access

When you want to save your work automatically without worrying about losing changes

When you want to use basic Excel features without installing the desktop app

Steps

Step 1: Open your web browser and go to office.com

- Browser address bar

The Office homepage loads showing apps including Excel

💡 Use a modern browser like Chrome, Edge, or Firefox for best experience

Step 2: Click the Excel icon

- Office homepage

Excel on the web opens with options to create or open files

Step 3: Click New blank workbook

- Excel start page

A new empty spreadsheet opens in the browser

Step 4: Type data or formulas into cells as you would in desktop Excel

- Spreadsheet grid

Cells update with your input and calculations happen automatically

Step 5: Click Share in the top right corner

- Excel toolbar

A sharing pane opens allowing you to invite others to view or edit

💡 You can set permissions to control who can edit or only view

Step 6: Click File > Save As to save your workbook to OneDrive or download a copy

- Excel menu

Your file is saved online or downloaded to your device

Before vs After

Before

You have an Excel file saved on OneDrive but no one else can access it

After

You share the file link with coworkers who can now open and edit it together in their browsers

Settings Reference

Sharing permissions

📍 Share pane in Excel toolbar

Control who can change or only see the spreadsheet

Default: Can edit when sharing with specific people

AutoSave

📍 Top left corner toggle

Automatically save changes as you work

Default: On for files saved in OneDrive

File format on download

📍 File > Save As > Download a Copy

Choose how to save a copy of your file to your device

Default: Excel Workbook (.xlsx)

Common Mistakes

Trying to use advanced Excel features not supported in Excel on the web

Excel on the web has fewer features than desktop Excel and some complex functions or macros won't work

Use Excel desktop app for advanced features or check feature availability before starting

Not saving the file to OneDrive or SharePoint before sharing

Files not saved online cannot be shared or collaborated on in real time

Save your workbook to OneDrive or SharePoint to enable sharing and collaboration

Summary

Excel on the web lets you create and edit spreadsheets in your browser without installing software

It is great for quick edits, sharing, and real-time collaboration with others

Remember that some advanced Excel features are not available in the web version

Practice

1. What is a key benefit of using Excel on the web compared to the desktop version?

easy

A. You can access and edit your spreadsheets from any device with internet.

B. It has more advanced formulas than the desktop version.

C. It does not save your work automatically.

D. You cannot share files with others.

Solution

1. Step 1: Understand Excel on the web features

   Excel on the web allows access from any device connected to the internet.

2. Step 2: Compare with other options

   Options A, B, and D are incorrect because Excel on the web supports common formulas, saves automatically, and allows sharing.

3. Final Answer:

   You can access and edit your spreadsheets from any device with internet. -> Option A

4. Quick Check:

   Access from any device = C [OK]

Hint: Remember: Excel on the web works anywhere with internet [OK]

Common Mistakes:

• Thinking Excel on the web has more formulas than desktop
• Believing it does not save automatically
• Assuming sharing is not possible

2. Which of these is the correct way to write a formula in Excel on the web to add cells A1 and B1?

easy

A. A1 plus B1

B. =SUM(A1+B1)

C. SUM(A1,B1)

D. =A1+B1

Solution

1. Step 1: Recall formula syntax for addition

   In Excel, to add two cells, use =A1+B1.

2. Step 2: Check each option

   =SUM(A1+B1) uses SUM incorrectly with plus sign inside. SUM(A1,B1) misses '=' and uses wrong syntax. A1 plus B1 is not a formula.

3. Final Answer:

   =A1+B1 -> Option D

4. Quick Check:

   Correct addition formula = A [OK]

Hint: Use '=' to start formulas, then write the operation [OK]

Common Mistakes:

• Using SUM with plus sign inside parentheses
• Omitting '=' at the start
• Writing formulas as plain text

3. If cell A1 contains 10 and B1 contains 5, what will the formula =IF(A1>B1, "Yes", "No") display in Excel on the web?

medium

A. No

B. Yes

C. 10

D. 5

Solution

1. Step 1: Evaluate the condition A1 > B1

   Since A1 is 10 and B1 is 5, 10 > 5 is TRUE.

2. Step 2: Apply IF formula logic

   IF condition is TRUE, so formula returns "Yes".

3. Final Answer:

   Yes -> Option B

4. Quick Check:

   Condition true = Yes [OK]

Hint: IF returns first value if true, second if false [OK]

Common Mistakes:

• Confusing which value IF returns on true
• Mixing up cell values with formula output
• Ignoring quotation marks around text

4. You entered the formula =AVERAGE(A1:A5 in Excel on the web but it shows an error. What is the problem?

medium

A. AVERAGE function does not work on ranges

B. Formula should start with SUM, not AVERAGE

C. Missing closing parenthesis ")"

D. Cells A1 to A5 must be numbers

Solution

1. Step 1: Check formula syntax

   The formula =AVERAGE(A1:A5 is missing the closing parenthesis ")" at the end.

2. Step 2: Understand function requirements

   AVERAGE works on ranges and cells can be numbers; missing parenthesis causes syntax error.

3. Final Answer:

   Missing closing parenthesis ")" -> Option C

4. Quick Check:

   Syntax error due to missing ")" = B [OK]

Hint: Always close parentheses in formulas [OK]

Common Mistakes:

• Forgetting to close parentheses
• Thinking AVERAGE can't use ranges
• Assuming formula must start with SUM

5. You want to share an Excel on the web file with your team so everyone can edit it at the same time. Which steps should you follow?

hard

A. Upload the file to OneDrive and use the Share button to invite team members

B. Save the file locally and email it to each person

C. Send a screenshot of the file to the team

D. Copy and paste the data into a Word document and share it

Solution

1. Step 1: Understand sharing in Excel on the web

   Excel on the web integrates with OneDrive for cloud storage and sharing.

2. Step 2: Identify correct sharing method

   Uploading to OneDrive and using the Share button allows real-time editing by multiple users.

3. Final Answer:

   Upload the file to OneDrive and use the Share button to invite team members -> Option A

4. Quick Check:

   Use OneDrive Share for collaboration = A [OK]

Hint: Use OneDrive Share button for live collaboration [OK]

Common Mistakes:

• Emailing local files causes version conflicts
• Sharing screenshots or Word docs loses spreadsheet features
• Not using cloud storage for collaboration