How to Use Excel in Office 365: Beginner Workflow

If you need to learn how to use Excel in Office 365 but are unsure where to open the app, how to build a spreadsheet, or how to work with formulas without breaking your file, this guide gives you a complete beginner path. By the end, you will know how to create, edit, format, calculate with, save, and share a basic Excel workbook in Microsoft 365 for everyday tasks.

Excel in Microsoft 365 is a spreadsheet application used to organize information, calculate values, analyze data, and collaborate with others. To start, open Microsoft Excel from the desktop app, Excel for the web, or Microsoft Teams, create a new workbook, enter data into cells, apply formatting from the Ribbon, add formulas or AutoSum calculations, then save and share the workbook through Microsoft 365 cloud storage.

Start Using Excel in Microsoft 365 with a First Workbook

Excel in Microsoft 365 combines the familiar Microsoft Excel spreadsheet tools with cloud-based access and collaboration features. A workbook is the complete Excel file, while worksheets are individual pages inside that file where you organize data.

For beginners, the main difference between Excel in Microsoft 365 and a standalone Excel license is the way the app is accessed and connected to Microsoft 365 services. A Microsoft 365 subscription typically provides access to Excel applications and cloud workflows, while a standalone Excel purchase focuses on the Excel application itself without the same subscription-based service model. For a broader overview of Excel for Office 365, explore how it integrates with other Microsoft 365 tools.

Open Excel and choose where to start

You can begin using Excel in Microsoft 365 in three common ways:

• Open the Excel desktop app from your computer’s applications list when you need full features, offline access, or advanced formatting.
• Open Excel for the web through a browser when you need quick access, light editing, or a file from another device.
• Open Excel through Microsoft Teams when a workbook is part of a team conversation or shared project.

Excel desktop is usually the best starting point for learning the complete workflow because it provides offline access and the full interface. Excel for the web is useful for browser-based access and common edits, while Excel in Teams is best when the workbook already belongs to a shared team workspace.

Create a blank workbook or use a template

To create a new spreadsheet in Excel:

1. Open Excel.
2. Select New from the start screen.
3. Choose Blank workbook to create an empty file.
4. Choose an Excel template if you want a ready-made structure for a budget, schedule, tracker, or another common task.

Templates can reduce setup time because they already include layouts, headings, and formatting. However, beginners should still understand how worksheets are organized so they can adjust a template instead of entering data into the wrong area.

Build and Edit Your First Spreadsheet Step by Step

A spreadsheet becomes useful when information is arranged in a structure that Excel can calculate and sort. A simple budget, task list, inventory list, or attendance tracker is enough practice for learning the basic workflow.

Navigate the Excel interface basics

The Excel interface contains a few areas beginners should recognize before entering information:

• The Ribbon is the menu area at the top of Excel that contains commands grouped into tabs such as Home, Insert, and Formulas.
• Columns run vertically and are labeled with letters.
• Rows run horizontally and are labeled with numbers.
• Cells are the individual boxes where rows and columns meet. Each cell has an address, such as A1 or B5.
• The worksheet is the working area where you enter and organize data.

A useful beginner habit is to identify the active cell before typing. The active cell is the one currently selected, and anything typed will appear there.

When learning Excel basics for Office 365, avoid treating the worksheet like a blank page. Each column should usually represent one type of information. For example, a household budget might use columns for Date, Category, Description, and Amount.

Create useful data layouts for practice

Start with small examples instead of trying to build a complicated report immediately. A beginner budget spreadsheet could include:

This structure makes later tasks easier because Excel can recognize each type of information separately.

In practical spreadsheet work, the easy-to-miss step is organizing data before adding formulas. If numbers, labels, and notes are mixed together in the same column, sorting, filtering, and calculations become harder.

To enter information:

1. Select a cell.
2. Type the value.
3. Press Enter to move to the next row.
4. Double-click a cell or select the formula bar to edit existing content.

If a value appears incorrectly, check the cell contents first. A common beginner issue is entering a number as text, which can prevent formulas from calculating correctly.

Choose the Right Excel Environment for Your Workflow

