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
  • 2553 views

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 :

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

1903 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

Reminder

Show

/

Join Live Training Session