Office Online - Discover Excel Online Tutorial

In this video, you will learn about discovering Excel Online in Microsoft 365. The video covers the potential of Excel online and how to use its basic and intermediate features.
This will help you become proficient in using Excel Online and enhance your productivity.

2:34
3136 views

Available in Microsoft365

Objectifs :

This video aims to provide a comprehensive guide on navigating the Excel Online interface, highlighting its features and functionalities that mirror the desktop application. Users will learn how to access, manage, and collaborate on documents effectively within the Office Online suite.

Chapitres :

Introduction to Excel Online
Excel Online is part of the Office Online suite, allowing users to access Microsoft’s most well-known applications directly through a web browser. This platform offers similar functionalities to the desktop version, enabling users to work seamlessly with their documents stored online or shared with them.
Accessing Excel Online
To begin using Excel Online, navigate to your Office home page. Here, you will find a dedicated menu for Microsoft Excel, which includes options for creating new documents using blank templates or recommended documents. The last section of this menu displays all your Microsoft Excel files, whether stored online or shared by colleagues through OneDrive, SharePoint, Teams, or Outlook.
Document Management
You can easily share documents and perform actions similar to those on the Office home page by right-clicking on files. The interface allows you to filter and search for documents using keywords. Clicking on the file name will take you to its storage location, and you can open it by selecting the document row. Notably, Excel Online automatically saves your document as soon as you make edits.
Exploring the Excel Online Interface
Upon opening a document, you will encounter the upper headband, which serves as a link between Excel Online and the entire Office suite. This menu allows you to open other applications or return to the Office portal. You can also change the document's name and path, provided you have the necessary permissions.
Utilizing the Search Functionality
The search bar is a powerful tool that not only helps you find documents and contacts but also allows you to search for app features. For instance, if you want to add a chart but are unsure how, simply type your query in the search bar, select the desired feature, and create your chart.
Ribbon Options in Excel Online
Excel Online displays a simplified ribbon by default. However, users can switch to a classic ribbon view for a more comprehensive set of tools to manage their Excel workbook. The interface includes three buttons for sharing the workbook, adding comments, and reviewing modification history when collaborating with coworkers.

FAQ :

What is Excel Online?

Excel Online is the web-based version of Microsoft Excel that allows users to create and edit spreadsheets directly in their web browser, offering similar functionalities to the desktop version.

How do I access my documents in Excel Online?

You can access your documents in Excel Online through the Office home page, where you can find your stored files, shared documents, and recommended templates.

Can I share my Excel Online documents with others?

Yes, you can share your Excel Online documents with others using the share button, allowing for collaborative editing and commenting.

What happens if I edit a document in Excel Online?

When you edit a document in Excel Online, it automatically saves your changes, ensuring that you do not lose any work.

How can I find specific features in Excel Online?

You can use the search bar in Excel Online to find specific features or tools by typing in keywords related to what you want to do, such as 'add a chart'.

What is the difference between the simplified ribbon and the classic ribbon in Excel Online?

The simplified ribbon in Excel Online displays fewer options for a cleaner interface, while the classic ribbon provides access to all tools and features available in Excel.

Quelques cas d'usages :

Collaborative Project Management

Teams can use Excel Online to collaboratively manage project timelines and budgets. By sharing the workbook, team members can edit and comment in real-time, ensuring everyone is on the same page. Challenges may include managing permissions and ensuring all team members are familiar with the online interface.

Data Analysis and Reporting

Data analysts can utilize Excel Online to analyze data sets and create reports. The ability to access files stored on OneDrive or SharePoint allows for easy retrieval of data. Analysts can also use the modification history feature to track changes made by colleagues, ensuring data integrity.

Educational Purposes

Educators can create and share Excel Online workbooks with students for assignments or collaborative projects. This allows for interactive learning experiences where students can work together on data analysis tasks. Potential challenges include ensuring all students have access to the necessary technology.

Budget Tracking