Microsoft 365 users may see Excel in several places, but these versions serve different situations. Choosing the right environment prevents confusion about missing features or file access.

Table of Excel environments

Use this simple decision rule:

Excel desktop versus Excel for the web

Excel desktop and Excel for the web share the same basic concepts: workbooks, worksheets, cells, formulas, and formatting. The difference is the working environment.

The desktop app is usually the better starting point when you need a complete Excel workflow, especially for tasks involving detailed formatting, printing, or working without an internet connection. Excel for the web is convenient when the priority is opening a file quickly from a browser and making common edits. For a detailed comparison, refer to Excel on Office 365: Features, Access, and Versions Explained.

A practical signal that you should switch environments is when a command or feature you expect is unavailable. Before changing anything important, save the workbook and confirm where the file is stored.

Excel opened through Microsoft Teams

Excel inside Microsoft Teams is designed around collaboration. It is useful when a team already shares a workbook through a Teams channel or conversation and multiple people need access.

The main beginner difference is ownership and workflow. In Teams, the spreadsheet is often part of a shared workspace rather than a personal file. Before editing, check whether the workbook is meant for individual work or group updates.

For a first practice file, Excel for the web or the desktop app is usually simpler. Move to Teams when the main need becomes coordinating edits with other people.

Use Formulas, AutoSum, and Tables for Everyday Tasks

Once data is entered, Excel becomes useful because it can calculate and organize information automatically. The three beginner features to learn first are formulas, AutoSum, and Excel Tables.

Write simple formulas for calculations

An Excel formula is an instruction that calculates a result using cell references. A cell reference tells Excel which cell contains the value to use.

For example:

=A2+B2

This formula adds the values stored in cells A2 and B2.

Use a typed formula when you need a specific calculation rule or when the included cells are not simply a continuous list. Common beginner examples include:

• =A2-B2 to subtract one value from another.
• =A2*B2 to multiply values.
• =SUM(A2:A10) to add a range of cells.

A formula is the better choice when the calculation logic matters. For example, a budget tracker may need a remaining balance formula that subtracts expenses from income.

Use AutoSum for quick totals

AutoSum is a shortcut for creating common totals without manually typing a formula. It is especially useful for adding a continuous list of numbers in a column or row.

A beginner rule is simple: use AutoSum for quick totals of nearby numbers; write a typed formula when you need to choose the exact cells, combine specific calculations, or create a custom rule.

Example workflow:

1. Select the empty cell below a column of numbers.
2. Select the Home tab on the Ribbon.
3. Click AutoSum.
4. Check the highlighted range Excel suggests.
5. Press Enter if the selected cells are correct.

For a non-adjacent calculation, a typed formula is usually clearer. For example, =SUM(A1,A3,A5) specifically tells Excel to add only those three cells.

Turn data ranges into Excel Tables

An Excel Table converts a normal range of cells into a structured data area with features such as filtering, automatic formatting, and easier expansion as new rows are added.

To create a table:

1. Select the range of data, including headers.
2. Select Insert on the Ribbon.
3. Choose Table.
4. Confirm that My table has headers is selected if your first row contains labels.
5. Select OK.

A table is useful before you manage larger lists because it keeps related information together. For example, a task list can be filtered by status, while a spending list can be sorted by category.

Format, Store, and Share Workbooks Safely

Formatting makes a worksheet easier to read, but it should support the information rather than hide it. Common beginner formatting tasks include adjusting numbers, highlighting headings, and changing column widths.

To format a worksheet:

1. Select the cells you want to change.
2. Open the Home tab on the Ribbon.
3. Use commands such as Bold, Borders, and number format options.
4. Adjust a column width by selecting the column boundary and dragging it until the text fits.

For example, a currency column should use a number format that displays money consistently instead of mixing text symbols and numbers manually.

Store important workbooks in a location you can access again, such as Microsoft 365 cloud storage connected to your account. Cloud storage also supports easier sharing and collaboration.

Before sharing a workbook, understand the permission difference:

