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
2827 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.

00:00:03

Office online apartman preporučuje

00:00:05

za korišćenje najpoznatijeg microsofta

00:00:07

aplikacijama direktno na mreži, slično

00:00:09

aplikacija na radnoj površini i jednako funkcionalna.

00:00:11

Dokumentima možete da pristupite iz

00:00:14

skladište na mreži ili deljeno sa prostorom.

00:00:16

Ovi dokumenti se mogu deliti

00:00:18

brzo i jednostavno.

00:00:19

U ovom videu saznajete kako da

00:00:22

kretanje kroz Excel interfejs na mreži.

00:00:25

Na matičnoj stranici vaše kancelarije kliknite ovde.

00:00:28

Meniju možete pristupiti posebno

00:00:30

posvećeno programu Microsoft Excel.

00:00:31

Ovde možete pronaći prazne predloške

00:00:34

i dokumente za kreiranje novog sadržaja.

00:00:37

Odmah ispod preporuke korporacije Microsoft

00:00:39

dokumenta koja će vam možda biti potrebna.

00:00:43

Poslednji odeljak obuhvata sve

00:00:45

Microsoft Excel datoteke.

00:00:47

One koje ste sami uskladištili na internetu

00:00:49

ili one koje dele tvoji saradnici,

00:00:51

vremenska prognoza na jednoj vožnji,

00:00:53

SharePoint timovi ili Outlook sa

00:00:55

desnim klikom možete da izvršite isto

00:00:57

radnje kao na matičnoj stranici sistema Office.

00:00:59

Možete koristiti različite filtere ali i

00:01:01

pretražite dokument pomoću ključnih reči.

00:01:03

Klik ispod imena datoteke je potreban

00:01:04

vi na njegovu lokaciju za skladištenje.

00:01:06

Kliknite na red dokumenta da biste ga otvorili.

00:01:09

Imajte na kraju da prednost na mreži

00:01:11

verzija je da automatski čuva

00:01:13

dokument čim ga uredite.

00:01:15

Otvoriće se aplikacija na mreži.

00:01:16

Hajde da obiđemo interfejs.

00:01:19

Pre svega, imate gornju traku za glavu.

00:01:21

Ovaj meni je veza između programa Excel

00:01:23

online i ceo kancelarijski apartman.

00:01:25

Možete da otvorite drugu aplikaciju jednim klikom.

00:01:29

Ili se vrati u kancelarijski portal.

00:01:32

Odmah pored njega.

00:01:33

Ovde možeš da se promeniš

00:01:35

ime dokumenta.

00:01:36

Kliknite na njega i promenite ime odmah ispod.

00:01:39

Možete da promenite putanju dokumenta.

00:01:42

Naravno da je ovo moguće samo ako

00:01:44

imaju dozvolu da promene lokaciju

00:01:46

datoteke u skladištu na mreži.

00:01:48

Pored pretraživanja dokumenata,

00:01:50

kontakti i šta god traka za pretragu može

00:01:52

koristi se za pretraživanje funkcija aplikacija.

00:01:55

Na primer, želim da dodam grafikon,

00:01:57

ali ne znam kako.

00:01:59

Pretražujem, a zatim bi izbor bilo koje funkcije

00:02:00

Želim i kreiram svoj grafikon.

00:02:08

Excel na mreži je izmešten sa

00:02:09

podrazumevano kao pojednostavljena traka,

00:02:11

već da se prebacim na klasičnu traku,

00:02:13

kliknite ovde. Ovde možete pronaći sve

00:02:16

alatke za obradu Excel radne sveske.

00:02:19

Tri dugmeta ovde ti to dozvoljavaju

00:02:21

deljenje radne sveske sa nekoliko klikova,

00:02:24

dodavanje komentara ili sustigavanje.

00:02:27

Kada radite zajedno na unakrsnoj tabeli,

00:02:29

ovde možete da pronađete svoj

00:02:31

coworkers modifikacija istorije.

00:00:03

O pacote office online recomenda

00:00:05

para usar o mais conhecido da Microsoft

00:00:07

aplicações diretamente online, semelhantes ao

00:00:09

aplicação de ambiente de trabalho e igualmente funcional.

00:00:11

Pode aceder aos documentos a partir do seu

00:00:14

armazenamento online ou espaço partilhado consigo.

00:00:16

Estes documentos podem ser partilhados

00:00:18

de forma rápida e simples.

00:00:19

Neste vídeo você aprende a

00:00:22

navegue pela interface online do Excel.

00:00:25

Na página inicial do seu escritório, clique aqui.

00:00:28

Você pode acessar um menu especificamente

00:00:30

dedicado ao Microsoft Excel.

00:00:31

Aqui você pode encontrar modelos em branco

00:00:34

e documentos para criar novos conteúdos.

00:00:37

Logo abaixo da Microsoft recomenda

00:00:39

documentos de que poderá necessitar.

00:00:43

A última secção inclui todos os

00:00:45

seus arquivos do Microsoft Excel.

00:00:47

Os que você mesmo armazenou on-line

00:00:49

ou os partilhados pelos seus colegas de trabalho,

00:00:51

tempo em uma unidade,

00:00:53

Equipas do SharePoint ou perspetivas com um

00:00:55

clique com o botão direito do mouse você pode executar o mesmo

00:00:57

como na home page do Office.

00:00:59

Você pode usar diferentes filtros, mas também

00:01:01

Pesquise o seu documento com palavras-chave.

00:01:03

Clicar abaixo do nome do arquivo leva

00:01:04

você para o seu local de armazenamento.

00:01:06

Para abri-lo, clique na linha do documento.

00:01:09

Note que a vantagem do online

00:01:11

versão é que ele salva automaticamente

00:01:13

o seu documento assim que o editar.

00:01:15

A aplicação online abre.

00:01:16

Vamos fazer um tour pela interface.

00:01:19

Em primeiro lugar, você tem a faixa superior da cabeça.

00:01:21

Este menu é a ligação entre o Excel

00:01:23

online e todo o pacote office.

00:01:25

Você pode abrir outro aplicativo com um clique.

00:01:29

Ou volte ao portal do escritório.

00:01:32

Mesmo ao lado.

00:01:33

É aqui que você pode mudar

00:01:35

O nome do documento.

00:01:36

Clique nele e altere o nome logo abaixo.

00:01:39

Você pode alterar o caminho do documento.

00:01:42

Claro que isso só é possível se você

00:01:44

ter permissão para alterar o local

00:01:46

do ficheiro no armazenamento em linha.

00:01:48

Além de pesquisar seus documentos,

00:01:50

contatos e o que a barra de pesquisa puder

00:01:52

ser utilizado para pesquisar as funcionalidades das suas aplicações.

00:01:55

Por exemplo, quero adicionar um gráfico,

00:01:57

mas não sei como.

00:01:59

Eu pesquiso e seleciono qualquer recurso

00:02:00

Quero e crio o meu gráfico.

00:02:08

Excel online deslocado por

00:02:09

padrão como faixa de opções simplificada,

00:02:11

mas para mudar para uma faixa de opções clássica,

00:02:13

clique aqui. Aqui pode encontrar todas as

00:02:16

ferramentas para processar sua pasta de trabalho do Excel.

00:02:19

Os três botões aqui permitem que você

00:02:21

compartilhar a pasta de trabalho com alguns cliques,

00:02:24

Adicione comentários ou atualize-se.

00:02:27

Quando trabalham em conjunto numa folha de cálculo,

00:02:29

é aqui que pode encontrar o seu

00:02:31

histórico de modificação de colegas de trabalho.

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

2273 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