Individuals or small businesses can use Excel Online to track their budgets. By creating a shared workbook, they can update expenses and income in real-time, making it easier to manage finances. Users should be aware of the need for consistent internet access to utilize the online features effectively.

Glossaire :

Microsoft Office Online Suite

A web-based version of Microsoft Office applications that allows users to create, edit, and share documents online.

Excel Online

The online version of Microsoft Excel that provides similar functionalities to the desktop application, allowing users to create and edit spreadsheets through a web browser.

OneDrive

A cloud storage service from Microsoft that allows users to store files and access them from any device connected to the internet.

SharePoint

A web-based collaboration platform from Microsoft that integrates with Microsoft Office and is used for storing, organizing, sharing, and accessing information from any device.

Teams

A collaboration platform from Microsoft that combines workplace chat, video meetings, file storage, and application integration.

Ribbon

A user interface element in Microsoft Office applications that organizes commands and tools into a set of tabs for easy access.

Document Path

The location of a document within the storage system, which can be changed if the user has the necessary permissions.

Modification History

A record of changes made to a document, showing who made each change and when.

00:00:03

The office online suite recommends

00:00:05

to use Microsoft's most well known

00:00:07

apps directly online, similar to the

00:00:09

desktop app and just as functional.

00:00:11

You can access documents from your

00:00:14

online storage or shared with you space.

00:00:16

These documents can be shared

00:00:18

quickly and simply.

00:00:19

In this video you learn how to

00:00:22

navigate the Excel online interface.

00:00:25

On your office home page, click here.

00:00:28

You can access a menu specifically

00:00:30

dedicated to Microsoft Excel.

00:00:31

Here you can find blank templates

00:00:34

and documents to create new content.

00:00:37

Just below Microsoft recommends

00:00:39

documents you may need.

00:00:43

The last section includes all

00:00:45

your Microsoft Excel files.

00:00:47

The ones you stored online yourself

00:00:49

or the ones shared by your coworkers,

00:00:51

weather on one drive,

00:00:53

SharePoint teams or outlook with a

00:00:55

right click you can perform the same

00:00:57

actions as on the Office home page.

00:00:59

You can use different filters but also

00:01:01

search your document with keywords.

00:01:03

Clicking below the file name takes

00:01:04

you to its storage location.

00:01:06

To open it, click in the document row.

00:01:09

Note that the advantage of the online

00:01:11

version is that it automatically saves

00:01:13

your document as soon as you edit it.

00:01:15

The online app opens.

00:01:16

Let's take a tour of the interface.

00:01:19

First of all, you have the upper headband.

00:01:21

This menu is the link between Excel

00:01:23

online and the entire office suite.

00:01:25

You can open another app with one click.

00:01:29

Or return to the office portal.

00:01:32

Right next to it.

00:01:33

This is where you can change

00:01:35

the name of your document.

00:01:36

Click on it and change the name just below.

00:01:39

You can change the path of your document.

00:01:42

Of course this is only possible if you

00:01:44

have permission to change the location

00:01:46

of the file in the online storage.

00:01:48

In addition to searching your documents,

00:01:50

contacts and whatever the search bar can

00:01:52

be used to search your apps features.

00:01:55

For example, I want to add a chart,

00:01:57

but I don't know how.

00:01:59

I search then select any feature

00:02:00

I want and create my chart.

00:02:08

Excel online displaced by

00:02:09

default as simplified ribbon,

00:02:11

but to switch to a classic ribbon,

00:02:13

click here. Here you can find all the

00:02:16

tools to process your Excel workbook.

00:02:19

The three buttons here allow you to

00:02:21

share the workbook with a few clicks,

00:02:24

add comments, or catch up.

00:02:27

When you work together on a spreadsheet,

00:02:29

this is where you can find your

00:02:31

coworkers modification history.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2639 Views

Microsoft 365 Video Training - Learn Microsoft Office Online

The difficulty of working in an emergency or remotely is that our favorite apps are not always available on the computer. Let's look togethe...

ALL COURSES