• Can view allows someone to read the workbook without changing the contents.
• Can edit allows someone to modify the workbook.

Use Can view for reports or reference files. Use Can edit only when another person needs to update the spreadsheet directly.

Worked example: sharing a workbook for review.

Situation: You want a colleague to check a budget but not change the numbers.

Steps:

1. Open the workbook in Excel for the web or the desktop app.
2. Click the Share button in the top-right corner.
3. Enter the recipient’s email address.
4. Select Can view for read-only access or Can edit for editing permission.

Result: The recipient receives access with the permission level you selected.

Note: Check permissions before sending the link because changing access later may require another update.

Fix Common Excel Problems Before They Slow You Down

Small mistakes are normal when learning Excel. The fastest fixes usually come from identifying what changed, checking the visible error message, and using recovery tools before making more edits.

Recover from mistakes with AutoSave enabled

AutoSave can save changes automatically when the file is stored in a supported Microsoft 365 location, but it should not be treated as a guarantee that every unwanted change can never happen. Recovery options depend on the file location and available versions.

Use these recovery steps:

1. Press Ctrl+Z immediately after an unwanted change to undo the latest action.
2. If the workbook has already been closed, open it and go to File > Info > Version History to check earlier saved versions.
3. Review the older version before restoring it so you understand what will change.

A safer way to check is to look for the visible result of the mistake. If a value, formula, or formatting change appeared unexpectedly, undo first rather than continuing to edit.

Resolve common Excel errors and fixes

Formula errors often show a clue about the problem. Two common examples are:

• #REF! usually indicates that a formula refers to a cell reference that no longer exists.
• #VALUE! often appears when Excel cannot use the type of value provided in a calculation.

Try these checks:

1. Check whether the formula contains a reference to a deleted or moved cell.
2. Confirm that cells used in calculations contain numbers rather than text.
3. Select the formula cell and review the references shown in the formula bar.

These checks will solve many beginner issues, but complex formulas may require additional review.

Practice Excel Skills in a Beginner Learning Sequence

Learning Excel in Microsoft 365 becomes easier when skills are practiced in an order that matches real tasks. Start with simple actions, then combine them into a complete workflow.

A practical sequence is:

1. Enter sample data into a worksheet and apply basic formatting, such as bold headers and borders.
2. Practice using AutoSum on a short list of numbers and compare the result with a manually written formula.
3. Create a simple calculation by writing a formula that references two cells, such as =A1+B1.
4. Convert a small data range into an Excel Table and practice sorting or filtering the information.
5. Share the workbook using either Can view or Can edit permissions and confirm that the access level matches your goal.

For a structured learning path, consider Excel Essential Training for Microsoft 365: Step-by-Step Beginners Guide to master foundational skills.

Repeat these tasks with everyday examples such as a monthly budget, a shopping list, or a project tracker. Each practice file should answer a real question: what information needs organizing, what calculation is needed, and who needs access.

After creating your first workbook today, open a blank Excel file and build a five-row task list with headings, formatting, one formula, and a share setting; this produces a complete practice loop from data entry to collaboration in a single session.

FAQ

Can you learn Excel by yourself?

Yes, you can learn Excel by yourself by practicing basic workflows such as entering data, formatting cells, creating formulas, using AutoSum, and organizing information in tables. Start with small projects like a budget, task list, or tracker, then gradually combine these skills into more complete workbooks.

Can beginners use Excel templates effectively?

Yes, beginners can use Excel templates effectively because templates provide ready-made layouts, headings, and formatting for common tasks. It is still important to understand how worksheets and cells are organized so you can adjust the template correctly and enter information in the right areas.

Can Excel be used without an internet connection?

Yes, the Excel desktop app is useful when you need offline access, advanced formatting, or a complete Excel workflow. Excel for the web is designed for browser-based access and common edits, while the desktop app provides a different working environment.

How often should beginners practice Excel?

Beginners should practice Excel regularly by repeating simple tasks and building small workbooks. A useful approach is to practice entering data, formatting worksheets, creating formulas, using AutoSum, converting ranges into tables, and sharing files with different permission settings.